Did you know…you can change the default file encoding for new query on SSMS?
If you have been reading my last blog posts, you know that I’m currently working on a SQL code migration...
2018-06-05
491 reads
Prepping for Mastering Index Tuning with Brent Ozar Unlimited
I got the chance to sign up for a few courses from the Brent Ozar Unlimited team and took it....
2018-06-15 (first published: 2018-06-05)
2,939 reads
WSFC Lost Quorum votes due to network problem
Problem:
Early in the morning I received emails requesting for support as the applications were failing to connect to one of...
2018-06-18 (first published: 2018-06-05)
4,692 reads
Linked Server to Azure SQL Database
You may (or may not) have a requirement to setup a linked server to Azure SQL Database from a locally...
2018-06-13 (first published: 2018-06-05)
1,863 reads
Bring Your Own Key to Azure SQL Database TDE New UI
In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key. At the time the only way to bring your...
2018-06-05
17 reads
Bring Your Own Key to Azure SQL Database TDE New UI
In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key....
2018-06-12 (first published: 2018-06-05)
1,905 reads
4 Ways To Define Lookup Values In A Query
Watch this week’s episode on YouTube.
Occasionally you may need to create a lookup table of values for a single query. ...
2018-06-13 (first published: 2018-06-05)
4,266 reads
4 Ways To Define Lookup Values In A Query
Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...
2018-06-05
33 reads
4 Ways To Define Lookup Values In A Query
Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...
2018-06-05
7 reads
SQL Database Corruption: Causes, Prevention, Fixing Techniques
“I had a Database File and I want to attach this MDF file to SQL Server 2014. However, whenever I...
2018-06-05
262 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