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,sql server - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » best practice » sql server (RSS)
11 August 2011 11:48

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...
Posted by ssqa.net | with no comments
Filed under: , , , , , , ,
05 April 2010 18:55

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...
Posted by ssqa.net | 1 comment(s)
Filed under: , , , , , ,
23 November 2009 00:49

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...
Posted by ssqa.net | with no comments
Filed under: , , , , , , , ,
14 November 2009 04:47

SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!

For any user manage the work with short-cut is desirable, for better productivity in your work (with UI tools) I always suggest to manage it by keyboard not with the mouse. Here is another block of SQL manageability series I want to cover based on feedback...
Posted by ssqa.net | 1 comment(s)
Filed under: , , , , ,
11 November 2009 17:17

SQL Server 2008 - Unstructured Data Storage Solutions and Best practices, SQLBits

Data is most business-critical for any organization and no doubt that they invest heavily to make data management system more efficient, above all the storage is important piece in the puzzle. Now a days there are no limitation in terms of what kind or...
Posted by ssqa.net | with no comments
Filed under: , , , , , , ,
11 November 2009 16:57

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...
Posted by ssqa.net | with no comments
Filed under: , , , , , , , , ,
04 November 2009 16:39

SQL Server Replication upgrade practices - choose optimal upgrade option

SQL Server Upgrade task needs a thorough planning and testing before you deploy the process in production environment. In this regard when performing an upgrade to a replicated environment, DBAs must make sure that all changes have been applied to all...
Posted by ssqa.net | with no comments
Filed under: , , , , ,
17 August 2009 14:49

SQL Server 2008 R2 CTP - BOL : refer to documentation to know what's new!

In response to the SQL Server 2008 R2 CTP post I have had flurry of emails asking what more they can learn on 'What's New' compared to the existing SQL Server 2008 RTM which has celebrated its first birtday! As a general recommendation I always...
Posted by ssqa.net | with no comments
Filed under: , , , , , , , ,
02 June 2009 04:49

Address the compliance needs of your environment using SQL Server!

Common Criteria (CC) Certification is required for any environment and SQL Server is no compromise or exception in this case. I would like to highlight a brief introduction to this requirement (as per my experience), in the recent times many changes to...
Posted by ssqa.net | with no comments
Filed under: , , , , , , , , ,