SQL Training: The Hidden Engine Driving Business Growth
In the digital age, data is the new gold, but it's worthless if you can't understand and use it. That's where SQL (Structured Query Language) comes in. SQL is...
2024-08-02
43 reads
Kilt Day!
This is a quick blog post to announce that I am reviving Kilt Day at PASS Data Community Summit. Over the last few years… ah hell, let’s just say...
2024-08-16 (first published: 2024-08-01)
143 reads
Finding Where xp_cmdshell is Used
I saw a post recently where someone was concerned about where xp_cmdshell was in use inside their system. They felt it was a security risk, and decided to get...
2024-08-14 (first published: 2024-07-31)
624 reads
Building Studio in Public: Using WordPress Components and Tailwind CSS in our Local Development App
Here's how we used WordPress Components and Tailwind CSS to build our local development app, Studio.
2024-07-31
49 reads
Tech in 2030
What will the technology world look like in 2030? Cloud computing will naturally be the backbone of the world but I think with variants in “decentralising” concepts. By this...
2024-08-09 (first published: 2024-07-31)
137 reads
Data (and Humans) At Rest
We talk a lot about data in the data world – imagine that! Sometimes, we talk about data at rest, but when do we all rest? Do we even...
2024-08-12 (first published: 2024-07-30)
199 reads
Why We’re Partnering With Perplexity
The short answer is: You’ll be eligible for a piece of the pie, plus increased traffic to your website.
2024-07-30
23 reads
Regular Expressions to Generate Disable/Drop Index Scripts
Earlier this year, I embarked on a bit of a project to tidy up the indexes in a sizeable database. This database has over 900 tables, and there are...
2024-08-12 (first published: 2024-07-29)
439 reads
DevOps Days Minneapolis
Once again, I’m off to a conference next week. This time it is DevOps Days Minneapolis. I haven’t been to a DevOps Days event, though I always enjoy DevOps...
2024-07-29
27 reads
SQL Saturday Baton Rouge 2024–Resources
For my talk at SQL Saturday Baton Rouge 2024, here are the resources. Slides: Architecting Zero Downtime.pptx GitHub: https://github.com/way0utwest/ZeroDowntime If you have questions, reach out.
2024-07-27
24 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers