Wanna join me at South Florida Code Camp?

On Saturday, March 2nd of 2019 I'm presenting 2 sessions. Join me for South FL Code Camp 2019 at Nova South Eastern University in the Carl DeSantis building. You can register for this one-day free learning event here. This year I am presenting 2 sessions. Real-time Sentiment Prediction in SQL Server Track: SQL/BI - Room 2067 Time:  9:50AM-11:00AM…

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…

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…

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…

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

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…

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! https://docs.microsoft.com/en-us/visualstudio/releasenotes/vs2015-version-history Troubleshooting info: Exit…

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

Keeping a good thing going. Register here (FREE): https://www.sqlsaturday.com/755/registernow.aspx 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…

SQL text search – 3x faster CONTAINS vs LIKE.

My friend asked, does SQL Server have a data type or type of index it can use to search for text in a field? Yes, use varchar. If possible, create a non-clustered index on the column or use a full-text search catalog index. You can use the Like operator or the Contains operator if you…

SQL Server 2017 – Deferred Name Resolution Bug.

This issue came up recently while in the midst of an upgrade to SQL Server 2017, but it's actually not related to the upgrade and has been around all along on previous versions. So I took a moment to write this, cause a friend told me it would make a nice blog post. Mad credit…