Setting Windows To Prefer IPv4 Over IPv6
This post is a bit different from my usual SQL Serer posts, I recently hit a problem where a legacy...
2018-05-03
481 reads
Blog Posts
The Forgotten Fourth SQL Server Recovery Model
SQL Server recovery models define when database transactions are written to the transaction log. Understanding these models is critical for...
2018-05-03 (first published: 2018-04-24)
2,983 reads
5 Ways to Examine Cardinality Metrics
In SQL Server the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The...
2018-05-02
390 reads
Azure SQL Data Warehouse Gen2 announced
Monday was announced the general availability of the Compute Optimized Gen2 tier of Azure SQL Data Warehouse. With this performance optimized tier, Microsoft...
2018-05-02
523 reads
Azure SQL Data Warehouse Gen2 announced
Monday was announced the general availability of the Compute Optimized Gen2 tier of Azure SQL Data Warehouse. With this performance optimized tier, Microsoft...
2018-05-02
191 reads
Database Files Down The Wrong Path
I manage a few servers used to host SQL Instances for development and test purposes. Each of those instances hosts...
2018-05-02 (first published: 2018-04-24)
2,960 reads
Dates and Times in SQL Server: What about TIMESTAMP?
It occurred to me that we haven’t covered the TIMESTAMP data type in this series about dates and times. TIMESTAMP...
2018-05-02
272 reads
Day 2: Introduction to MySQL
Story of MySQL is very interesting and involved emotions in it. This is my understanding and my though on Journey...
2018-05-02
308 reads
Getting my Twitter Data via Azure Logic Apps
As a mini project I wanted to use Azure logic apps to pull tweets from my twitter account when people...
2018-05-02
342 reads
SQL Homework – May 2018 – Create a database
I’ve really got to make a plan here at some point. So far I’ve been just putting down things as...
2018-05-02
259 reads
Blogs
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
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...
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