SQL, .NET and everything Microsoft
Many of you have asked me the performance impact of: a) Running a default profiler trace b) Enabling...
Date: 03/31/2007
Well, as mentioned earlier, the SQL Server Support team now has an official blog and I am busy...
Date: 12/06/2006
We recently posted a blog about SQL 2005 Security enhancements, focussing on encryption and...
Date: 11/02/2006
We are seeing this issue for many customers installing SQL 2005 SP1. Check out the resolution for it...
Date: 10/29/2006
I wrote another article for Simple-Talk.com and it is available to view now. Fine Tune Your Database...
Date: 10/11/2006
We have recently added Reporting Services as a blog category for our SQL Server Support Blog. Would...
Date: 10/09/2006
Recently, I blogged about an issue with SQL Server 2005 tools. You might get the below error when...
Date: 10/03/2006
I am running a survey on Query Notification and would appreciate if you could fill it out....
Date: 09/30/2006
Well, I have been blogging at a new blog home. https://blogs.msdn.com/sqlblog/ This blog is setup by...
Date: 09/27/2006
Sometime ago, I blogged about SQL Server 2005 installation and how you can use Add/Remove programs...
Date: 08/27/2006
Many customers have asked me if they can install SQL 2000 and SQL 2005 on the same box, side by...
Date: 08/18/2006
Today, one of my articles got published at Simple Talk Magazine in the UK. In this article, I take a...
Date: 08/11/2006
Well, the last month has been really hectic and I have been involved with a lot of stuff that I...
Date: 07/27/2006
This is the first installment in my FAQ series. In this blog entry, I have consolidated all the...
Date: 07/07/2006
Just a quick note, Microsoft has published a great whitepaper on TempDB. You can download it here:...
Date: 06/29/2006
I have received a lot of questions on installing Analysis Services 2005 on a cluster and I wanted to...
Date: 06/14/2006
Unlike SQL 2000, SQL 2005 setup on a cluster now requires you to provide domain groups for each...
Date: 06/14/2006
When you install SQL Server 2005, depending upon the components you installed, you will see a couple...
Date: 06/13/2006
You will be surprised to know how many times this topic comes up during discussions with SQL Server...
Date: 06/04/2006
You may see the following error message in SQL Server 2005 Error logs or event logs: SQL Server has...
Date: 06/03/2006
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 launched SQL Server 2005 in November, 2005. This build was called the RTM version. In...
Date: 05/27/2006
Due to your company's password policies, you might have to change the password of the domain account...
Date: 05/04/2006
I wanted to post this quick blog to answer a very common question - domain vs local system account...
Date: 05/04/2006
In SQL Server 2005, you can set collations at the following levels: - Server Level o You set the...
Date: 05/03/2006
Generally, you would set the startup accounts for SQL Server services during the startup. However,...
Date: 05/03/2006
The answer to this question is NO. However, there are some special considerations, so read on. You...
Date: 05/03/2006
SQL Server 2005 has 32-bit and IA64bit versions (just like SQL 2000), but it also has a specific...
Date: 04/28/2006
Maintenance Cleanup Task is a new feature available in SQL 2005 which can be used to remove files...
Date: 04/23/2006
Database Mail is a new feature in SQL 2005 that provides enterprise class mailing functionality in...
Date: 04/23/2006
Yesterday, Microsoft officially launched Service Pack 1 for SQL 2005. - Learn about the new features...
Date: 04/19/2006
When you try to install SQL Server 2005, the setup wizard runs under setup.exe. This service then...
Date: 04/18/2006
SQL Server creates dump files (files with a .mdmp extension) by default under the LOG folder. These...
Date: 04/18/2006
If you want to know the edition and build versions of SQL Server 2005 programmatically, you can use...
Date: 04/18/2006
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
I thought of posting this quick blog entry today. I work with many Microsoft's customers - big and...
Date: 02/12/2006
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