Filestream is a great feature for databases that have to handle a large volume of BLOB data. It allows the DBA to store data in Filesystem folders rather […]

In this video we cover the two options available under parameterization in MSSQL database properties. Ad hoc queries are queries that aren’t stored procedures. Since the code is […]

It’s become significantly rarer for database corruption to occur nowadays because of hardware and software improvements. In older version of SQL Server it was fairly common for database […]

In this video we cover multiple database options most of which are fairly easy to understand and don’t really require significant research before being set. Often these settings […]

https://www.youtube.com/watch?v=SAzmOEqVoIQ Another one of the database options which doesn’t serve any real purpose. As shown in this video the setting is overridden by session level settings so it […]

https://youtu.be/SAzmOEqVoIQ Another one of the database options which doesn’t serve any real purpose. As shown in this video the setting is overridden by session level settings so it […]

The use of AUTO SHRINK I think needs no explanation. Almost anybody who has worked on SQL Server understands the way databases can quickly grow. In these cases […]

https://youtu.be/8ugpVfPzvz4 In this video we are going to talk about auto update statistics. This is a feature in the database engine that automatically triggers a stat update when […]

In this video we cover the next database option which is AUTO CREATE INCREMENTAL STATISTICS. This option is useful when the database has partitioned tables. It allows the […]

Auto create stats is one of those database options that every DBA knows they should set to ON. In this video we explore what happens when you set […]