A ratty-looking red diskette

T-SQL Tuesday Retrospective #010: Indexes

(You can see previous T-SQL Tuesday retrospectives by visiting this link.) In September 2010, Michael J. Swart (blog | Twitter) invited us to talk about indexes. Indexes are strange things. You never need to explicitly create one to create a fully-functional database, but if you want a database to perform well, they’re indispensable. Many words
-> Continue reading T-SQL Tuesday Retrospective #010: Indexes

network cables coming out the back of a switch

T-SQL Tuesday Retrospective #009: Beach Time

(If you’d like to read my other T-SQL Tuesday Retrospective posts, click here.) In August 2010, Jason Brimhall (blog | Twitter) invited us to discuss preparing for vacations: “Write about what you have done to be able to get a break from the job. Beach time is usually vacation time, but is really anything that
-> Continue reading T-SQL Tuesday Retrospective #009: Beach Time

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