Feedback for IT
Steve Jones thinks we should be building feedback loops into all our systems. Not just for customer service, but also for bugs.
2010-07-29
128 reads
Editorials
Prevent Outsourcing
Outsourcing is a fact of life, but with the economic issues worldwide, it has also slowed. That will change eventually and Steve Jones has some thoughts about what you can do to prevent it for your job.
2010-07-28
292 reads
High End or Low End
Steve Jones talks about the need to perhaps get more depth and breadth to the information that we present at events like SQL Saturday to help people learn at all levels.
2010-07-27
171 reads
Software Vendor Security
This week Steve Jones finds some issues with the security of third party vendor software.
2010-07-26
118 reads
Thinking Time
It's important to have time to think, but quite often we don't find the time. Steve Jones comments on how he's learned just how valuable this can be.
2010-07-26
362 reads
ROWE
ROWE stands for a Results Oriented Work Environment. This Friday Steve Jones asks if you'd like to work in one.
2010-07-23
181 reads
Self-Service vs. Managed BI
Is self service BI a good idea? Some people think so, others don't. Steve Jones talks about one of the issues and why it might actually not be a problem.
2010-07-22
384 reads
Becoming Highly Productive
Today we have a guest editorial from Andy Warren. You can get more productive, but are you being productive at the tasks that you should be working on? See what Andy Warren has to say.
2010-07-21
261 reads
Incompetent or Malicious
When someone else doesn't do a good job to prove a point, are they incompetent or malicious? Steve Jones comments.
2010-07-20
294 reads
Backup Isn't Enough
When is backup not enough? Steve Jones talks about a few things that can cause you issues and a backup can't help you recover from.
2010-07-19
365 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