Half Of You Don’t Understand Variables and Transactions.

• by Additional Articles

• Brent Ozar Unlimited Blog

• T-SQL

Do table variables and variables respect transactions? If we set the value of a variable during a transaction, and we roll it back, what happens?

2020-09-09

The Future of DevOps

• by Additional Articles

• Redgate

• Conferences, Classes, Events, and Webinars

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

Using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets

• by Additional Articles

• MSSQLTips.com

• Azure

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

• by Additional Articles

• SimpleTalk

• PowerShell

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

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

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

• by Additional Articles

• MSSQLTips.com

• 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

• by Additional Articles

• MSSQLTips.com

• 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

How Do I Know If My Query Is Good Enough for Production?

• by Additional Articles

• Brent Ozar Unlimited Blog

• query

Find out with Brent Ozar.

2020-09-02

Using Filters to Fine-tune Redgate Database Deployments

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

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

• by Additional Articles

• MSSQLTips.com

• 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