Specialists or Generalists: Who are best as Developers?
Should we have specialists or generalists working as developers in our companies? A guest editorial today from Mike Angelastro asks the question.
2011-08-29
263 reads
Editorials
Would You Rather Work for a Strong or Weak Manager?
Today we have a guest editorial from Andy Warren. Andy asks if you prefer to have a strong manager or weak one, and why.
2011-08-26
197 reads
Keep Data Forever
Today Steve Jones talks about some of the issues with keeping data around a long time and a new archival medium.
2011-08-25
218 reads
Pop Tarts and Hurricanes
Today Steve Jones talks about the relation between hurricanes and poptarts, and why you should be working on your T-SQL skills.
2011-08-24
161 reads
The Talent Crunch
There seems to be no shortage of IT jobs in the US, and Steve Jones reminds us that the shortage is for talented workers, not just workers.
2011-08-23
488 reads
Devil's Advocate
With the one hand, Chris applauds the outstanding work of the SQL Server community, and tentatively raises the other to ask if we're on the cusp of a chance.
2011-08-22
128 reads
Virtual Security
As more and more companies move to virtualized servers, security should be on their minds. Steve Jones talks about that changes that you should consider.
2011-08-22
129 reads
A Flock of SQL Servers
Do you want to integrate Twitter with your database server? Steve Jones asks the question this week.
2011-08-19
137 reads
Benefits
Benefits for workers seem to be on the decline. Steve Jones talks about the issue, which might be something you give more weight to when choosing your next job.
2011-08-17
149 reads
Back to Basics
This week Steve Jones reminds us that the basic skills we may take for granted might need some refreshing or updating.
2011-08-15
332 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
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