When I was working with Snowflake on a project, it seemed security (assigning roles to users, assigning permissions etc.) is not as straight forward as it is in SQL...
2022-04-13 (first published: 2022-04-02)
231 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-01
34 reads
Creating useful reports is part art and part science. On one end of the spectrum, you have visually appealing and highly customized reports and dashboards that are truly works...
2022-04-13 (first published: 2022-03-31)
462 reads
This is a short blog to give you a high-level overview on a product called Azure IoT Central. I saw this fairly new Azure product (GA Sept 2018) in...
2022-04-11 (first published: 2022-03-31)
190 reads
Registration for the Data Community Summit opens today! You can sign up and come to Seattle in November with all the other data platform pros that you’ve missed seeing...
2022-04-08 (first published: 2022-03-31)
105 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-31
25 reads
Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is ... Continue reading
2022-04-15 (first published: 2022-03-31)
346 reads
Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is ... Continue reading
2022-03-31
573 reads
Ve středu 9.3.2022 jsme se tradičně sešli nad novinkami ze světa dat, datových skladů, Power BI, Azure apod. Jestli jste chyběli (ale příště dorazíte, že? :D), zde je malý...
2022-03-31
9 reads
This blog post is based on my personal experience running an Azure Data Explorer (ADX) cluster. I was doing a presentation for Data Platform Summit in India, I spun...
2022-04-11 (first published: 2022-03-31)
154 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...
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
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