Altering a Column with NOT NULL
A short piece, as I ran into the need recently to alter a column to NOT NULL status. I’ve rarely...
2015-03-12
786 reads
Blog Posts
Future of Database Mirroring
One of the beloved feature of SQL server standard edition for HA is database mirroring, since you only have 2-node...
2015-03-12
482 reads
Operational Data Store (ODS) Defined
I see a lot of confusion on what exactly is an Operational Data Store (ODS). While it can mean different...
2015-03-12 (first published: 2015-02-26)
9,561 reads
SQL backup directly to Azure storage
Most companies required to keep their database backup offsite (on tape) for many years due to audit requirement. This normally...
2015-03-12
964 reads
Audit Schema Change Report
In a recent article on SSG, I discussed how to use Extended Events to function in a Profiler like fashion. You can read about that here. I recommend reading...
2015-03-11
6 reads
Data Compression–A unique feature PART–II TIP #92
In last post TIP #91 we talked about What is Data compression ? What are the features ? Now in this tip...
2015-03-11
616 reads
Using Solutions in SSMS
There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions,...
2015-03-11
1,231 reads
Why I don’t (yet) recommend In-Memory OLTP to my customers
Ok, some of you will hate me after this blog posting, but it has to be said. Over the last...
2015-03-11
798 reads
Azure Data Factory
What is the Azure Data Factory?
The Azure Data Factory is a managed service for data storage and processing. It allows...
2015-03-10
1,395 reads
Exam Prep 70-463: Variables and Parameters
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-03-10 (first published: 2015-02-23)
8,062 reads
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
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:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
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