In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hopefully I can demystify some of the concepts for […]
2020-12-31
4,164 reads
In this article we cover all of the steps required to install, setup and configure SQL Server Reporting Services.
2020-12-31
Feature branching and pull requests are two important concepts when using Git. In this article, Kendra Little explains these patterns and even provides a video to demonstrate.
2020-12-30
In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.
2020-12-30 (first published: 2015-05-13)
55,467 reads
Learn and share tool tips with your peers. Redgate has launched their Tool Tips Swap to help everyone make the most of their Redgate products. To get involved, simply share your top Redgate tool tip for boosting productivity. All tips will be collated into a blog post and shared with the community. Plus, you’ll get the chance to win a 3-month subscription to Pluralsight.
2020-12-30 (first published: 2020-12-17)
A typical project following any industry standard process for building Azure Data Factory (ADF) pipelines will have different environments as part of development lifecycle. They might be named Development, Staging, Production, and so on. This article describes an approach to save costs from running ADF pipelines using Triggers. Typical ADF environments will have pipelines ingesting, […]
2020-12-29
2,956 reads
In this tip we are going to build a sample data pipeline and explore Azure Synapse Analytics data integration and orchestration features.
2020-12-29
In this tutorial we will cover common questions related to the SQL Server msdb database. This is one of the standard system databases that are part of every SQL Server installation. This tutorial will give you a better idea of what the msdb database...
2020-12-29
Israel Valverde explains the triple benefits of extending SQL Monitor to cover your SQL Server instances running on Amazon RDS, in terms of SQL Server performance optimization, controlling AWS-hosting costs, and in having a single, unified view of the health of all your SQL Servers, regardless of where they are hosted.
2020-12-28
In this article we look at the SQL Server REPLACE function and show several examples of how this can be used to replace text values in strings.
2020-12-28
This is a submission for the Pulumi Deploy and Document Challenge: Shhh, It’s a Secret!What...
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
I recently had a new pipeline fail. It was actually a copy of an...
Comments posted to this topic are about the item The User Login
Comments posted to this topic are about the item Using Feature Flags
Comments posted to this topic are about the item Understanding UNION and UNION ALL...
When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?
See possible answers