Dandyman provides you these useful articles related to SQL Server

>> SQL Server 2005 - Row Level Security

This whitepaper shows you on how to implement row level security with SQL 2005 [source Microsoft]

>> Dynamic Pivoting with SQL 2005

PIVOT function in SQL 2005 is nice, but it doesn't really dynamically pivot, this one helps

>> How to DEBUG a SQL .CLR stored procedure or function

One of todays most frequently asked questions, how do I debug a managed stored proc and stored proc with SQL 2005? This Microsoft Article describes how to use a debugger within Visual Studio and step into the code

>> Comparing SQL Service broker with other technologies

This blog, written by Rushi Desai compares SQL Service Broker to other Messaging Technologies

>> SQL Server datatypes

In this powerpoint presentation I give an overview of the SQL Server Datatypes, datatype precedence and how SQL datatypes should be used in .NET

>> Using the OUTPUT keyword in SQL 2005

This example shows you how to use the OUTPUT keyword

>> SQL Server Injection attacks article by Ted Malone

This great article on SQL injection attacks is on MCPMag and is written by a 'reference' in database security, fellow MCT Ted Malone

>> Advantages of a 64-bit Environment for SQL Server2005

This Whitepaper describes the Advantages of a 64-bit Environment for SQL Server2005

>> Compilation and Plans in SQL Server 2005

This document describes how SQL Server uses compilation and execution plans

>> SQL Server 2005 Integration Services

This article gives an overview of SQL Server 2005 Integration Services

>> CLR For Database Administrators - what to know

This article describes what DBA's should know about CLR integration

>> The SQL Server 2005 Database Engine Tuning Advisor

This article describes SQL Server 2005 Database Engine Tuning Advisor

>> Database Mirroring in SQL Server 2005

What is Database Mirroring in SQL Server 2005?

>> Database Mirroring: Alerting on Database Mirroring Event

This document shows how to implement alerting on Database Mirroring Event

>> Database Mirroring: Best Practices and Performance Considerations

Database Mirroring: Best Practices and Performance Considerations

>> SQL Server Enterprise Security

SQL Server Enterprise Security

>> SQL Server Service Oriented Architecture

SQL Server Service Oriented Architecture

>> Working with Indexed views in SQL Server 2005

Working with Indexed views in SQL Server 2005

>> Online Indexing Operations in SQL Server 2005

Online Indexing Operations in SQL Server 2005

>> Partitioned Tables and Indexes in SQL Server 2005

Partitioned Tables and Indexes in SQL Server 2005

>> Performance Tuning Using Waits and Queues

Performance Tuning Using Waits and Queues

>> Scalability: Internals, Troubleshooting, and Best Practices for use of Scaleout Technologies in SQL

Scalability: Internals, Troubleshooting, and Best Practices for use of Scaleout Technologies in SQL Server 2005

>> Scalability: Planning, Implementing, and Administering Scaleout Solutions with SQL Server 2005

Scalability: Planning, Implementing, and Administering Scaleout Solutions with SQL Server 2005

>> SQL Server 2005 Failover Clustering White Paper

SQL Server 2005 Failover Clustering White Paper

>> SQL Server 2005 for Oracle Database Professionals

SQL Server 2005 for Oracle Professionals

>> SQL Server 2005 Management Tools Overview

SQL Server 2005 Management Tools Overview

>> SQL Server 2005 Security Best Practices - Operational and Administrative Tasks

SQL Server 2005 Security Best Practices - Operational and Administrative Tasks

>> SQL Server 2005 Snapshot Isolation Level

SQL Server 2005 Snapshot Isolation Level

>> SQL Server I/O Basics

SQL Server I/O Basics

>> SQL Server I/O Basics

SQL Server I/O Basics

>> Statistics Used by the Query Optimizer in Microsoft SQL Server 2005

Statistics Used by the Query Optimizer in Microsoft SQL Server 2005

>> Strategies for Partitioning Relational Data Warehouses in Microsoft SQL Server

Strategies for Partitioning Relational Data Warehouses in Microsoft SQL Server

>> Troubleshooting Performance Problems in SQL Server 2005

Troubleshooting Performance Problems in SQL Server 2005

>> Working with Tempdb in SQL Server 2005

Working with Tempdb in SQL Server 2005

>> Upgrading a SQL 2000 Database to SQL 2005

This presentation describes the upgrade strategies to SQL Server 2005 for the Database Engine.The presentation was presented at SQL Connections in 2006