Shadow IT
There are often Shadow IT groups in many companies. Steve Jones talks about the potential problems of these groups, and how he has dealt with them in the past.
2012-08-28
226 reads
Editorials
Outsourcing Jobs
This week Steve Jones looks at some of the jobs being outsourced and how that might affect data professionals.
2012-08-27
187 reads
Ten Million Lines of Code
Intuit manages ten million lines of code in a single codebase and does a great job of it. Read a little about what they do.
2012-08-27
230 reads
Fix v. Create
This Friday Steve Jones wants to know how you spend your time. Do you get to do a lot of new development or do you end up fixing, tuning, and improving old code. Let us know.
2012-08-24
131 reads
Being Exceptional
It's time to vote for the Exceptional DBA awards, and Steve Jones is asking for your opinion. Take a moment and recognize one of your peers as the best DBA in 2012.
2012-08-23
157 reads
Make a Backup First
The hack on a Gizmodo writer using Amazon and Apple customer service security holes was shocking. Steve Jones notes that while security is important, backups are even more important.
2012-08-22
178 reads
Big Data Jobs
Big Data is in the news and there is a lot of job growth. Steve Jones lists a few industries and areas where you might find one.
2012-08-21
313 reads
Brad McGehee Moves On
The SQLServerCentral and Database Weekly editors recognize the contribution of Brad McGehee to the websites and newsletters, and to DBA education in general, over the past 5 years.
2012-08-20
167 reads
The Influence of the Cloud
This Friday Steve Jones is talking clouds. In the next year, will the cloud influence your job or will it be a fad for you?
2012-08-17
147 reads
Marketing Data is Exploding
The explosion of social media data has resulted in a lot more marketing data for companies. Some are using it well and some aren't, but in both cases, Steve Jones notes there are more opportunities for data professionals.
2012-08-16
158 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