You can improve your SQL performance by using indexes. But you have to choose the proper indexes and make sure the ones you do choose fit into your business situation. In this indexing guide, you will find answers to common indexing questions, indexing dos and don'ts, and tricks for working with the Index Tuning Wizard to improve overall system performance for SQL Server 2000 servers. This is particularly useful for servers that need a boost before they are upgraded to SQL Server 2005.

Utility Procedures

by David Poole

SQLServerCentral.com

Administration

Have you ever wanted to create your own utility procedures in SQL Server? Maybe your own information schema view? SQL Server export David Poole brings us an article dicussing these very topcis and offers advice on how to proceed.

Stored procedure: Generate code for ad hoc data operations

by Additional Articles

Other

Miscellaneous

A SQL Server DBA often needs to perform ad hoc operations on data in their databases. The tasks can typically be handled with simple T-SQL statements, but other times a more complex operation is called for – and having to manually enter all the T-SQL code necessary for such an operation is not appealing! It can be difficult to perfect the syntax, and tedious to list column names once, twice or even three times. Fortunately, useful template code can be easily generated instead of being entered by hand.

Applying the Principle of Least Privilege to User Accounts on Windows

by Additional Articles

MSDN Communities

Security

A defense-in-depth strategy, with overlapping layers of security, is the best way to counter these threats, and the least-privileged user account (LUA) approach is an important part of that defensive strategy. The LUA approach ensures that users follow the principle of least privilege and always log on with limited user accounts. This strategy also aims to limit the use of administrative credentials to administrators, and then only for administrative tasks.

DB Ghost Packager

by Press Release

SQLServerCentral.com

DB Ghost BUILDS, COMPARES and SYNCHRONIZES your SQL Server databases. It guarantees database integrity by building databases directly from your source control system.

Interviewing

by Steve Jones

SQLServerCentral.com

Miscellaneous

How should you interview for that new DBA job? What is appropriate and what should you leave out? Steve Jones shares some advice on interviewing that has helped him in his career.

OPENROWSET function in SQL Server 2005

by Additional Articles

Database Journal

T-SQL

mong other enhancements in SQL Server 2005, enhancements were made to the OPENROWSET function. This article illustrates BULK operations of the OPENROWSET function.

Microsoft Reporting Services 2005 Features and Enhancements

by Kamran Ali

SQLServerCentral.com

Architecture

Reporting Services was one of the most popular add-ons to SQL Server 2000 and the next version has been greatly improved. Author Kamran Ali brings us a look at some of the new features and enhancements in this platform.

Transact-SQL in 2005

by Press Release

SQLServerCentral.com

SQLServerCentral

The March issue of the SQL Server Standard is now available for purchase, download, and should arrive in your mailbox any day. Check out the Table of Contents and read the editorial.

SQL Server Redundancy for SMBs

by Bilal Ahmed

SQLServerCentral.com

Disaster Recovery (DR)

Building a highly fault tolerant and available SQL Server is expensive and difficult. This brings about unique challenges for small businesses who often lack the resources of large enterprises. Bilal Ahmed and Shivan Bindal discuss the various ways of building redundancy and the challenges of each.

Indexing Guide: The art and science of SQL Server indexing

Utility Procedures

Stored procedure: Generate code for ad hoc data operations

Applying the Principle of Least Privilege to User Accounts on Windows

DB Ghost Packager

Interviewing

OPENROWSET function in SQL Server 2005

Microsoft Reporting Services 2005 Features and Enhancements

Transact-SQL in 2005

SQL Server Redundancy for SMBs

Blogs

Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond

Going to Cloud? Look at the Shared Responsibility Model

How Long Will It Take to Learn SQL? The Truth Might Surprise You

Forums

Restore dbs

Fine-tune SQL for better performance

Row-level security in SQL server

Question of the Day

Initial Config of tempdb