iFTS Best Practices

This blog offers a number of Best Practices surrounding the Integrated Full Text Search (iFTS) feature in SQL Server 2008 ... Source : SQLCAT Team - Blog Post

Implementing Database Object Schemas

A great whitepaper explaining the benefits of Database Object Schemas. As well as listing a number of best practices, it explains how schemas can be used to protect database objects from unintended access/modification as well as simplifying administration ... Source : Michael Redman - MSDN.com - Technical Article

Inside Resource Governor

In this post, Boris takes us through the setup and execution of a Resource Governor demo, and in doing so, exposes some of the nuances of how it works ... Source : Boris Baryshnikov - Technet.com - Blog Post

Integration Services: Performance Tuning Techniques

This white paper describes common performance-tuning techniques that you can apply to your SQL Server Integration Services (SSIS) data integration solutions ... Source : Microsoft.com - TechNet Article

Lock Escalation & Trace Flags

By default, SQL Server will choose the appropriate lock granularity & escalation points. This can be overridden with trace flags and query hints, however, as Sunil points out, there are various limitations with doing so ... Source : Sunil Agarwal - MSDN.com - Blog Post

Login Failures after a Mirroring Failover

One of the crucial aspects of a successful database mirroring installation is ensuring logins work at both ends (principal and mirror). As Chad points out, the SIDs for SQL Server logins need to match to ensure a smooth failover process ... Source : Chad Boyd - MSDN.com - Blog Post

MemToLeave and 32-bit SQL Backup failures

A common symptom of MemToLeave issues on 32 bit systems are backup failures with "reserve contiguous memory" related errors. In this post, Joe discusses adjusting the BufferCount and MaxTransferSize as an alternative to increasing the MemToLeave value (-g switch) ... Source : Joe Chang - SQLBlog.com - Blog Post

Microsoft Assessment and Planning (MAP) Toolkit

Version 3.2 of the MAP tool now includes a SQL Server Instance Discovery module, a fantastic tool for planning an Enterprise consolidation or upgrade project ... Source : Ward Pond - Technet.com - Blog Post

Minimal logging in SQL Server 2008

It was in, then it was out, and now it's back in again. Check out this post regarding the new Minimal Logging feature in SQL Server 2008 ... Source : SQL Server Storage Engine - Blog Post

One of the (many) benefits of Stored Procedures

In addition to reducing Adhoc SQL induced cache bloat, Stored Procedures increase security by avoiding the need to grant permissions to underlying tables. In this post, Tony Rogerson uses an example of a recent SQL Injection Robot to highlight this point ... Source : Tony Rogerson - SQLBlogcasts.com - Blog Post