SQL Database Backups using DBATools PowerShell Module
Want to learn how to set up a PowerShell DBA environment? Here's how to configure it for SQL Server backups. T
2022-02-08
76 reads
Passed DP-900–A Review
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-02-07
118 reads
Query Your Statistics: dm_db_stats_properties
We’ve always been able to look at statistics with DBCC SHOW_STATISTICS. You can even tell SHOW_STATISTICS to only give you the properties, STAT_HEADER, or histogram, HISTOGRAM. However, it’s always...
2022-02-21 (first published: 2022-02-07)
451 reads
Daily Coping 7 Feb 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-02-07
20 reads
Creating a distributed Service Broker application with Docker
As you might know, I have written a long time ago a book about Service Broker – a technology within SQL Server that almost nobody is aware of and...
2022-02-21 (first published: 2022-02-07)
466 reads
SQL Server – Backing up the Tail of the Log
When a database gets corrupted or failure occurs, before restoring the database from the backups you've created, it is recommended to create a tail-log backup of the records that...
2022-02-16 (first published: 2022-02-07)
1,039 reads
Azure DB for MySQL – Storage v1 vs v2
When it comes to MySQL and storage you will normally have to decide on 3 options: basic, general purpose v1 or v2. Basic does support up to 1TB and...
2022-02-07
34 reads
Starting your Azure Journey – Free Trial, Tenant and Subscription
G’day, Over the last few years I’ve had the privilege of helping people start on their Azure journey. Some come along with Azure Subscriptions, others just want to get...
2022-02-23 (first published: 2022-02-07)
493 reads
A Hard Drive Retrospective – SQL Server Edition
Sometimes it’s good to look back and appreciate what we have and how far we’ve come. This applies to many things, but today I’m talking about the humble hard...
2022-02-18 (first published: 2022-02-06)
583 reads
Data Thoughts – Renewing Microsoft Certifications
G’Day, I recently renewed one of my Azure Certifications, extending it by another year from the original expiry data. You can extend any certification that is about to expire...
2022-02-16 (first published: 2022-02-05)
455 reads
Blogs
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
Car Update October 2026
By Steve Jones
This month I want to look at a few of the things I’ve seen...
SQL Server 2016 Has Reached End of Support. Now What?
By SQLPals
SQL Server 2016 Has Reached End of Support. Now What? On...
Forums
PostgreSQL 19 Is Late
Comments posted to this topic are about the item PostgreSQL 19 Is Late
Hyperscale Replicas V
Comments posted to this topic are about the item Hyperscale Replicas V
A Heavy Heart
Comments posted to this topic are about the item A Heavy Heart
Question of the Day
Hyperscale Replicas V
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers