Are You Protected from Ransomware
There have been many organizations that have become victims of ransomware over the years. Occasionally we hear about some high-profile cases in the news. Most every case I’ve read...
2023-09-19
2 reads
Blog Posts
Product Review: DataVeil
If you’re looking at data masking tools, I recently was able to review the DataVeil solution. Quite simply, getting production data out of non-production environments is still a big...
2023-09-19
37 reads
ADS Copilot Experiments with XML
I sent some code to a customer recently to help them decrypt some stored procedures. I sent a quick and dirty set of code, noting at the bottom that...
2023-09-18 (first published: 2023-08-23)
218 reads
Common Mistakes in SQL Server – Part 1
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is...
2023-09-18
477 reads
Common Mistakes in SQL Server – Part 1
In this series of articles I will be sharing the common mistakes in SQL Server. I am certain that this is going to be very interesting read, here is...
2023-09-18
8 reads
State of the Database Landscape Survey 2023
As data professionals, of any stripe, we should, as much as we can, where we can, base our decisions on data. After all, in theory anyway, we’re the experts...
2023-09-18 (first published: 2023-08-23)
222 reads
The Last Price Bump for the Data Community Summit
This week the cost of the PASS Data Community Summit jumps up to full price, on Sep 21. This is your last chance to save big, so get someone...
2023-09-18
29 reads
DataMoshpit!
Today I’m presenting at DataMospit, the most metal conference in the data space! You can download the Sea of Madness bingo card from here: https://github.com/spaghettidba/CodeSamples/raw/master/SQLServerInfernals/InfernalBingo.xlsx The winner will get...
2023-09-16
69 reads
A New Word: Justing
justing – n. the habit of telling yourself that just one tweak could solve all your problems – if only you had the right haircut, if only you found...
2023-09-15
15 reads
Friday Flyway Tips: Searching Migrations
When a Flyway Desktop (FWD) project (or Flyway project) has been around for a long time, there can be a lot of migration scripts. That can be a pain...
2023-09-15 (first published: 2023-08-11)
105 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)...