The HUGE announcement at Microsoft Build yesterday was Microsoft Fabric (see Introducing Microsoft Fabric: Data analytics for the era of AI), now available in public preview. I have been...
2023-06-12 (first published: 2023-05-24)
540 reads
In SQL Server you can also compress your encrypted backups. Unlike TDE this has been possible with Backup Encryption since the feature was first made available, and there have...
2023-06-12 (first published: 2023-05-24)
376 reads
Microsoft has just announced Microsoft Fabric during the Microsoft Build conference. This is a unified analytic solution of the era of AI. Microsoft Fabric is an end-to-end, unified analytics...
2023-05-24
18 reads
Microsoft has just announced Microsoft Fabric during the Microsoft Build conference. This is a unified analytic solution of the era of AI. Microsoft Fabric is an end-to-end, unified analytics...
2023-05-24
489 reads
MY WILL, MY BUG, MY GRADUATEJust a little under 18 and one half years ago, William came into my life. There are a lot of words to describe a new...
2023-05-23
44 reads
Using Statistics Parser to easily read output from STATISTICS IO and STATISTICS TIME.
2023-05-23
297 reads
I ran across an interesting post from Rita Fainshtein that looked at the different types of graphs for a set of data. I thought that was interesting, so I...
2023-06-09 (first published: 2023-05-22)
480 reads
Unlike TDE, there is some extra CPU overhead when you take an encrypted backup as the data has to be encrypted before being written to disk – whereas with...
2023-06-05 (first published: 2023-05-22)
279 reads
Recently I was doing a cleanup of one model, and I used Best Practice Analyzer (BPA) in Tabular Editor as a helper. Later, I realized I forgot to set...
2023-06-05 (first published: 2023-05-22)
547 reads
I’m working on SSAS Tabular project and suddenly i got following error when I even try to connect to SSAS.
Messages:
“The following system error occurred: A device attached to the...
2023-05-22
149 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Comments posted to this topic are about the item AI Experience Gap that we...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
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