Power BI Custom Visuals Class (Module 21 – Advanced Time Slicer)

In this module, you will learn how to use the Advanced Time Slicer Power BI Custom Visual.  The Advanced Time...

Power BI Custom Visuals Class (Module 23 – Sparkline)

In this module you will learn how to use the Sparkline Power BI Custom Visual.  The Sparkline allows you to...

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 Server DMA – Data Migration Assistant V2.0

One of the benefits of twitter is that you get to hear about new tools quickly, one of the tools...

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

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

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

A Recap of PASS Summit 2016

Yes, it’s that time of the year again. It’s time for the annual PASS Summit. Just like every year, I...

DB CI: Getting Test Results in VSTS

One of the things I struggled with a bit was getting test results to appear in VSTS from my builds....

Get Backup History for All Databases in Server

Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions...