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

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… Continue reading I’ll be presenting Saturday 6/9/2018 @NovaSE – 1:30pm Room 3046

I’ll be presenting Saturday 2/24/2018 @USF School of Business – 8:30am Room 118 (Tampa, FL)

Hi, I just received the news that I got selected to speak at University of South Florida Saturday, 2/24/18 at 8:30am in Room 118 (USF School of Business - BSN, 12212 USF Maple Drive, Tampa, Florida, 33620). Here’s the event info: http://www.sqlsaturday.com/699/EventHome.aspx Register here (FREE): https://www.sqlsaturday.com/699/registernow.aspx Pls fwd this invite to your friends and colleges… Continue reading I’ll be presenting Saturday 2/24/2018 @USF School of Business – 8:30am Room 118 (Tampa, FL)

I’ll be presenting tomorrow at Nova Southeastern University – 9:50am Room 2081 (Carl DeSantis Building)

Hi, I just received the news that I got selected to speak at Nova Southeastern University tomorrow, 2/10/18 at 9:50am in Room 2081 (Carl DeSantis Building). Here’s the event info: http://fladotnet.com/codecamp/Home.aspx Register here (FREE): https://eventbrite.com/e/south-florida-code-camp-2018-tickets-38099337143 Pls fwd this invite to your friends and colleagues if you think they’ll be interested in attending. There will be… Continue reading I’ll be presenting tomorrow at Nova Southeastern University – 9:50am Room 2081 (Carl DeSantis Building)

My Schedule @ PASS Summit 2017

Here's my week's schedule - narrowed down with help of friends, for my 1st time at SQL PASS Summit 2017 in Seattle, WA. Here's the full conference schedule: http://www.pass.org/summit/2017/Sessions/Schedule.aspx My Schedule: Precon: Mon: Data Modeling with Power BI (603, Marco) Tues: Columnstore Indexes – Practical Solutions & Techniques (606, Niko) Conf: Wed: 1015am: Benchmarking & Testing In-Memory OLTP… Continue reading My Schedule @ PASS Summit 2017

SQL Server 2016 Always Encrypted – Parameterized Samples

With Always Encrypted in SQL Server 2016, if you want to Insert, Update or Filter by an encrypted column (ie. DML) the statement must be parameterized and/or use sp_executesql. Jakub shows how to do this on his post at the SQL Server Security Blog, but here's the condensed version of the article with all the sample scripts/instructions… Continue reading SQL Server 2016 Always Encrypted – Parameterized Samples