Top 20 Microsoft Classes – Are You Up to Speed?

As the year if halfway gone, and you are evaluating the remainder of your plans for training, I wanted to share with you the most recent list of Top … [Read more...]

In-Memory OLTP in SQL Server 2014

The development name for this new technology is Hekaton. It’s Greek and means 100 (hundred) which was the aim of performance improvement with this … [Read more...]

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

SQL Tip for Collapsing a Long Query

SQL Tip: Saving Code Space When Using SQL Server Management Studio Queries A long query in SSMS: Click the minus sign next to the long query … [Read more...]

Examining SQL Server’s I/O Statistics: Part 4

Part Four of Four (Capturing Multiple Reads to Table) Storing I/O Stats at Meaningful Intervals Analyzing I/O statistics gathered during peak … [Read more...]

Examining SQL Server’s I/O Statistics: Part 3

Part Three of Four: fn_virtualfilestats Using fn_virtualfilestats to Get I/O Statistics fn_virtualfilestats returns a table of I/O statistics at … [Read more...]

Examining SQL Server’s I/O Statistics: Part 2

Part Two of Four: sp_monitor Using sp_monitor to get I/O Statistics sp_monitor is a system stored procedure that produces four recordsets that … [Read more...]

Examining SQL Server’s I/O Statistics: Part 1

Part One of Four (Statistical Functions) Reading and writing to the disk is the heart of what any database management system does, SQL Server … [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...]

SQL Server TempDB Usage, Performance, and Tuning Tips

What is TempDB responsible for in Microsoft SQL Server? Global (##temp) or local (#temp) temporary tables, temporary table indexes, temporary … [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...]

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

Did You Know?…Quick Facts About Microsoft Software

Directions Training put together a quick "did you know" list about popular Microsoft software.  Take a moment and test yourself to see, did you … [Read more...]