A woman stands in a library

T-SQL Tuesday Retrospective #014: Resolutions

At the end of 2010, Sean McCown (blog | Twitter) invited us to talk about resolutions: Things like getting certified, or perfecting a process, or taking management classes, etc are all things that are commonly found in your yearly goals at work. So if you’re going to make some kind of resolution to do something,
-> Continue reading T-SQL Tuesday Retrospective #014: Resolutions

Post image

Speaking at SQLSaturday #710 in Edmonton on May 5th, 2018

I will be presenting twice at SQLSaturday #710 in Edmonton, on 5 May 2018. You can join me for two sessions: Back to the Future with Temporal Tables What’s New In SQL Server 2017 SQLSaturday is a volunteer-based day of free training for data professionals, and I encourage you to attend if you’re in Alberta.
-> Continue reading Speaking at SQLSaturday #710 in Edmonton on May 5th, 2018

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 text, known as collation. The next step was understanding data types in general, and how SQL Server stores them. After that was understanding normalization, with a focus on only having
-> Continue reading Where To From Fundamentals?

Western Digital WD Red internal HDD sliced in half on pink surface

Database Corruption Challenge

Steve Stedman has been running a contest over on his site, the Database Corruption Challenge, which I discovered last week quite by chance through Twitter. Not to brag, but I’ve been the fastest to solve the last two challenges. It has been refreshing to ply my SQLskills training on other people’s corrupt databases, albeit in
-> Continue reading Database Corruption Challenge