When It’s Still Viable
If a technology is still viable, don’t overlook it. Don’t get caught up chasing the “shiny” or the “perfect” solution just because you can.
2024-10-08
26 reads
Blog Posts
Getting Started with Azure SQL Database – A Beginners Guide
Last Updated on September 24, 2024 by John Morehouse Years ago, I saw the wave of the future and that wave was Cloud. The Cloud is not a fad...
2024-10-07 (first published: 2024-09-24)
395 reads
Moving T-SQL Tuesday to Jekyll
I got a message a few months back that Microsoft was deprecating the MySQL server version that I was using in Azure. The cost was going up, and while...
2024-10-07
15 reads
Msg 3140 – Could Not Adjust the Space Allocation for File
I often need to shrink database files. I know, ‘shrinking is bad’, however there are situations where it is very much needed. In my line of work, I come...
2024-10-07
267 reads
SQL Query Stats via Powershell
Sometimes, work tasks and questions that come up in the SQL Server Community Slack coincide.
A couple weeks ago, DrData asked
With SET STATISTICS IO ON, is there really no way...
2024-10-07 (first published: 2024-09-22)
299 reads
Step Up Your Data Game: Learn Advanced SQL Techniques for Analysis
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential for revealing insights buried within extensive databases. However, basic SQL queries can only take you...
2024-10-07
42 reads
SQL Saturday Boston 2024 Slides
Thanks to everyone that came to my talks. Slides are below. Best Practices for Seamless Deployments Balance in Life with a Career If you have questions, please reach out.
2024-10-06 (first published: 2024-10-05)
29 reads
SQL Saturday Boston 2024 Slides
Thanks to everyone that came to my talks. Slides are below. Best Practices for Seamless Deployments Balance in Life with a Career If you have questions, please reach out.
2024-10-05
5 reads
A New Word: Moledro
moledro – n. a feeling of resonant connection with an author or artist you’ll never meet, who many have lived centuries ago and thousands of miles away but can...
2024-10-04
8 reads
A New Word: Moledro
moledro – n. a feeling of resonant connection with an author or artist you’ll never meet, who many have lived centuries ago and thousands of miles away but can...
2024-10-04
196 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