Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Download – Microsoft SQL Server 2008 Feature Pack, August 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download, SQL Utility
Download the 2008 Feature Pack for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008. The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest versions of: Redistributable components…
Read More

SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported – VS SP1 ISO Download

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Software Development, SQL Download, SQL Utility
I previously wrote article SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported where I discussed how downloading Visual Studio SP1 will fix the error of Visual Studio 2008 connecting to SQL Server 2008. I have provided link to SP1 which…
Read More

SQLAuthority News – Cumulative update package 1 for SQL Server 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download, SQL Service Pack
Cumulative update package 1 for SQL Server 2008 is released. Click on link : http://support.microsoft.com/kb/956717/en-us Update : I have received few emails where developer did not find where to click on the support page to download the update package. Following image describes the link which is on very top of…
Read More

SQLAuthority News – Download – Microsoft SQL Server 2008 Books Online (August 2008)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, SQL Download
SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. Books Online includes the following types of information: Setup and upgrade instructions. Information about new features and backward compatibility. Conceptual descriptions of the technologies and…
Read More

SQL Server – 2008 – Cheat Sheet – One Page PDF Download

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Best Practices, Database, DBA, Software Development, SQL Cheat Sheet, SQL Coding Standards, SQL Download, SQL Scripts, SQL Server, SQL Utility

Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and for novice developers it is good to keep all the important SQL Script and SQL Statements handy.

I have attempted to create cheat sheet for SQL Server 2008 most important commands. User can print this in one A4 size page and keep along with them. This can be used in interviews where T-SQL scripts are being asked.

Read More

SQLAuthority News – Security Update for SQL Server 2005 Service Pack 2

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL Download, SQL Server Security, SQL Service Pack
Developers who are using SQL Server Service Pack 2 must install this security patch for it. A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it. You can help protect your computer…
Read More