My Running Journal

After spending three months doing pushups and ab exercises, I’ve come to realise something:

There is no substitute for regular cardio!

After just one run, all my sluggishness, all of my worries, all of my inaction just seemed to evaporate. From now on, I will endeavour to run three times a week, and this blog will hold me accountable to my word.

Date Distance Time Speed Details
March 2016 55.1 km 290.5 min 11.38 kph 9
April 2016 43.6 km 236 min 11.08 kph 7
2016-5-4 4.8 km 30 min 9.6 kph Takahagi East
2016-5-5 5.7 km 30 min 11.4 kph Takahagi West-East Cct
2016-5-7 5.7 km 32 min 10.68 kph Takahagi East-West Cct
2016-5-8 5.0 km 29 min 10.34 kph Gusto-Roundabout Cct
2016-5-10 5.0 km 27 min 11.11 kph Gusto-Roundabout Cct Light rain
2016-5-12 6.1 km 35 min 10.45 kph Beisia-Roundabout Cct
2016-5-14 6.1 km 32 min 11.43 kph Beisia-Roundabout Cct
2016-5-17 6.8 km 35 min 11.65 kph 7Eleven-Beisia-Roundabout Cct
2016-5-21 6.8 km 37 min 11.02 kph 7Eleven-Beisia-Roundabout Cct
May 2016 52.0 km 287 min 10.87 kph
2016 TOTAL 155.5 km 843.6 min 11.05 kph

Alerts and Notifications in SSIS

An alert enables an operator or operators to receive notifications when a certain event occurs within SQL Server, such as a query error, SSIS package failure, or backup completion.There are three different methods of notifications, as follows:

  1. Database Mail
  2. Pager (for which support will be removed in the future, but is still supported for anyone stuck in 1994)
  3. Net send (still supported but this feature cannot be used for any OS after Windows XP Service Pack 2)2000px-crystal_clear_app_email-svg

Hmm, so there’s really only one method of notification which you should use: the Database Mail notification.

There are three ways in which you could use notifications with SSIS packages:

  1. The Send Mail Task, typically in an Event Handler (SMTP server will be required to set this up)
  2. The Notify Operator Task, which is similar to the Send Mail Task, but allows you to select the operators in SQL Server Agent to be notified
  3. The Execute SQL Task, using the sp_notify_operator command, is basically the same thing as the Notify Operator Task, but this method allows greater flexibility.

 

Logging options for SSIS

There are several logging options available for SSIS packages, and it can be difficult to know which is the best one to use. Let’s take a closer look at the different SSIS logging options, and what they can do.

SQL Server log provider saves log events into the sysssislog table in the msdb database by default, or in a database which you specify. The table can then be shared between users who can access the database.

Text files log provider stores the same information as the SQL Server log provider into a text file. This could easily be emailed to another user, or imported to a database or Excel spreadsheet later.

XML files log provider allows you to save the information as an XML file, which can add portability to the log data across different platforms, and also allow easy reading which viewed in an XML viewer or certain web browsers.

SQL Server Profiler, when used in SSIS, provides the same information as the other log providers, but saves the log events as a trace file so that it can then be correlated with Performance Monitor. This is a great way to monitor performance issues and pinpoint drags on performance. (See this great article by Brad McGehee for more info)

Windows Event Log log provider stores event information in Windows Event Viewer, which can then be used by system administrators. I feel this method is a little tedious when it comes to analysis, but some might find it useful.

For performance related diagnostics, I would store the log events in a trace file, otherwise I’d stick with the sysssislog table.

However, the log provider that is best for you will of course depend on the situation and how the log information will be used.