(David Weber) Most security experts’ recommendations include changing passwords frequently to enhance security. It is easy to change the password on a SQL Server Username via Query Analyzer. Changing the password with Query Analyzer makes it easy to coordinate changing the password on the database s

(Bob Beauchemin) Learn how to apply the tracing functionality in ADO.NET 2.0 to track down bugs and bottlenecks in your applications.

(Mike Chapple) Take a moment and review the database tables located on the first page of this article. Notice that we have a driver — Jack Ryan — who is located in a city where there are no vehicles. Our vehicle managers would like this information to be included in their query results to en

(Dan Sullivan) SQL Server 2005 has added a new format for queries called a Common Table Expression or CTE. CTE’s are part of the SQL:1999 Specification and represent further compliance with this specification by SQL Server. This article will cover using one of the many capabilities of CTE’s, imp

(Kalen Delaney) In SQL Server, indexes are one of the most important data structures—they are the only means by which SQL Server can process huge tables in a reasonable amount of time. In my November column, “Get Into Index Structures” (InstantDoc ID 43939), I described the structure and organizatio

(Steve Jones) One of the keys to SQL Server performance is ensuring that you have the proper indexes on a table so that any queries written against this table can run efficiently. There are more articles written about designing indexes, choosing columns, etc for optimizing performance, so I will

(Jon Winer) Connecting to and executing commands against a database is a simple task. We do it without much thought because in today’s applications, data access is common place and necessary. For those of us who work in a Microsoft ‘Shop’, ADO and ADO.NET is the norm when it comes to reading and wr

(Allan Mitchell) This article is meant as a very gentle introduction into creating your own custom transformation component in SQL Server 2005 Integration Services. In the article we will be touching upon a few of the essential methods available to us in the new object model and showing you how

(Brad M. McGehee) For this part of the performance audit, you will be using the SQL Profiler tool that comes with SQL Server. As this article focuses on how to perform a performance audit, and not on how to use tools, it is assumed that you know how to use SQL Profiler. If you have not used it b

(Tim DiChiara) Locking is a natural part of any application. But if the transactions in your application are not designed correctly, you could have serious performance and scalability problems. Rahul Sharma discusses those design issues and gives you ways to troubleshoot locking problems to make