Know How to Recover SQL Server Database Without Backup
Microsoft SQL Server has widely used database management system for storing and retrieving data. It stores its files in MDF,...
2018-01-24
597 reads
Configuring Persistent Storage for SQL Server in Azure Container Services
I’ve been playing around with SQL Server running in Kubernetes in Azure Container Services (AKS) for a while now and...
2018-02-01 (first published: 2018-01-24)
1,470 reads
Power BI Custom Visuals Class (Module 87 – Funnel with Source MAQ Software)
In this module you will learn how to use the Funnel with Source Custom Visual by MAQ Software. The Funnel...
2018-01-30 (first published: 2018-01-24)
1,257 reads
Will GDPR cause a “Database Run”?
What is GDPR, everyone’s (current) favorite acronym? It stands for “General Data Protection Regulation” and is an act / law / set...
2018-02-05 (first published: 2018-01-23)
2,413 reads
Quick Editing Tips (Day 23)
There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...
2018-01-23
189 reads
Quick Editing Tips (Day 23)
There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...
2018-01-23
320 reads
You Need a New Hobby
Not sure who this is that is attempting to hack into my blog so desperately, but seriously, time for a...
2018-01-23
304 reads
AWS EC2 Linux AMI with pyodbc
AWS EC2 Linux AMI with pyodbc, psqlODBC, Microsoft ODBC Drivers Context: Using pyodbc within a small python application to pull tracking data from an Azure SQL Server DB, do...
2018-01-23
83 reads
Using dbatools to verify your SQL Server instances version compliance
One of the main DBA's duties is to guarantee that SQL Server instances are up-to-date in terms of patches (Service...
2018-01-23
749 reads
My Favorite SQL Prompt Features
SQL Prompt from Redgate Software is one of the tools that I cannot live without. Well, that’s probably an exaggeration...
2018-02-02 (first published: 2018-01-23)
3,266 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers