Default Backups and Feature Awareness
Default backup schemes for databases would be a nice enhancement.
2019-05-08
258 reads
Default backup schemes for databases would be a nice enhancement.
2019-05-08
258 reads
I consider myself fortunate that I get to work with so many different clients while engaged in Comprehensive Database Performance Health Check. Recently we found out that one of...
2019-05-06
(last updated: 2019-05-05 @ 11:55 EST / 2019-05-05 @ 15:55 UTC ) I had gone through the process of uninstalling the now obsolete SQL Server 2019 CTP, and then...
The...
2019-05-05
This question has come up many times how to capture the SQL Server Database Recovery Progress or Total time take to recover a database. It will help to plan...
The...
2019-05-04
On occasion you have to find means to get around an issue. John Morehouse shows why Robocopy can be a useful tool in testing circumstances.
2019-05-03
Once in a while you might need to make common changes to a lot of SQL Server Agent Jobs.
2019-05-03
You know what it’s like, you need to fail your AG over but is it safe to fail over? Even if your AG says it is, there are other thing to consider...
2019-05-03
498 reads
Achieving minimal logging with INSERT...SELECT can be a complicated business.
2019-05-02
Gail Shaw keeps seeing this in all sorts of places. People getting an unexpected result when working with a subquery, typically an IN subquery, and assuming that they’ve found...
2019-05-02
For me, this particular code to generate a script to recreate indexes has more practical use in a replication environment.
For example, the default replication setting is to exclude the...
The...
2019-04-26
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers