SQLOPS IS THE ONLY AUDIT YOU’LL NEED FOR PRODUCTION DATABASES

What are the roles and responsibilities of DBA vs DBE

What are the roles and responsibilities of DBA vs DBE

A DBA (Database Administrator) and a DBE (Database Engineer) both work with databases, but their roles and responsibilities differ. A DBA is typically responsible for the day-to-day management and administration of a database or group of databases. This can include...

Understanding JOINS in SQL Server

Understanding JOINS in SQL Server

Joins in SQL Server are used to combine rows from two or more tables based on a related column between them. The purpose of a join is to retrieve data from multiple tables as if the data were coming from one table. A real-life example of using a join in SQL Server...

Map disks to volumes on your Windows instance

Map disks to volumes on your Windows instance

List NVMe volumes You can find the disks on your Windows instance using Disk Management or Powershell. List NVMe disks using Disk Management You can find the disks on your Windows instance using Disk Management. To find the disks on your Windows instance Log in to...

How to read Snowflake data from SQL Server

How to read Snowflake data from SQL Server

To read data from a Snowflake database into SQL Server, you can use the following methods: Use the SQL Server Integration Services (SSIS) to create a package that transfers data from Snowflake to SQL Server. Use the Snowflake Data Provider for SQL Server to create a...

How to import JSON file into SQL Server table

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

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....