SQL Server 2016: Soaring to new heights

With enhanced performance features, full cloud integration, and industry-leading security features, SQL Server 2016 is providing organizations with … [Read more...]

Get a Free Upgrade to MCSA – Windows Server and SQL Server

Don’t put off your MCSA training and certification any longer—the FREE upgrade offer is back! The life of an IT Pro can be hectic. Believe us, we … [Read more...]

[Chicagoland Event] Free SQL Server 2016 TechClinic

Want a hands-on look at what’s new in SQL Server 2016?  Need a database that supports business critical applications securely?  Want one that offers … [Read more...]

What SQL Server 2005 End-of-Service Means for Your Business

Still running SQL Server 2005? As of April 12, Microsoft stopped supporting SQL Server 2005. This means it’s time to upgrade to SQL Server 2014, SQL … [Read more...]

Microsoft Transact SQL (T-SQL) Demystified

The example SQL script includes Line Numbers for ease of reference and reflects the default SQL Server Management Studio (SSMS) color coding scheme as … [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...]

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

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