SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

An Exclusive Interview with Author Fernando Guerrero On How to Get the Most of ADO.NET and SQL Server

Fernando Guerrero, SQL Server MVP (Most Valuable Professional), is the author of the Que book, Microsoft SQL Server 2000 Programming, and is currently writing a book on ADO.NET and SQL Server for Apress. He is the Principal Technologist and SQL Server Product Consultant for QA, which is the leading IT training company in the U.K. […]

SQL Server 6.5 Useful Undocumented Stored Procedures

In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 6.5. sp_fixindex This stored procedure can be used to fix a corruption in a system table by recreating the indexes on the system table. This is an example: EXEC sp_fixindex pubs, sysindexes, 2 sp_lock2 As a SQL […]

Useful Undocumented SQL Server Extended Stored Procedures

An extended stored procedure (xp) is a dynamic link library that runs directly in the address space of SQL Server and is programmed using the SQL Server Open Data Services API. You can run extended stored procedures from the Query Analyzer, for example, just as you would normal stored procedures. Extended stored procedures are used […]

Useful Undocumented SQL Server Extended Stored Procedures

An extended stored procedure (xp) is a dynamic link library that runs directly in the address space of SQL Server and is programmed using the SQL Server Open Data Services API. You can run extended stored procedures from the Query Analyzer, for example, just as you would normal stored procedures. Extended stored procedures are used […]

SQL Server TSQL Coding Conventions, Best Practices, and Programming Guidelines

Databases are the heart and soul of many enterprise applications, and it is very essential to pay special attention to database programming. I’ve seen in many occasions where database programming is overlooked, thinking that it’s something easy that be done by anyone. This is wrong.For a better performing database you need a real DBA and […]

Undocumented SQL Server 7.0 System Tables

In this article, I want to tell you about undocumented system tables shipped with SQL Server 7.0. These tables are used by some system stored procedures and stored in the master database (only the sysfiles1 system table is stored in each database). syscursorcolumnsContains the list of server cursor’s columns. This table is stored in the […]

Some Useful Undocumented SQL Server 6.5 DBCC Commands

In this article, I want to tell you about some useful undocumented DBCC commands, and how you can use these commands in SQL Server 6.5 for administering and monitoring.DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logical consistency of a database, although they are also […]

Windows 2000 Cluster Services: Testing and Verifying the Windows 2000 Cluster Service

The worst is now over. If you have successfully gotten this far, most likely the Windows 2000 Cluster Service is ready to be used. But since I trust a computer installation only as far as I can throw it (which is not very far), it is a good idea to test the Cluster Service installation […]

Install Windows 2000 Cluster Services: Installing the Windows 2000 Cluster Service: Node 1

This portion of the article shows you, step-by-step, how to install the Windows 2000 Cluster Service. Not every potential option will be discussed, only the most common. This section has been divided into two web pages to make it easier to load into your web browser and read. There are many graphics, and it make […]

Install Windows 2000 Clustering Services: Establishing User Accounts and Security

Setting up the appropriate user accounts and establishing the necessary security is one of the easiest steps when creating a cluster. It is also one of the easiest to forget. What I like to do in this step is not only set up the domain service account for the cluster service, but also to set […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |