Azure Data Studio Schema Compare Extension
A coworker recently introduced me to the SQL Server Schema Compare extension in Azure Data Studio. It has come in handy since we don’t have any paid-for tools, so...
2023-07-13
20 reads
A coworker recently introduced me to the SQL Server Schema Compare extension in Azure Data Studio. It has come in handy since we don’t have any paid-for tools, so...
2023-07-13
20 reads
A Barebone Script To Generate SQL Script to Create Synonyms
This stored procedure can be used to generate a SQL script to create synonyms for all tables in...
2023-07-12 (first published: 2023-07-10)
60 reads
I had a requirement to temporarily prevent access, read or write, to a particular database for all users except 2 users. There were hundreds of SQL Logins with access...
2023-07-12 (first published: 2023-07-11)
100 reads
Heraflux is returning to deliver a new webinar with Rubrik and ActualTech Media titled “How to Secure Your Azure SQL Data.” With Azure SQL Server offerings continuing to grow...
2023-07-12 (first published: 2023-06-27)
65 reads
Restoring a SQL Server backup in a Docker container is quite easy. To begin with, you will need persistent storage on your Docker container to follow this blog post....
2023-07-12 (first published: 2023-06-29)
390 reads
I recently presented a session on the Query Store at Data Saturday Rhineland and the question came up: If there’s already a query hint on a query, what happens...
2023-07-10 (first published: 2023-06-26)
269 reads
While we do maintain an exact inventory of sql servers and their configuration, its too numerous and I often find myself in a need to look up AG connection...
2023-07-10
323 reads
We’re a little delayed this month. Both the host and I forgot about this. So far in June, I’ve been in Fort Lauderdale, Las Vegas, Denver, and Cambridge for...
2023-07-10 (first published: 2023-06-20)
218 reads
My number one reason that you should test your backups is to make sure you know how to restore/recover. The absolute worst time to learn how to restore is...
2023-07-10
4 reads
The call for speakers is open! We’re always excited to have experienced and past speakers return (Rob Volk!), but if you’re a first time or relatively new speaker just...
2023-07-07
26 reads
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
By Steve Jones
mcfeely – adj. inexplicably moved by predictable and well-worn sentiments, even if they are...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
HI All, can any one reply on this when primary is down and not...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers