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?

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