Hack / Protect SQL Server – Resources 💎

Here's my Resources slide from this weekend's presentation. Stay tuned - live recording coming soon. Resources: fleitasarts.com andy.pt SQL Server R Services Samples: Microsoft Repo Pre-Trained ML Models: Install in SQL Server SQL Server Machine Learning Services: Tutorials SQL Server Components to Support Python: Interaction of Components Threading ML: Logistic Regression Interactive deep learning: Learn alert…

Giving 💰💰💰 3 Sessions in 1 Day

SQL Saturday 864 - South Florida, United States is less than 2 weeks away. June 8, 2019 @NSUFlorida. This is a whole day, free event open to the public. You can register here. I am giving 3 sessions that day and may be raffling 2x $50 gift cards per session. You should come to my session(s)…

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…

Encryption and Database Source Control

Since returning from PASS Summit, I spent a rigorous amount of time developing slides & demos to share the latest technologies I learned, attempting to deliver on my pact with my CIO and Director. Yesterday, I delivered the 2nd round on that promise and received great feedback. PS. Shopping for a new tie. I intentionally focused…

Backup SQL Server Database(s) to Azure Blob Container

This is a step by step guide to help a friend that is looking for a quick and inexpensive way to upload/migrate his small on-prem SQL Server databases onto Azure cloud without having to use complex tools.   Note: This will work on SQL Server 2012 or above with internet connectivity.   SUMMARY: Create Azure…

VIDEO: 5 Questions from CIOs to SQL DBAs and Developers

TRANSCRIPT Hi, I’m Hiram and I’m a Database Administrator and Developer. I am recording this video to answer 5 questions I got recently from CIOs. 1. What have you done regarding DB high availability to assist with the implementation of Active/Active solutions? <See video: Answer 1 goes here> 2. Can you deconstruct how you solved…

1st Time Presenting at SFCodeCamp 2018

Well, that turned out much better than expected. After receiving the news, the day before the conference, that I was selected to speak at South Florida Code Camp 2018, I shared the news with friends and colleagues inviting them to the event. Immediately, I rushed to prepare the necessary equipment and pick up my speaker…

PASS Summit 2017

Today was another good day at work. Since returning from summit, I spent a rigorous amount of time developing slides & demos to share what I learned, attempting to deliver on my pact with my CIO and Director. Well, that came true today in full-circle & the feedback was amazing! Recording: Slides: This is a…