Feeds:
Posts
Comments

Archive for November, 2009

SQL SERVER – Whitepaper Consolidation Using SQL Server 2008

Posted in SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology on November 15, 2009 | Leave a Comment »

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 Microsoft SQL Server instances and [...]

Read Full Post »

SQLAuthority News – Disk Partition Alignment Best Practices for SQL Server

Posted in Best Practices, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology on November 14, 2009 | Leave a Comment »

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: Mike Ruthruff, Robert Smith, Bruce [...]

Read Full Post »

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

Posted in Database, Pinal Dave, Software Development, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on November 13, 2009 | 4 Comments »

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 the system. It also provides [...]

Read Full Post »

SQL SERVER – Disable CHECK Constraint – Enable CHECK Constraint

Posted in Pinal Dave, SQL, SQL Authority, SQL Constraint and Keys, SQL Index, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on November 12, 2009 | 11 Comments »

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. USE AdventureWorks GO – Disable the constraint ALTER TABLE [...]

Read Full Post »

SQL SERVER – Sharepoint Resource Available for SQL Server

Posted in SharePoint, SQL, SQL Authority, SQL Documentation, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology on November 11, 2009 | 2 Comments »

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 firewall. The accelerator allows users [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers