My Idea for the PASS Summit 2010 Opening Night Reception
First, some background. If you’ve been to the Summit you know that we have an opening night reception, lots of...
2010-04-16
1,120 reads
Powershell SMO Problem
We’ve been running the Enterprise Policy Management tools available from Codeplex for a few months now (Thanks to Buck Woody’s...
2010-04-16
721 reads
Confio Ignite: Part II
I’m continuing to evaluate Confio’s Ignite database monitoring tool. I’ve had it collecting data on a couple of production servers...
2010-04-16
1,816 reads
Book Review – SQL Server Integration Services: Problem – Design – Solution
I usually don't do book reviews (at least publicly, anyway), but when I find a piece of work that I...
2010-04-16
2,162 reads
SQL Server 2008 R2
The RTM date is out for SQL Server 2008 R2. At the UK Tech Days it was released as May...
2010-04-16
624 reads
Visiting Chicago
A few weeks back I was in Chicago for three days for work. I’ve been through the airport a couple...
2010-04-16
958 reads
A DMV a Day – Day 16
We have two DMVs for Day 16. The first one is sys.dm_exec_cached_plans, which is described by BOL as:
Returns a row...
2010-04-16
669 reads
SQL Server 2008 R2 – Release Date
This is a very short post
I’m probably very late to this party but…SQL Server 2008 R2 is scheduled for release...
2010-04-15
516 reads
PowerShell 2.0 on Windows XP SP3 - Can It Be Upgraded?
In my last blog post I indicated that I would be adding learning PowerShell to my list of goals. I...
2010-04-15
5,045 reads
SQL Server 2008 R2 Release Date: May 21 2010
R2 is ready to roll!
As expected, Brent “Master” Ozar (Blog | Twitter) already scooped the story, but it never hurts to...
2010-04-15
482 reads
Blogs
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...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
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