Audit SQL Agent Jobs
One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance - unless they fail. What if the job failed because something was changed in...
2019-01-17
215 reads
Audit SQL Agent Jobs
One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance – unless they fail. What if...
2019-01-17
1,006 reads
Getting Parameters Out From a Stored Procedure–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-01-31 (first published: 2019-01-16)
3,759 reads
Database modelling in a post-SSMS world: dbForge Studio
A few months ago, Microsoft announced that SQL Server Management Studio (SSMS) will no longer include the visual Database Diagrams...
2019-01-16
235 reads
Multi-server scripts with SSMS using SQLCMD mode
SSMS is the most common tool used by SQL Developers or DBA’s but unfortunately there are some features that are...
2019-01-30 (first published: 2019-01-16)
3,216 reads
Watch all my free PASS Summit recordings– and more videos at Pass.org
A magical thing happened this week in the SQL Community Slack (it’s free to join, by the way, sign up here). In the midst of a discussion about the...
2019-01-16
52 reads
Butter in My Coffee and Low Carb Tortillas: Keto Day 2
Hello Dear Reader, just a quick check in, I had originally planned to blog yesterday. However, screen shots of apps made for a terrible looking blog.Fortunately I found that...
2019-01-16
20 reads
Butter in My Coffee and Low Carb Tortillas: Keto Day 2
Hello Dear Reader, just a quick check in, I had originally planned to blog yesterday. However, screen shots of apps...
2019-01-16
231 reads
Data Modeling Webcast Rescheduled
Unfortunately, due to a last minute scheduling conflict on my side, we’ve had to reschedule the data modeling webcast with...
2019-01-16
142 reads
A brief introduction for bcp
I end up using the bcp utility to move tables between environments, and I’ve found that a lot of the...
2019-02-04 (first published: 2019-01-16)
3,190 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