How to use PowerShell cmdlets, such as Select-String, to glance at the contents of the application logs, or use them in conjunction with Regular Expressions to sift through log files in detail looking for particular types of error.
2021-07-23
In this article we look at a PowerShell script that can quickly retrieve information about all databases from all servers that are configured to use database mirroring.
2021-07-19
How Redgate Deploy will help you ensure that databases and applications can grow and develop in step, and to implement a workflow for delivery of database changes that is resilient, repeatable, fast and visible.
2021-07-19
Compare the schemas of two SQL Server databases using SQL Compare command line then quickly produce a diff report showing you immediately which tables, views and functions have changed.
2021-07-16
In this article we look at different SQL Server backup types and schedules and the steps to take to properly restore a database.
2021-07-12
Redgate engineer Matthew Flatt talks about the challenges of database Continuous Integration and what you need to do to become great.
2021-07-09
This statement can be the biggest hurdle in changing software development and deployment processes. So, the question comes up pretty frequently: How do you overcome it? Grant Fritchey explores techniques to understand and coach others towards change.
2021-07-07
When you are using Flyway, how can you test your database migration script first to make sure it works exactly as you intended before you let Flyway execute it?
2021-07-05
When you begin to automate your deployments, you’re also going to start automating your testing. After all, a deployment, in and of itself, is a test. However, you'll pretty quickly come to the question: who is responsible for building tests?
2021-06-23
In this article we cover the steps on how to send notifications to business users when a change in a dataset used for Power BI has occurred.
2021-06-23
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Hi We have an stored procedure which runs frequently and it contain logic in...
Hi I am new to replication and we have database of size around 2TB...
I want to query a table that has a datetime column ([CreateDateTime]) and get...
Ask SSC