The Future of DevOps
Join Microsoft MVP Kendra Little to discover how you can fully left-shift your deployments with version control and automatic cloning using Redgate's latest innovations.
2020-09-08
Additional Articles
Using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets
In this article we look at two methods of using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets.
2020-09-08
How to Use Parameters in PowerShell Part II
PowerShell is a basic skill any administrator working in Windows or Azure should know. After writing his first article about PowerShell parameters, Greg Moore realized that there is even more to talk about. This article covers using pipelined parameters and more.
2020-09-07
Introduction to Analyzing Waits using SQL Monitor
Phil Factor sets out with the modest aim of giving you enough of an introduction to waits to better understand the wait information you get from a SQL Server monitoring tool like SQL Monitor, and the rather overwhelming amount of information available in the underlying DMVs and Extended Events.
2020-09-07
Transfer data from SQL Server to MySQL
In this article we look at how to use PowerShell to transfer data from SQL Server to MySQL.
2020-09-04
How do You Identify Object Dependencies in SQL Server
In this article we look at different ways to determine if one SQL Server database object is dependent on another database object.
2020-09-03
2020-09-02
Using Filters to Fine-tune Redgate Database Deployments
Filters are used by Redgate's SQL Compare, SQL Source Control, DLM Dashboard, and SQL Change Automation. A typical use for a filter is to work on just one schema within a database or just a limited set of tables and routines. You would also want to use a filter to exclude certain object, such as database users, from comparisons. Phil Factor explains how they work, and how to create, edit and then use them within the various Redgate tools.
2020-09-02
Getting Started with Delta Lake Using Azure Data Factory
This article will demonstrate how to get started with Delta Lake using Azure Data Factory's new Delta Lake connector through examples of how to create, insert, update, and delete in a Delta Lake.
2020-09-01
So, You Want to Be a DBA…
Many people with tech careers did not follow a straight path to get there. In this article, Pamela Mooney gives some advice for those who would like to be a DBA.
2020-08-31
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