Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – SQL Server Related Downloads from Microsoft

December 21, 2008

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Feature Pack for SQL Server 2005 December 2008 Download the December 2008 Feature Pack for Microsoft SQL Server 2005, a collection of standalone install packages that provide additional value for SQL Server 2005. Microsoft SQL Server Protocol Documentation The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary…

SQL SERVER – Change Collation of Database Column – T-SQL Script

December 20, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Collation, SQL Scripts, SQL Server Security, SQL Utility

Just a day before I wrote about SQL SERVER – Find Collation of Database and Table Column Using T-SQL and I have received some good comments and one particular question was about how to change collation of database. It is quite simple do so. Let us see following example. USE…

SQLAuthority News – Download – SQL Server 2005 Books Online (December 2008)

December 19, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQL Download

Download an updated version of Books Online for Microsoft SQL Server 2005. Books Online is the primary documentation for SQL Server 2005. The December 2008 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to “New and…

SQLAuthority News – Download Microsoft SQL Server 2005 Service Pack 3

December 18, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQL Download, SQL Service Pack

Service Pack 3 for Microsoft SQL Server 2005 is now available. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP3. You can use these packages to upgrade any of the following SQL Server 2005 editions: Enterprise Enterprise Evaluation…

SQL SERVER – Interesting Interview Questions – Revisited

December 17, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Best Practices, Software Development, SQL Scripts

I really enjoyed users participation in my previous question. Read SQL SERVER – Interesting Interview Questions before continuing reading this article. This interview question was about user participation and about how good and how different you can come with your T-SQL script. What I really liked is that many users…

SQL SERVER – Find Collation of Database and Table Column Using T-SQL

December 16, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Collation, SQL Scripts, SQL Server Management Studio

Today we will go over very quick tip about finding out collation of database and table column. Collations specify the rules for how strings of character data are sorted and compared, based on the norms of particular languages and locales Today’s script are self explanatory so I will not explain…

SQLAuthority News – Wedding Day of Author – Photographs – Mr. and Mrs. SQLAuthority

December 15, 2008

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Wedding

On December 12, 2008 I had posted a note on blog when I completed 800th Article on this blog. The same day was also my wedding day. Read more about the same here SQLAuthority News – Wedding Day of Author. Thank you very much for your wishes and wonderful emails.…