Stairway to Biml Level 2: Biml Basics
The next step in the stairway to Biml teaches you how to build a basic SSIS package using the scripting language.
Introduction to DevOps: 10 Guidelines for Implementing DevOps
In this last article in the series, Robert Sheldon discusses ten guidelines that will help organisactions implement DevOps successfully.
Moving Encrypted Data to Azure SQL Database
Learn how you can move encrypted data from on premises SQL Server to Azure SQL Database.
Introduction to the Partition By Window Function
Window functions can be life savers by making a complicated SQL calculation easy. A window function combines that logic and provides row by row or window by window feedback. Read on to learn more!
Making the switch to SQL Monitor
Australia and New Zealand’s leading cloud account software provider Xero needed a cost-effective monitoring solution with better features and coverage. Read Xero’s story about how they switched from their old monitoring tool to Redgate’s SQL Monitor.
Azure Sphere
The Azure Sphere project is a great piece of research at Microsoft that might help us data professionals with security.
Understanding Auctions
We participate in auctions all the time even when we don’t realize it. In this article, Joe Celko discusses the many different types of auctions and how they work.
Best Option for Working with Files in SSIS
This time we will compare different solutions to copy system folders using different SSIS tasks.
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
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
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