SQL Server Security – Fixed server and database roles
Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.
Changing Edge Security
Security is changing, and the "edge" of where we need to protect data is changing as well.
Extending Custom Execution in the SSIS Catalog – Level 21 of the Stairway to Integration Services
In this installment of the Stairway to Integration Services, Andy Leonard shows you how to execute packages synchronously or asynchronously.
Batch Processing using Flyway
How to create a batch file that executes any number of database migration tasks across a range of servers and databases, using Flyway.
Common Data Transformations in Power Query
In this article we walk through an example of using Power Query to transform source data that can be used in a Power BI report.
Installing Docker Desktop on Mac
Introduction This article will help you install the Docker Desktop for Mac. Before we show that, let us start by understanding what the Docker Desktop software can do for you. To understand Docker, we need to understand what a container is. If you remember a few years ago, the only way of deploying application code […]
Recover Deleted TDE Key for Azure SQL Database
In this article we look at the steps to recover a deleted TDE key that is being used by Azure SQL Database for database encryption.
A data transformation problem in SQL and Scala: Dovetailing declarative solutions Part II
In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Sejati Mulia Telpon/WA:08137887595
BCA KCP Sejati Mulia Telpon/WA:08137887595.Koperasi Sejati Mulia, Jl. Raya Ragunan B 1, Jati Padang,...
BCA KCP Kramat Jaya Tlpn/Wa 0853.7373.7551
Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec. Cilincing, Jkt Utara, Daerah...
BCA KCP Pondok Indah Telpon/WA:08137887595
BCA KCP Pondok Indah Telpon/WA:08137887595.Jl. Metro Pondok Indah No.60 & 61 UA, Pd. Pinang,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers