SQL Server security best practice

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

Change the Collation Settings in MS SQL Server

This post will show you how to change the collation settings in MS SQL Server for specific database...

Resolve collation conflict

In this post I will show you how you can resolve collation conflict error...

Book: SQL Server 2008 High Availability

In this book I have tried to cover every single piece of information that might requires for installing and configuring SQL Server HA option like Clustering, Replication, Log Shipping and Database Mirroring...

Why to recompile Stored Procedure

Generally, we create views and stored procedures (proc here after) ...



DevCon - 2007 Organized by Pune User Group

Pune User Group has organized an event “DevCon “ in the month of August, the details and for Entry passes check your nearest location on website



Download System View Map for MS SQL Server 2005

Download the System View map for SQL Server 2005, this would definately helpfull to DBA(s).

Webcast on Reading Execution Plan and Query Tuning


Aug - 28th ; 14:00 - 15:30 IST

SQL Server 2005: Reading Execution Plans
The toughest part of analysis of any query is reading the execution plans. Many see this as the most difficult part, but this webcast removes this myth. We will walk you through the various operators and what they mean in the actual reading of the execution plan. There are some small changes made between SQL Server 2000 to SQL Server 2005 and we will take a quick at the same too.

Speaker: Vinod Kumar

Aug - 28th ; 14:00 - 15:30 IST

SQL Server 2005: Query Tuning
As part of application development everyone is faced with the need to tune their applications query. One aspect will be reading execution plans, but there are tons of other parameters that need attention to start the tuning exercise. This webcast takes a look at those parameters and the various tools and the tuning parameters we need to use with SQL Server 2005.

Speaker: Vinod Kumar