ITIL certification for DBAs – Part 1

 
In some point of your career as DBA you might have interacted with ITIL or at least your heard about...

ITIL certification for DBAs – Part 2

 
In my previous post I did my best explain a little bit what ITIL is and how important is for...

Ohhhhhh S…t!! A tribute to Robert Davis

Today marks 3 days since we’ve lost Robert Davis a.k.a SQLSoldier, one of the pillars of SQL Family community.

I was...

4 Improvements to Azure SQL Database

If I was a wizard I would make these 4 improvements to Azure SQL Database. They are in no particular...

Adding the KeyMap Extension in SQL Operations Studio

I’m playing with SQL Operations Studio a bit to get a feel for what works and what doesn’t. So far,...

Azure SQL DW – Let’s Shuffle?

Initially, the main focus of this post was going to be quick and about using the latest version of SSMS...

Change SQL Server Collation – Back to Basics

Every now and again we have to deal with a sudden requirements change. When that happens, we sometimes just need to take a step back and evaluate the entire...

DBA Fundamentals–Tuesday 11 Central–Execution Plans

WHAT:       EXECUTION PLANS FOR BEGINNERS
WHEN:       Tuesday,    04/17/18  - 11:00 am – 12:00 pm
WHO:         Thomas LeBlanc
WHERE:     https://attendee.gotowebinar.com/register/7086336336602188044
This will be a Beginners session highlighting the starting point for using the...

Deleting a lot of data

I recently had the task of deleting a bit over a billion rows from a table. Now I could have...

Machine Learning Server at the CBusPass User Group

Come out Thursday, April 12 to learn how to leverage Microsoft Machine Learning Server. Machine Learning Server HopATopBikeShop BACPAC and Demo Scripts