Hands-On Data Analysis With Power BI Desktop at PASS BA Marathon

I’m delighted to announce I’ll give a session at the next PASS BA webinar marathon. The topic of this marathon...

How Row versioning impact tempDB ?

Scenario: DBA found that tempdDBdatabase usage is getting high and most of the size is consumed by row versioning. DBA...

Monday Coffee 2017-03-06

Last week Docker announced the availablity of Docker Enterprise Edition. The existing version of Docker that I’ve been using has...

Queries with optional parameters

These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or...

SQL Clone

Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server...

SQL Server Fixed Role Permissions

It is very important to understand who has what level of access within the server and databases on that server. Sometimes we see users being granted server or database...

Using GROUP BY instead of DISTINCT

Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers GROUP...

The Ebb & Flow of Community Participation

It’s an interesting moment when you discover the SQL community (or any other I suppose). It’s the moment of finding the...

Using dbatools for automated restore and CHECKDB

OK, so if you haven’t heard of the dbatools.io project run by Chrissy LeMaire and company…you’ve likely been living under a rock. I strongly encourage you to check it out...

This blog post is just a quick follow from my presentation last week for the SQL PASS PowerShell Virtual Chapter....