Remember the Default Window
I ran across a question recently from a user about why they had strange results from a windowing query. This...
2018-09-10 (first published: 2018-08-23)
2,683 reads
My Azure SQL Database Elastic Job is Broken!
I use elastic pools. They are a fabulous way of saving money when running many Azure SQL Databases, that is...
2018-08-23
340 reads
Power BI Custom Visuals Class (Module 116 – Scatter Chart by Akvelon)
In this module you will learn how to use the Scatter Chart by Akvelon. The Scatter Chart by Akvelon has...
2018-09-11 (first published: 2018-08-23)
2,630 reads
PSPowerHour v1.0 Wrap-Up
The first edition of the PSPowerHour is in the books and it looks like it was a big success. This one was dbatools-heavy but I chalk that up to...
2018-08-23
9 reads
Azure SQL Database high availability
In this blog I want to talk about how Azure SQL Database achieves high availability. One of the major benefits from moving from on-prem SQL Server to Azure SQL...
2018-08-22
161 reads
Azure SQL Database high availability
In this blog I want to talk about how Azure SQL Database achieves high availability. One of the major benefits...
2018-08-22
843 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 also used to stored NoSQL unstructured data, and because...
2018-08-22
9 reads
SQL in the City, Fall 2018 – Join Us!
SQL in the City is coming up, and it's a huge opportunity to learn. Register now to attend the free online streamed event, and join the Redgate team in...
2018-08-22
13 reads
Relational databases aren’t the problem
Content warning: This is the first of two rebuttal essays, about why someone is wrong on the Internet. It is...
2018-09-10 (first published: 2018-08-22)
3,154 reads
How to cause a simple spill to tempdb
Sometimes it’s useful to know how to cause a problem. Maybe you’ve never encountered the problem, and want to get hands-on experience. Maybe you’re testing a monitoring tool, and...
2018-08-22
23 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