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?

A still from the film "Bill & Ted's Excellent Adventure"

Professionalism in the age of COVID-19

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 on Twitter about what it means in the information security (InfoSec) field. The vast majority of InfoSec people in the conversation railed against the premise that
-> Continue reading Professionalism in the age of COVID-19

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