Encrypt SQL Server Stored Procedures to Protect Source Code
In this article, we cover how to encrypt a SQL Server stored procedure and how SQL Server hides the source code for these objects once encrypted.
2023-01-30
In this article, we cover how to encrypt a SQL Server stored procedure and how SQL Server hides the source code for these objects once encrypted.
2023-01-30
We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.
2023-02-06 (first published: 2023-01-30)
216 reads
Today Steve encourages everyone to feel welcome in the data professional community.
2023-01-27
107 reads
In this article, we look at how to setup and configure Contained Availability Groups in SQL Server 2022 and some of the new options this feature allows.
2023-01-27
Facebook isn't sure where all your personal data is stored. Are you sure your organization is any different?
2023-01-25
103 reads
In part 3 of this series, see how you can use the principles from the series to build an Azure Data Factory pipeline.
2023-01-25
4,934 reads
Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many poorly documented secrets about how to use User Assigned Managed Identity.
2023-01-25
This article shows how you can use an R script to import data into Power BI.
2023-01-23
1,795 reads
Removing data from your systems isn't as easy as you might think. It is especially important to be aware when you are doing this for compliance.
2023-01-23
202 reads
This tip drills down on how to process JSON files with SQL Server and demonstrates an approach for extracting key values from JSON nested key-value pairs.
2023-01-23
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
Comments posted to this topic are about the item What happens when we drop...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers