Failed IT Projects
A new theory of why some IT projects fail has Steve Jones intrigued, however he thinks we can do better, and not just with better developers.
2010-08-12
332 reads
Editorials
The Bottom Line
A good employee should try to affect the bottom line in their company, striving to make a difference. Steve Jones passes on some advice on how to do that today.
2010-08-11
179 reads
Fooling SQL Server
Today Steve Jones looks at the new release of restore technology from Red Gate software that allows you to "fool" SQL Server.
2010-08-10
482 reads
(Un)Common Speed Phreakery
Is there such a thing as too much attention to the performance of SQL? It isn’t only a question of time and inclination, but also of the resilience and flexibility of the code.
2010-08-09
180 reads
Security Disclosure
Did your company lose data last year? It can be hard to know, especially when even laws designed to ensure breaches are reported have loopholes. Steve Jones thinks this is a bad idea.
2010-08-09
89 reads
Counting Servers
Which big tech company has the most servers? It doesn't matter, but how you show the data can matter. Steve Jones talks about a skill data professionals should develop.
2010-08-04
228 reads
Keeping Fresh
Today Steve Jones talks about how you might be able to help keep your employees excited and happy with their jobs.
2010-08-03
171 reads
Houston, we have a problem
Phil Factor takes a sideways look at Houston, a new tool for building SQL Azure applications, and is somewhat underwhelmed by what he finds.
2010-08-02
237 reads
Snoops
A survey shows the majority of IT administrators have snooped for data on their networks. Steve Jones reminds us to be professionals, each and every day.
2010-08-02
150 reads
2010-07-30
1,159 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