Azure Data Factory Pipeline Logging Error Details
In this article we will cover how to capture and persist Azure Data Factory pipeline errors to an Azure SQL Database table.
2021-02-16
Additional Articles
Execute Dynamic SQL commands in SQL Server
In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. This is where dynamically building SQL statements can be useful.
2021-02-15
The Future of Database DevOps
Join Pramod Sadalage, Director at Thoughtworks, and a stellar line up of speakers for Redgate Summit: The Future of Database DevOps on February 17 & 18. You’ll discover the latest trends in DevOps, brand new insights from the 2021 State of Database DevOps report, an introduction and technical demos of Redgate’s solutions for Database DevOps, and more.
2021-02-15 (first published: 2021-01-29)
Connect to SQL Server
In this article we look at the different ways to connect to various SQL Server services using tools like SSMS, BCP, SQLCMD, PowerShell and more.
2021-02-12
Getting Started with Flyway and SQL Server
Phil Factor explains how to get started with Flyway, as simply as possible, using PowerShell. This article provides a practice set of database automation scripts that will build a SQL Server database, and then update it, running a series of migrations scripts that make some schema alterations, and load the database with test data.
2021-02-12
Search SQL Server error log files
The SQL Server error log is helpful for troubleshooting issues. Greg Larsen demonstrates several ways to search SQL Server error log files.
2021-02-11
Gitflow Workflow Hotfix Branching for SQL Database Projects
Git is a great tool for source control and in this tip we look at how you can utilize Git source control to build and deploy database hotfixes.
2021-02-10
Melissa Data Quality Solutions for SSIS
For organizations relying on the SQL Server, Melissa's solutions directly integrate with SSIS, so the learning curve is minimal. You can drag and drop Melissa components in SSIS to validate, cleanse, append and enhance data.
2021-02-09
What will you learn at the Redgate Summit?
There's just 1 week left until the Redgate Summit: The Future of Database DevOps. Check out this blogpost for what's in store, spoilers from our speakers on what they're most excited to share on the day, and why you should attend.
2021-02-09
SQL Server Extended Events Filtering by Database Name
In this article we look at how to properly filter out events using a database name pattern in an Extended Events Session.
2021-02-08
Blogs
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
The Last Good DBCC Run
Comments posted to this topic are about the item The Last Good DBCC Run
count the number of NULLs in a row
Hi everyone I have a SP that finds the average based on 3 tables. ...
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers