Browse by Tags

How fast you can obtain information about missing indexes? Its easy and quick!
23 November 09 12:49 AM | ssqa.net | with no comments

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...

Filed under: sql server, index, dba, indexes, best practice, execution plan, feature, dmv, missing index

SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!
14 November 09 04:47 AM | ssqa.net | 1 comment(s)

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...

Filed under: sql server, benefits, best practice, ssms, shortcuts, keyboard

SQL Server 2008 - Unstructured Data Storage Solutions and Best practices, SQLBits
11 November 09 05:17 PM | ssqa.net | with no comments

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...

Filed under: sql server, conference, sqlbits, xml, best practice, solution accelerator, standard, storage

Achieve SQL Server 2008 High Availability and Disaster Recovery - technical case study, SQLBits
11 November 09 04:57 PM | ssqa.net | with no comments

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...

Filed under: sql server, 2008, conference, sqlbits, dba, high availability, discussion, best practice, backup, disaster recovery

SQL Server Replication upgrade practices - choose optimal upgrade option
04 November 09 04:39 PM | ssqa.net | with no comments

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...

Filed under: sql server, replication, database, testing, upgrade, best practice

SQL Server 2008 R2 CTP - BOL : refer to documentation to know what's new!
17 August 09 02:49 PM | ssqa.net | with no comments

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...

Filed under: sql server, documentaiton, download, msdn, benefits, bol, ctp, best practice, web

Address the compliance needs of your environment using SQL Server!
02 June 09 04:49 AM | ssqa.net | with no comments

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...

Filed under: sql server, security, profile, implementation, compliance, enterprise edition, best practice, solution accelerator, standard, assurance