Take a walk
When I need to clear my head, I go for a walk. When I need to think about a problem, I go for a walk.… Read More »Take a walk
SQL Server 2017 Administration Inside Out
For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind,… Read More »SQL Server 2017 Administration Inside Out
T-SQL Tuesday: The Contributing Factor
Ewald Cress writes: Find a person or several people to pick on, and tell us a shareable story or two about how they have made… Read More »T-SQL Tuesday: The Contributing Factor
Compañero Conference and SQL Modernization Roadshow
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to share some thoughts about migrating… Read More »Compañero Conference and SQL Modernization Roadshow
Speaking at SQLSaturday #635 in Vancouver this weekend
This coming weekend, at SQLSaturday #635 in Vancouver BC, I will be presenting a brand new talk about Temporal Tables, one of my favourite features… Read More »Speaking at SQLSaturday #635 in Vancouver this weekend
Where To From Fundamentals?
The Database Fundamentals series is now done. We started with understanding what a database is, and then spent a little time understanding how databases store… Read More »Where To From Fundamentals?
SQL Server Management Studio v17.0
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server, was decoupled from the server… Read More »SQL Server Management Studio v17.0
Upcoming SQLSaturdays in Alberta, Canada
Taking a short break from the Database Fundamentals series of the last few weeks, I’d like to mention some upcoming PASS community events in the… Read More »Upcoming SQLSaturdays in Alberta, Canada
SQL Modernization and Cloud Migration Talk in Calgary
On 28 February 2017, I will be speaking at Microsoft Calgary as part of a roadshow for AMTRA Solutions. Lunch will be provided. You can… Read More »SQL Modernization and Cloud Migration Talk in Calgary
Data Platform MVP Award
I am pleased to announce that I was awarded the Data Platform MVP Award by Microsoft on 1 January 2017. Nothing changes with my customers.… Read More »Data Platform MVP Award
A look back, and a look forward
Time flies. My father used to wear a t-shirt that claimed, “When you’re over the hill, you pick up speed.” I’m turning 40 in a… Read More »A look back, and a look forward
SQL Saturday in Calgary!
I am very happy (and terrified) to announce that Calgary will host its very first SQL Saturday, #607, on 29 April 2017. Noel Tan and… Read More »SQL Saturday in Calgary!
Updated Max Server Memory Script
Earlier this year I released a free T-SQL script that will calculate the correct amount of RAM you should allocate to SQL Server, assuming it is a… Read More »Updated Max Server Memory Script
Interview Questions for a SQL Server DBA
When I’m interviewing a SQL Server DBA, I have three questions that I always ask. My favourite interview question is this: “What is the difference… Read More »Interview Questions for a SQL Server DBA
What to do at PASS Summit 2016
Next week, while blog posts are scheduled as expected, I will be attending my third PASS Summit. Summit 2014 In my first year, I attended every single event… Read More »What to do at PASS Summit 2016