This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, and more.  Read more...

A synonym is a new object to SQL Server 2005. It is a way to give an alias to an already existing object. For example, if you have a table named SalesHistoryFromArchiveF  Read more...

SQL Server 2005 has so many new features that in my opinion if you read only BOL for a year you'd find something new every day. One of those is Multiple Active Result Sets or MARS. Multiple Active Result Sets is a new SQL Server 2005 feature that, putting it simply, allows the user to run more than one SQL batch on an open connection at the same time.  Read more...

Reporting Services is one of the most widely used subsystems in SQL Server and there have been some very creative solutions invented by DBAs around the world. New author Carolyn Richardson is one of those, bringing us a implementation that tracks uptime and disk space for her SQL Servers   Read more...

The next evoution of T-SQL, which will be released in SQL Server 2005, contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Coming ever so closer to the SQL-99 specification with Common Table Expressions, new author Srinivas Sampath brings us an introduction to this new way of writing complex queries.   Read more...

Grant Fritchey steps into the workbench arena, with an example-fuelled examination of catching and gracefully handling errors in SQL 2000 and 2005, including worked examples of the new TRY..CATCH capabilities.  Read more...

What is the page size in SQL Server 2005? That's an easy question, but what is the maximum row size? They're not the same thing and ANdy Warren shows you why.   Read more...

Arthur Fuller recently instructed a colleague on how to automate the process of trimming table data in SQL Server 2005. Find out how he is able to turn an onerous task into a breeze.  Read more...

Learn how to merge and split existing partitions.   Read more...

It's nice to have little amenities in your development tools. They make for easier development and can save you a little time. Synonyms is one of those tools.  Read more...

SQL Server 2005 has changed many of the ways in which we will use SQL Server in the future with a dizzying array of new features and enhancements. Sureshkumar Ramakrishnan brings us the second part in a series looking at what these changes do and how to use them.   Read more...

One of the most requested features from SQL Server developers is the integration of source control with T-SQL code. SQL Server Management Studio brings some integration with Visual Source Safe and longtime SQL Server author Raj Vasant explains it to us.   Read more...

SQL Server 2005 has changed many of the ways in which we will use SQL Server in the future with a dizzying array of new features and enhancements. Sureshkumar Ramakrishnan brings us the first part in a series looking at what these changes do and how to use them.   Read more...

Part III of the article series illustrates how to partition an existing table with data into four different file groups.  Read more...

If you create functions or stored procedures from SQL Server 2005 Management Studio, you will notice that the new window is filled with a template. In general, you get a skeleton interspersed with markers. This article discusses how you can use templates.   Read more...

Learn how to make life easier by dividing large tables and indexes into smaller parts.  Read more...

This article discusses how to upload multiple image or text files to the SQL Server database varbinary column.  Read more...

The aim of this article is to show you how to make full use of SQL 2005 query notification with ASP.NET 2.0. It tackles the implementation details largely from SQL Server's perspective and includes many DBA tips and tricks for troubleshooting query notification.   Read more...

In this article, we examine some of the best new features and characteristics available in the 2005 version.  Read more...

So, you’ve just installed SQL Server 2005 but don’t know how to configure it. This video will instruct you how to use the SQL Server 2005 Surface Area Configuration tool to turn on SQL Server features like CLR integration and how to enable ports. Free registration required.   Read more...