What it is Page Life Expectancy (PLE)
Which cup will you prefer to go the less
number of times to the coffee maker?image was taken from hereLet us...
2018-06-21
228 reads
New Session: Profiling Your Data
Data Quality is a huge issue, especially now with more and more data being created daily. According to Micro Focus...
2018-06-20
275 reads
Updating to SQL Change Automation
The SQL Change Automation release was early this week. This is replacing ReadyRoll and our DLM Automation products, rolling them...
2018-06-20
1,036 reads
Dates and Times in SQL Server: DATENAME()
Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many...
2018-06-20
918 reads
SSMS reset window layout (Day 37)
SSMS is a wonderful tool. You can drag Windows around, grouped with others, split, docked, undocked, hidden… it seems endless...
2018-07-02 (first published: 2018-06-20)
4,743 reads
SQL Server Patching within an Always On Environment
SQL Server Patching with the introduction and adoption of Always On has changed. The traditional method by waiting for Service...
2018-06-20
177 reads
Overview of SQL Server 2017 Docker containers on Linux machine
SQL Server 2017 is the biggest release and most important releases in the Microsoft product history simply because of the...
2018-06-20
1,409 reads
Strings vs Identifiers
A common mistake, and one I make frequently myself is to use a string in place of an identifier, or...
2018-07-02 (first published: 2018-06-20)
3,395 reads
Replication Max Text Length
Ever seen the below error? Until this week I hadn’t. So, I figured I’d take a little time and introduce...
2018-06-28 (first published: 2018-06-20)
10,937 reads
Deploying to Azure Without Writing JSON Arm Templates
Reading Time: 6 minutes (not a minute longer)
TLDR; ARM templates are a great way to deploy to Azure, setting up...
2018-06-19
398 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