The Growth of Storage
This week Steve Jones asks you to predict the future of hardware. When will we have laptops that rival the specs of today's large SQL Server servers.
2013-01-18
119 reads
Editorials
Serious Security
The password issue has Steve Jones concerned. So many of us that use computing devices don't do a good job of securing our information.
2013-01-17
140 reads
Message Queues in Software
Steve Jones talks about Service Broker and messaging and how these techniques can help you build a more robust application.
2013-01-16
275 reads
Cramming for Interviews
Today Steve Jones talks about the questions people ask on the Internet about interviews. Are they ok? Should you cram for an interview this way?
2013-01-15
347 reads
Global Insecurities
The various security scans of 2012 reported lots of potential problems in companies. Why don't vendors make it easier for us to install and configure their software securely?
2013-01-14
83 reads
The Java Danger
This week a vulnerability in Java has prompted a large scale notice to the general public.
2013-01-14
169 reads
The Auditing Poll
Is auditing in use in your applications? Steve Jones wants to know as he thinks it will be more important in the future for most software.
2013-01-11
117 reads
A Patch Disaster
What would happen if the wrong patches were applied to your database server? The results could be a huge problem. Steve Jones reminds you to be careful with mass patches.
2013-01-10
150 reads
Statistical Protection
Statistical databases contain lots of information that can be used in a variety of ways, but it can also be abused. Steve Jones talks about some of the problems and potential solutions.
2013-01-08
117 reads
The $50,000 Laptop
The average value of a lost laptop has been found to be much more than you might expect. Steve Jones talks about a recent study.
2013-01-07
227 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