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
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item Effective Engineering
There is a table tblItems with below structure ( i cannot change the below...
If I run the Data Migration Assistant to check for an upgrade from SQL Server 2008 to SQL Server 2022, which categories of issues are pointed out as potential items that can affect an upgrade? (choose 3)
See possible answers