Parameterizing Azure Policy and Ensuring Azure SQL AD Authentication
I wrote before about enforcing Azure SQL AD Authentication using Azure Policies in two different ways. First, only auditing if the Azure SQL is using AD Authentication or not. Later, automatically enabling the AD Authentication on Azure SQL Servers whe …
Now is the Right Time for the 2022 Brent Ozar Unlimited Scholarship Applications.
We normally do this in the fall, but given last week’s news, I bet you can understand why we’re doing this a little early, dear reader. You work at a charity or non-profit, helping them make a difference with data, fights for the rights of …
SQL Server Sample Databases
Northwind, Pubs, Aventureworks, AdventureworksDW, WideWordImporters, etc are important sample databases used in SQL Server. In this article, we will explain these databases and help you to find them, install them and understand them. Also, you will und …
SQL Database Snapshots for Reporting, Auditing and Data Recovery
The post SQL Database Snapshots for Reporting, Auditing and Data Recovery appeared first on SQLServerCentral.
I’m Coming Back to Israel for the Data.TLV Summit!
The Data.TLV Summit on September 15th is a big free conference on data engineering, business intelligence, data analysis, and … beer. I’m excited to announce that I’ll be back in Tel Aviv again for it, and this time I’m teaching …
Python Try Except Code Samples
The post Python Try Except Code Samples appeared first on SQLServerCentral.
Randomizing the Day Inside a Month Using T-SQL
I recently ran across an interesting situation in our development databases. We have begun to protect various PII information in our systems by running scripts in the development databases when we restore a production backup. We do this as we have had …
DevOps 101 webinar: The role of Automation
The post DevOps 101 webinar: The role of Automation appeared first on SQLServerCentral.
I Wish SQL Server Warned About Hard-Coded Estimates.
I wish we got a yellow bang on execution plans when SQL Server was making up an estimate out of thin air. I’ll give you an example: if you compare two columns on the same table, looking to find rows where they’re equal, SQL Server has a har …
Real-Time Monitoring of MySQL Server
When an application runs without any glitch in business, no one bothers. However, as soon as the application gets slower in returning results, everyone in the organization wants to know the reasons and resolution. For any DBA, they must know the real-t …
2021 Session video library available
The post 2021 Session video library available appeared first on SQLServerCentral.
How to run Kubernetes clusters locally on Windows
The post How to run Kubernetes clusters locally on Windows appeared first on SQLServerCentral.
Pour One Out for Distributed Replay. It’s Deprecated in SQL Server 2022.
I love how Microsoft treats deprecated and discontinued features in SQL Server. No, seriously. I give Microsoft a lot of sarcasm and lip around here, but Microsoft takes serious care to make it easy to upgrade versions without worrying about your appli …
File-Based Log Monitoring on AWS MYSQL RDS
We have often seen that one solution often does not have multiple different scenarios in the real world. It is true to monitor database performance efficiency on the different cloud platforms. The way the cloud platform works on Azure is very different …
Power BI Report Builder Expressions – Build In Fields and Functions
Power BI Report Builder expressions are an important topic to have smarter and more interactive reports. In this article, we will show some common fields, and functions used in Power BI Report Builder. The previous article looked at date expressions. P …