TNWikiSummit15 Presentation: Error Handling in SQL Server 2012 and 2014

 

The follow text is copied from this blog:
Official Blog of TechNet Wiki

 

Using Error Handling within the Transact SQL language needs a deep knowledge. It depends on the SQL Server version, there are various implementations for handling the errors in T-SQL. But if you use SQL Server 2012 or later versions, you can use the simplest and fully structured error handling.

Saeid Hasani showed how to implement such simple error handling in T-SQL. He showed this topic from a problem solving approach and particularly in SQL Server 2012  and the later versions. In this session, he covered some questions to providing a step by step tutorial for designing a structured error handling mechanism in SQL Server.

This session is available for download using the following links:

Video:

https://gallery.technet.microsoft.com/TN-Summit15-Structured-dfdcb9a5

PowerPoint:

https://gallery.technet.microsoft.com/TN-Summit15-Structured-118896bb

Original TN Wiki Article:

http://social.technet.microsoft.com/wiki/contents/articles/20002.structured-error-handling-mechanism-in-sql-server-2012.aspx

Judges’ comments for the article are from TechNet GURU Awards – September 2013 :

Richard Mueller:

“Useful tutorial with lots of examples and very good links. Excellent comparison of THROW and RAISERROR.”

Jinchun Chen:

“Nice article. Thank you for the sharing.”

Ed Price:

“Incredibly well formatted with images, code, and explanations. And great interactions in the comments, making the improvements suggested by Naomi. ”

DB:

“Useful, clear and accurate guidance on error handling”

Samuel Lester:

“Great coverage of different techniques, challenges, pros/cons. Well done, very informative, and easy to read.”

 

Advertisements

TechNet Wiki International Summit 2015

You can register by filling out the TNWiki Summit15 form  and choosing your favorite Presentations.

Registration for TNWiki Summit15 are open  REGISTER NOW   !!!

Here’s the schedule:

 DAY 1 – March, 17th
Time / GMT  DEV track WIKI track  INFRA track
GMT “-8”  :  01h00PM
GMT “-2”  :  07h00PM
GMT “0”   :  09h00PM
GMT “+2” :  11h00PM
“TechNet Wiki
Social Synergy”
by Ed Price
GMT “-8”  :  01h45PM
GMT “-2”  :  07h45PM
GMT “0”   :  09h45PM
GMT “+2” :  11h45PM
“SharePoint:
Adding client-side
controls to an AngularJS
app in Office 365”
by Matthew Yarlett
“Wiki Life (Turkish):
Best Practices”
by Hasan Dimdik,
Erdem SELÇUK,
Recep YUKSEL
and Ugur Demir
“SQL Server:
SQL Server Memory”
by Shashank Singh
aka Shanky
GMT “-8”  :  02h30PM
GMT “-2”  :  08h30PM
GMT “0”   :  10h30PM
GMT “+2” :  12h30AM
“Wiki Life (Portuguese):
Best Practices”
by Alan Carlos,
Durval Ramos
and Luciano Lima
“Exchange Server
Kurulum SenaryolariKSEL”
by Recep YUKSEL
(only Turkish Language)
GMT “-8”  :  03h15PM
GMT “-2”  :  09h15PM
GMT “0”   :  11h15PM
GMT “+2” :  01h15AM
“Small Basic”
by Ed Price
“Writing a Good Wiki Article”
by Matthew Yarlett
“Segurança em Profundidade
em Ambientes Microsoft”
by Luciano Lima
(only Portuguese Language)
 DAY 2 – March, 18th
Time / GMT  DEV track WIKI track  INFRA track
GMT “-8”  :  09h00AM
GMT “-2”  :  03h00PM
GMT “0”   :  05h00PM
GMT “+2” :  07h00PM
“Creating and Querying
Microsoft Azure
DocumentDB”
by Chervine Bhiwoo
“Visio with Office 365
SharePoint Online”
by Daniel Christian
aka Dan Christian
GMT “-8”  :  09h45AM
GMT “-2”  :  03h45PM
GMT “0”   :  05h45PM
GMT “+2” :  07h45PM
“Visual C#:
Working with
WCF Data Services”
by Jaliya Udagedara
“Cross-Linking and Making
our Articles Discoverable”
by Richard Mueller
“Transact-SQL:
The power of
INSTEAD OF Triggers”
by Ronen Ariely aka Pituach
GMT “-8”  :  10h30AM
GMT “-2”  :  04h30PM
GMT “0”   :  06h30PM
GMT “+2” :  08h30PM
“Building a Business
Intelligence Solution with
Power BI Components”
by Paul Turley
“Wiki Ninjas
Social Media”
by Ronen Ariely aka Pituach,
Peter Geelen
and Sandro Pereira
“Windows Server:
Leading Spaces in
Active Directory Names”
by Richard Mueller
GMT “-8”  :  11h15AM
GMT “-2”  :  05h15PM
GMT “0”   :  07h15PM
GMT “+2” :  09h15PM
“Small Basic and TechNet”
by Nonki Takahashi
“Exchange Server”
by Ugur Demir
(only Turkish Language)
GMT “-8”  :  01h45PM
GMT “-2”  :  07h45PM
GMT “0”   :  09h45PM
GMT “+2” :  11h45PM
“How to Integrate Cortana
in a Windows Phone
application”
by Sara M.G.Silva
“TechNet Guru”
by Peter Laker
aka XAML guy
“BizTalk Server 2013 R2
JSON support and
integration with Cloud API’s”
by Steef-Jan Wiggers
GMT “-8”  :  02h30PM
GMT “-2”  :  08h30PM
GMT “0”   :  10h30PM
GMT “+2” :  12h30AM
“Wiki Ninja Belts”
by Margriet Bruggeman,
Peter Laker
aka XAML guy
and Ed Price
“DevOps Desenvolvimento
e Operações Juntos!”
by Alan Carlos
(only Portuguese Language)
 DAY 3 – March, 19th
Time / GMT  DEV track WIKI track  INFRA track
GMT “-8”  :  11h15AM
GMT “-2”  :  05h15PM
GMT “0”   :  07h15PM
GMT “+2” :  09h15PM
“Implementing audio
media stream sources in
windows phone 8.1”
by Mihai Cosmin
aka MCosmin
GMT “-8”  :  12h00PM
GMT “-2”  :  06h00PM
GMT “0”   :  08h00PM
GMT “+2” :  10h00PM
“Office 365
SharePoint Uygulamalari”
by Erdem SELÇUK
(only Turkish Language)
“Présentation de la recherche
dans SharePoint 2013”
by Benoit Jester
(only French Language)
GMT “-8”  :  01h00PM
GMT “-2”  :  07h00PM
GMT “0”   :  09h00PM
GMT “+2” :  11h00PM
“Wiki Life (French):
Best Practices”
by Benoit Jester
and Gokan Ozcifci
“Windows Server:
Active Directory Migration”
by Hasan Dimdik
GMT “-8”  :  01h45PM
GMT “-2”  :  07h45PM
GMT “0”   :  09h45PM
GMT “+2” :  11h45PM
“Structured Error
Handling Mechanism
in SQL Server 2012 & 2014”
by Saeid Hasani
“Wiki Life: Technet Wiki
Best Practices
(from administrators view)”
by Peter Geelen
“The good,the bad and ugly
part for Office365
for large sized enterprises”
by Gokan Ozcifci
(only French Language)
GMT “-8”  :  02h30PM
GMT “-2”  :  08h30PM
GMT “0”   :  10h30PM
GMT “+2” :  12h30AM
“Getting Started with
MongoDB on Azure”
by Jan Hentschel
aka Horizon_Net
“TechNet Wiki:
User Groups”
by Craig Lussier
GMT “-8”  :  03h15PM
GMT “-2”  :  09h15PM
GMT “0”   :  11h15PM
GMT “+2” :  01h15AM
“From Forums to Wiki:
Templates”
by Sandro Pereira
“FIM 2010
Best Practices & Technet Wiki”
by Peter Geelen
GMT “-8”  :  04h00PM
GMT “-2”  :  10h00PM
GMT “0”   :  12h00AM
GMT “+2” :  02h00AM
“Evitando que minha
coluna IDENTITY quebre
a sequencia numérica”
by Durval Ramos
(only Portuguese Language)
“TechNet Wiki
International Communities”
by Ed Price
“The difference between
SharePoint On-Prem’ platforms
and Cloud/Hybrid”
by Gokan Ozcifci

 

Webinar: Error Handling in SQL Server

 

TN Summit 2015

 

March 19, 2015 9:45 PM GMT

Saeid Hasani

Structured Error Handling in SQL Server

The goal of this session is to provide a simple and easy to use error handling mechanism with minimum complexity. This session is compatible with MS SQL SERVER 2012 and 2014.

Biography

Saeid Hasani is a Senior Database Developer, SQL Server Consultant, freelance SQL author and T-SQL Trainer. His main expertise is T-SQL Programming and Query Tuning. As a database developer, he has several years of experience in developing software in various domains such as MIS, ERP and customized Enterprise applications. As a freelance SQL author, he has been writing about SQL since 2010. He has been one of the MSDN SQL Server Forums Moderators.

Webinar Link: https://www307.livemeeting.com/lrs/0000000379_116/Registration.aspx?pageName=gdx8jdv0r7rmftrk