Learn in the Margins
It can be very hard to find time to learn new skills and get better at your job. Today Steve Jones talks about finding a little time in the margins of your life.
2012-06-07
215 reads
Editorials
The Platform as Code
Today Steve Jones talks about the need to understand code to be a good administrator. Our systems are more complex and we cannot manage multiple systems by clicking on buttons in an interface.
2012-06-06
127 reads
Managing Risk
Managing risk is a park of business, but it also requires that we have the information to properly assess the issues. Do we prevent that in IT?
2012-06-05
139 reads
New Security Holes
Siri is seen as a data security hole at IBM. This is something that Steve Jones thinks we might need to be more concerned about in the future, especially as more and more processing takes places outside of our walls.
2012-06-04
153 reads
The Upgrade Avalanche
This year we will see a large number of upgrades from Microsoft to much of its technology stack. Can IT Pros handle the load?
2012-06-04
108 reads
Career Engagement
This Friday Steve Jones asks if you like your job. Are you engaged? Do you want to stay? Give us your answer today.
2012-06-01
213 reads
Never, Ever Use Clustered Indexes
Today we have a guest editorial from Grant Fritchey that might surprise you. Today Grant talks about clustered indexes in your tables.
2012-05-31
977 reads
Is Empowerment Good?
Today Steve Jones notes that we use computers to enable others to handle their own work without help. But is that always a good idea.
2012-05-30
113 reads
Create Your Own Intense Interview
Today Steve Jones talks about interviews and the way in which he approaches them to make sure that the job is the best fit for both the company and the candidate.
2012-05-29
280 reads
Happy Memorial Day 2012
It's Memorial Day in the US and Steve out is paying tribute to our soldiers and cutting grass on the tractor. He's left you a blooper reel to enjoy.
2012-05-28
75 reads
Blogs
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
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...
Forums
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
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...
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