SQL Homework – December 2018 – Configure SSMS

I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of...

SHUTDOWN SQL Server

I explore the question of if it is possible to reboot the server from within SQL Server or even simply shut down the entire server. Well, you can certainly...

SHUTDOWN SQL Server

Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL Server....

Deadlocks in a SQL Server Database

Deadlocks in SQL Server happen when 2 (maybe more) processes are fighting over a resource in the database and are...

Epic Life Quest – looking back

This will be my last post for the year. In this am going to look back on goals I set...

Three tips to help your database team avoid burn out this holiday season

As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of the busiest and most stressful times of the year...

Three tips to help your database team avoid burn out this holiday season

As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of...

Getting SQL Services, Starting, Stopping and Restarting them with dbatools

There was a question in the #dbatools slack channel 

Getting dbatools
dbatools enables you to administer SQL Server with PowerShell. To get...

Turbo Charged Staging\Caching Tables With In Memory OLTP

Since SQL 2012 some really awesome new technologies have been introduced into the engine that are massively underused. Everyone is...

We Speak Linux – OpenSSH For Windows Pros

I’m proud to announce that I will be speaking at this months We Speak Linux Webinar. Each month We Speak Linux brings cross platform training to the Windows world....