Centralized Management Server 101
Registered Servers
I've used Central Management Server registered servers in SSMS for primarily one purpose, saving connections. 🙂 This is definitely not...
2016-10-16
395 reads
Registered Servers
I've used Central Management Server registered servers in SSMS for primarily one purpose, saving connections. 🙂 This is definitely not...
2016-10-16
395 reads
If you need to do code comparison on a lot of files in Visual Studio, I ran across an extension...
2016-10-12
812 reads
Update: 2017-07-14
Still find this incredibly awesome! Developer just updated for Visual Studio 2017 after a lot of hard work. Github...
2016-10-12
273 reads
I had some cross database comparisons that I wanted to simplify, but ensuring the collation matched. The amount of objects...
2016-10-10
353 reads
I had some cross database comparisons that I wanted to simplify, but ensuring the collation matched. The amount of objects...
2016-10-10
110 reads
I discovered a bit of info on working with float values, while creating a hash value that contained a float...
2016-10-08
3,855 reads
I discovered a bit of info on working with float values, while creating a hash value that contained a float...
2016-10-08
143 reads
Didn't see SQL 2016 Configuration manager in the start menu. Ran a quick search to see if this was a...
2016-09-30 (first published: 2016-09-21)
1,946 reads
The following command is run to gain details on deadlocks.
DBCC TRACEON (1222,-1)
However, once the SQL instance is restarted this...
2016-09-26 (first published: 2016-09-19)
1,757 reads
Didn't see SQL 2016 Configuration manager in the start menu. Ran a quick search to see if this was a...
2016-09-21
97 reads
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