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,044 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,630 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
9 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
10 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,252 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
724 reads
Blogs
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...