Microsoft SQL Server 2008 R2 Service Pack 2

Posted by Deepak Kumar | Posted in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized | Posted on 28-07-2012

1

Microsoft on july 26th announced that SQL server 2008 R2 service pack is now available to download. If you apply this service will upgrade SQL build version to 10.50.4000.0; Also visit this link to find what all bugs have been fixed in this service pack.

 

 

What are the common SQL DBA mistakes?

Posted by Deepak Kumar | Posted in SQL BI/DW/SSRS, SQL DBA, SQL Dev | Posted on 21-03-2011

4

On any given production environment a SQL DBA must follow set of best practices to ensure smooth and highly optimized databases availability. Here are few common mistakes that I have identified and would recommend to fix if you have encountered or seeing anything similar.

1. Not preparing and validating a reliable backup and recovery policy with backup files retention period for databases as per agreed data loss and application downtime it may cause while recovering databases.

© 2010 SQLKnowledge.com Increase your website traffic with Attracta.com