A New Word: Harmonoia
harmonoia – n. an itchy sense of dread when life feels just a hint too peaceful – when everyone seems to get along suspiciously well, with an eerie stillness...
2023-10-13
25 reads
Blog Posts
Creating an Empty Repo in GitHub–#SQLNewBlogger
I saw someone struggling with getting started with a Visual Studio project and Azure DevOps. They got a conflict, which I’ll show and then get you started with an...
2023-10-13 (first published: 2023-09-20)
222 reads
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call the same process for different values, you can create widgets to allow you to pass...
2023-10-13 (first published: 2023-09-28)
332 reads
dataMinds Connect 2023 – Raiders of the Lost ADX slides
You can find the slides for the session that I gave with Johan at dataMinds Connect 2023 at GitHub. As usual, the event was amazing. A lot of great...
2023-10-12
19 reads
A NEW’er Solution For An Old Problem: How To Gain Access To SQL Server When No DBA Around
How To Gain Access To SQL Server When No DBA
When I showed a draft of this article to a friend of mine, to...
2023-10-11 (first published: 2023-09-22)
893 reads
Data Platform SLAs
Database professionals of the world – I have a question. Has your organization defined service level agreements (SLAs) for your data estate? I’m talking specifically the Recovery Point Objective...
2023-10-11 (first published: 2023-09-18)
225 reads
Microsoft Fabric roadmap
Microsoft Fabric is an awesome product that has now been in public preview for five months. If you are not familiar with it, check out my recent video where...
2023-10-11
214 reads
An Important Break
I left home last Tuesday for work, heading to New Jersey for work. Over the weekend, I took a side trip to see my daughter play volleyball at university,...
2023-10-09
19 reads
Common Mistakes in SQL Server – Part 4
Last week we have discussed how Null Values can cause a trouble in Common Mistakes in SQL Server – Part 3. This week I would like to draw your...
2023-10-09
13 reads
October Is National Disability Employment Awareness Month
As many of you know, I was diagnosed with ALS or Lou Gehrig’s disease a couple of years ago. Since then, I have 9 made it a personal mission...
2023-10-09
13 reads
Blogs
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
SQL Server Availability Groups
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers