🔐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,…

Get Cognitive API 📺

In this short video, I explain how to call the Azure Cognitive Services - Text Analytics API from SQL Server by using T-SQL and Python in a Stored Procedure. In the demo, I first cover the prerequisite steps and create a view to prep data in JSON format. Then, I use the Sentiment Analysis API…

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…

Sentiment Prediction – Resources 😃

Here's my Resources slide from this weekend's presentation. Stay tuned - live recording coming soon. Resources: fleitasarts.com github.com/hfleitas/SentimentPrediction ailab.microsoft.com 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 Resource Governor: Alter External…

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…

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…

TRY/CATCH Custom Message – SQL Error Handling

Crediting Basa for neat details, check out his blog is full of good things. The idea is to control the message returned to the app front-end, rollback the transaction if need be or retry with another command. More on this...with how to log the activity as well. Thanks, Hiram

SQL Sync Logins – Domain Accounts

Hypothetically, say you can't grant dbo permissions. Instead you just need read, write and execute for stored procedures. Common Database-Level Roles are: db_datareader, db_datawriter, and my personal favorite db_executor. Ideally, you would use a domain security group (making the accounts members of the group) and grant the group access to the SQL Server instead of…