🔐Security in a shared workspace

Well, why?... perhaps you prefer not spinning more resources to segmentate the environment or decouple the workloads, but you still need to enforce data security across domains. Lets look at how to secure an HR container in a shared Azure Synapse Analytics workspace that serves mixed workloads by using only RBAC permissions at the storage,…

🏹 SQL Audit – See Through Walls

It's #TSQLTuesday and I received a question that occurs any day of the week. I hadn't posted anything in a few days, so I thought I'd share this one. Hope it helps. A Friend Asked Does the native audit feature has any GUI where we can see the reports ( example:- List of the users…

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…

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…

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…

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…

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…