2012-10-22
88 reads
Editorials
Unprofessional Employers
This Friday Steve Jones talks about training and employers, and who has the responsibility for your knowledge? Let us know if you think your employer shares the burden with you.
2012-10-19
332 reads
Windows Server 2012 and Hyper-V
Steve Jones talks about the improvements in Hyper-V in Windows Server 2012. These days there isn't a good reason to avoid considering virtualization for SQL Servers.
2012-10-18
281 reads
Manage By Delegation
There always seem to be more and more instances to manage, but not more and more staff. Steve Jones talks about the key to good management being delegation of the work.
2012-10-17
157 reads
I'm Not a Rock Star
Steve Jones reflects on the SQL in the City tour that recently wrapped up in the US.
2012-10-16
163 reads
Innovation
This Friday Steve Jones wants to know if innovation matters in your company. And if you really enjoy working with computers and solving problems.
2012-10-12
264 reads
Potential
We often view potential hires based on their potential and not necessarily on their experience. Today Steve Jones talks about the dangers of putting more emphasis on future, rather than past, performance.
2012-10-10
132 reads
Why SQL Server is Better Than Oracle
WARNING: This editorial contains graphic language. Viewer discretion is advised.
2012-10-09 (first published: 2007-10-04)
1,653 reads
Software is Like Building a House
One of the really classic analogies in software is that it's like building a house. You have a foundation, multiple teams, lots of contractors that specialize in something, etc. And it's an analogy that's debated as to its relevance over and over. I won't go into the correctness of this analogy, but I wanted to comment on it.
2012-10-08 (first published: 2007-10-05)
415 reads
Your Password has Failed the Test
Your data is in the public domain and as a DBA you need to be very familiar with what it is possible for the sinner to do with a handy password, and how easily that sinner can get hold of it.
2012-10-08
157 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
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...
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