PASS Summit 2022 - Day 1 In Pictures
The first "full" day of PASS 2022 kicked off with a bang when Rohan Kumar (@RohanKData) stepped out on the keynote stage to announce SQL Server 2022 was GA...
2022-11-25 (first published: 2022-11-17)
239 reads
Optimized Plan Forcing in SQL Server 2022
I’ve been reading Bob Ward’s book “SQL Server 2022 Revealed” and one of the new features in Intelligent Query Processing (IQP) jumped out at me. Not because it’s going...
2022-11-16
81 reads
#PASSDataSummit – Keynote 1 Live Blogging
Happy to be chosen to live blog the keynote events out at the PASSDataSummit in Seattle, Washington this week. This page will be updated through the Keynotes, all you...
2022-11-16
35 reads
On Hybrid Events
In my blog post last night on Days 1 and 2 of the PASS Summit, I included the following comment:
(Along with that, I think having "hybrid" events like our...
2022-12-02 (first published: 2022-11-16)
156 reads
Find the Hidden Lego Steve at the Summit
I’m part of a Redgate promotion at the PASS Data Community Summit. They ordered some Lego Steve’s, which will be available at the booth. You can post some photos...
2022-11-16
29 reads
Daily Coping 16 Nov 2022
Today’s coping tip is to change your normal routine today and notice how you feel. I am a person who likes a routine. While I travel a lot and...
2022-11-16
23 reads
Database Mirroring login attempt failed with error: ‘Connection handshake failed. An OS call failed: (80090302) 0x80090302(The function requested is not supported).
Here’s a quick one for today and is an issue that had me stumped for a while. It’s not one that I’d come across before and there isn’t really...
2022-11-28 (first published: 2022-11-16)
351 reads
PASS Summit 2022 - Pre-Cons Were Amazing!
It's that time again...TUESDAY!
https://www.mememaker.net/static/images/memes/4791280.jpg
I mean...NOVEMBER!
https://tinyurl.com/33hezsje
OK fine...SUMMIT!
https://img.memegenerator.net/images/10802365.jpg
I have very much missed in-person events and I am glad that Redgate (@Redgate) has managed to continue the @PASSDataSummit framework - virtual presentations...
2022-11-16
79 reads
SQLibrium SQL Server on VMware training now free
I’m proud to be a part of the SQL Server communities globally. I do everything I can do to give back when I can. Too many times, I feel...
2022-12-02 (first published: 2022-11-15)
297 reads
SQL Server 2022 is Coming
We still don’t have an exact release date for SQL Server 2022 but at this stage we can have strong confidence that it will be with us before the...
2022-11-15
96 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