A New Word: mahpiohanzia
mahpiohanzia – n. the frustration of being unable to fly, unable to stretch out your arms and vault into the air, having finally shrugged off the burden of your...
2023-08-25
38 reads
Blog Posts
Finding Identity Columns–#SQLNewBlogger
I had to find a set of identity columns recently and through this would make a good blog post. Another post for me that is simple and hopefully serves...
2023-08-25 (first published: 2023-08-02)
251 reads
Open Online Community Hangout During PASS Summit
Are you bummed that you can’t attend the PASS Data Community Summit conference in-person this November during the week of November 13? There’s lots of reasons to be there,...
2023-08-25
8 reads
T-SQL Tuesday #165 Job Titles – What do you need?
My dear friend Josephine Bush a.k.a HelloSQLKitty hosts this month’s T-SQL Tuesday. Josephine’s call to us is to share our understanding of the multitude of job titles available out...
2023-08-25 (first published: 2023-08-08)
172 reads
Using Secrets in Docker Swarm for SQL Server
In a previous post I went through how to run SQL Server in Docker Swarm and in this post I want to continue delving into the Docker Swarm platform...
2023-08-23 (first published: 2023-08-02)
188 reads
What’s in a SQL Server Managed Instance?
My current position involves a lot of work with SQL Server Managed Instances so you’ll probably be hearing a lot ... Continue reading
2023-08-23 (first published: 2023-08-03)
437 reads
Creating and Configuring a Power BI VNet Data Gateway
If you are using Power BI to connect to a PaaS resource on a virtual network in Azure (including private endpoints), you need a data gateway. While you can...
2023-08-21 (first published: 2023-08-01)
723 reads
Decrypting Stored Procedures with SQL Compare
I had a client that was struggling with some encrypted stored procedures. They needed to decrypt them, which I know is a pain in the #@$%@#$@#$#@. I had to...
2023-08-21
239 reads
Reflections on the Software Industry
Every now and then we like to have someone do a guest post, with a topic of their own choosing. This time, we picked Kevin Miller (LI). Kevin is...
2023-08-21 (first published: 2023-08-01)
170 reads
A New Word: Rückkehrunruhe
rückkehrunruhe – n. the feeling of returning from an immersive trip only to notice if fading rapidly from your awareness, as if your brain had automatically assumed it was...
2023-08-18
191 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...