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,… Continue reading 🔐Security in a shared workspace
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… Continue reading Get Cognitive 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… Continue reading Hack / Protect SQL Server – Resources 💎
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… Continue reading Sentiment Prediction – Resources 😃
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… Continue reading SQL Server Always On – Monitor The Redo_Queue_Size
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
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… Continue reading SQL text search – 3x faster CONTAINS vs LIKE.
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… Continue reading SQL Server 2017 – Deferred Name Resolution Bug.
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… Continue reading SQL Sync Logins – Domain Accounts
You must be logged in to post a comment.