Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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