NoSQL Is Not Everywhere
NoSQL has been getting a lot of press in the last year, but it's not necessarily the best platform or solution for you. Steve Jones comments on NoSQL and alternative platforms.
2010-09-21
382 reads
Editorials
Big Data and SQL
Today Steve Jones talks about how some companies find efficiencies by training employees to use SQL. Perhaps that's a good idea for all developers.
2010-09-20
259 reads
The Cloud is Nothing Special
This week Steve talks about cloud computing, and the fact that a lot of what the cloud does is no big deal. But it can be helpful to IT professionals.
2010-09-20
288 reads
We Are Not Alone
Today we have a guest editorial from Robert Pearl that talks about the SQL Server community, and how you can get involved.
2010-09-16
145 reads
Social Engineering Dangers
Social engineering is one of the most effective ways to hack information out of a company. Steve Jones looks at this technique and a recent contest at DefCon that featured social engineering.
2010-09-15
169 reads
More Than SQL
Today Steve Jones talks about the upcoming SQL Saturday #52 in Colorado, and how it's encompassing more than just a day of SQL learning.
2010-09-14
98 reads
Getting Fired from an Unpaid Job.
Phil Factor initially brooded about being fired from a job he was just doing unpaid to help out. Then he suddenly realized that they were probably right.
2010-09-13
359 reads
Instrumentation
This Friday Steve Jones is looking for the instrumentation or monitoring that you build into your applications.
2010-09-10
201 reads
Enjoy Your Job
A reminder today that there are people that enjoy their jobs. Steve Jones reminds us that we should take jobs based on that criteria.
2010-09-09
260 reads
Talking To You Makes Me Smarter
There's a lot of value in the interactions that professionals have with each other. A guest editorial from Andy Warren talks about the benefits of meeting new people.
2010-09-07
143 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