Adding File to Database in AlwaysOn Availability Group

When a database is part of AlwaysOn Availability Group, it means whatever commands we are executing on Primary replica database,...

Friday Reading 2018-07-27

Phew, I’m not going to complain about the hot weather…I’ll miss it when it’s gone.
Linux Load Averages: Solving the Mystery

Good...

Getting Schooled by Brent

Earlier this year Brent Ozar invited me to attend some of his online classes for free. Free is good! Training...

How to handle big numbers in SSAS Tabular

Intro

Intro
I have recently faced the issue of handling big numbers in SSAS Tabular. Our SSAS model processes accounting data for...

I’m speaking at SQL Saturday 749 : Baton Rouge

Hello Louisiana! It’s that time of year again. I’ll be speaking on Saturday August 11th in Baton Rouge with many...

Power BI new feature: Composite models

There are two really great features just added to Power BI that I wanted to blog about: Composite models and...

T-SQL Tuesday #104 Roundup

This month’s T-SQL Tuesday topic asked “What code would you hate to live without?” Turns out you like using script...

Keep up with SQL Server Patches!

Keep up with SQL Server Patches with us with our feed from Microsoft.  Check it out!  http://vitamindba.com/sql-server-releases/
The post Keep up with...

Quickly Change SQL Job Owners

It is not unusual to find a server where some random user created a bunch of jobs to be run...

Selecting a Random Row From a Table

A couple of times recently I’ve seen the question asked, ‘How can I select a single row at random from...