VirtualBox SQL FCI - Given Network Name Is Unusable
The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a...
2017-04-19
2,784 reads
The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a...
2017-04-19
2,784 reads
The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a 2 server Windows 2012 R2 failover cluster with shared...
2017-04-19
14 reads
In February 2017, Microsoft announced the general availability of Blob Auditing for Azure SQL Database. While auditing features were available...
2017-04-18
645 reads
I am honored to be a Guest Blogger at SQLPerformance.com. As a member of the SentryOne Product Advisory Council (PAC)...
2017-04-18
370 reads
Simple post today: How to compare two plans in SSMS.
This task is a task that is often done by a...
2017-04-18 (first published: 2017-04-14)
2,045 reads
Hello!
So, on another blog a long time ago, I wrote a couple of posts about foreign keys and what step...
2017-04-18
126 reads
This story originally appeared in Hacker Noon on February 10, 2017.
I can't tell you the number of times the title of this post has crossed my mind as I...
2017-04-18
18 reads
This summer I’m going to try something a little different. I’ll be speaking at a technology conference that is not...
2017-04-18
371 reads
As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern....
2017-04-18 (first published: 2017-04-10)
1,555 reads
2017-04-18
250 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