2010-11-25
79 reads
Editorials
Windows Phone 7
Steve Jones has a pre-holiday look at the new Windows Phone 7 platform, with some thoughts on how it was designed.
2010-11-24
160 reads
Disaster Planning Includes You
Today we have a guest editorial from Andy Warren. Andy discusses the need to consider personnel when you are planning for things to go wrong.
2010-11-23
168 reads
Decoupling the Database
Database refactoring is a difficult proposition at the best of times, but is rendered more or less impossible if the database is close-coupled to the application's other components. In a guest editorial, Mladen Prajdic stresses the importance of a native SQL Server abstraction layer.
2010-11-22
2,807 reads
Security by Obscurity
Today we have an editorial reprint from Aug 23, 2005 as Steve is on vacation. Does security through obscurity work? Steve Jones thinks it can help in a limited sense, providing another layer of protection.
2010-11-22
129 reads
Little Devices
This Friday Steve Jones asks if you think that your job could be done with smaller devices. Is there a chance that a mobile phone, a tablet or something else could help you be more productive?
2010-11-19
168 reads
The DBA Disconnect
It seems that there is a disconnect between how technical people view security and how business people see it. Steve Jones talks about the problems that we have in trying to secure the systems we manage.
2010-11-18
183 reads
Are You a Ten?
Are you truly an expert in SQL Server? Would you claim to be a 10 on a scale of 1 to 10? Steve Jones notes that the product is so wide and deep that it's unlikely any of us will be an expert in most of SQL Server, and that's OK.
2010-11-17
312 reads
Google Scale
Not many of us work at Google scale, where every little thing you do can matter. However Steve Jones thinks that the little things still matter when you are building software.
2010-11-16
237 reads
Proving Your Identity
We have to provide security for our data, and to some extent that means verifying who has access. SQL Server has limited means for doing this other than relying on the OS, but Steve Jones has some ideas on how to make this more secure.
2010-11-15
140 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