Tactics to Find Outdated Statistics in SQL Server

Statistics in SQL Server are used to identify the type of plan that needs to be executed for a query....

What are the system databases?

I get to help with technical interviews every now and again, and one of the questions we always ask is...

Day 20 Innodb Storage engine

InnoDB is the major Storage engine and is default Storage engine after MySQL 5.5 version. As standard RDBMS requires ACID...

SQL Server Stress Testing Using OStress – RML Utilities

As a DBA, implementing a new database consists of a variety of aspects like correct table structure, tuning the stored...

Power BI with Maps: Choose Your Destination

(2018-May-20) A childhood dream to travel around the world fueled by reading Gulliver's Travels stories and Robinson Crusoe attempts to survive on a...

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. If...

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...