The Question – Why?
The question I get asked a lot by other data professionals at conferences, events, speaking engagements, family, friends, etc. is...
2014-10-14 (first published: 2014-10-06)
5,943 reads
The SQL Professor
C-R-U-D The Basics
C-R-U-D The Basics
What is CRUD? Well, there are a lot of things I can think of when I use the...
2014-10-09 (first published: 2014-10-01)
8,117 reads
Passwords – A T-SQL Tuesday Topic
Being engrossed with the daily tasks at hand I completely missed this month’s T-SQL Tuesday is being brought to you...
2014-09-18
314 reads
SQL Prompt 6.4 – Get It
This guy looks just like me a few weeks ago only one difference…..he has hair!!! Okay seriously though, I felt...
2014-09-18
462 reads
What I Wish I Had Known Sooner…as a DBA
Yesterday I took a minute and to review some posts by some Data Professionals and in doing so I came...
2014-08-28
1,102 reads
ISPACs – Got To Love Em
Being a DBA and working with various teams, I have become accustomed to deploying SSIS packages. I’ll even go back...
2014-08-20
579 reads
And Just Like That….Three Years
Time is a constant. Anything and everything requires time it seems, and with that said I received a reminder today...
2014-08-18
291 reads
T-SQL Tuesday #57 – SQL Family and Community
Maybe it is just me, but these monthly block parties seem to be coming around quicker and quicker as time...
2014-08-12
300 reads
SQL Prompt – The Power Within
*Photo by Red Gate
Come a little closer; no seriously come on over just a little closer as I don’t want...
2014-07-15
561 reads
T-SQL Tuesday #56 – Assumptions
Question: “What time is it?”
Answer: “T-SQL Tuesday time”
Question: “What time?”
Answer: “T-SQL Tuesday time”
“I can’t hear you?!?!?!”
That’s right; it’s that time...
2014-07-09
408 reads
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers