Skip to content
Thoughts of an IT Professional
Looking to the clouds
  • About Me
  • Contact Me
  • Presentations

Month: December 2010

Stored Procedure Error Handling Best Practices, Part 3

Posted on 30th December 2010 by Alan Eardley

In part 1 of this series, I outlined the design of a solution that I have used to record errors in a manner that allows a unique ID to be returned to the user which in turn can be used to trace the error. In part 2 I described the database objects that are required Read More

Posted in SQL Server Tagged Best Practices, Stored Procedures

Stored Procedure Error Handling Best Practices, Part 2

Posted on 30th December 2010 by Alan Eardley

In the part 1 of this series, I outlined the design of a solution that I have used to record errors in a manner that allows a unique ID to be returned to the user which in turn can be used to trace the error. In this part of the series, I explain the database Read More

Posted in SQL Server Tagged Best Practices, Stored Procedures

Stored Procedure Error Handling Best Practices, Part 1

Posted on 28th December 2010 by Alan Eardley

Over the years I have worked with SQL Server a regular requirement was the ability to log errors in the database in a way that lets them be retrieved by support teams and allows end users to have a reference number. This first part of this series will describe the design of the solution, the Read More

Posted in SQL Server Tagged Best Practices, Stored Procedures

System Stored Procedures

Posted on 28th December 2010 by Alan Eardley

Using the “sp_” prefix for a stored procedure has some interesting effects on SQL Server.  Firstly it looks for the stored procedure in the Master database (dbo schema) and then it looks in the current database (default schema for the user, then dbo schema). The reason it is looking in Master first is that it Read More

Posted in SQL Server Tagged Best Practices, SQL Scripts, Stored Procedures, System Procedures

Best Practices for the Management of SQL Scripts

Posted on 16th December 2010 by Alan Eardley

I have been a long time fan of writing scripts for every action that is taken to make any changes in a database.  This means that version control tools can be used to track the changes and if necessary repeat them. In previous roles I have worked in environments where it has been essential to Read More

Posted in SQL Server Tagged Best Practices, SQL Scripts, Stored Procedures

Database Mail, Part 5-Monitoring

Posted on 16th December 2010 by Alan Eardley

Now that Database Mail is set up and can be used it is important to monitor the process.  In particular the following issues should be identified as they may have an impact on the effectiveness of any solution that depends on Database Mail: The service broker must be running The e-mails should not be failing Read More

Posted in SQL Server Tagged Database Mail, Monitoring

Database Mail, Part 4–Sending an e-mail

Posted on 15th December 2010 by Alan Eardley

In the previous parts of this series, I have enabled Database Mail, created an account and created a profile.  With everything now set up, it is important to test the ability to send an e-mail. At this point, I am assuming that the SMTP server has been set up and is working properly.  SQL Server Read More

Posted in SQL Server Tagged Database Mail

Database Mail, Part 3–Creating a Profile

Posted on 14th December 2010 by Alan Eardley

In Part 1 of this series I produced a stored procedure to enable Database Mail and in Part 2 I produced a stored procedure to create an account.  Now, to be able to use an account, and to send an e-mail you need to have a profile. A profile is related to one or more Read More

Posted in SQL Server Tagged Database Mail, Stored Procedures

Database Mail, Part 2–Creating an Account

Posted on 14th December 2010 by Alan Eardley

In Database Mail, Part 1 I produced a stored procedure that enables Database Mail.  The second stage is to create an account which determines the e-mail address that messages will be sent from and the SMTP server that will be used to send the e-mails. It is worth noting that if your organisation has primary Read More

Posted in SQL Server Tagged Database Mail, Stored Procedures

Database Mail, Part 1

Posted on 14th December 2010 by Alan Eardley

Over the years I have come across many reasons for Database Mail to be activated, and a couple of reasons not to use it. The main reasons for activating it are the added flexibility that can be achieved in reporting the success or failure of maintenance jobs or any unattended processes and for monitoring and Read More

Posted in SQL Server Tagged Configuration, Database Mail, Stored Procedures
Posts navigation
Older posts →

Twitter: al_eardley

  • @kevmcdonk DLP in Teams is E5, and unless they change that, I expect this will be too about 5 hours ago from Twitter Web App in reply to kevmcdonk ReplyRetweetFavorite
  • @CollabDaysBirm has an awesome schedule for Thursday 28th Jan! 18 sessions across 3 channels, all online https://t.co/NrDzHkmFkq about 5 hours ago from Twitter Web App in reply to CollabDaysBirm ReplyRetweetFavorite
  • @TATTOOEDCRMGUY @MicrosoftUK @Avanade Wow! Best of luck Chris about 11 hours ago from Twitter Web App in reply to TATTOOEDCRMGUY ReplyRetweetFavorite
  • If you were in any doubt about the benefits of @MSPowerPlat then read this post from @donasarkar about the 3 low-co… https://t.co/kgzRalW473 about 14 hours ago from Twitter Web App ReplyRetweetFavorite
  • This is a great update, coming in Feb. Data loss prevention (DLP) for Microsoft Teams will now support security gr… https://t.co/yP05H1lIVN about 14 hours ago from Twitter Web App ReplyRetweetFavorite
  • It's good to know that hierarchical sensitivity labels in Microsoft Teams will now show the parent and not the chil… https://t.co/FCLGB5yo9u about 14 hours ago from Twitter Web App ReplyRetweetFavorite
  • Next Thursday (28 Jan) at @CollabDaysBirm I will be explaining what Workplace Analytics is and how it can help your… https://t.co/0lLdBZ5c1S about 14 hours ago from Twitter Web App ReplyRetweetFavorite
  • Join me next Tuesday (26 Jan) at @MCSCUG to learn how Entitlements in @azuread can help you manage permissions for… https://t.co/jF72qT0Moj about 15 hours ago from Twitter Web App ReplyRetweetFavorite
  • @Worrelpa @kevmcdonk @joshcarlisle @gregor_suttie @Pixel_Robots @SteveNewall That was a good event - there were so… https://t.co/r5Xkolc5KM about 15 hours ago from Twitter Web App in reply to Worrelpa ReplyRetweetFavorite
  • This is a great set of guidelines - I love the concept of a responsible we application 👍 https://t.co/NjxzKcqobQ 10:25:30 AM January 15, 2021 from Twitter Web App ReplyRetweetFavorite
@al_eardley

Archives

  • November 2020 (2)
  • October 2020 (1)
  • September 2020 (4)
  • June 2020 (1)
  • May 2020 (2)
  • April 2020 (1)
  • March 2020 (2)
  • February 2020 (1)
  • December 2019 (2)
  • November 2019 (7)
  • October 2019 (3)
  • September 2019 (1)
  • August 2019 (2)
  • July 2019 (4)
  • June 2016 (2)
  • May 2016 (2)
  • April 2016 (2)
  • February 2016 (3)
  • August 2015 (1)
  • April 2015 (4)
  • March 2015 (2)
  • February 2015 (1)
  • January 2015 (2)
  • December 2014 (1)
  • November 2014 (2)
  • October 2014 (2)
  • September 2014 (2)
  • August 2014 (2)
  • July 2014 (1)
  • June 2014 (4)
  • April 2014 (4)
  • March 2014 (6)
  • December 2013 (1)
  • October 2013 (2)
  • September 2013 (1)
  • August 2013 (1)
  • July 2013 (1)
  • June 2013 (1)
  • April 2013 (1)
  • June 2012 (2)
  • April 2012 (1)
  • January 2012 (2)
  • November 2011 (1)
  • March 2011 (1)
  • December 2010 (17)
Theme by Out the Box