Virtualisation – An Introduction
For the last two years or so, in one capacity or another I have been running SQL Server in virtual...
2010-04-21
666 reads
Blog Posts
A DMV a Day – Day 20
The DMV for Day 20 is sys.dm_exec_cached_plans which is described by BOL as:
Returns a row for each query plan that...
2010-04-20
1,095 reads
Growing PASS Step One - Communication
My History with PASS
Over the last two years I have become more involved in the SQL Server community through attending...
2010-04-20
616 reads
Review: Ninite
Found Ninite while browsing a list of efficiency tools on PCWorld.com. It’s a one stop super installer, you run through...
2010-04-20
630 reads
Sad Sack – Hardware Failures all over
I feel like I have some bad digital karma lately. In the past week I’ve had these downed systems:
iPod iTouch...
2010-04-20
646 reads
SQL Saturday #39, New York, New York
A town so big they named it twice.
If you’re not excited about SQL Saturday in NYC this weekend… why not?...
2010-04-20
520 reads
SQL Server Agent
Found out this week – that we should be restarting this service at least once a week ! (thus allowing the CPU...
2010-04-20
382 reads
Staying Current with SQL Server Builds
There was some conversation on Twitter about how to get notification when new Cumulative Updates are released for SQL Server...
2010-04-20
975 reads
Stepping Stone Cert II
Back on March 30, I wrote about a Stepping Stone Certification that seems to be missing between the MCM and...
2010-04-20
749 reads
Whats a Good Rule for Max Degree of Parallelism?
Introduction
I am one of those people that believe that anything worth doing is worth having a script to do it....
2010-04-20
557 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