2017-01-23
102 reads
2017-01-23
102 reads
One of the tools that Redgate write is SQL Prompt. This might be my favorite product, and I’m constantly impressed...
2017-01-23
708 reads
2017-01-23
1,301 reads
One of the things that I’ve seen DBAs query for is free space in a database. In fact, this is...
2017-01-20 (first published: 2017-01-06)
3,086 reads
This is actually a simple, short post, but writing helps me remember things, and since I had to learn this,...
2017-01-20
921 reads
Sometimes the hardware or software we use prevents upgrades, which isn't necessarily good for any of us.
2017-01-20
83 reads
2017-01-20
1,021 reads
The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran...
2017-01-19
17,027 reads
2017-01-19
1,188 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-01-18 (first published: 2017-01-13)
2,118 reads
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
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...
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