Daily Coping 24 Jan 2023
Today’s coping tip is to get outside and notice five beautiful things. I decided to do this on a snowy, stormy day in Denver. I was up early with...
2023-01-24
14 reads
Exam Cram with DataWeekender talk - Think Like a Certification Exam
Fresh off of a two-part, co-authored blog series on certification exams and test-taking prep, I've got a fresh batch of fun sample questions for the January 2023 Data Weekender Exam...
2023-01-24
30 reads
Q&A on certification exams, exam prep, and test-taking skills
Part 2 of 2. This blog post is co-authored by Ajayi Anwansedo, PhD and William Assaf, who met and worked together at The Futures Fund, a STEM non-profit which offers introductory coding and...
2023-02-03 (first published: 2023-01-23)
298 reads
So, you're considering pursuing a certification exam
Part 1 of 2. This blog post is co-authored by Ajayi Anwansedo, PhD and William Assaf, who met and worked together at The Futures Fund, a STEM non-profit which offers introductory coding and...
2023-01-24 (first published: 2023-01-23)
57 reads
When to have multiple data lakes
A question I get asked frequently from customers when discussing Data lake architecture is “Should I use one data lake for all my data, or multiple lakes?”. Ideally, you...
2023-02-01 (first published: 2023-01-23)
496 reads
Starting the Flyway PoC–Environment
I’ve had a goal to redo my demo environments and get them set up to work for a variety of customers in different places. I decided to do this...
2023-02-03 (first published: 2023-01-23)
124 reads
Daily Coping 23 Jan 2022
Today’s coping tip is to eat healthy today with some nourishing food. A few days before think I was getting ready for my daughter to leave for university. I...
2023-01-23
17 reads
EightKB 2023
EightKB is back! The biggest online SQL Server internals conference is back in 2023…happening on May 24th. We’ve open our call for speakers, you can submit here: – https://sessionize.com/eightkb-may-2023/...
2023-01-30 (first published: 2023-01-23)
167 reads
What is calling my T-SQL scalar function (millions of times)?
In this post we look at a method using Extended Events (XE) to identify what parent objects are calling a given SQL function and how often. The background is...
2023-02-01 (first published: 2023-01-23)
481 reads
Daily Coping 20 Jan 2023
Today’s coping tip is to take a different route today and see what you notice. I’ve had this tip come up a few times and each time I’ve enjoyed...
2023-01-20
17 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