Category Archives: SQL Server

SQL Server 2008 R2 Service Pack 1

Posted on by
Reply

Service Pack 1 for SQL Server 2008 R2 has been recently released and available to download for SQL Server customers / users. You can download the Service Pack from http://www.microsoft.com/download/en/details.aspx?id=26727.

There are certain enhancements for SQL Server 2008 R2 product along with fixing a lot of known bugs in the RTM. The Service pack is released in all 3 major hardware platforms (X86,X64 and Ia64) and it is applicable for almost all Editions of SQL Servers.

For a list of known bugs that are addressed in the Service Pack 1, refer this knowledge base article http://support.microsoft.com/kb/2528583

As always whenever a service pack is applied on a mission critical system, it is suggested practice that you test the service pack thoroughly in a test environment.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

– Bru Medishetty

List of all Data and Log Files of a SQL Instance

Posted on by
Reply

Ever faced a sitaution where you had to find out all the database files (Data and Log) of a SQL Instance?

I came across this situaion many times, especially when I am working with a new SQL Instance which was taken over by my team OR when the previous admin of that box has left the company and its now my turn to maintain / administer that instance.

In order to list the files, we just need to query the system table sysaltfiles.  The picture below is a screen show that I ran earlier today on one of my SQL Instances.

SELECT * FROM SYSALTFILES

This  query can be further tweaked to get only the data files or only the log files by adding where clause and filter by griupid column. Groupid = 1 indicates it is a data file and groupid = 0 indicates it is a log file.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

– Bru Medishetty

List of SSIS Error Messages

Posted on by
Reply

Today, when I was working on SSIS packages, I got an error which as often in SSIS is not clear and descriptive. I searched online for the description and explanation and found this link in MSDN. http://msdn.microsoft.com/en-us/library/ms345164.aspx

The page contions all messages in SSIS (be it Error or Warning or Informational etc). It contains the error cumber and what does it mean.. Hope it helps you too in finding the explanation/ description for your error/ warning code.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

– Bru Medishetty