Reading Stored Procedure Output Parameters in Azure Data Factory
This article will help you to work with Store Procedure with output parameters in Azure data factory.
Removing SA from Azure SQL Database
Azure SQL Database is getting the ability to turn off SQL authentication.
3 steps to get started with Database DevOps
Once you’ve committed to changing your culture in order to automate your database deployments, what’s next? You’ve already done the hard part, making the decision to shift the culture. In this blogpost, Grant Fritchey explores three steps you can take next to begin your Database DevOps journey.
Where I See Databases Going in the Next 10 Years
This month, to mark the 20th anniversary of BrentOzar.com, Brent steps back and looks at the big picture.
Maintenance Windows
Is it better to ask forgiveness than permission? Some people take that approach to maintenance windows, but that isn't permissible in the cloud.
Migrating SSIS packages to Azure - Lift and Shift using Azure Data Factory
Unlike an on premises SQL Server, Integration Services (SSIS) works very differently on Azure. If there are requirements to run our existing SSIS packages on Azure, then we need to understand our options. In this article we will talk about our options for migrating SSIS to Azure and what components are required to migrate SSIS packages. […]
Cherry-picking Migrations using Flyway
Describing the two main use cases for occasional "cherry picking" of Flyway database migration scripts: back-filling emergency production hotfixes to version control and managing parallel development streams.
Query Audit data in Azure SQL Database using Kusto Query Language (KQL)
In this article we look at how you can user the Kusto Query Language (KQL) for querying Azure SQL Database audit data.
Malleable Source Control
Git has proved to be a better fit to the needs and workflow of a database development team than anything that came before. Git is valuable because it encourages branching and merging, giving more choice in the way that your team can work. Due to the ease with which you can adapt Git, there is […]
I Hate To Send This Email
Steve Jones wonders how many of us have had to send, or will have to send this email.
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers