DevOps Basics – Connecting to a Git Remote
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-05-18
643 reads
Blog Posts
Implementing Buffer Pool Extension
Buffer Pool Extension was released in SQL 2014 so it’s not new. It is also not advertised very much, but...
2017-05-18
193 reads
Removing an App Service Plan in Azure
In my previous postI adhered to my O-OCD (Operational OCD) and standardised my App Service Plan name to fit in...
2017-05-18 (first published: 2017-05-07)
1,591 reads
Setting SQL Server Max Memory Dangerously Low
Hopefully you know the relevance and importance of setting a correct value for max memory on your SQL Server. By...
2017-05-18
433 reads
Employers, let your people work from home
Work from home is, astoundingly, still not the norm in United States IT offices. This is ludicrous, because employees want...
2017-05-17
446 reads
Partitioning on a nullable column
tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add...
2017-05-17 (first published: 2017-05-03)
2,130 reads
Querying a Database
When we want to retrieve information from a database, we query the structure with language appropriate to the database. Remember...
2017-05-17
113 reads
Replacing an expiring SQL Server encryption key
So you’re using encryption in SQL Server, but you’ve discovered that the expiration date of a certificate is expiring. What...
2017-05-17 (first published: 2017-05-05)
5,696 reads
SQL Data Warehouse reference architectures
With so many product options to choose from for building a big data solution in the cloud, such as SQL...
2017-05-17
814 reads
SQL Server 2016 SP1 – A significant change to licencing
A lot has been written about the change of licencing in SQL 2016 SP1. Here's my two-pence worth.
2017-05-17
20 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers