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

pink sofa chair near a body of water

Ambling through undocumented DBCC commands may result in boredom

There comes a time when we heed a certain call. The call is to avoid dangerous undocumented DBCC commands in SQL Server, especially those that bypass built-in protections. I’m looking directly at you DBCC WRITEPAGE. Besides, Paul Randal (blog | Twitter) has written strongly and authoritatively on the topic, striking fear in the hearts of everyone
-> Continue reading Ambling through undocumented DBCC commands may result in boredom

Calgary Data User Group

Calgary Data User Group with Deborah Melkin and Andy Yun

Next week on Wednesday is the Calgary Data User Group’s second event for 2021, and the second event as a member of Microsoft’s new Azure Data Community. Since last year February we have been offering two sessions per event, with the opportunity for a lightning session (15 minutes) as well as the regular-length session (60
-> Continue reading Calgary Data User Group with Deborah Melkin and Andy Yun

listen more

T-SQL Tuesday Retrospective #013: What the business wants

Click here to read previous retrospective entries. From Steve Jones (blog | Twitter) in December 2010 comes the question “What issues have you had in interacting with the business to get your job done?” However a little digging showed that the business didn’t really understand the technology. They were asking for a result, and [the DBA] took them
-> Continue reading T-SQL Tuesday Retrospective #013: What the business wants

Internals of a spinning hard drive

Zeroing out a transaction log file does not use zeroes

I’ve been doing SQLskills training recently, and Paul Randal (blog | Twitter) reminded our class that zeroing out a transaction log file does not use zeroes (0x00). Well, not since SQL Server 2014 at any rate. As you can see from this post, the stamping of the transaction log since SQL Server 2016 is done
-> Continue reading Zeroing out a transaction log file does not use zeroes

Azure Data

What is a community advisory board anyway?

For those of us who have been involved in the Microsoft Data Platform community for a few years, the events of the last few months have been dramatic, culminating in the end of the Professional Association for SQL Server (PASS), which closed down in January 2021. As I wrote previously, this left local user groups
-> Continue reading What is a community advisory board anyway?

T-SQL Tuesday Retrospective #012: Why DBA skills are necessary

This is my ongoing series of answering T-SQL Tuesday posts far too late to be of any use. Click here if you want to read previous entries. Paul Randal asked us in November 2010 why DBA skills are necessary. As a reminder, DBA stands for Database Administrator, and this unleashes a discussion outside of the
-> Continue reading T-SQL Tuesday Retrospective #012: Why DBA skills are necessary

Blue table vise

T-SQL Tuesday Retrospective #011: Misconceptions

(If you would like to read the previous T-SQL Tuesday Retrospective entries, visit this link.) In October 2010, Sankar Reddy asked us which misconceptions we’ve been labouring under when it comes to SQL Server: The possibilities for writing up a post on this topic invloving SQL Server are enormous even if you are a novice
-> Continue reading T-SQL Tuesday Retrospective #011: Misconceptions

A gaming console remote showing settings buttons

Which configuration changes in SQL Server require a restart?

SQL Server is a complex beast, with many configuration options that can range from recommended to completely avoided. Since the release of SQL Server 2016, several options that were recommended post-install have been rolled into the default installation options and no longer need to be done, and similar changes were made with SQL Server 2017.
-> Continue reading Which configuration changes in SQL Server require a restart?