SQLAuthority News Archives - Page 89 of 118 - SQL Authority with Pinal Dave

SQLAuthority Author Visit – A True Outsourcing Giant and Technology Leader DigiCorp in Ahmedabad India

February 18, 2009

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

Database, DigiCorp, SQLAuthority Author Visit

Last week, I happen to visit one of the tech company in Ahmedabad, India. I visit different IT organization for two purpose – learn more about technology advancement in different organization and help them with any issues if they are facing with Microsoft technology and in particular SQL Server. I…

SQL SERVER – 2008 – Download Microsoft SQL Server 2008 Express with Tools Free

February 9, 2009

Pinal Dave

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

Database, SQL Download, SQL Server Express, SQL Utility

Note: Download Microsoft SQL Server 2008 Express with Tools Free by Microsoft SQL Server 2008 Express Edition was much awaited version of SQL Server 2008. It is FREE and available to download from web. Microsoft SQL Server 2008 Express with Tools (SQL Server 2008 Express) is a free, easy-to-use version…

SQLAuthority News – Two Promotion to Help Community

February 5, 2009

Pinal Dave

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

Microsoft Certifications, SQL Jobs

In this difficult time of recession I have two promotion to share with SQL Server community. 1) Discount on Microsoft Exams and Free Second Retake Due to bad job market, the ratio to available jobs to available candidates is lower than usual. Microsoft exams are key to stand up in…

SQLAuthority News – Download SQL Server 2008 System Views Poster – PDF – A Wall Poster

February 3, 2009

Pinal Dave

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

Best Practices, Database, SQL Download

Microsoft has published SQL Server 2008 System Views Poster. This poster should be must have poster for any SQL Server Developer. I have this poster on my wall. If you have extra copy of this postered in print. Do send it to me and I will forward it to developer…

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

February 1, 2009

Pinal Dave

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

Database, 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…

SQL SERVER – 2008 – 2005 – Rebuild Every Index of All Tables of Database – Rebuild Index with FillFactor

January 30, 2009

Pinal Dave

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

SQL Cursor, SQL Index, SQL Scripts

I just wrote down following script very quickly for one of the project which I am working on. The requirement of the project was that every index existed in database should be rebuilt with fillfactor of 80. One common question I receive why fillfactor 80, answer is I just think…

SQLAuthority News – Download Cumulative update package 3 for SQL Server 2008

January 27, 2009

Pinal Dave

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

SQL Download, SQL Service Pack

For almost one year I have been using SQL Server 2008 and I keep watch on its update. Cumulative Update Package 3 has been made available now. Latest SQL Server 2008 version is 10.0.1787.0. Download Cumulative update package 3 for SQL Server 2008 Abstract courtesy : Microsoft Reference : Pinal…