My Schedule @ PASS Summit 2018

This was my 2nd time attending the annual conference and I barely got a chance to plan my schedule ahead of time. I pretty much selected the pre-con(s) the same day they were announced months prior, but not the general conference sessions until 2 days before my flight to Seattle, WA. I compiled this list… Continue reading My Schedule @ PASS Summit 2018



Looking back at 2018. Bought House Promoted at work Spoke at South Florida Code Camp Skylar was born Spoke at SQL Saturday Orlando & Tampa Improved coding skills (ML, Py, R, C#, Go, DAX, M) Ocean turned 3 Promoted at work again Contributed to open-source project BrentOzarULTD/SQL-Server-First-Responder-Kit (#1809) Accepted into SQLEAP Built 3 AI Bots… Continue reading 2018

SQL Server Always On – Monitor The Redo_Queue_Size

Cause sometimes you need to check why replication is slow or halted. For example, like during an IO storm - no hurricane pun intended. Say you have transnational replication over an Always On (SQL Server Availability Groups) environment that's a publisher. To see in the Dashboard just add the column, this is what it looks… Continue reading SQL Server Always On – Monitor The Redo_Queue_Size

Hack / Protect / Predict – SQL Server (Slides for SQL Saturday Orlando 801)

Hi, I'm excited to share with you that I'll be presenting this Saturday, October 6, 2018, at SQL Saturday Orlando. The most fun SQL Saturday event I've attended. It's going to be my first time announcing this content on SQL Server 2019 (currently ctp 2) and SSMS 18 preview 4. Plus, maybe playing SQL Family Feud.… Continue reading Hack / Protect / Predict – SQL Server (Slides for SQL Saturday Orlando 801)

Hurdles of Encryption – Refresh X from Y

In short, sys.dm_database_encryption_keys allowed to see the encryption state and I found the system was in progress of decrypting the database. The hurdle originated while trying to restore encrypted database backups generated by Prod svr(s) to Dev svr(s). The lower env needed the Prod keys to decrypt the Prod backup files. While trying to restore… Continue reading Hurdles of Encryption – Refresh X from Y

Enable Source Control in SSMS

Edit this file as administrator. Ref the correct path. I am using SSMS 17.8.1. or latest. C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\ssms.pkgundef Uncomment the following block and save. Relaunch SSMS, Tools, Options, Source Control, Plug-in Selection, VSTFS. You should see a Team menu at the top Menu bar. Must have VS2015 installed! Troubleshooting info: Exit… Continue reading Enable Source Control in SSMS

I’ll be presenting Saturday 6/9/2018 @NovaSE – 1:30pm Room 3046

Keeping a good thing going. Register here (FREE): You can extend the invite to your friends and colleges if you think they’ll be interested in the topics. I'll be presenting at Nova South Eastern this Saturday afternoon at 1:30pm in Room 3046 of the Carl DeSantis Building (3301 College Avenue, Carl DeSantis Building, Davie, FL 33314). Here's my… Continue reading I’ll be presenting Saturday 6/9/2018 @NovaSE – 1:30pm Room 3046