SQL Server 2008 and SQL Server 2008 R2 - OUT of SUPPORT July 2019
Both SQL Server 2008 and SQL Server 2008 R2 go out of extended support with Microsoft in July 2019. That’s...
2019-01-02
185 reads
Gethyn Ellis
SQL Server 2008 and SQL Server 2008 R2 - OUT of SUPPORT July 2019
Both SQL Server 2008 and SQL Server 2008 R2 go out of extended support with Microsoft in July 2019. That’s fast approaching and as we enter the new year...
2019-01-02
9 reads
Fun-time Friday - Data outages, Security Breaches and Brexit
It’s been an interesting week here at gethynellis.com. We have been busy with a SQL Server version upgrade for a...
2018-12-28 (first published: 2018-12-07)
1,947 reads
Fun Time Friday: Black Friday, Mad Friday, Frantic Friday or Black Eye Friday
Black Friday (No,not Shopping!), Mad Friday, Frantic Friday or Black Eye Friday is a nickname for the last Friday before...
2018-12-21
168 reads
Fun Time Friday: Black Friday, Mad Friday, Frantic Friday or Black Eye Friday
Black Friday (No,not Shopping!), Mad Friday, Frantic Friday or Black Eye Friday is a nickname for the last Friday before Christmas (Today!) in the United Kingdom.It is the most...
2018-12-21
11 reads
Fun time Friday - A week is a long time in....
A week is a long time in...
SQL Server Land
A week is a long time in SQL Server land. This week...
2018-12-14
168 reads
Fun time Friday - A week is a long time in....
A week is a long time in...
SQL Server LandA week is a long time in SQL Server land. This week I have been busy working on a version migration...
2018-12-14
7 reads
A New Video - Create a DB Executor Role
A long long time ago, I wrote a blog post showing how to create db_executor role in SQL Server. There...
2018-11-19 (first published: 2018-11-12)
1,825 reads
Sharding: Horizontal Scaling in Azure SQL Database
David has produced a talk all about Sharding. Or if you prefer horizontally scaling your Azure SQL database.
You can view...
2018-10-19 (first published: 2018-10-04)
2,731 reads
Money Ball: Fantasy Football Kicks Off Tonight - Jeff's Degenerates
You might think that this blog post is out of place here but I'm hoping use some of the data...
2018-08-10
295 reads
Blogs
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers