SQL Documentation Archives - Page 6 of 20 - SQL Authority with Pinal Dave

SQLAuthority News – SQL Server 2008 SP3 Available to Download

October 15, 2011

This news is one week late but still very useful as per my perspective. Please note this are for SQL Server 2008 and will not work with SQL Server 2008 R2. SQL Server 2008 Service Pack 3 Enhanced upgrade experience from previous versions of SQL Server to SQL Server 2008…

SQLAuthority News – System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance

October 9, 2011

Pinal Dave

SQL Tips and Tricks

Database, SQL Documentation, SQL Download

Microsoft is continuously releasing System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance

SQL SERVER – SQL Backup and FTP – A Quick and Handy Tool

October 3, 2011

Pinal Dave

SQL Tips and Tricks, SQLAuthority News

SQL Backup and Restore, SQL Documentation, SQL Download, SQL Utility

Scroll down at the end of this post to win my SQL Wait Stats Book. I have used this tool extensively since 2009 at numerous occasion and found it to be very impressive. What separates it from the crowd the most – it is it’s apparent simplicity and speed. When…

SQL SERVER – CE – List of Information_Schema System Tables

October 2, 2011

Pinal Dave

SQL Tips and Tricks

SQL Documentation, SQL Download

Yesterday I wrote blog post that I downloaded WebMatrix and it was very easy to install, after installing I noticed it has default database as SQL CE. I started to play with SQL CE and I was glad that it supports many of the Information_Schema. There is one important thing…

SQL SERVER – CE – Samples Database for SQL CE 4.0

October 1, 2011

Pinal Dave

SQL Tips and Tricks

SQL Documentation, SQL Download

I recently installed WebMatrix Version Next. I found it very neat and easy to install. You can download it for FREE. After installing it I download when I checked the about page, it displayed following result. ————————— About WebMatrix ————————— Version 2 Beta WebMatrix: 7.1.1307.1 IIS 7.5 Express: 7.1.1307.1 .NET…

SQL SERVER – Denali – Download CTP3 Demo VHD Including Fully Configured Services and Integration with SharePoint 2010 and Office 2010

September 24, 2011

Pinal Dave

SQL Tips and Tricks

SQL Documentation, SQL Download

During my office hours observed, a very common question is”What is Denali?” once I answer that Denali is the next version of the SQL Server, the follow up question is where can I download it. I have explained the installation and download part over here: SQL SERVER – Denali CTP3…

SQLAuthority News – Implementing a Microsoft SQL Server Parallel Data Warehouse Using the Kimball Approach

September 18, 2011

Pinal Dave

SQL Tips and Tricks

SQL Documentation, SQL Download, SQL White Papers

This white paper explores how the Kimball approach to architecting and building a data warehouse/business intelligence (DW/BI) system works with Microsoft’s Parallel Data Warehouse, and how you would incorporate this new product as the cornerstone of your DW/BI system. For readers who are not familiar with the Kimball approach, we…