Finding a Work-Life Balance
Like most everyone who works hard in our industry, I’ve run into more than a few conflicts trying to balance...
2009-02-25
1,603 reads
Like most everyone who works hard in our industry, I’ve run into more than a few conflicts trying to balance...
2009-02-25
1,603 reads
Microsoft has introduced a new website (part of Microsoft.com) called Thrive. It is still in its infancy, but its focus...
2009-02-25
1,371 reads
This question comes up a lot in the forums: "How do I know if the login owns any objects?" Usually...
2009-02-24
7,437 reads
Today, Microsoft release a security advisory about a new vulnerability in Microsoft Excel. This one affects both PCs and Macs....
2009-02-24
1,808 reads
I like being able to view samples on my Kindle. It's one of the very neat features of the Kindle...
2009-02-24
1,655 reads
I've scheduled another iteration of my Technical Speaking Seminar for March 14, 2009 in Orlando. It's free, and I'm hosting...
2009-02-24
1,478 reads
When the weather is cold, the Prius performs much worse (relatively) than it does when it’s warm. It makes sense...
2009-02-24
1,798 reads
Question: What would be the best practice to configure Failover Clustering and Database Mirroring?
This question is frequently asked in one...
2009-02-23
1,558 reads
Yesterday I blogged about how to figure out what database principals corresponded to what server principals. The key is to...
2009-02-23
1,879 reads
All of the videos I've done are up under my profile. However, the video for The difference between GRANT, DENY...
2009-02-23
1,499 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