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

4/27/2009

Patching MS SQL Server Cluster

Ofent I found a question in a forums that "How to patch SQL Cluster" or "Patching SQL Server Cluster"

To answer this, there is nothing so special requirement but offcourse there is one thing one should consider and that is "Always patch active/primary node first". One should run SP setup on the primary node and it will get applied on the both node, we do not need to start/stop any services this is managed by SQL Server itself.

Refer section 3.2.5 Installing SQL Server 2005 SP2 on a Failover Cluster Instance

4/20/2009

Get Discount of 25% to first 25 people for Surat SQL Server User group - TechEd India 2009

Dear Surat SQL Server User Group members,

Culminis, INETA APAC and PASS, have worked along with Microsoft to secure a unique discount for our user group members. TechEd is happening in after a period of 3 years. http://www.microsoft.com/india/teched2009/. With Steve Balmer, CEO of Microsoft is giving the Keynote, and illustrious speakers presenting.

Tech.Ed-India 2009 is all about getting yourself ready for the next wave of technology innovations and trends. In today's economic scenario, more than ever before, it has become pertinent that we stay ahead of the curve so as to establish ourselves as the future trend- setters. Tech.Ed-India 2009 - with its offering of sub-events - offers you this opportunity to interact with some of the leading lights in the business and technology space globally, talk to Microsoft product development teams directly, and get in-depth hands-on-trainings and certifications in some of the most coveted and anticipated technologies of our time.

Special Discount for Surat SQL Server User Group Members

If you are attending TechEd, as a member of "Surat SQL Server User Group" you can get a 25% discount. This discount is available to the first 25 people to respond via an email to inteched2009@surat-user-group.org the first 25 people to respond will receive instructions on how to avail the discount.
You are requested to Share your User name and email id which you use to sign in to Surat User Group Website while submitting your request.

Hey, if you are not the registered member of Surat User Group, do not worry. Get your self registered here and grab the opportunity!!!!

4/08/2009

Download SQL Server 2008 SP1

Microsoft has released SP1 for SQL Server 2008 http://support.microsoft.com/kb/968382

List of the bugs that are fixed in SQL Server 2008 Service Pack 1