Save Money On Your Azure Monthly SQL Database Bill
Microsoft gives you two purchasing models for your Azure SQL Databases (SQL DB), a DTU and a vCore based model...
2018-09-05 (first published: 2018-08-22)
2,251 reads
Is a SELECT statement always executed?
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-08-22
192 reads
#SQLCareer 3/4 August 6th 2018
Last month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the IT/database...
2018-09-06 (first published: 2018-08-22)
1,657 reads
Always On SQL Server Replica in a Disconnected State
Sometimes the SQL logs and application logs provide some great info in regards to errors and issues. When building an...
2018-08-22
5,676 reads
Format Query as JSON
JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it...
2018-09-06 (first published: 2018-08-22)
3,729 reads
NFL Football Player Stats & Analysis 2018 is now available!
I’ve had a lot of people ask me for this over the past few months and its finally (mostly) ready!...
2018-09-03 (first published: 2018-08-21)
2,557 reads
SQL in the City Summit
This fall, in October, Redgate Software will be hosting three, live, in-person events. These events will take place in New...
2018-09-03 (first published: 2018-08-21)
1,475 reads
Distributed cache service stuck in started & Provisioning on CA page
Hello Readers,
As per Previous article, i tried to explain configuration of Distributed Cache in SharePoint 2013 environment. Same follows for...
2018-08-21
1,090 reads
SQL Server Error 5123 Attach Database - Resolution
SQL server error 5123 occurs when users want to attach the database, which has been placed on different locations. This error is a kind of permission error that occurs...
2018-08-21
78 reads
SQL Server Error 5123 Attach Database - Resolution
SQL server error 5123 occurs when users want to attach the database, which has been placed on different locations. This...
2018-08-21
35,325 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