SQL Server

A Quick Diff Checker for SQL Server Databases

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

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-02

SQL Server transaction log architecture

• by Additional Articles

• SimpleTalk

• Learn SQL

• Article

The transaction log file for a SQL Server database critical for for maintaining database integrity. In this article, Greg Larsen explains SQL Server transaction log architecture.

2021-06-30

Creating and Maintaining a SQL Code Snippet Library

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

How to save all your different types of SQL code snippets in a central library of JSON Snippet Collections, where you can search and edit each collection and then write them out as individual code snippets, for use in SQL Prompt, SSMS or your programmer's clipboard.

2021-06-28

Running SQL Clone on an Azure VM with Azure File Storage

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

How to use SQL Clone in the Azure Cloud, installing it on an Azure Virtual Machine, storing a copy of your SQL Server database as an 'image' on an Azure File Share, and then deploying multiple clones to another Azure VM or to a remote machine.

2021-06-25

Move SQL Server Files for Master Database

• by Additional Articles

• MSSQLTips.com

• SQL System Database
• system database
• System databases

• Article

In this second part of this article we look at how to move the SQL Server master database files to a different location.

2021-06-21

SQL Server performance tuning: Nine best practices

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

SQL Server performance tuning can seem overwhelming when you don’t know where to start. In this article Robert Sheldon explains 9 best practices for performance tuning.

2021-06-16

How to Find Unused Databases in SQL Server

• by Additional Articles

• MSSQLTips.com

• Database Administration
• SQL Server

• Article

In this article we look at how to identify if SQL Server databases are not being used and a process to take these unused databases offline.

2021-06-14

The four best features to look out for in SQL Monitor

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

In this blog, David Yard at Kingston Technology shares his favorite SQL Monitor features and how they’re helping him to make sure their large SQL Server estate performs at its best.

2021-06-11

SQL Server Resource Governor Game

• by Additional Articles

• MSSQLTips.com

• Resource Governor

• Article

Learn about the SQL Server Resource Governor and how it can be used to manage your SQL Server workloads via this game format that can help your team gain better insights.

2021-06-09

• Discuss

Redgate Streamed: Embracing technology trends for database success

• by Additional Articles

• Redgate

• Conferences, Classes, Events, and Webinars

• Article

Innovating in the database is crucial for success, and we’re seeing new trends impact the database, like cloud migration, SRE, and the growing need for big data and tools to support growing estates. On 23 June, Redgate Streamed brings you organizations who have implemented these database technology trends, including speakers from Google, Microsoft, and AWS, who will share their success stories and tips for embracing technology changes.

2021-06-07