SQL Server In Place Upgrades
Good morning dear blog reader. Today’s episode is fresh from a great weekend with the family. It is always fun to go on a road trip with my wife...
2022-09-27
2,124 reads
Blog Posts
Daily Coping 26 Sep 2022
Today’s coping tip is to enjoy photos from a time with happy memories. On vacation today in Venice, so I ought to get more, but I’ve started to put...
2022-09-26
8 reads
Learning PostgreSQL: The Tools
In case you don’t know, I’ve been writing a series of articles over on Simple-Talk as I learn PostgreSQL. It’s all from the point of view of a SQL...
2022-09-26 (first published: 2022-08-01)
260 reads
T-SQL Tuesday #154 – SQL Server 2022
This month’s T-SQL Tuesday is being hosted by Glenn Berry , and the subject he chose is “SQL Server 2022.” Microsoft has recently released the RC0 version of SQL...
2022-09-26 (first published: 2022-09-13)
368 reads
Daily Coping 23 Sep 2022
Today’s coping tip is to notice what you are feeling without any judgment. Today I’m stressed. I have been traveling a bit and trying to work remotely from my...
2022-09-23
13 reads
Look Into Chocolatey
Just a suggestion, but I’d say you should look into Chocolatey. Let me explain why. Sabbatical For those who don’t know I was recently on a six-week sabbatical from...
2022-09-23 (first published: 2022-09-12)
346 reads
Snowflake – Where is the explain/execution plan?
Whatever your database background is you will have heard of an execution / explain plan. Snowflake is no different. Coming from a MS SQL background I was used to...
2022-09-23
111 reads
Using Snowflake – Hands On
Now let’s start the process of creating a snowflake account in the Azure Cloud. You can sign up for a free trial from here – https://signup.snowflake.com/ I am going...
2022-09-23 (first published: 2022-07-26)
381 reads
Daily Coping 22 Sep 2022
Today’s coping tip is to ask a trusted friend to tell you what strengths they see in you. On one hand this would seem easy. On the other, it...
2022-09-22
8 reads
Power BI Tracker
Znáte ten pocit, kdy jste si přepsali nějakou složitější measure a rádi byste jí vrátili do stavu, jak vypadala před hodinou? Nebo kolega něco upravil ve vašem modelu, ale...
2022-09-22 (first published: 2022-09-21)
17 reads
Blogs
Who are you? Building an identity map.
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Call a Fabric REST API from Azure Data Factory
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...
Distributed Availability Group Dashboard
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This...
Forums
Create Raw Zone Tables using Generative AI: Data Engineering with Fabric
Comments posted to this topic are about the item Create Raw Zone Tables using...
Database DevOps Metrics
Comments posted to this topic are about the item Database DevOps Metrics
Replacing a NULL II
Comments posted to this topic are about the item Replacing a NULL II
Question of the Day
Replacing a NULL II
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers