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 …
SQL Monitor supports Amazon RDS Monitoring
The post SQL Monitor supports Amazon RDS Monitoring appeared first on SQLServerCentral.
MYSQL Long Running Queries
When any business or application begins, the amount of the data is limited, and the complexity of the business logic is simple; as time goes by, the data and complexity both increase for the business. The same queries running very fast in the beginning …
Introducing the MySQL SELECT statement
The series so far: Getting started with MySQL Working with MySQL tables Working with MySQL views Working with MySQL stored procedures Working with MySQL stored functions Introducing the MySQL SELECT statement Up to this point in the series, I’ve …