Showing posts from May, 2009

DBA database management checklist

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…

Deprecated Features – SQL Server 2008

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…

More on log shipping

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…

Inline variable initialization in SQL Server 2008

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 …

How to fix orphaned SQL Server users

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&…

Return a CSV of the affected records without using OUTPUT

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

Guidelines for enabling indexes and online index operations

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: …
Subscribe Our Newsletter