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 [crayon-6516f9e735a17668646339/] Findings SQL Server was configured for Max/Min RAM to 11gb on a 16gig system.
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 »
Share this PostThis sample script walks through some of the Microsoft Change Data Captures functions. Copy and past the script into SQL Server Management Studio and execute each command. Sample output is included in the script. This demo is based on the [AdventureWorksLT2008] database [crayon-6516f9e735e6a747728340/] [crayon-6516f9e735e6e419508053/] OverviewCDC.pdf Share this Post