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

SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.2

September 12, 2009

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

This download package is intended for Microsoft Premier Customers Only. This package includes all of the scoping tools necessary to prepare and qualify your environment to receive a Risk and Health Assessment Program for Microsoft SQL Server. Download Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool…

SQL SERVER – Importance of Database Schemas in SQL Server

September 7, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation

Beginning with SQL Server 2005, Microsoft introduced the concept of database schemas. A schema is now an independent entity- a container of objects distinct from the user who created those objects. Previously, the terms ‘user’ and ‘database object owner’ meant one and the same thing, but now the two are…

SQL SERVER – Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

September 4, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence, SQL Documentation, SQL Download, SQL White Papers, SQLAuthority Author Visit

In my recent Business Intelligence Training Roadshow August September 2009 I quite often get request to provide more details about Analysis Service Cubes for Excel 2007 PivotTable. Here is the white paper on the same subject. Microsoft Office Excel 2007 takes advantage of most of the features in Microsoft SQL…

SQLAuthority News – Application and Multi-Server Management

August 30, 2009

Pinal Dave

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

Business Intelligence, Data Warehousing, SQL Documentation, SQL Download, SQL White Papers

SQL Server 2008 R2 – Application and Multi-Server Management SQL Server Technical Article Title: SQL Server 2008 R2Application and Multi-Server Management Introduction Writers: Geoff Allix Technical Reviewers: Joanne Hodgins, Omri Bahat, Morgan Oslake Published: February 2010 SQL Server 2008 R2 introduces new management tools to help improve IT efficiency and…

SQL SERVER – Plan Caching in SQL Server 2008

August 29, 2009

Pinal Dave

SQL

SQL Cache, SQL Documentation, SQL Download, SQL Server, SQL White Papers

Plan Caching in SQL Server 2008
SQL Server Technical Article
Writer:Greg Low, SolidQ Australia
Technical Reviewers From Solid Quality Mentors: Andrew Kelly, Eladio Rincón, Itzik Ben-Gan
Technical Reviewers From Microsoft: Adam Prout, Campbell Fraser, Xin Zhang
Published: August 2009

SQL SERVER – Introduction to SQL Azure

August 27, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Cloud Computing, SQL Azure, SQL Data Storage, SQL Documentation

What is SQL Azure? In short, SQL Azure is simply a Microsoft branding change. SQL Services and SQL Data Services are now known as Microsoft SQL Azure and SQL Azure Database. There are a few changes, but fundamentally Microsoft’s plans to extend SQL server capabilities in cloud as web-based services…

SQLAuthority News – SQL Server 2008 Migration White Papers

August 23, 2009

Pinal Dave

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

MySQL, SQL Documentation, SQL Download, SQL Migration, SQL White Papers

Quite often I get project when I am asked to migrate different database to SQL Server. Microsoft has excellent white papers written for this series. Guide to Migrating from MySQL to SQL Server 2008 In this migration guide you will learn the differences between the MySQL and SQL Server 2008…