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.
A Custom Execution Method – Level 19 of the Stairway to Integration Services
The next level of the Stairway to Integration Services looks at how you can execute your package.
Stairway to Advanced T-SQL Level 1: Intro to Advanced T-SQL Using a CROSS JOIN
The first installment of this new stairway series will be discuss the CROSS JOIN operator. This stairway should help readers prepare for passing the Microsoft Certification exam 70-461: Querying Microsoft SQL Server 2012.
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.
How to replace an identity column with a sequence number
SQL Server provides two ways to include an incrementing number in a table. Greg Larsen explains how to replace an identity column with a sequence number.
Blogs
Fixing a giant or running a SQL Server project deployment with Temporal tables
By Rayis Imayev
(2022-Jan-27) When Hogarth, a nine-year-old boy, a character from “The Iron Giant” movie, met a...
Azure Cosmos DB introduction
Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and...
Display dates between two input dates using SQL DATEDIFF function in SQL Server
SQL Server has a very useful function called DATEDIFF. This function is used to...
Forums
Create View in stored procedure
Hello, I'm new here and currently learn SQL Server. For my program I try...
Optimize Query
--####################################### --Given Rawdata --####################################### create table #Base (C1 char(1),C2 char(3)) insert into #Base values...
Static data masking is not showing in 18.0 above
I read this article trying to understand the feature of data masking in SQL...
Ask SSC