(Muthusamy Anantha Kumar) Part I of Monitor Blocking in SQL Server 2000 described how to get detailed information on blocking. Blocking is unavoidable in most types of applications. In this article, instead of collecting information every 5, 10 or 15 minutes, I am going to discuss how to collect det

(Tim McCarthy) For most Web applications, caching relatively static database data in memory can boost application performance several fold. Caching not only takes some of the load off your database server, but it can also eliminate a network round-trip. Often, a Web application stores its cache

(Marcin Policht) It is time to gather remaining pieces of information dealing to the SQL Server 2000 Security, concluding at the same time our series dedicated to this subject. We will review them in the context of pre- and post- SQL Server 2000 installation tasks. Some of the topics discussed h

(Bart Duncan) There are plenty of good sources of information about how to deploy SQL Server in a secure fashion. However, these resources are often targeted at database administrators tasked with securing already developed applications. In addition, there is a rich body of information that discusse

(Joseph Sack) DBCC SHOWCONTIG allows you to report on fragmentation information for the data and indexes of a specified table. If neither an index nor table is specified, DBCC SHOWCONTIG will report on all tables within the database. You can capture this output by adding “WITH TABLERESULTS” to t

This step-by-step article describes how to configure ISA Server 2004 to save log information that is in a SQL Server database.

(John Papa) Every day a developer somewhere needs to write code to iterate through SQL Server system objects, query and update tables in linked servers, handle optimistic concurrency, and retrieve column and stored procedure metadata. In this month’s column, I will address these and other T-SQL deve

(Puneet) This article will provide you a trick which will help you in replacing cursors with your code.

(Steven Warren) As a database administrator, I like automation. When it comes to my backups, I like to automate as much as possible. SQL Mail gives me the ability to know when my backups are successful and when they fail.

(Gary Zaika) After the World Trade Center attacks of September 11, 2001, many organizations reconsidered how they manage and protect crucial business data. Having a remote data center with a second set of databases and application servers has become a common practice. Businesses have been willin