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
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
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
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
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
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
In this article we cover why Windows Failover Cluster nodes can go into a quarantined state, how to resolve this as well as how to set threshold values for this cluster node state.
2021-02-08
This article focuses on the use of OData Queries to integrate DevOps Analytics data to Power BI.
2021-02-05
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-05
Oracle archived redo size may be smaller than that of online redo log files. In this article, Jonathan Lewis takes a deeper look.
2021-02-04
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
Recently I received a cry for help over Teams. The issue was that an...
Given the following table and query, this will return any records(based on message_id) that...
How to merge two tables with unlike fields. I have two table with one...
Hello, First of all, I find it odd/annoying that I can't exclude a Project...
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