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


TechMela 2007 is here!

TechMela 2007 is a first of its kind technology Mela in India. Erstwhile we had TechEd for developers, ITPC for IT Pros, IndiMix for designers and MEDC for Mobile and Embedded Professionals. Each of these events used to happen at few chosen cities. Now with this new event, it will be one place for 4 days! details at www.techmela.com

read more | digg story


Feature Pack for SQL Server 2005

Have you downloaded stand alone value addition packages for SQL Server 2005 like Best Practice Analyzer,Performance Dashboard etc. ? Here is a link where you can find this all http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en


Dear All MVP(s),
SQLSPEC is a software that helps DBA(s) to document Database Objects, It is a tool from
Elsasoft LLC; they are giving out SQLSPEC for free to MVP(s) and significant contributors to SQL Server Community, drop a mail to sqlspec@elsasoft.org, with below information
Your full name
Proof of your contribution to the database community
Proof of your Microsoft MVP, Microsoft MCT, or Oracle ACE status if applicable

There's more detail here: http://www.elsasoft.org/mvp.htm
You may also have a look at Software Spotlight at http://www.sql-server-performance.com/software_spotlights/da_sqlspec.asp