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 …
Insights from the SSRS database
The post Insights from the SSRS database appeared first on SQLServerCentral.
SQL Database Overview
The post SQL Database Overview appeared first on SQLServerCentral.
Fixing « The Distributor has not been installed correctly » Error with AWS
The Problem To migrate a SQL Server database to AWS or to implement a data migration/transfer strategy to AWS, a common tool we use is the Data Migration Service (DMS). This is a native AWS tool and supports many different database technologies, includ …