Data Warehouse Performance in SQL 2008
A great overview of the Data Warehousing improvements in SQL 2008 including Star Joins, Partitioned Tables, Data Compression and Partition Aligned Indexed Views ... Source : Microsoft.com - Technet Article
Source Code Analyzer for SQL Injection
To help against the increasing amount of SQL Injection attacks, Microsoft has released a tool to analyze ASP and ASP.NET source code for SQL Injection vulnerabilities. This blog post provides a link the download along with a description of the tool including code examples for analyzing directories of multiple asp files. ... Source : Microsoft.com - MSDN Blog Post
Duplicate Indexes
Some great scripts from Paul to find duplicate (or overlapping) indexes ... Source : Paul Nielsen - SQLBlog.com
Trace Replay Tools
This post discusses the pros and cons of two trace replay tools used to simulate production load in test environments; SQL Profiler and Ostress, now included in RML Utilities. As well as providing a description of each tool, the post provides recommendations on which tool is appropriate for different scenarios ... Update; This codeplex tool can also be used to generate a load test using a Profiler trace ... Source : Microsoft SQL ISV Program Management Team - Blog Post
Configuring Report Server Databases
The latest instalment of the "Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series". This article focuses on the configuration of the ReportServer and ReportServerTempDb databases. Update; Also in this series is a comparison of scaling up Reporting Services solutions in 2008 compared to 2005 ... Source : SQLCat.com - Article
SQL Server & Firewalls
With Windows Server 2008 being the first Server OS to enable the Windows Firewall by default, now is a great time to review the SQL Server firewall strategy. This post provides a five step approach for achieving best practice firewall configuration for SQL Server ... Source : Microsoft.com - MSDN Blog Post
sys.dm_exec_requests
The sys.dm_exec_requests DMV comes in handy for troubleshooting a variety of performance problems, but as Aaron points out, the BOL entries on this DMV are limited. In this post, Aaron shows us a variety of ways it can be used in troubleshooting various issues ... Source : Aaron Bertrand - SQLBlog.com
T-SQL Enhancements in 2008
T-SQL Legend Itzik Ben-Gan takes us on a tour of the new T-SQL features in 2008 including MERGE, Table Valued Parameters, HIERARCHYID and lots more ... Source : Microsoft.com - MSDN Article
sp_indexinfo
A fantastic proc from Tibor that returns index information from a number of DMVs. Among other information, it returns the indexes for a table, the type of index (clustered or non clustered), the included columns, how often the index is used and the space taken by the index. Great stuff Tibor ... Source : karaszi.com - Article
A Brief History of SQL Server (1989 - 2000)
One of the chapters from an earlier edition of Kalen Delaney's "Inside SQL Server" books is a history of the product from 1989. This chapter was removed from the 2005 version of the book but is available online as a pdf. This is a fascinating read for anyone with an interest in SQL Server or RDBMS technology in general. Thanks Kalen! ... Source : insidesqlserver.com
Filtered Indexes
Grumpy takes us through one of the benefits of Filtered Indexes - reducing the maintenance impact for 24/7 operations ... Source : Grumpy Old DBA - sqlBlogCasts.com - Blog Post