Introduction to Using Bitbucket and CI/CD for Your App
If you have been in the DevOps space, you should know about version control and must have worked with 0ne. But, have you heard of BitBucket? No? Well, this tutorial is for you.
2023-09-27
CI/CD
How to Implement CI/CD in Azure Data Factory (ADF)
Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.
2023-03-10
12,104 reads
How to successfully deploy databases with external references
Database objects often have references to external databases which makes continuous integration problematic. In this article Liz Baron and Sebastian Meine demonstrate a solution.
2021-10-27
The key to great database CI is disposable databases
Redgate engineer Matthew Flatt talks about the challenges of database Continuous Integration and what you need to do to become great.
2021-07-09
Blogs
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Extending a SQL Server Failover Cluster Across Regions in Google Cloud Platform (GCP)
By davebem
I was the principal author of this SIOS whitepaper, which describes how to build...
Forums
How to determine if a DB is currently being used
Hi - I'm looking for advice regarding the best & quickest way to establish...
Data cleansing/conversion tool HPE
Hello. I am looking for a tool Data cleansing/conversion, was recommended HPE any...
System views in a contained availability group
I have a query that runs in a job to check on orphaned users....
Question of the Day
The LAGging NULL
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers