This article demonstrates how to manage the development of complex queries by building them in stages with temporary tables, table variables and common table expressions.

The Window Is Shrinking

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve talks about security and the fact that your window for lax security is shrinking for new applications.

Automatically Capturing SQL Server Performance Metrics

by Additional Articles

Database Journal

This article looks to provide a method that you can use to collect the author's top 10 SQL Server performance metrics automatically over time.

Hardware Hacking

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones examines one of the issues of foreign chip production: security. Will this be an attack vector in the future?

Hidden RBAR: Counting with Recursive CTE's

by Jeff Moden

SQLServerCentral.com

T-SQL

"Counting" is essential to many high performance code techniques. SQL Server MVP, Jeff Moden, shows us how to make sure that we're "Counting" and not "Crippling" our trick-code.

TSQL Challenge 62 - Break a long sentence in groups of 5 words

by Jacob Sebastian

SQLServerCentral.com

T-SQL Challenges

Read the input string and break each sentence into groups of 5 words. A row may contain more than one sentence. Each sentence in the input should start a new group.

What SQL Server Books Do You Recommend

by Brad McGehee

SQLServerCentral.com

Editorial

Brad's noticed that there are fewer good books about SQL Server on the shelves, and asks which books you'd recommend to people who are new to SQL Server

Adding the Script Task to Your SSIS Packages

by Additional Articles

SimpleTalk

Script Task

Script tasks are a great way of extending SSIS functionality, when none of the built-in components are quite right for the task you need to perform. But how to go about creating a script task? No worries, once again Robert Sheldon is on hand to provide easy instructions on how to do it.