Configuring Database Mirroring in SQL Server
I plan on writing a series of posts on database mirroring, this is the first. Database Mirroring is a new...
2010-03-07
3,719 reads
Blog Posts
SQL LiteSpeed Error: XML returned from Engine was invalid
SQL LiteSpeed Error: XML returned from Engine was invalid
This is a very common error returned from SQL LiteSpeed. So what...
2010-03-06
2,876 reads
Opening Keynote – SQL Saturday #33
I didn’t quite read this, but this was the written part of what I have as the opening keynote for...
2010-03-06
463 reads
SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)
SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)
The content of this update includes 11 Presentations, 17...
2010-03-06
618 reads
Breaking Down TempDB Contention
Breaking Down TempDB Contention
What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...
2010-03-05
82,004 reads
Going to Charlotte for SQLSaturday #33
I’m flying up Friday afternoon for SQLSaturday #33. Looking forward to the trip, Charlotte is a great area and I...
2010-03-05
392 reads
Index your FK
A few months ago I read an article from SQLServerCentral.com about some Foreign Key gotchas. Since that article, I have seen...
2010-03-05
871 reads
Keep Your Data Clean
In working with client data you start to notice trends that raise flags in your mind. In my case I'm...
2010-03-05
505 reads
More SQL Azure Samples
I have been playing around some more with SQL Azure in order to get ready for an upcoming presentation, so...
2010-03-05
2,279 reads
PASS Update #24
Time to update you again on all things PASS. First, I haven’t made a lot of progress on the speaker...
2010-03-05
537 reads
Blogs
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...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
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...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries