Read-Scale Availability Group Setup
What is a Read-Scale Availability Group? A Read-Scale Availability Group is a Clusterless Availability Group. It’s sole purpose and design is to scale out a read workload. More importantly...
2018-07-05
14 reads
Blog Posts
Read-Scale Availability Group Setup
What is a Read-Scale Availability Group? A Read-Scale Availability Group is a Clusterless Availability Group. It’s sole purpose and design...
2018-07-05
669 reads
Read-Scale Availability Group Setup
What is a Read-Scale Availability Group? A Read-Scale Availability Group is a Clusterless Availability Group. It’s sole purpose and design is to scale out a […]
The post Read-Scale Availability...
2018-07-05
13 reads
The Right to Be Erased is Coming to California, Along with Other Privacy Rights
In the last year, developers and DBAs have heard a lot about the General Data Protection Regulation (GDPR) law passed by the European Union. These regulations not only impact...
2018-07-05
12 reads
Community recognition
On the first day of January 2017, I was honoured to receive an email naming me as a Microsoft MVP...
2018-07-04
313 reads
My Speaking Schedule
I have quite a few speaking engagements coming up. Rather than an intermittent blog post, I’ve decided to have a...
2018-07-04 (first published: 2018-06-25)
1,651 reads
SQL Puzzle – FizzBuzz3d
I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case...
2018-07-04 (first published: 2018-06-27)
2,172 reads
Updating VSTS to SQL Change Automation
We (Redgate) released SQL Change Automation a few weeks back. This is the first stage to implementing a combined toolset...
2018-07-04
1,004 reads
Alter Multiple Databases at Once
This is a quick and dirty method I often use when I want to make a change to multiple databases...
2018-07-03 (first published: 2018-06-26)
2,515 reads
Building Better Test Data on the Redgate Hub
I have a new piece published over at the Redgate Hub: Building Better Test Data with SQL Provision. Part of...
2018-07-03
849 reads
Blogs
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
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...
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