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...
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...
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...
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...
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...
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...
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...
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....
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...
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...
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...
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...
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...
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...
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:...
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...
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...
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...
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...
Date: 06/04/2006
SQL Error Messages – I/O Related
You may see the following error message in SQL Server 2005 Error logs or event logs: SQL Server has...
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...
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....
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...
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...
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...
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...
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,...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 02/09/2006