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?

Azure Data

Welcome to the Azure Data Community, empowered by Microsoft

After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this year and its video library & brand names were bought by Red Gate Software Ltd, it left the SQL Server Family (#SQLFamily) in a quandary. On the one hand, the big PASS Summit will be revived and all archive videos will be
-> Continue reading Welcome to the Azure Data Community, empowered by Microsoft

SODIMM RAM

How does the buffer pool handle low memory conditions?

(Thanks to Erik Darling for reviewing this post. Check out his training materials.) One of the bigger clichés in the data professional vocabulary (behind “it depends”) is that you always give SQL Server as much RAM as you can afford, because it’s going to use it. But what happens when SQL Server runs out of
-> Continue reading How does the buffer pool handle low memory conditions?