Is Your SSIS Catalog Migration Ready
In this article, we will see if the given SSIS catalog is ready for migration without any issues using SSIS Catalog Migration Wizard inspect feature.
SQL Server Monitoring Using Free Tools
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
Install SQL Server and Oracle using PowerShell and Windows Containers
In this article we look at how to install SQL Server and Oracle using PowerShell to create development environments using Windows Containers.
Defining DevOps
Many people ask about DevOps and what it entails. Steve has a few thoughts on the challenges of adopting DevOps in a company.
How to Integrate Azure DevOps with Azure Synapse Studio
Learn how to connect your Synapse workspace to a Git repository.
Crowdsourcing quality: Can the hive mind/herd mentality help you in software testing?
Crowdsourcing is one way to get a job done. In this article, Devyani Borade describes crowdsourcing quality testing of software.
Testing a Flyway Database Migration
Often, we want to test the new version of a database, produced by a Flyway migration, before committing the new migration file, or to test the same migration run on a number of different databases. This article demonstrates how to do it, by generating and using JSON parameter files to run a series of Flyway actions on any number of databases, on any number of servers.
Knowing When to Respond
I ran into this quote on the Microsoft Learn site, which I thought was a great way to think about how to administer a system: "Without a baseline, every issue encountered could be considered normal and therefore not require any additional intervention." When I've had users file tickets or complain about things not working well, […]
Working with Fail Activity in Azure Data Factory
Introduction In this article, we will talk about a newly introduced activity in Azure Data Factory, which is the fail activity. The fail activity is very useful to stop or fail the pipeline at the specified point. For example, a lookup activity might return no data or a switch activity executes the default block. We […]
Exploring the Flyway Schema History Table
Flyway uses a schema history table to track the version of each database, recording in it every versioned migration file applied to build that version. It's worth understanding exactly how Flyway uses this table, the possible dangers of moving it to a non-default location and how to do it safely, if required.
Blogs
Master the Foundational Basics
By Brian Kelley
It tells us to take the time to master the foundational basics of whatever...
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Forums
ssrs order of operation question
hi i need "sample size" in my report's 4th data region which is a...
Query Network Protocols from T-SQL or PowerShell
Hello experts, I want to be more organized about the SSL certificates we have...
Occasional Sql Server 2019 slowness (upgraded from 2014) -- please help...
Hi everyone, We recently upgraded our server to Sql Server 2019 (15.0.2125.1 (X64) on...
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers