Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Tips and Tricks   (RSS)

Security in SQL 2005 - encryption and decryption

Posted Thursday, November 02, 2006 11:12 PM by Sanchan
We recently posted a blog about SQL 2005 Security enhancements, focussing on encryption and decryption. Check it out and let us know what you think. http://blogs.msdn.com/sqlblog/archive/2006/11/02/part-i-data-security-enhancements-in-sql-server-2005.asp Read More...
0 Comments
Filed under:

“Unexpected error occurred” during SQL Server 2005 SP1 install

Posted Sunday, October 29, 2006 10:22 AM by Sanchan
We are seeing this issue for many customers installing SQL 2005 SP1. Check out the resolution for it at our support blog http://blogs.msdn.com/sqlblog/archive/2006/10/09/_1C20_Unexpected-error-occurred_1D20_-during-SQL-Server-2005-SP1-install_2E00_.asp Read More...
0 Comments
Filed under:

More topics added to the SQL Support blog

Posted Monday, October 09, 2006 2:02 PM by Sanchan
We have recently added Reporting Services as a blog category for our SQL Server Support Blog. Would encourage you to check it out. http://blogs.msdn.com/sqlblog/default.aspx Read More...
0 Comments
Filed under:

Errors while using tools in SQL 2005

Posted Tuesday, October 03, 2006 10:04 PM by Sanchan
Recently, I blogged about an issue with SQL Server 2005 tools. You might get the below error when using these tools: Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. Read More...
1 Comments
Filed under:

Add/Remove programs and SQL 2005 - continued

Posted Sunday, August 27, 2006 9:55 AM by Sanchan
Sometime ago, I blogged about SQL Server 2005 installation and how you can use Add/Remove programs to add or remove components in SQL 2005. I recently published a KB article on this – KB 922670 . Please refer to it for more information on this topic and Read More...
1 Comments

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

Posted Friday, August 18, 2006 5:39 PM by Sanchan
Many customers have asked me if they can install SQL 2000 and SQL 2005 on the same box, side by side. The answer to this is YES. You can install SQL 2000, SQL 7.0 and SQL 2005 on the same box. However, there are certain special considerations that you Read More...
2 Comments

Upgrade from SQL Server Evaluation Edition to full blown editions?

Posted Thursday, July 27, 2006 11:22 PM by Sanchan
Well, the last month has been really hectic and I have been involved with a lot of stuff that I never planned for – as you can see, I didn’t get much of a chance to blog this month. But now that things are back to normal pace, I am coming back!!! Recently, Read More...
7 Comments

FAQs - SQL Server and Disk Subsystem requirements

Posted Friday, July 07, 2006 2:20 PM by Sanchan
This is the first installment in my FAQ series. In this blog entry, I have consolidated all the questions that I have received from my readers about available disk subsystems in the market and their compatibility with SQL Server. I have tried to address Read More...
1 Comments

Working with TempDb in SQL 2005

Posted Thursday, June 29, 2006 7:13 PM by Sanchan
Just a quick note, Microsoft has published a great whitepaper on TempDB. You can download it here: http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/WorkingWithTempDB.doc I will add more blog content about TempDb soon. Read More...
0 Comments

SETUP – Installing Analysis Services 2005 on a cluster

Posted Wednesday, June 14, 2006 12:25 AM by Sanchan
I have received a lot of questions on installing Analysis Services 2005 on a cluster and I wanted to write this blog to answer those questions using specific scenarios. Scenarios - You create a new Windows Cluster and decide to install ALL components Read More...
2 Comments

SETUP - SQL 2005 and domain groups best practices

Posted Wednesday, June 14, 2006 12:07 AM by Sanchan
Unlike SQL 2000, SQL 2005 setup on a cluster now requires you to provide domain groups for each clustered service – like SQL Database Engine, SQL Agent, FTS, Analysis Services. Many customers have asked me interesting questions about domain groups and Read More...
2 Comments

Add/Remove Program and SQL 2005

Posted Tuesday, June 13, 2006 11:21 PM by Sanchan
When you install SQL Server 2005, depending upon the components you installed, you will see a couple of entries in the Add/Remove programs related to SQL Server 2005. The most important one is Microsoft SQL Server 2005. This entry provides you with a Read More...
4 Comments

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

Posted Sunday, June 04, 2006 11:08 PM by Sanchan
You will be surprised to know how many times this topic comes up during discussions with SQL Server DBAs. I guess the reason for confusion or discussion primarily emanates from the fact that the documentation on this topic hasn’t been that detailed. So Read More...
5 Comments

SQL Error Messages – I/O Related

Posted Saturday, June 03, 2006 9:04 AM by Sanchan
You may see the following error message in SQL Server 2005 Error logs or event logs: SQL Server has encountered %d occurrence(s) of I/O requests taking longer than %d seconds to complete on file [%ls] in database [%ls] (%d). The OS file handle is 0x%p. Read More...
4 Comments

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

Posted Sunday, May 28, 2006 1:49 AM by Sanchan
I wanted to publish this quick blog tonight to answer some of the questions that I have received recently regarding installation from an .ini file. Microsoft has published a great MSDN article that lists the commands and options to use for installing Read More...
11 Comments
More Posts Next page »
 
Page view tracker