Introduction to Parallel Query Execution

SQL Server has the ability to execute queries using multiple CPUs simultaneously.  We refer to this capability as parallel query execution.  … [Read more...]

Determining Drive Letters in Use by SQL

Problem Auditing a SQL Server environment and determine what drive letters are in use by each instance. You can query sys.database_files for each … [Read more...]

SQL Server Partition Wizard

The T-SQL code to create partition functions, partition schemes, and then altering the table to use the partition can be overwhelming for some … [Read more...]

Texting Alerts from SQL Server Database Mail

The Issue: You need to get alerts from my SQL Server databases 24/7, but you don't always carry your laptop to check email and when you do, you may … [Read more...]

Top 10 Transact-SQL Statements a SQL Server DBA Should Know

Directions Training's Microsoft SQL Server training experts wanted to share this helpful "Top 10" Microsoft SQL Server tip sheet. The top 10 T-SQL … [Read more...]

Top Ten Reasons to Use MS SQL Server 2012 Part 2

Directions Training is well known for its Microsoft SQL Server training to IT professionals. This MS SQL Server training post is in continuation from … [Read more...]

Top Ten Reasons to Use MS SQL Server 2012 Part 1

1. AlwaysOn SQL Server Failover Cluster Instances Multi-subnet failover clusters: A SQL Server multi-subnet failover cluster is a configuration … [Read more...]