SQLServerAgent is not currently running so it cannot be notified of this action.

  SQLServerAgent is not currently running so it cannot be notified of this action. Chris Skorlinski Microsoft SQL Server Escalation Services Have you seen errors like these below when attempting to run SQL Replication Wizard or start a SQL Agent job?  TITLE: Microsoft SQL Server Management Studio —————————— SQLServerAgent is not currently running so it…


CDC does not require Unique Index

Unique Index not required for Change Data Capture Chris Skorlinski Microsoft SQL Server Escalation Services Change Data Capture feature of SQL 2008 is based on Transactional Replication.  CDC and Transactional Replication used the same internal stored procedure sp_replcmds to retrieve data updates from the transaction log.  However, unlike Transactional Replication, CDC does NOT require the…


Snapshot Agent Performance –MaxBCPThreads

Snapshot Agent Performance –MaxBCPThreads We noticed a large published database was taking a long time for the Snapshot to be applied to the subscriber.  Looking further in sp_who and sys.sysprocesses we noticed only one Distribution Agent thread executing the bulk insert statements. It took a while but we discovered the publication was created using “concurrent…


All About Automatically Monitoring Replication Agent Failures

All About Automatically Monitoring Replication Agent Failures Vijay RodriguesMicrosoft SQL Server Support SQL Server Management Studio provides a way to monitor events, such as replication agent events, using alerts. SQL Server includes a set of predefined alerts for replication agents. If you would like to start the monitoring for replication agent failures, please follow below…


Download the C# 4.0 Language Specification

Time to update your knowledge of the C# language! 🙂Get your copy of the C# 4.0 Language Specification here or of the C# 5.0 Language Specification here.

4

Extreme Programming (XP) at a Glance

Note: This article is updated at Extreme Programming at a Glance. Extreme Programming (XP) is a lightweight software development methodology based on principles of simplicity, communication, feedback, and courage.   I like to be able to scan methodologies to compare approaches.  To do so, I create a skeleton of the activities, artifacts, principles, and practices.    Here…


Scrum Flow at a Glance

Note: This article is updated at Scrum at a Glance. When I analyze process flows, I like to see them at a glance, in terms of activities and artifacts.  This helps me compare it with other approaches to find similarities and differences.  This is my view of Scrum at a glance: Activities Artifacts Product Backlog…


The Four Circles of XP (Extreme Programming)

Note: This article is updated at 4 Circles of Extreme Programming. When I first learned eXtreme Programming (XP), my mentors introduced it using four circles.  I really liked how the four circles made it easy to remember the XP practices, and I liked how it made them easier to remember.  This post is a walkthrough…


Career Growth

Note: This article is updated at Career Development, Professional Development, and Personal Development. Do you have an effective approach for thinking about your career growth?   With things like a “jobless economic recovery,” careers ending, and a “skills-for-hire” economy, it’s even more important to focus on growth while managing your career.  At the end of the…


Trends for 2010

Note:  This article is updated at Trends for 2010. “The best way to predict the future is to create it.” – Peter Drucker This is my summary of key trends to watch for 2010.  Putting it together is a time-consuming exercise, but it’s one of the most important things I do for the year.  It…