(Santveer Singh) I was reading the article Every DBA Should Know Which Databases are be Backed Up by Leo Peysakhovich. I agree with Leo, that most of the time when we need a backup of database, we noticed that we don’t have backup of that database or we have a very old set of backups. To avoid this

(Brian Moran) Most IT professionals recognize that addressing performance problems during development is faster, easier, and less expensive than waiting until after you roll out your application to production. But development teams that take performance tuning seriously during the early stages of de

(Brad M. McGehee) Disaster recovery is an important topic to DBAs. In this interview with Dr. Vas Srinivasan, Vice President of Marketing of Sonasoft.com, makers of SonaSafe for SQL Server, you will learn about the importance of SQL Server backups and disaster recovery.

(Brian Moran) I’m seeing pageiolatch_sh values in the master..sysprocesses table’s lastwaittype column. Many sysprocesses rows that have a pageiolatch lastwaittype also have nonzero values for waittime, so I know that the server process IDs (SPIDs) are waiting. What do the pageiolatch values mean?

When a client computer connects to an instance of SQL Server that is running on another computer in the network, the data that is exchanged between the client computer and the server computer may have to be kept confidential, especially in scenarios such as authentication. To make sure that the

(Jules Bui) This script will check the rerun status of failed or cancelled jobs and the job steps. There are many times when you have multiple job/steps failures and you would like to find out in a quick way of what needs to be rerun. This will help. (script)

(Stefan Popovski) Using Hierarchy of Stored Procedures we can generate hierarchical report of nested procedures: If Proc1 calls Proc2 and Proc2 calls Proc3 we will have this report: -Proc1 –Proc2 —-Proc3 (R)

(Steve Warren) There have been many occasions where I found it necessary to move the database and log files to different drives to increase performance. When you want to move a typical user database to a different drive for performance or to split out the logs, you run sp_detach and sp_attach to per

(Brad M. McGehee) If you do a lot of Transact-SQL development, you know that the tools provided with SQL Server 7.0 and 2000 aren’t as complete or integrated as you might like. In most cases, you probably use some combination of Query Analyzer, Enterprise Manager, DTS, and maybe even some third-

(Muthusamy Anantha Kumar) The objective of this article is to analyze and understand how SQL Server uses Binary digits for categorizing and how to query such categorized binary numbers to produce detailed results.