Backing Up Multiple Databases in an Instance of SQL Server

Sometimes things that seem complicated are much easier than you think and this is the power of using T-SQL to take care of repetitive tasks. One of … [Read more...]

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...]

SQL Server – Using REPLACE in an UPDATE Statement

This blog covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and also … [Read more...]

How to Import a Text File into SQL Server 2012

Importing a Text File into SQL Server 2012 using the OpenRowSet() Function The OPENROWSET bulk row set provider is accessed by calling the … [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...]

Data Quality Services in SQL Server 2012

Introduction Microsoft SQL Server 2012 Data Quality Services (DQS) is a powerful tool that can help your IT teams (especially QA and testers) … [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...]

MS SQL Server 2012 Editions

Microsoft SQL Server 2012 training experts, Directions Training has put together an easy to understand reference guide explaining each of the various … [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...]