Understanding the new MAXDOP settings in SQL 2016

If you have just begun using SQL Server 2016 or you have been using it for a while now you...

Restore through FULL backup

Problem

A common misconception that i've heard a few times around backups is that a FULL backup invalidates previous TRANSACTION LOG...

Power BI Custom Visuals Class (Module 19 – Chiclet Slicer)

In this module you will learn how to use the Chiclet Slicer Power BI Custom Visual.  The Chiclet Slicer is...

Off Again

It’s another week of travel for me, starting early this morning. This is another crazy trip, and yes, I did...

My SQL Prompt GitHub Repo

Last year I published an article on SQLServerCentral from Guarab Vohra on using SQL Prompt with a VCS. I really...

Future DBA – Big Data -MongoDB 2

In our earlier blog we discussed an introduction to MongoDB. so, how is MongoDB is into BigData, MongoDB has a...

Upcoming Webinars: What’s New in SSRS and MDS 2016

I’ll be delivering two webinars for MSSQLTips.com in the coming months. The first one is about the – amazing – new features...

SQL 2016 SSMS memory leak?

Has SSMS (SQL Server Management Studio) been crashing on you? Have you been getting Out of Memory messages when attempting...

Detaching corrupt databases

Question – Can you detach a corrupt database? Answer – IT DEPENDS! More specifically it depends on the SQL Server version. SQL...

PowerShell: Extending Modules – System Parameter measurement

The Microsoft Technet Guru Award  (August 2016) winning article  – Silver
PowerShell: Extending Modules – System Parameter measurement

PowerShell: Extending Modules – System Parameter measurement

Abstract
The...