Move SQL Server Files for Master Database
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
Articles
Conditional DELETE and INSERT in PostgreSQL
Introduction We are comfortable with inserting/deleting record(s) into/from a table. But we sometimes get confused when we need to insert or delete records conditionally from a table. Let us look at an example. Example scenario Suppose we have a table, called ALL_EMPLOYEES, which contains all employees' information who are working or had ever worked for […]
2021-06-18 (first published: 2021-05-12)
10,801 reads
Azure Databricks Access Controls and Row Level Security
Azure Databricks has a number of Access Controls and Row Level Security options that we will explore in this article.
2021-06-18
Branching and Merging in Database Development using Flyway
How to exploit the branching and merging capabilities of Git for scaling up team-based development, when doing Flyway migrations.
2021-06-18
Handling Row-level Errors in ADF Data Flows
If you are working with ADF (Azure Data Factory) data flows, then you may have noticed there was a new feature released in November 2020, which is useful to capture any error while inserting/updating the records in a SQL database. This article will describe how to setup the error row handling feature and why it's […]
2021-06-16 (first published: 2021-05-02)
5,648 reads
Managing SQL Snippet Collections using JSON and PowerShell
Maintain your favorite SQL snippets and queries centrally, using PowerShell to save and update each snippet collection, in JSON, and then converting them into SQL code snippets for SQL Prompt.
2021-06-16
SQL Server performance tuning: Nine best practices
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
Azure Storage: Blob and Data Lake Storage Gen2
Introduction Azure Storage is the service for storing different types of data. A storage account is created first. The storage account provides a unique namespace for different types of Azure storage data accessible from anywhere in the world over HTTP or HTTPS. Data in the Azure storage account is durable and highly available, secure, and […]
2021-06-14 (first published: 2021-05-01)
7,580 reads
How Can Redgate Tools Help with a Cloud Migration?
The cloud migration tools and processes that will help you move a database to the cloud, from planning, implementation and validation through to extending existing development and deployment processes to the new cloud platform.
2021-06-14
How to Find Unused Databases in SQL Server
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
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
Which Pench Safari Package Is Right for You in 2026?
Planning a wildlife adventure in Pench National Park can be exciting yet overwhelming, especially...
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers