Exploring the SQL Compare Options
Phil Factor dissects and disentangles the various SQL Compare options.
2020-07-28
Additional Articles
How to Expand a Range of Dates into Rows using a SQL Server Numbers Table
In this article we look at different T-SQL code examples that can help you build a range of date rows based on a starting and ending date.
2020-07-28
SQL Server TempDB Tutorial
In this article we cover many different questions about the SQL Server TempDB database to give a better understanding of what is and what it is used for.
2020-07-27
SQL Server Backup Monitoring with PowerShell
In this part of the series we look at how to use the PowerShell monitoring scripts to collect backup information from your monitored instances.
2020-07-24
SQL Server MSDB Database Tutorial
In this tutorial we will cover common questions related to the SQL Server msdb database. This is one of the standard system databases that are part of every SQL Server installation. This tutorial will give you a better idea of what the msdb database.
2020-07-23
Automate Database Restore for SQL Server
In this article we look at how to automate a SQL Server database restore using a PowerShell script.
2020-07-22
Power BI Incremental Refresh for SQL Sources
In this article we look at the incremental refresh feature when working with Power BI data sources and how to implement for your reports.
2020-07-21
Getting Started with GitFlow
In this article, Diogo Souza explains GitFlow, a branching model for Git. He demonstrates how to work with GitFlow to create and deploy a feature and a hotfix to GitHub.
2020-07-20
Power BI Incremental Refresh for SQL Sources
In this article we look at the incremental refresh feature when working with Power BI data sources and how to implement for your reports.
2020-07-20
6 New Courses Published on the Redgate University
Master the fundamentals of Redgate products with easy to follow video courses on Redgate University. This month 6 new courses have been published to help you advance your skills including courses on SQL Prompt, SQL Monitor, SQL Change Automation, SQL Compare, and Database DevOps for Oracle. All brought to you by some amazing presenters like Kendra Little, Grant Fritchey, Kathi Kellenberger and the Redgate team of experts. Start learning now!
2020-07-17
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
How do you approach engineering services consulting?
I’ve been thinking a lot about the role of consulting in engineering projects. Having...
Columnstore index question
Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...
Transactional Replication
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers