Executing SQL Server Stored Procedure from Perl
This article illustrates how to setup a development environment using Perl and SQL Server on the following platforms: Microsoft Windows, Red Hat Linux, and Sun Solaris. Step by step, you can learn, and may choose, the best way that fits into your own requirements.
How to Search for Date and Time Values Using SQL Server 2000
Before you can effectively query date/time (or temporal) data, you have to know something about how date/time values are stored. In this article, Bryan demonstrates the various ways in which to query an SQL Server to successfully retrieve the records you may be seeking.
Replication: SQL Server 2000 - Part 2
In this second, and final, installment, Mahesh gives us a step-by-step approach on how to implement replication across a network using SQL Server 2000.
Replication: SQL Server 2000 - Part 1
In this first installment of a 2-part series, Mahesh describes and explains what Replication is, its features and benefits, and how you can put it to use.
SQL Sever: Storing Code in Binary or Text Files Rather than Stored Procedures
Learn how to extend SQL Server #39;s capabilities by making use of binary and text files, to execute SQL queries, in place of Stored Procedures.
Execute SQL on Multiple Tables/Columns - New Feature in SQL Server 2000
In this latest article, Raghavendra introduces us to a feature available to us in SQL Server, allowing us to execute SQL statements on multiple tables and columns.
How to Connect to a SQL Server from Visual FoxPro
Sayed explains how one could connect from Visual Foxpro to a SQL Server, and the problems related to making this connection.
SQL Server Hardware Tuning and Performance Monitoring
In this article, Sayed will lead the way in presenting you guys with a performance enhancing solution for your system. Discover how to optimise your system by investigating what hardware you really need for your applications.
Primary Key on Multiple Tables – New RDBMS Concept in SQL SERVER 2000
The reason for this article is to demonstrate how the Multiple Table Primary Key concept can help our readers to enforce Entity Integrity across the tables embedded in an SQL Server 2000 database. Read more ...
Migrating from Sybase to SQL Server
Projects involving database migration are common. In this article Sayed shares his experiences in migrating from Sybase to SQL Server...
What #39;s Best for DBAs? GUI or T-SQL Commands?
Ok all you DBAs out there. Here is an article that will stir up a debate. Narayana discussed the pro and cons between these two options. What do you think is better for DBAs?
How to Perform a SQL Server Performance Audit
This lengthy article written by Brad, explains how to check the performance of your SQL Server.
An Introduction To The Bulk Copy Utility
There are a number of ways to import and export data with SQL Server 2000. Bulk copy is one of them. In this article Mitchell introduces us to basic import/export functionality with the bulk copy command utility.
SQL Server Stored Procedures 101
Stored procedures can offer performance gains when used instead of regular queries. In this article Himanshu starts with the basics and gives us the 101 on stored procedures.
Building Your First SQL Server 2000 Database
SQL Server 2000 is one of the most popular RDBMS #39;s for the Windows platform. Never worked with SQL Server 2000 before but dying to know how? In this article Mitchell looks at how to create your first database, and also shows you how to manipulate this database through both Enterprise Manager and Query Analyzer.
Extended Stored Procedures: Intro And 10 Cool Examples
In this article Joe takes us through what an SQL Server 2000 extended stored procedure is. He also shows us how to use 10 of SQL Server 2000 #39;s most coolest extended stored procedures to accomplish tasks such as killing a system process, writing to the event log, encrypting data to a database, parsing XML, shelling to the command-line, and more.
Creating User Defined Functions In SQL Server 2000
Microsoft SQL Server 2000 allows us to create our own functions and call them through code. These functions are known as UDF #39;s (User Defined Functions). In this article Mitchell #39;s going to teach us how to create three different types of UDF #39;s and how to work with them through batches of SQL code.
Sample Chapter: Wrox Beginning SQL Server 2000 Programming
Wrox are well known for their How-To series of books, which teach beginning-intermediate developers how to use Microsoft technologies properly and efficiently. Today, Mitchell takes a look at chapter three from Beginning SQL Server 2000 Programming , which is published by Wrox Press.
Using Triggers In MS SQL Server
Triggers allow us to execute a batch of SQL code when either an insert, update or delete command is executed against a specific table. In this article David will describe exactly what triggers are, he will show you how to create new triggers from scratch, how to test triggers, and also provide you with some valuable links/books to help you learn more about triggers.