SQL Server – Blocking a Truncate
The truncate option is fast and efficient but did you know that it takes a certain lock where you could...
2018-07-31
573 reads
Community Engagements Second Half of 2018 – It’s all about Biml
I have a couple of community engagements coming up in the second half of 2018 and I’d like to share...
2018-07-31
338 reads
Power BI Custom Visuals Class (Module 113 – Small Multiple Line Chart)
In this module you will learn how to use the Small Multiple Line Chart. The Small Multiple Line Chart allows...
2018-08-07 (first published: 2018-07-31)
2,282 reads
SQL Operations Studio: Keyboard Shortcuts, Actual Plans, & More
Last week I posted a quiz on SQL Operations Studio, a free, multi-platform tool from Microsoft. This tool is under active development and the features are improving by the day...
2018-07-31
29 reads
Should You Use Index Hints?
Watch this week’s post on YouTube
One of the things that the SQL Server query optimizer does is determine how to...
2018-08-16 (first published: 2018-07-31)
3,859 reads
Should You Use Index Hints?
Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...
2018-07-31
12 reads
Should You Use Index Hints?
Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...
2018-07-31
11 reads
Failed to join local availability replica to Availability Group – SQL Server error 41106 and 41158
When you configure SQL Server AlwaysOn Availability Group from management studio, it may fail with below error while joining secondary...
2018-07-31
15,797 reads
SQL Server Availability Group Auto Seeding Error
SQL Server Availability Group Auto Seeding is a wonderful thing, it saves database administrators time when setting up availability groups. ...
2018-07-30
717 reads
Coming Back After complete 3 Years
Friends/My Readers,
Its been a long i have been away from my blogging.When i see back Its exactly 3 yrs Today(30/July/2015...
2018-07-30
324 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