SQLTreeo – Migration of extended properties to local storage
New SQLTreeo version introduced local storage option when your folders are stored to file system as structure of files and...
2013-03-28
1,687 reads
Network Packet Size: to Fiddle With or Not to Fiddle With
A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s...
2013-03-27
3,275 reads
The DBA Team #1–Code and Slides
Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment...
2013-03-27
1,651 reads
XQuery
In 2005 version of SQL Server, XQuerying was introduced. It’s a powerful feature and when used together with a CTE,...
2013-03-27
230 reads
What to Do When You Can't Wipe an Infected System
When it comes to workstations within most organizations, the solution when one gets infected is to wipe it and re-image...
2013-03-27
2,669 reads
Six top SQL Server 2012 management tools you should know about
Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities,...
2013-03-26
1,466 reads
SQL Server: Purging msdb History Tables to Control msdb Database Growth
From time to time, I see the following question posted on various SQL Server forums by different users asking why...
2013-03-26
1,552 reads
XML Support and SQL Server (Part 5)
Checkout the fifth part of my XML support and SQL Server article series here.
In this article, I discussed the basic...
2013-03-26
635 reads
A Rickety Stairway to SQL Server Data Mining, Part 10.2: DMX DML
by Steve Bolton
The three introductory posts in this series of self-tutorials on SQL Server Data Mining (SSDM) and the...
2013-03-26
2,230 reads
Policy Based Management On Change: Prevent not available
Policy Based Management has 4 evaluation modes and if you are not already familiar with them you can go HERE...
2013-03-26
1,865 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