SQLRally
A new event is coming to the East Coast next year that will give people a chance to experience a SQL Server conference at a much lower cost.
2010-07-19
88 reads
Editorials
Collective Intelligence
Trying to keep up with all the learning going on in the SQL Community can be frustrating. Or is it? Give us your answer in this week's Friday poll.
2010-07-16
151 reads
From “One of the Pack” to “Top Dog”
A guest editorial today from Justin H-Davies examines the change to management from the perspective of someone going through the transition. How do you deal with those former co-workers?
2010-07-15
448 reads
The Private Cloud
Cloud computing is becoming more and more prevalent in technology. However most people think of a public cloud on the Internet. Steve Jones says a private cloud might be a better idea for many companies.
2010-07-13
286 reads
GOSQL vs. NOSQL
If we're getting pulled down a blind alley by acronyms, we may as well make up a more optimistic one.
2010-07-12
320 reads
The Utilty
Is Information Technology a utility service for companies? Steve Jones thinks it can, and should, be, but it can also be a lot more. It can be a strategic part of your enterprise.
2010-07-12
100 reads
Assumptions
For this Friday poll, Steve Jones asks about assumptions that cause you problems at work.
2010-07-09
142 reads
Leanring from Experts
A guest editorial from Andy Warren. Experience helps us do a better job, and one way you can get that is learning from experts.
2010-07-07
257 reads
What if TDE was available in Standard Edition?
Today we have a guest editorial from John Magnabosco that looks at TDE, and the reasons that it ought to be in Standard Edition.
2010-07-06
420 reads
2010-07-05
198 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