SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

1/31/2011

Tip for Backing up User Databases

We all take a database backup as a first resort to recover from a damage occur during the disaster / server crash / for any other reason if require to recover or restore our data back to its previous stat as it was before the database server was crashed!! And for this we schedule a job or make use of database maintenance plan which will take a database backup be it Full / Differential or Log, and we all take a special care and consideration when we design the backup strategy!! But what happened if one fine day when you need your database...

1/25/2011

SQL Server 2008 High Availability – A Book

I have no words to explain my excitement and happiness to share news with you all - my book on SQL Server 2008 High Availability is published!! I have started authoring this book in May 2010 and as the time passes and gradually I move to the final chapter of the book, I was feeling like aha finally it is done!!! – Do you think so, it was this easy? No, every publication house has their own set of rules to be followed while authoring a...

1/21/2011

Download SQL Server Training Kit

Couple of months back I have wrote a blog article about the availability of Microsoft SQL Server Developer Training Kit which is very helpful resource for the SQL Server Developers, trainers and professionals to understand the improvements comes with the release of SQL Server 2008. Recently, 18th January 2011 Microsoft has released the updated version of Microsoft SQL Server Developer Training Kit which has # 31 Presentations (includes Slide decks, videos and transcripts) # 27 Demos (includes installer scripts, videos and transcripts) #...

1/19/2011

Download Section for Script and free ebook

Dear Readers, Good News!! I have created a new section on this site from where you can download various scripts I have created and uploaded on my community website. Currently you can download scripts for: To Find Missing Index To get various SQL Server Property details To search a given word from a string Script which will take backup and verifies the backup set as well Script which will give you an idea on how to perform transaction in smaller chunks You may find them all at http://www.sql-server-citation.com/p/downloads.html,...

1/01/2011

welcome 2011

Dear Readers, Wishing you all very happy and prosperous new year, may the new day bring you joy and happines...