SSMS Output Window

In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time....

Automation and cleaner code/data are the key to future success

This blog post is a copy of a post I wrote for SQL Masters Consulting as part of T-SQL Tuesday....

Book Review – Analyzing Data with Microsoft Power BI and Power Pivot for Excel

As preparation for my session at Techorama.be about data modeling in self-service BI, I decided to read the book Analyzing Data...

Profiler for Extended Events: Quick Settings

Not long ago, I wrote a rather long article about a new-ish feature within SQL Server Management Studio (SSMS) that...

Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Database-level

Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However,...

The 700 Milestone

I’ve watched various SQL Saturday milestones go by. I missed 100 in Brazil, but did manage to get to 200...

What's New In SQL Server 2017? at the March '18 Baton Rouge SQL Server User Group

Thanks to everyone to attended the BRSSUG meeting tonight at our sponsor's location at the Baton Rouge Alliance Safety Council location and their awesome classroom training facility.See you next...

Why contractors need recruitment agents?

Welcome to WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent...

Dates and Times in SQL Server: TIME

This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...

Every Single Execution Plan is an Estimated Plan

All the execution plans are estimated plans. All of them. There fundamentally isn’t any such thing as an “Actual” plan.

Where...