SQL Reserved vCores
Have you ever heard of SQL Reserved vCores? Well I never until recently. With this concept you have the ability...
2018-08-16
347 reads
Blog Posts
Take the SQLChallenge: Tuning a Stored Procedure
I’ve just published a new SQLChallenge course for subscribers, and I think it’s one of the best ones yet. Your mission is to: Identify which statement is slowing down...
2018-08-16
24 reads
Using the built-in System Health session
When Microsoft introduced Extended Events (XE) in 2008, they also gave us a built-in XE session called system_health (though it’s...
2018-08-16 (first published: 2018-08-01)
5,524 reads
Using the PowerShell AST to find a ForEach Method
In dbachecks we enable people to see what checks are available by running Get-DbcCheck. This gives a number of properties including...
2018-08-16
336 reads
A Day in the Life (2/?) - August 14, 2018
This is my second installment in a series responding to Steve Jones’s (blog|twitter) #SQLCareer challenge. I decided to jot down most of what I did through the day, filling...
2018-08-15
10 reads
AlwaysOn Data Synchronization in Synchronous and Asynchronous Mode
When you are working on the AlwaysOn feature, it is crucial to understand how the AlwaysOn commit process works. This...
2018-08-15
5,741 reads
Do you even PowerShell, bro? An ode to dbatools and dbachecks.
Shall I compare thee to Management Studio? Thou art more scriptable and consistent. Those out-of-memory errors do tend to lose...
2018-08-15
325 reads
I’m Joining Redgate Software!
I’m excited to announce that I’m joining the evangelist team at Redgate. Starting next Monday, I’ll be working with Steve Jones, Grant Fritchey, and Kathi Kellenberger — plus the whole...
2018-08-15
18 reads
Identifying HIPAA, PCI & SOX Data for Masking
Working for a company based in the UK (still currently a part of the EU) I had a lot of...
2018-08-15 (first published: 2018-07-30)
2,684 reads
Information Measurement with SQL Server, Part 4.2: The Jensen–Shannon Divergence and Its Relatives
by Steve Bolton
…………In the last installment of this amateur series of self-tutorials on DIY data mining metrics, we saw how...
2018-08-15 (first published: 2018-07-31)
2,321 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Kontak Bank BCA KCP Purwosari [083178278662]
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
Alamat Bank BCA KCP Palur [083178278662]
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers