Share this PostI was teaching a class this weekend at http://www.sqlsaturday.com/60/eventhome.aspx on using Change Data Capture to pull changed data from SQL Server. I complete my class so I headed over to Thomas LaRock http://thomaslarock.com/ class on WAITS AND QUEUES. It was a great class and I always enjoy listening to Thomas speak. He has
Read More »
Share this PostHow to Archive your SQL Errorlogs into a Table Chris Skorlinski Microsoft SQL Server Escalation Services Have you noticed your SQL Server errorlogs taking up a lot of disk space? Ever wonder what was logged a few weeks ago, but the logs have already rolled over? Why not create a SQL Agent job
Read More »
Share this PostI 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 2010-12-27 03:03:31.41 spid2s Warning: unable to allocate 'min server memory' of 13312MB. 2010-12-27 03:11:54.71 spid52
Read More »
Share this PostWe had this question about SQL 2008 virtual cluster. Question: Is it possible to add node in existing SQL Server 2008 or 2008 R2 Failover cluster instance without downtime (without stopping SQL Server or MSCS services)? Answer: Absolutely! SQL Server 2008 was designed with rolling installation and upgrades in mind. To confirm: I
Read More »
Share this PostMicrosoft SQL Server has the ability to REPLICATE data changes to Oracle. We see more and more customers migrating to SQL Server, then setting up SQL data Replication to move change SQL data back to a legacy Oracle system until the Oracle server is no longer needed. Our customer got this error after
Read More »