Revoke the permission(s) before dropping the server principal
As a remote DBA I often have to log in to client systems for a fixed amount of time and...
2018-06-27 (first published: 2018-06-15)
14,089 reads
Volunteer for PASS!
This week, I had the opportunity to be the moderator for Joseph Barth’s (blog|twitter) 24 Hours of PASS Summit Preview session about Azure Data Factory V2. It was fun,...
2018-06-15
6 reads
PoshSSDTBuildDeploy 2.0.268.0 - Now With Issue Management!
Hello!
Concluding this weeks work on PoshSSDTBuildDeploy is adding one of the features I spoke about yesterday, which was joining the OperationSummary and Alerts objects to produce a new table...
2018-06-15
14 reads
Information Measurement with SQL Server, Part 4.1: The Kullback-Leibler Divergence
By Steve Bolton
…………This informal series of tutorials on how to implement a hodgepodge of information metrics in SQL Server is...
2018-06-25 (first published: 2018-06-14)
2,179 reads
Speaking At SalemSQL, A Kind Of Homecoming
I am so excited to announce that I will be giving my Data Types Do Matter session for the SalemSQL...
2018-06-14
253 reads
The transaction log for database ‘MyDB’ is full due to ‘LOG_BACKUP’
Your transaction log is full. Both Microsoft, and about 100 articles and blogs have covered this topic, but let's take...
2018-06-14
367 reads
SQL Server -Database Backup Report using PowerShell and T-SQL
In the previous articles, we discussed several ways of taking backup and testing the restore process to ensure the integrity...
2018-06-14
1,034 reads
Respectfully Responding
I typically don’t write opinion posts, but given recent events I thought it was important to follow up on one of my tweets....
2018-06-29 (first published: 2018-06-14)
2,273 reads
Docker Challenges
I’ve been trying to get time to play with Docker more. I had it setup on my old laptop and...
2018-06-14
1,117 reads
The identity column, the insert and the linked server.
tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted...
2018-06-14
534 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