Deleting Azure SQL Database VNETs
This is quite a new feature (currently in preview) but an important one where we now have the ability to...
2018-02-07 (first published: 2018-01-29)
1,034 reads
How To: Install SQL Server on an Azure VM
Last month I demonstrated creating an Azure VM with SQL installed using one of the default templates. While this is...
2018-01-29
623 reads
Managing SQL Server Transaction Log File
Overview
In our previous section we have discussed how to create an audit trigger in SQL Server and how it helps...
2018-01-29
1,742 reads
Speaking at PASS Summit and why you need to think about submitting….
This post is about the honor and experience of speaking at PASS Summit not once (2016) but twice (2017).
I recently...
2018-01-29
393 reads
2017 Year in Review for SQLDusty.com
2017 was an awesome year for SQLDusty.com! Thank you to all of the readers and visitors that stopped by to...
2018-01-29
402 reads
Database Backup Options for SQL on Azure IaaS
[read this post on Mr. Fox SQL blog] Recently I had a requirement to collate and briefly compare some of the various methods to perform SQL Server backup for...
2018-01-28
19 reads
Database Backup Options for SQL on Azure IaaS
[read this post on Mr. Fox SQL blog]
Recently I had a requirement to collate and briefly compare some of the...
2018-01-28
1,115 reads
Saving SSMS Settings (Day 28)
Over the last several weeks, we have been making several changes to various settings in SSMS. Now that you have...
2018-01-28
397 reads
Doing More with Less – My Productivity Guide
Houston, We Have a Problem
We are living in a crazy world. And it just gets more and more crazy all...
2018-01-28
861 reads
Comparing Query Plans (Day 27)
When you are performance tuning code, you will frequently examine the execution plans to see what is happening. As you...
2018-01-27
462 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