Waking Up to No Support
Support for SQL Server 2008 and 2008 R2 ended yesterday. Steve has a few thoughts on what you should be thinking about today.
2019-07-10
341 reads
Editorials
The Clear Cloudy Future of Databases
The future of databases is in the cloud. Maybe not for everyone, but it is becoming a trend.
2019-07-09
385 reads
Building Helpful Commit Messages
Using a VCS is a core skill, according to Steve. One part of that is learning to write better commit messages.
2019-07-08
511 reads
Summer Break
Just one day between a holiday and a weekend, so Steve asks for the ways you escape work this summer.
2019-07-05
129 reads
2019-07-04
133 reads
Fines for Data Access
A government is fined for allowing inappropriate access to data. That might be something we deal with in other companies at some point.
2019-07-03
210 reads
Balancing Hard and Soft Skills
Today Steve talks about the soft skills and why these might be important as you advance in your career and grow into a senior role.
2019-07-02
550 reads
CCPA Preparation
The California Consumer Privacy Act takes effect in a year and there is lots of work to be done. One firm is trying to help companies get ready.
2019-07-01
352 reads
Over-thinking Database Build Scripts
With SQL Server we tend to build databases, when necessary, from one or more build scripts. If making changes to existing versions of the database, we then script the required changes. Usually, a synchronization tool will create a script that can be tweaked to work; although occasionally it will require something more complicated, as when […]
2019-06-29
354 reads
Organisations and Technical Apartheid
Today we have a guest editorial that looks at DevOps and the need for your culture to promote collaboration.
2019-06-28
322 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