Using DTEXECUI to generate a DTEXEC command line statement the easy way
SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool...
2013-08-05 (first published: 2013-07-31)
2,730 reads
Kenneth Fisher
Generic Dynamic SQL Stored Procedure
Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle...
2013-07-31 (first published: 2013-07-22)
3,632 reads
Notes on debugging Database Mail problems
I’ve had to debug database mail problems several times over the last year or so. Below is a collection of...
2013-07-29
1,410 reads
I’m going to my first SQL Saturday!
I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused...
2013-07-24
665 reads
Scripting a partitioned table or index, a caution.
I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting.
First here...
2013-07-22 (first published: 2013-07-15)
2,558 reads
Amusing SQL Trick – Hide yourself from SQL Server
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead...
2013-07-17
840 reads
Ordering steps in a SQL Agent job
Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is...
2013-07-15 (first published: 2013-07-08)
2,199 reads
Writing Dynamic SQL (A how to)
A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions...
2013-07-01
2,741 reads
Using OUTPUT to back up a change
How will you back out if your change doesn’t work?! Always take a backup! There should always be a back...
2013-06-26
2,432 reads
Metadata Functions (OBJECT_NAME for example)
What is a metadata function? According to BOL a metadata function is one that returns data about the database or...
2013-06-24
845 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