New indexes, hypothetically

I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought...

Trick or Treat...Have I got an IT Training treat for you...

It Trick or Treat on Monday...Two days on and I have a treat for you. Learning Tree's Great Value IT...

SQL Server DMA v2.0 – Migration Time

In my last post I showed you how to conduct an assessment using DMA – Database Migration Assessment tool v2.0 This...

SQL : How to Find Unused Indexes details

The Dynamic Management View (DMV) named sys.dm_db_index_usage_stats that track  index usage details of the database. This DMV gives an information about...

SQL Split String Function (STRING_SPLIT in 2016)

* originally published in our old blog in August 2011 - updated with SQL Server 2016 reference

As a SQL Server developer you are often faced with the need to...

SQL Split String Function (STRING_SPLIT in 2016)

* originally published in our old blog in August 2011 - updated with SQL Server 2016 reference

As a SQL Server developer you...

PASS Summit Announcements: Azure Analysis Services

Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception.  I’m writing a set...

Creating Custom Databases with SQL Prompt

SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself...

Stored Procedures Are Not Faster Than Views

A performance tuning tip I saw recently said, “Views don’t perform as well as stored procedures.”
<sigh>
Let’s break this down, just...

SQL Server Infrastructure and Virtualization Boot Camp

I am proud to announce the availability of our new training offerings! We are launching a live web-based version of our...