Data Type Precedence and Implicit Conversions

SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data. When the data types do not match, SQL Server has to...

Data Type Precedence and Implicit Conversions

Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...

Data Type Precedence and Implicit Conversions

Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...

T-SQL Tuesday #113–Personal Databases

This month we have a really interesting question for the T-SQL Tuesday invitation. Todd Kleinhans is the host and asks about personal databases. Do we use them for anything?...

T-SQL Tuesday #113 -A Database for the Great Outdoors

This month’s T-SQL Tuesday comes from Todd Kleinhans (blog | twitter) who wants to know what we’re doing with databases outside of work.

I’m curious- outside of work and...

Automatically Drop a Login/User (and Solve the Schema Owner Problem)

Ever tried to drop a user/login, only to find that they owned a schema? Here's how I do it...

SQL Server on Linux – how does it actually work?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...

Learning Jupyter Notebooks

I’m starting the process of learning how to use Jupyter Notebooks. Notebooks are documents that contain live code, commentary, results, pictures and more. Jupyter Notebooks are used for presentations,...

My Very First Azure SQL Database

I recently delivered my very first SQL Saturday pre-con for SQL Saturday Richmond on Friday, March 29, 2019.  You can read about that adventure here. As part of the...

Database In Recovery Redux

One of the more gut-wrenching experiences of a DBA is to have a database get stuck in recovery. This typically happens when the server was rebooted unexpectedly and typically...