How to sync user logins across SQL Server instances – dbatools is brilliant

This blog post is about how brilliant dbatools are. In this case – for syncing user logins between SQL Server instances.
Background:
Whenever...

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...