SQL Server 2005 SP3 Cumulative Update 9 (Build 4294)
Microsoft has released SQL Server 2005 SP3 Cumulative Update 9, which is Build 4294. I count 13 fixes in this...
2010-04-19
1,088 reads
Blog Posts
SQLSaturday #39 in NYC - Countdown - Event Preview!
Happy Monday, everyone! The internet is a buzz! I have never seen so much energy and enthusiasm as SQLSaturdays, and...
2010-04-19
1,045 reads
A DMV a Day – Day 18
The DMV for Day 18 is sys.dm_clr_tasks, which is described by BOL as:
Returns a row for all common language runtime...
2010-04-18
1,723 reads
Difference between log shipping and database mirroring
Compiled by Abi Chapagai (April 2010)
Implementation of High Availability depends in the need of the business. Each of the technologies...
2010-04-18
24,667 reads
Opportunities in (I.T.) Chaos
I just finished reading “The next wave of technologies” by Phil Simon. A great read! It proposes a...
2010-04-18
22 reads
Opportunities in (I.T.) Chaos
I just finished reading “The next wave of technologies” by Phil Simon. A great read! It proposes a new Enterprise 2.0 - not related to earlier Web 2.0 related...
2010-04-18
11 reads
SQL Server 2008 Database Mirroring – Abi Chapagai
Introduction
In any distributed environment, database synchronization between two different locations or different servers’ is very essential for mission critical applications....
2010-04-18
2,253 reads
Three Speaking Events in Six Days
AlantaMDF SQL Server Users Group. Photo courtesy of www.sqlvariant.com.
I have just finished up a three event speaking tour that, which...
2010-04-18
648 reads
A DMV a Day – Day 17
The DMV for Day 17 is sys.dm_db_index_usage_stats, which is described by BOL as:
Returns counts of different types of index operations...
2010-04-17
905 reads
Latest Simple-Talk.com Article Published on Deployment Management - to be Front Page Starting Monday
After several months of reflection/rewrites with colleagues (because orignally I forgot the Rollback plan - oops), and reworking the bilingual templates,...
2010-04-17
725 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