Daily Coping 24 Nov 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-11-24
15 reads
Issue with Windows pass through authentication
It began with an error thrown by a linked server. The linked server is on our warehouse server and connects to our SSIS server using the “login’s current security...
2021-12-03 (first published: 2021-11-23)
1,341 reads
Daily Coping 23 Nov 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-11-23
17 reads
Data jokes
I’m feeling a bit uninspired this week, and I plan on only doing one post this week, so I figured ... Continue reading
2021-12-03 (first published: 2021-11-23)
906 reads
My book “Learn T-SQL from Scratch” is launched
A lot of my colleagues and people in my network reached out to me to train them on the SQL Server and T-SQL. They think that my style of...
2021-11-23
27 reads
My book “Learn T-SQL from Scratch” is launched
A lot of my colleagues and people in my network reached out to me to train them on the SQL Server and T-SQL. They think that my style of...
2021-11-23
328 reads
Tech Lunch News
Predminulý týden (10. listopadu 2021) jsme porádali už nekolikátý verejný Tech Lunch. Jde o pulhodinový call, na kterém pravidelne prezentujeme novinky ze sveta dat (datové sklady, Azure, SQL Server,...
2021-11-23
18 reads
Azure Synapse Analytics database templates
One of the biggest announcements at Microsoft Ignite that seemed to be overlooked by a lot of people was Azure Synapse Analytics database templates, now in public preview. I...
2021-12-01 (first published: 2021-11-22)
268 reads
Reading Data from the Command Line in PowerShell–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In every language I’ve coded in, there is...
2021-11-22
104 reads
Daily Coping 22 Nov 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-11-22
17 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
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
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...
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