Splitting ID’s with commas, updating them, and then Slamming them back together
Unfortunately my company still uses
MS Access DBs. That's Access 97 folks! I've battled many challenges over the
last couple months with...
2011-08-16
1,258 reads
find...underlings...
find.....underlings.....
searching......
underlings found......
I recently was given the task to create a stored procedure to find people who are under other people...
2011-06-22
844 reads
Double Hop of Doom
I recently had to battle through THE DOUBLE HOP OF DOOOOOMMM!! It was a very rewarding experience and I think...
2011-06-20
4,428 reads
Don't touch that Maintenance Plan Job
Good ol Maintenance plans. With 2005 and beyond we received the glorious SSIS backed Maintenance plans. I love SSIS so...
2011-06-12
1,934 reads
Can Scrum work for the DBA?
Agile! Scrum! Development methodologies! Sprint!
If you have a manager who reads any web page about being a manager, then you...
2011-05-29
8,421 reads
Recovery Model for Every Database
One thing that is enjoyable about my position is working with people who have no idea what SQL is besides...
2011-05-25
1,175 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Fulltext filter daemon host (FDHost) process has stopped abnormally
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers