Blog Posts

Daily Coping 23 Sep 2022

• by Steve Jones

• The Voice of the DBA

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

Snowflake – Where is the explain/execution plan?

• by Arun Sirpal

• All About SQL

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

1 reads

Daily Coping 22 Sep 2022

• by Steve Jones

• The Voice of the DBA

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

Power BI Tracker

• by Joyful-Craftsmen

• Joyful Craftsmen Blog

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)

Checking Database Compatability = #SQLNewBlogger

• by Steve Jones

• The Voice of the DBA

Recently I needed to check the compatibility level of a database and SSMS didn’t work. This is what I did in T-SQL.https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16 Another post for me that is simple...

2022-09-21

Daily Coping 21 Sep 2022

• by Steve Jones

• The Voice of the DBA

Today’s coping tip is to leave positive messages for yourself to see regularly. I could use post-its, or something else, but something that has worked well for me with...

2022-09-21

“Done in 7 minutes” -SQL Server 2019 Install

• by gbargsley

• GarryBargsley

This blog comes to you from the home office after three days of caring for my sick six-year-old son. Yay for stomach bugs… Have you ever needed to install...

2022-09-20

1 reads

Azure Managed Instance Changing DNS prefix

• by jsterrett

• John Sterrett

Azure Managed Instances are provisioned by default with a yourname.uniqueid.databases.windows.net DNS fully qualified domain name (FQDN). Even on your private virtual network you will still have to use this...

2022-09-20

Conversion Precedence

• by Kenneth Fisher

• SQLStudies

Recently I talked about the difference between implicit and explicit datatype conversions. In it I ran this code: With the ... Continue reading

2022-09-20

Daily Coping 20 Sep 2022

• by Steve Jones

• The Voice of the DBA

Today’s coping tip is to find a caring, calming phrase to use when you feel low. Life is mostly good, but there are times I feel down, depressed, low,...

2022-09-20