SQL Server Error Handling In Depth

TRY/CATCH RAISERROR Pre SQL Server 2012 Since SQL Server 2005 we’ve had TRY CATCH syntax in SQL Server handle errors....

Thanks for joining us at SQLSat Dallas!

Engaged crowds and great questions at both my morning sessions on Saturday morning at SQLSat Dallas, an event put together by a team of expert SQLSat organizers, including SQL...

C# – Read emails from exchange online mailbox (Office 365) into SQL Server

You have an Office 365 mailbox. You want to use C# to read those mails and save them to SQLServer.
The...

SQL Server Triggers and Transactions

In this post I’m going to detail with examples how triggers behave with transactions…

How Do Triggers Behave With Transactions?
To demo...

SQL Server Triggers and Transactions

In this post I’m going to detail with examples how triggers behave with transactions…

dbachecks – Improved Descriptions

With the latest release of dbachecks we have added a new check for testing that foreign keys and constraints are...

Day 19 MyIASM Storage engine

MyIASM storage engine is available from the early stage of MySQL this engine is developed from IASM language and it...

How to Extract last name or first name(s) from a combined field

Extracting pieces of information from a string can be a daunting task. This is an example of a REVERSE technique.
The...

How to Extract last name or first name(s) from a combined field

Extracting pieces of information from a string can be a daunting task. This is an example of a REVERSE technique.
The...

Helper function to convert binary to decimal and back

In this post you will find two small functions that convert binary value to a decimal one and vice versa.