black iPhone 4 on brown wooden table

It’s 2021, so why are you reading this?

If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking. There’s also a high likelihood that you live in the United States. The technology industry seems to be thick with this stereotype, but as I mentioned in a series of posts about gatekeeping, if we only listen to (or read) white
-> Continue reading It’s 2021, so why are you reading this?

padlock and chain

Security update for all supported versions of SQL Server (CVE-2021-1636)

Microsoft announced updates today for all supported versions of SQL Server, for a privilege escalation vulnerability that leverages Extended Events. For security reasons no further details have been provided, but you can expect more information in the near future, now that this update is public. From the knowledge base article: Data can be sent over a
-> Continue reading Security update for all supported versions of SQL Server (CVE-2021-1636)

Female developer at whiteboard with colleagues

T-SQL Tuesday Retrospective #008: Gettin’ Schooled

To view posts about previous T-SQL Tuesday entries, please use this tag. The late, great, Robert Davis invited us on Independence Day 2010 to write about Gettin’ Schooled: We return to our days of youth to take a fresh look at learning. How do you learn? How do you teach? What are you learning or
-> Continue reading T-SQL Tuesday Retrospective #008: Gettin’ Schooled

December 2020 calendar

2020 was certainly a year on the calendar

According to my blog post schedule, this is the final post of the year. It’s nothing more than a coincidence, but making it through the worst year in living memory could also be considered a sign. While it’s true that calendars are arbitrary, Western tradition says this is the end of one more cycle, so let’s
-> Continue reading 2020 was certainly a year on the calendar

SQL Server 2008 R2 logo

T-SQL Tuesday Retrospective #007: Summertime in the SQL

This is the seventh post in my retrospective attempt to answer every T-SQL Tuesday invitation. In the beginning of June 2010, Jorge Segarra invited us to write about our favourite hot new feature in SQL Server 2008 or 2008 R2. For me, this would be the introduction of the DATE, TIME, and DATETIME2 data types
-> Continue reading T-SQL Tuesday Retrospective #007: Summertime in the SQL

Glass Door Knob Circa 1931

T-SQL Tuesday Retrospective #006: What about blob?

I am revisiting old T-SQL Tuesday invitations from the very beginning of the project. On May 3, 2010, Michael Coles invited us to write about how we use LOB data, so now you know what this week’s post is about. Let’s go over some definitions and complain a little, because that’s how cranky data professionals
-> Continue reading T-SQL Tuesday Retrospective #006: What about blob?

chart

T-SQL Tuesday Retrospective #005: Reporting

A few weeks ago, I began answering every single T-SQL Tuesday from the beginning. This week it’s the fifth entry, and on April 5th, 2010, Aaron Nelson invited us to write about reporting. You can visit the previous entries here: T-SQL Tuesday #001 – Date/Time Tricks T-SQL Tuesday #002 – A Puzzling Situation T-SQL Tuesday
-> Continue reading T-SQL Tuesday Retrospective #005: Reporting