Troubleshooting SQL Server error “The operating system returned error 1453”

Troubleshooting SQL Server error “The operating system returned error 1453” Chris Skorlinski Microsoft SQL Server Escalation Services I worked on an interesting SQL startup problem today.  I don’t see this error very often, but since there wasn’t much on the web, I thought I would write it up and post it on my blog. Errorlog…


Trends for 2011

I put together a trends map in my trends for 2011 post. I took a look across consumer trends, Enterprise trends, market trends, and what’s on the minds of CIOs, CFOs, and CEOs.  I also drew from my experience from talking with key folks on what’s going on, including many customers and what they’re focused…


optimal tic-tac-toe (XKCD)

This blog post has moved to https://matthewvaneerde.wordpress.com/2010/12/10/optimal-tic-tac-toe-xkcd/


Downmixing stereo to mono

This blog post has moved to https://matthewvaneerde.wordpress.com/2010/12/07/downmixing-stereo-to-mono/


Lock Timeout in Replication Create Publication

Lock Timeout in Replication Create Publication Chris Skorlinski Microsoft SQL Server Escalation Services Normally, the Snapshot create publication script only needs to lock the table long enough to generate a Create Table script for the Distribution Agent to apply to the Subscriber.  However, the create Publication was being blocked on the Publisher.  We discovered a…


How to: Initialize a Transactional Subscription from a Backup with Multiple Backup Files

How to: Initialize a Transactional Subscription from a Backup with Multiple Backup Files Chris Skorlinski Microsoft SQL Server Escalation Services Below is a slight modification to the How to: Initialize a Transactional Subscription from a Backup steps to handle Publisher database backups to multiple BAK FILES. 1)       Execute sp_addpublication (Transact-SQL) at the Publisher on the…


How to move MDF/NDF for a Replicated Database

How to move MDF/NDF for a Replicated Database Chris Skorlinski Microsoft SQL Server Escalation Services Here is another customer question about Replication I thought worth sharing. I am using SQL Server 2008 64 bits. I have to change the location of the data file (i.e. MDF file). I was planning to  detach and attach. DB…