SQL, .NET and everything Microsoft

Performance Impact of querying SQL Server 2005 DMVs and implementing Page Checksum

Many of you have asked me the performance impact of: a) Running a default profiler trace b) Enabling...

Author: Sanchan Date: 03/31/2007

Where am I these days?

Well, as mentioned earlier, the SQL Server Support team now has an official blog and I am busy...

Author: Sanchan Date: 12/06/2006

Security in SQL 2005 - encryption and decryption

We recently posted a blog about SQL 2005 Security enhancements, focussing on encryption and...

Author: Sanchan Date: 11/02/2006

“Unexpected error occurred” during SQL Server 2005 SP1 install

We are seeing this issue for many customers installing SQL 2005 SP1. Check out the resolution for it...

Author: Sanchan Date: 10/29/2006

My second article is now available to view

I wrote another article for Simple-Talk.com and it is available to view now. Fine Tune Your Database...

Author: Sanchan Date: 10/11/2006

More topics added to the SQL Support blog

We have recently added Reporting Services as a blog category for our SQL Server Support Blog. Would...

Author: Sanchan Date: 10/09/2006

Errors while using tools in SQL 2005

Recently, I blogged about an issue with SQL Server 2005 tools. You might get the below error when...

Author: Sanchan Date: 10/03/2006

Have you used Query Notification in SQL 2005? Fill out this survey

I am running a survey on Query Notification and would appreciate if you could fill it out....

Author: Sanchan Date: 09/30/2006

Where am I these days?

Well, I have been blogging at a new blog home. https://blogs.msdn.com/sqlblog/ This blog is setup by...

Author: Sanchan Date: 09/27/2006

Add/Remove programs and SQL 2005 - continued

Sometime ago, I blogged about SQL Server 2005 installation and how you can use Add/Remove programs...

Author: Sanchan Date: 08/27/2006

Installing SQL 2005 and SQL 2000 on the same box - what you should know?

Many customers have asked me if they can install SQL 2000 and SQL 2005 on the same box, side by...

Author: Sanchan Date: 08/18/2006

My Article - Query Notification and SQL 2005

Today, one of my articles got published at Simple Talk Magazine in the UK. In this article, I take a...

Author: Sanchan Date: 08/11/2006

Upgrade from SQL Server Evaluation Edition to full blown editions?

Well, the last month has been really hectic and I have been involved with a lot of stuff that I...

Author: Sanchan Date: 07/27/2006

FAQs - SQL Server and Disk Subsystem requirements

This is the first installment in my FAQ series. In this blog entry, I have consolidated all the...

Author: Sanchan Date: 07/07/2006

Working with TempDb in SQL 2005

Just a quick note, Microsoft has published a great whitepaper on TempDB. You can download it here:...

Author: Sanchan Date: 06/29/2006

SETUP – Installing Analysis Services 2005 on a cluster

I have received a lot of questions on installing Analysis Services 2005 on a cluster and I wanted to...

Author: Sanchan Date: 06/14/2006

SETUP - SQL 2005 and domain groups best practices

Unlike SQL 2000, SQL 2005 setup on a cluster now requires you to provide domain groups for each...

Author: Sanchan Date: 06/14/2006

Add/Remove Program and SQL 2005

When you install SQL Server 2005, depending upon the components you installed, you will see a couple...

Author: Sanchan Date: 06/13/2006

SQL Server 2005 and compressed drives - what you should know?

You will be surprised to know how many times this topic comes up during discussions with SQL Server...

Author: Sanchan Date: 06/04/2006

You may see the following error message in SQL Server 2005 Error logs or event logs: SQL Server has...

Author: Sanchan Date: 06/03/2006

How to install SQL 2005 from the command prompt and using .ini file ?

I wanted to publish this quick blog tonight to answer some of the questions that I have received...

Author: Sanchan Date: 05/28/2006

TIP - How do I prevent users from seeing DBs in Enterprise Manager/SSMS that they don't have rights to?

I came across this excellent blog by Euan Garden, who is a Group Program Manager at Microsoft....

Author: Sanchan Date: 05/28/2006

Microsoft launches cumulative package for SQL Server 2005

Microsoft launched SQL Server 2005 in November, 2005. This build was called the RTM version. In...

Author: Sanchan Date: 05/27/2006

TIP - I changed the password for the domain account that SQL uses as startup account...

Due to your company's password policies, you might have to change the password of the domain account...

Author: Sanchan Date: 05/04/2006

TIP - Should I use a Domain Account OR a Local System Account for SQL Server services?

I wanted to post this quick blog to answer a very common question - domain vs local system account...

Author: Sanchan Date: 05/04/2006

TIP - How to find out the collation in SQL Server 2005?

In SQL Server 2005, you can set collations at the following levels: - Server Level o You set the...

Author: Sanchan Date: 05/03/2006

TIP - How to change the startup account in SQL 2005?

Generally, you would set the startup accounts for SQL Server services during the startup. However,...

Author: Sanchan Date: 05/03/2006

TIP - Do we need to run SQL Server under an administrative account?

The answer to this question is NO. However, there are some special considerations, so read on. You...

Author: Sanchan Date: 05/03/2006

SQL 2005 and Editions on 32-bit/64-bit

SQL Server 2005 has 32-bit and IA64bit versions (just like SQL 2000), but it also has a specific...

Author: Sanchan Date: 04/28/2006

ENHANCEMENT - Maintenance Cleanup Task and SP1

Maintenance Cleanup Task is a new feature available in SQL 2005 which can be used to remove files...

Author: Sanchan Date: 04/23/2006

ENHANCEMENT - Database Mail in SQL 2005 64 bit and SP1

Database Mail is a new feature in SQL 2005 that provides enterprise class mailing functionality in...

Author: Sanchan Date: 04/23/2006

SQL 2005 Service Pack 1 is launched!

Yesterday, Microsoft officially launched Service Pack 1 for SQL 2005. - Learn about the new features...

Author: Sanchan Date: 04/19/2006

TIP - Permissions required to run SQL Server setup?

When you try to install SQL Server 2005, the setup wizard runs under setup.exe. This service then...

Author: Sanchan Date: 04/18/2006

How to change the dump directory for SQL Server, Agent and FTS?

SQL Server creates dump files (files with a .mdmp extension) by default under the LOG folder. These...

Author: Sanchan Date: 04/18/2006

How to identify the build and edition of SQL 2005?

If you want to know the edition and build versions of SQL Server 2005 programmatically, you can use...

Author: Sanchan Date: 04/18/2006

Installing SQL 2005 from CDs

When you order SQL 2005, you get either a DVD or 2 CDs. CD 1 contains server components and CD 2 has...

Author: Sanchan Date: 04/18/2006

Log Shipping between SQL 2000 and SQL 2005 is not possible

I thought of posting this quick blog entry today. I work with many Microsoft's customers - big and...

Author: Sanchan Date: 02/12/2006

Server Registration Feature not available in SQL 2005

I am not sure how many of you are aware of this feature in SQL 2000, so will start with a little...

Author: Sanchan Date: 02/09/2006