PASSITON discount code for PASS Summit 2018
This week only PASS has a new discount code of PASSITON for an additional $200 off 3-day registration. This is...
2018-09-18
322 reads
Blog Posts
sp_translate, A Universal Translator in SQL Server. Just One Example Of How Powerful the Python/SQL Partnership Can Be.
In my recent post, Installing External Modules into SQL Server’s Python I had a look at just how simple it is to...
2018-09-18
597 reads
The Trigger Roundup–T-SQL Tuesday #106
This month was my turn to host T-SQL Tuesday. I chose Trigger Headaches or Happiness as the topic, and I...
2018-09-18
894 reads
4 Usage Scenarios for Bots
So, what do you really know about bots or how they can help your organization? You may be thinking, Pragmatic...
2018-09-17
178 reads
A Summit Contest for registering by Sept 22
If you haven’t registered for the 2018 PASS Summit and plan to go, you might press to get registration done...
2018-09-17
872 reads
Azure SQL Database Read Scale-Out
Read Scale-Out is a little-known feature that allows you to load balance Azure SQL Database read-only workloads using the capacity of...
2018-09-17 (first published: 2018-09-05)
2,549 reads
Deleting a User that Owns a Schema
This was an interesting question I saw posted recently. Through SQL Server 2000, trying to delete a user that owned...
2018-09-17
35,460 reads
How do I grant permissions to view users and their permissions?
tl;dr; VIEW DEFINITION
Every now and again you’ll have a user that needs to be able to see what permissions other...
2018-09-17
345 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-17 (first published: 2018-09-04)
2,495 reads
Learn about SQL Source Control in Redgate University
I love the SQL Source Control product from Redgate. It’s not perfect, and it can be slow to run at...
2018-09-17
240 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