All Articles - SQL Authority with Pinal Dave

SQL SERVER – Fix : Error : Invalid object name ‘sys.configurations’. (Microsoft SQL Server, Error: 208)

December 8, 2009

As you all know that SQL Azure CTP has been released; here, I have included a step-by-step guide for how to configure the CTP: SQL SERVER – Azure Start Guide – Step by Step Installation Guide. For pricing and introduction, please read SQLAuthority News – SQL Azure – Microsoft SQL…

SQL Server – White Paper – An Introduction to Fast Track Data Warehouse Architectures by Erik Veerman

December 7, 2009

Pinal Dave

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

Business Intelligence, Data Warehousing, SQL White Papers

An Introduction to Fast Track Data Warehouse Architectures SQL Server Technical Article Writer: Erik Veerman, Solid Quality Mentors Technical Reviewer: Mark Theissen, Scotty Moran, Val Fontama Published: February 2009 The performance and stability of any application solution—whether line of business, transactional, or business intelligence (BI)—hinges on the integration between solution…

SQL SERVER – White Papers – Consolidation Guidance for SQL Server – Consolidation Using SQL Server 2008

December 6, 2009

Pinal Dave

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

Database, SQL White Papers

Consolidation Using SQL Server 2008 Writer: Allan Hirt, Megahirtz LLC (allan@sqlha.com) Technical Reviewers: Lindsey Allen, Madhan Arumugam, Ben DeBow, Sung Hsueh, Rebecca Laszlo, Claude Lorenson, Prem Mehra, Mark Pohto, Sambit Samal, and Buck Woody Published: October 2009 What are the considerations when creating a consolidation plan for my environment? What…

SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore

December 5, 2009

Pinal Dave

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

MVP, SQL Scripts, SQLAuthority Author Visit

I recently had opportunity to attend TechDays 2009 Infosys. The dates of the event was Nov 16-17, 2009. This event was the largest technology conference by Microsoft in Infosys. Microsoft Tech Days focused on positioning Microsoft as the company to bet on for future technology investments by businesses and consumers…

SQL SERVER – 2008 Star Join Query Optimization

December 4, 2009

Pinal Dave

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

Best Practices, Business Intelligence, Data Warehousing, SQL Joins

Business Intelligence (BI) plays a significant role in businesses nowadays. Moreover, the databases that deal with the queries related to BI are presently facing an increase in workload. At present, when queries are sent to very large databases, millions of rows are returned. Also the users have to go through…

SQLAuthority News – Airline Review – Paramount, Kingfisher, Go Air, Indigo, Jet Airways, Indian Airlines, Spicejet

December 3, 2009

Pinal Dave

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

SQLAuthority Author Visit

First of all, this is a totally different article that I have ever written on this site. As the regular readers of my blog are aware that I am always traveling due to my different assignments at work. In last two months, I have been on flight for 36 times;…

SQL SERVER – Validate an XML Document in TSQL using XSD by Jacob Sebastian

December 2, 2009

Pinal Dave

SQL

SQL Scripts, SQL Server, SQL XML

Let us learn about XML Document in TSQL using XSD by Jacob Sebastian.

SQLAuthority News – A Daily Doze of Technology – Alvin Ashcraft’s Morning Dew

December 1, 2009

Pinal Dave

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

A common question that I receive is regarding how I keep myself updated with latest information about technology and what is going on at present. I read lots of blogs and books. I am usually traveling 4 days in my any regular work week. I read physical books at the…

SQL SERVER – Size of Index Table for Each Index – Solution

November 30, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

Earlier I have posted small question on this blog and requested help from readers to participate here and provide solution. Please read the original Puzzle here. SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table The puzzle was to write…

SQL SERVER – Azure Start Guide – Step by Step Installation Guide

November 29, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure

As SQL Azure CTP is released I have included here step by step guide for how to configure the CTP. For pricing and introduction please read SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing First it has to be configured online at Login using…