How to prevent SysAdmins from accessing specific tables in SQL Server
There are several ways to prevent sysadmins from reading data from specific databases in SQL Server, but one common approach is to use database roles and permissions. Create a new role: Create a new role, such as “db_restricted_reader” with SELECT...
How to import JSON file into SQL Server table
There are several ways to import a JSON file into a SQL Server table, including using built-in functions, using third-party tools, or writing a custom script. Here is an example of how to import a JSON file into a SQL Server table using the built-in OPENJSON function:...
How to hide a stored procedure in a stored procedure in SQL Server
There are a few ways to hide a stored procedure in a stored procedure in SQL Server, but one common approach is to use dynamic SQL. Dynamic SQL allows you to generate and execute T-SQL statements at runtime, which can be used to hide the underlying stored procedure....
How to export SQL Server data to JSON file
There are several ways to export SQL Server data into a JSON file, including using built-in functions, using third-party tools, or writing a custom script. Here is an example of how to export SQL Server data into a JSON file using the built-in FOR JSON function:...
The only audit you'll need for production databases!