A Clean Values Clause with SQL Prompt
I’ve had this code in a snippet for a long time: I appreciate the markup to prevent SQL Prompt from doing this, which used to always happen. I can’t...
2019-05-13
121 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
Communicate Smarter Not More
After installing Microsoft Teams, Steve has a bit of communication overload.
2019-05-13
209 reads
2019-05-13
1,050 reads
2019-05-11
128 reads
Initialize-HgsServiceName Fails in VMWare
A short one, but one that took some digging and debugging and help from others. Saving here, so I remember, as do others. I had a VMWare Workstation v12.x...
2019-05-10 (first published: 2019-05-01)
150 reads
2019-05-10
471 reads
The Impediments to Change
SQL Server is releasing a new version of the engine every 12-24 months at this point. That puts pressure on all of us to learn constantly about the changes. Even if we don't look to upgrade all of our existing instances, we can't buy older versions when the new one is released. Often many of […]
2019-05-10
254 reads
2019-05-09
1,229 reads
The Death of the GDPR
The GDPR is struggling with enforcement against some of the larger tech companies. Steve thinks this is a problem, but it might not matter for smaller companies.
2019-05-09
502 reads
Default Backups and Feature Awareness
Default backup schemes for databases would be a nice enhancement.
2019-05-08
258 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers