Data Professionals at Work – a book-writing adventure
I love to write. It is how I express myself best. During the last fall I was pondering starting on...
2018-09-04
277 reads
Blog Posts
Deploying To a Power Bi Report Server with PowerShell
Just a quick post to share some code that I used to solve a problem I had recently.
I needed to...
2018-09-04 (first published: 2018-08-21)
5,880 reads
Does The Order Of Index Columns Matter?
Watch this week's video on YouTube
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.
Creating your first...
2018-09-04
5 reads
Does The Order Of Index Columns Matter?
Watch this week's video on YouTube
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.
Creating your first...
2018-09-04
12 reads
Don’t cutoff yourself with dates in T-SQL – Did you know…
Almost all the applications we use have a lot of options. And, sometimes we even stumble across them by accident.
Who’s...
2018-09-04
265 reads
Don't cutoff yourself with dates in T-SQL - Did you know...
Almost all the applications we use have a lot of options. And, sometimes we even stumble across them by accident. Who’s ever heard something like “Normal user don’t even...
2018-09-04
20 reads
Getting started with SQL Server Tools
This article is part of the SQL Server Tools series, aimed at giving you an idea of the available tools and techniques...
2018-09-04
647 reads
Interview Query – 1
Somewhere on internet i found this question. Thought to share it with you all. We have two tables, school_students and Class_student. ...
2018-09-04
37 reads
MongoDB 4.0.2 release
As i was discussing about MongoDB in my earlier blog, on NOSQL ACID stands for Atomic, Consistent, Isolation, and Durable...
2018-09-04
230 reads
Power BI Custom Visuals Class (Module 115 – Circle KPI Gauge)
In this module you will learn how to use the Circle KPI Gauge. The Circle KPI Gauge displays a single...
2018-09-04 (first published: 2018-08-14)
3,211 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
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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