Sharing Remote Desktop Sessions
I work for a very large company where divisions are spread out literally all over the world. There are many...
2010-07-28
907 reads
I work for a very large company where divisions are spread out literally all over the world. There are many...
2010-07-28
907 reads
Introduction
Replication is the process of copying data between two databases on the same server or different servers on the same...
2010-07-28
31,941 reads
This week at SQL University we are talking about capacity planning. I am the guest lecturer for this topic, and...
2010-07-28
5,041 reads
…or, How I Learned to Stop Worrying and Love the Bomb
I had a SQL dev’s dream come to me via...
2010-07-28
906 reads
I’ll be speaking for the SQL PASSDatabase Administration Virtual Chapter today at 12 PM Eastern time. The topic will be...
2010-07-28
587 reads
Have you heard the sound of silence? Yep, that’s been my blog.
It’s been weeks since I’ve posted anything on here,...
2010-07-27
682 reads
Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur. So can...
2010-07-27
1,474 reads
Do I follow my own advice?
I’ve been asked that at a few of my Modern Resume presentations if I do...
2010-07-27
1,486 reads
Or “Monitoring plan cache usage”
For people interested in the details of how SQL is using and reusing execution plans, there...
2010-07-27
1,138 reads
Ran across Pillbox in Government Computing News (GCN), a web app that lets you identify what a pill is based...
2010-07-27
624 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