The Next Step for SQL Server
This past week saw the next version of SQL Server, code named Denali, released as a public CTP. Steve Jones comments on the new version.
2010-11-15
331 reads
Editorials
More Triggers
This Friday Steve Jones talks about database design and specifically asks how you prefer to design triggers.
2010-11-12
901 reads
Live Monitoring
You can get a look into how SQLServerCentral handles the load of it's database servers with a new tool, and release of reports.
2010-11-11
356 reads
Automated Driving
Could we ever have computers automating our cars and handling the driving for us? Steve Jones doesn't think so, despite some ongoing projects.
2010-11-10
123 reads
Code of Conduct for Software Maintenance
A number of companies came together to develop a code of conduct recently for software vendors. Steve Jones thinks this is a good idea.
2010-11-09
225 reads
Should You Write Down Your Passwords?
Today we have an older editorial by Steve Jones being republished. This piece talks about security and why it might be a good idea to write down those passwords.
2010-11-08
292 reads
Enterprise Management
This Friday Steve Jones asks the question about how you manage large numbers of SQL Server instances.
2010-11-05
222 reads
One Time Passwords
Facebook has implemented a new security feature that Steve Jones thinks might work well for SQL Server as well.
2010-11-04
273 reads
Swarms
Steve Jones talks about the workplace of the future, and a prediction from the Gartner Group that it will include swarms.
2010-11-03
150 reads
Life Without a Net
Today we have a guest editorial from Rodney Landrum that talks about life in the past, when we couldn't look up everything on the Internet.
2010-11-02
234 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