November 2009 - Page 3 of 5 - SQL Authority with Pinal Dave

SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle

November 16, 2009

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

Update: Do not forget to checkout last three photos and follow me on twitter (of course!) I have previously documented my four-day experience of SQL PASS 2009 Summit at Seattle. There were many reasons for SQL enthusiasts to attend the SQL PASS event; I am listing my own reasons here…

SQL SERVER – Whitepaper Consolidation Using SQL Server 2008

November 15, 2009

Pinal Dave

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

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 Many companies are considering or have already implemented consolidation of computing resources, including…

SQLAuthority News – Disk Partition Alignment Best Practices for SQL Server

November 14, 2009

Pinal Dave

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

Best Practices, SQL White Papers

Disk Partition Alignment Best Practices for SQL Server Writers: Jimmy May, Denny Lee Contributors: Mike Ruthruff, Robert Smith, Bruce Worthington, Jeff Goldner, Mark Licata, Deborah Jones, Michael Thomassy, Michael Epprecht, Frank McBath, Joseph Sack, Matt Landers, Jason McKittrick, Linchi Shea, Juergen Thomas, Emily Wilson, John Otto, Brent Dowling Technical Reviewers:…

SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies

November 13, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Policy Management, Software Development, SQL Scripts

Introduction This article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful difference. Policy based management is loaded with several advantages. It can help you implement various policies for reliable configuration of…

SQL SERVER – Disable CHECK Constraint – Enable CHECK Constraint

November 12, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Index, SQL Scripts

Foreign Key and Check Constraints are two types of constraints that can be disabled or enabled when required. This type of operation is needed when bulk loading operations are required or when there is no need to validate the constraint. The T-SQL Script that does the same is very simple.…

SQL SERVER – Sharepoint Resource Available for SQL Server

November 11, 2009

Pinal Dave

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

SharePoint, SQL Documentation, SQL White Papers

Here is quick list of the tools which are available for SQL Server and Sharepoint. These are recently updated resources from Microsoft. External Collaboration Toolkit for SharePoint This solution allows users to create collaboration environments that use the familiar SharePoito deploy a SharePoint-based environment for collaboration with people outside your…

SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning

November 10, 2009

Pinal Dave

SQLAuthority News

SQL Index, SQL Server, SQL Training

This is very short note announcing details about my course details for ‘Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning’.