Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

best practice,dba - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » best practice » dba (RSS)

SQLBits 9 - Query across the Mersey, Backup North! - High Availability and Disaster Recovery for the Novice DBA

I believe by this time most of you might have registered/noted your diaries with the dates about upcoming SQLBits 9 conference. If you haven't registered yet then, hurry-up - Registration is Now Open , like the previous events this is also a 3 day...

SQL Server Management Data Warehouse - quick tour on setting health monitoring policies

Profiler, Perfmon, DMVs & scripts are legendary tools for a DBA to monitor the SQL arena. In line with these tools SQL Server 2008 throws a powerful stream with policy based management (PBM) framework & management data warehouse (MDW) methods...

How fast you can obtain information about missing indexes? Its easy and quick!

On the subject line the process to find the answer is not a short one! By design SQL Server engine takes care when the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the best indexes...

Achieve SQL Server 2008 High Availability and Disaster Recovery - technical case study, SQLBits

How can you achieve the High Availability & Disaster Recovery on database platform? What are factors involved to keep the system available to maintain revenue stream? What kind of management principles you need to implement? Well there are lot more...