It’s #TSQL2sday time! This month’s invitation has been sent out by Brent Ozar and he asks us to describe the most recent issue – or the last ticket –...
2024-02-23 (first published: 2024-02-13)
212 reads
Last week, the Cybersecurity & Infrastructure Security Agency (CISA) put out an emergency directive which ordered federal agencies to pull Ivanti Connect Secure and Ivanti Policy Secure installations from...
2024-02-23 (first published: 2024-02-05)
195 reads
We have numerous Azure Analysis Services servers running in the cloud and needed a way to have near-real time monitoring of the queries being run. This KQL query will...
2024-02-21 (first published: 2024-02-06)
239 reads
I was working with a customer that was doing some error handling in procs and helped them do some error tracking. As we were working through things, I realized...
2024-02-21 (first published: 2024-02-07)
621 reads
As a follow up to my blog Common Data Mesh exceptions, I wanted to discuss various types of data mesh topologies I am seeing being built. I put them...
2024-02-19 (first published: 2024-01-30)
466 reads
Azure SQL Database and SQL Server 2016 introduced a new security feature for SQL Server databases called Always Encrypted. Always Encrypted is a feature designed to protect sensitive data,...
2024-02-19 (first published: 2024-02-04)
567 reads
Erik Darling, founder of Darling Data, has created these fantastic stored procedures to query SQL Server more efficiently to get health, log, or performance information. I will go through...
2024-02-16 (first published: 2024-01-30)
528 reads