Sites anglophones


Randomizing the Day Inside a Month Using T-SQL

Publié le 24 juin 2022 sur sqlservercentral.com
 

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

Publié le 24 juin 2022 sur sqlservercentral.com
 

The post DevOps 101 webinar: The role of Automation appeared first on SQLServerCentral.

I Wish SQL Server Warned About Hard-Coded Estimates.

Publié le 23 juin 2022 sur brentozar.com
 

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

Publié le 23 juin 2022 sur journey to sqlauthority
 

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

Publié le 22 juin 2022 sur sqlservercentral.com
 

The post 2021 Session video library available appeared first on SQLServerCentral.

How to run Kubernetes clusters locally on Windows

Publié le 22 juin 2022 sur sqlservercentral.com
 

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.

Publié le 21 juin 2022 sur brentozar.com
 

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

Publié le 21 juin 2022 sur journey to sqlauthority
 

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

Publié le 20 juin 2022 sur sqlservercentral.com
 

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

Publié le 20 juin 2022 sur sqlservercentral.com
 

The post Insights from the SSRS database appeared first on SQLServerCentral.

SQL Database Overview

Publié le 17 juin 2022 sur sqlservercentral.com
 

The post SQL Database Overview appeared first on SQLServerCentral.

Fixing « The Distributor has not been installed correctly » Error with AWS

Publié le 17 juin 2022 sur sqlservercentral.com
 

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

Publié le 17 juin 2022 sur sqlservercentral.com
 

The post SQL Monitor supports Amazon RDS Monitoring appeared first on SQLServerCentral.

 

MYSQL Long Running Queries

Publié le 16 juin 2022 sur journey to sqlauthority
 

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

Publié le 15 juin 2022 sur simple-talk.com
 

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 …

 


Pages :