Welcome to my World of SQL

Problem For both old and new DBAs there are fundamental procedures that should be addressed and proper processes put in place to handle various areas of database management for SQL Server. Whet…

BACKUP LOG .. WITH NO_LOG / TRUNCATE_ONLY Almost every dba  uses “BACKUP LOG <mydb> WITH TRUNCATE_ONLY or NO_LOG” statement to truncate the database; Basically when you truncate the log file…

In this post I will follow up on my previous post on log shipping. I did some test and will give you a detailed explanation of how to set it up for SQL 2005, including preparations and 'what to d…

This is one of the cool features that I like in sql server 2008. We can initialize the variable inline. DECLARE @i int = 10 ; Seems to be a simple, but it saves a 'Select /Set' statement You…

When you restore a Microsoft SQL Server database on a different machine, you cannot access the database until you fix the permissions. The problem is that the user in the database is an "orphan&…

set nocount on declare @Tab table ( id int identity , i int , j date ) insert into @Tab select 1 , '2008-01-01' insert int…

Here are some important points that every new DBA should be aware of about enabling indexes and online index operations, few of them are extracted from SQL 2005 Books online and reliable resources: …