Microsoft recently announced that you’ll get Azure Data Studio (ADS) when you install SQL Server Management Studio (SSMS) starting with version 18.7.1. Azure Data Studio has been around for a couple of years, and it has some great features that most of us never imagined for SSMS, like the ability to connect to PostgreSQL databases […]
2020-11-07
1,305 reads
Is the decision for a new database starting to switch from the default of on-premise to in the cloud? Steve Jones has a few thoughts on when we'll get there.
2020-11-06 (first published: 2016-07-11)
254 reads
The differences in our understanding of technologies can make for some communication challenges.
2020-11-05 (first published: 2016-11-01)
177 reads
One of the challenges of using scripts is maintaining them and ensuring the adapt over time.
2020-11-04
121 reads
2020-11-03
132 reads
SSMs and ADS are the new tools for SQL Server and the data platform, both of which are now available separately from SQL Server.
2020-11-02
551 reads
There’s the old saying “Whether you think you can or you think you can’t -- you’re right” from Henry Ford. I’ve thought about this more recently while reading the book The Rise of Superman Decoding the Science of Ultimate Human Performance which talks about how athletes have performed so called impossible feats over the past few […]
2020-10-31
114 reads
2020-10-30
112 reads
I heard someone at the 2020 DevOps Enterprise Summit conference say that quality needs to be built in. That's something that many, or hopefully most, of us believe. Everyone ought to do quality work and build it into their daily tasks. However, the person speaking went further and defined this in a way I like: […]
2020-10-29
198 reads
2020-10-28
171 reads
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
I’m excited to announce the release of a new open-source project that fully automates...
Comments posted to this topic are about the item Server-Level Table sizes
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
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