HuggyBear

Born and raised in Vancouver, Canada, with a brief excursion to study in Brussels, Melbourne & Washington D.C., Hugo has been working with SQL Server since 1998. He’s busied himself as a DBA since 1999 (with mcdba & mcitp certifications in ‘01 & ‘08 respectively), as independent consultant with his own company, Intellabase Solutions, since 2002 (now part time), and has held various permanent position with Transcontinental, Sun Life Canada, and now Alithya as a consultant. He enjoys writing documentation for quick, safe infrastructure rebuilds and expansions, and most challengingly, propositions to Executives Management on how to improve enterprise Security. He has spoken at SQLteach/DevTeach, Montreal Dot Net User Group, SQLGulf, Vermont User Groups over 5 times, has a blog on SQLServerCentral, and has been recognised as a SQL Server MVP in 2010.
  • Interests: Lately (2019): windfoiling or windsurfing with a Skroka foil....amongst many other supposedly 'extreme' sports, but which are really just the norm for people raised in Lotusland aka Vancouver, BC, lower-mainland region, Sea-to-Sky country as we know it.
  • Blog: http://dbhive.blogspot.com/
  • Jobs: SQL DBA, Data Engineer, Migrator, Clusterer, Security Implementor

Configuring Auto-Retry on SQL Server Agent

The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to use it. I hope to clarify in which circumstances an auto-retry works best and when not to use it also. The (disclaimer!) point is that every job has its own constraints, requirements, and has to be evaluated individually for whether an auto-retry will work. I will try and keep this summary short and crisp, but still with enough detail to understand auto retry best.

2009-06-01

3,877 reads

Blogs

Abuse, Patience, and Understanding

By

I’ve been struggling with an author for a few months. I tried to work...

Daily Coping 21 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SSIS Logging – Linking sysssislog with custom log

By

I was working on an ETL solution, which was expected to run for hours....

Read the latest Blogs

Forums

cumulative updates in multi instance standalone server

By noobdba

For 2019, how would one go about applying CU on multiple instances in a...

Powershell String was not recognized as a valid DateTime

By webrunner

Hello experts, I'm trying to import some CSV data into a SQL database using...

connecting to SQL Database from asp application and setting CONTEXT_INFO

By skb 44459

connecting to SQL Database from asp application and setting CONTEXT_INFO. <connectionStrings> <add name="CLHN_AppConnectionString" connectionString="Data...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers