Thanking the Volunteers
Grant takes a moment to thank the SQL Saturday organizers that put on these amazing events.
2019-09-27
134 reads
Editorials
Would a Duress Password be a Good Idea?
Today we have a guest editorial from Andy Warren. Should we adopt a duress password, just in case we find ourselves in a movie situation while at work?
2019-09-26 (first published: 2015-04-21)
511 reads
The Multi-skilled Developer
Is the DBA a fading star? More likely, there is a general lack of understanding of the roles of the different types of DBA, and of the other IT teams that ensure that successful application developments happen in any large enterprise.
2019-09-25 (first published: 2015-06-08)
657 reads
Is Data the Future of the Vibrant Web?
There is a lot of data collected from web browsing. Steve doesn't think we need all that data, unlike Google.
2019-09-24
200 reads
Working in Smaller Teams
Steve likes working in smaller teams and has some thoughts on why this is important to him.
2019-09-23
215 reads
Using Big Data to Improve Health
With the help of a database that provides fully representative data, we can do a great deal more to advance medical and pharmaceutical science. Phil Factor explains what stands in our way.
2019-09-21
306 reads
A Good Reason to use a VCS
Steve has a good reason to use a version control system. It's a different kind of backup that you might need.
2019-09-19
389 reads
Beware, More Ransomware is Coming
Ransomware has become a large problem in the last few years, and Steve thinks this will continue to increase because of insurance payouts.
2019-09-18
250 reads
What You Should Know About Coding
Today Steve thinks about the skills and approach we ought to be taught before we start building software as a career.
2019-09-17
386 reads
The Crazy Times of Year
Do you have busy times of the year that recur regularly? In some positions I've held, we had certain events or processes that always caused additional stress and headaches for employees. As a bartender, certain holidays (New Years, Halloween) were extra crazy. In one company, every quarter was an adventure involving a late, or a […]
2019-09-16
187 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