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 […]
DB Options: Auto Create Stats and why it should be ON
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 […]
Database Options – Auto Close and why should set it to OFF
Auto close is one of those features that should have been removed long back. The setting needs to stay at default of OFF for reasons that will be […]
Using Bookmarks in PowerBI
https://www.youtube.com/watch?v=SftUYP6nchk PowerBI is a robust reporting tool that has a number of easy to use and configurable options when it comes to reporting. One of the most frequently […]
Temp table Owner
Recently I came across a post on LinkedIn which required identifying the user who created a temp table. This is an interesting use case and thought I’d write […]
SQL 2019 – Christmasql
Early November I had posted I would be conducting a series of sessions on MS SQL server. The response was really great and while I intended to do […]
SQL 2019 – Database Snapshot for In-Memory OLTP table
Traditionally Database snapshots have been used mainly to get Database mirroring secondary’s to act like Readable secondary. As you might be aware in mirroring etc. the databases are […]
Backup and restore of encryption keys and restoring
USE master; /************************************************************* CREATE YOUR MASTER KEY AND YOUR CERTIFICATE FOR TDE AND ALL OTHER TYPES OF ENCRYPTION *************************************************************/ OPEN MASTER KEY DECRYPTION BY PASSWORD = ‘Isthis@securePa$word?’; BACKUP […]
SQL 2019- Max DOP and Memory Configuration
Probably the most useless recommendation and as far as I am concerned not a feature. Why? If you are a DBA you know that DOP and Memory limits […]
SQL 2019- Optimize for sequential key
Last page contention is one of the textbook examples for latch contention. This frequently occurs on tables that are narrow and have high inserts happening against a sequential […]