Born SQL with Randolph West

Upcoming speaking engagements

• by Randolph West

• Born SQL with Randolph West

The last time I presented a session was at the final PASS Summit in November 2020, so it is time to get back on the virtual conference trail again....

2021-04-07

3 reads

Zeroing out a transaction log file does not use zeroes

• by Randolph West

• Born SQL with Randolph West

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...

2021-03-31

17 reads

What is a community advisory board anyway?

• by Randolph West

• Born SQL with Randolph West

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...

2021-03-24

7 reads

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

• by Randolph West

• Born SQL with Randolph West

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...

2021-03-17

117 reads

T-SQL Tuesday Retrospective #011: Misconceptions

• by Randolph West

• Born SQL with Randolph West

(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...

2021-03-16 (first published: 2021-03-10)

288 reads

Which configuration changes in SQL Server require a restart?

• by Randolph West

• Born SQL with Randolph West

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...

2021-03-03

21 reads

Welcome to the Azure Data Community, empowered by Microsoft

• by Randolph West

• Born SQL with Randolph West

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...

2021-02-24

83 reads

Calgary Data User Group – 24 February 2021 at 5pm MST

• by Randolph West

• Born SQL with Randolph West

This Wednesday, from 5pm to 7pm Mountain Standard Time, the Calgary Data User Group is presenting two sessions for your virtual attendance. 15 minutes: A lightning talk on Kubernetes...

2021-02-22

10 reads

How does the buffer pool handle low memory conditions?

• by Randolph West

• Born SQL with Randolph West

(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...

2021-02-17

7 reads

Professionalism in the age of COVID-19

• by Randolph West

• Born SQL with Randolph West

Some years ago, I wrote about what it means to be “professional” (and that it doesn’t mean having to wear a suit and tie). Recently a conversation broke out...

2021-02-10

162 reads