Over the last few years, I’ve had a few people ask me why I don’t create two Twitter accounts so I can separate work and personal things. I choose...
2022-10-07 (first published: 2022-09-26)
226 reads
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
14 reads
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
19 reads
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
134 reads
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
14 reads
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)
28 reads
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
12 reads
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
40 reads
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-10-05 (first published: 2022-09-20)
348 reads
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
54 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
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...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers