PASS Summit 2019

Speaking at PASS Summit 2019

I am delighted to announce that I have been selected to speak at the largest Microsoft Data Platform conference in the world, PASS Summit 2019, in Seattle WA, USA. As our database community has extended beyond SQL Server into Azure and other platforms, there’s a lot to take in over the course of three days
-> Continue reading Speaking at PASS Summit 2019

SQL Saturday 840 in Edmonton next weekend

As I mentioned last month, I will be speaking at SQL Saturday in Edmonton Alberta next weekend. I have been selected to speak for three separate sessions, on the following topics: 10:45 Managing and monitoring SQL Server on Linux from the command line This session will focus on installing, managing and monitoring SQL Server on
-> Continue reading SQL Saturday 840 in Edmonton next weekend

Using a home-grown Azure Blob Storage solution for SQL Server backups

I’m here for the small organizations, the shops that can’t afford expensive solutions to maintain their environments. I’m here for them because that’s me: the one-person consultancy. I’ve built stuff that’s useful to me, and then made it available for free on GitHub. My first SQL Saturday session, way back in 2015, was the public
-> Continue reading Using a home-grown Azure Blob Storage solution for SQL Server backups

The free SQL to Excel Export tool

Earlier this month I released a new, free tool to export SQL Server query data to Excel files¬†without needing Excel. It also installs stored procedures and runs them, if that’s what you desire. Go ahead and play with it. I’ll wait. There was some positive interest on Twitter, for which I am very grateful, and
-> Continue reading The free SQL to Excel Export tool

Canadian SQL Saturday speaking events

I am pleased to announce that I will be speaking at two separate SQL Saturdays in March and April of this year. The first event is in Victoria (the capital city of British Columbia, located on Vancouver Island), and the second is in Edmonton, the capital city of Alberta. I will be presenting the same
-> Continue reading Canadian SQL Saturday speaking events

Speaking at SQLBits in March 2019

I have been selected to speak for a second time at SQLBits, which is being hosted in Manchester UK this year from 27 February to 2 March 2019. My session is called An overview of SQL Server 2019 for the busy DBA / developer. Here is the abstract: SQL Server 2019 is a major new
-> Continue reading Speaking at SQLBits in March 2019

PASS Summit Speaker Idol 2018

This scheduled post is coming to you from Seattle, where the PASS Summit 2018 has just kicked off. Because it is a scheduled post, I have no idea what announcements from the convention will be made today and tomorrow, but rest assured that they will be worth looking at. In the meantime, I have been
-> Continue reading PASS Summit Speaker Idol 2018

Do you even PowerShell, bro? An ode to dbatools and dbachecks.

Shall I compare thee to Management Studio? Thou art more scriptable and consistent. Those out-of-memory errors do tend to lose hours of work. And I mean, SSMS doesn’t run from the command line. Sometimes I get those line-endings errors, Not to mention IntelliSense bombing out; And figuring out which tab I was in can be
-> Continue reading Do you even PowerShell, bro? An ode to dbatools and dbachecks.