Exam Prep 70-463: Data Flow Transformations
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-01-29
1,664 reads
Blog Posts
Installing multiple default instances on a single server
As you probably know, SQL Server allows only one default instance per server. The reason is not actually something special to...
2015-01-29
51,053 reads
Minion Reindex 1.1 Release (and re-release)
We released Minion Reindex version 1.1 last week. The changes are fairly small: Made sure Minion Reindex handles all nonstandard naming...
2015-01-29
1,256 reads
Power BI Workshop Videos
I’ve created a series of five tutorial videos for a set of workshops I’ll be doing at several events this...
2015-01-29
667 reads
Power BI Workshop Videos
I’ve created a series of five tutorial videos for a set of workshops I’ll be doing at several events this...
2015-01-29
1,138 reads
SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-01-29 (first published: 2015-01-26)
6,301 reads
SQL- Querying XML attributes from XML Column
Read XML column attributes in to two columns DimType and Dimvalue from the below example also retrieve the data matching...
2015-01-29 (first published: 2015-01-22)
38,204 reads
Trapping Online Index Operations
Recently I wrote an article about Capturing Online Index Operations. In that article, I discussed a problem that I had...
2015-01-29
1,323 reads
Trapping Online Index Operations
Recently I wrote an article about Capturing Online Index Operations. In that article, I discussed a problem that I had encountered. Well, there were multiple problems. One was an...
2015-01-29
4 reads
ASP.Net MVC File Stream, Initiated From Javascript Post
I was recently working on a page that does an AJAX post to an MVC controller passing quite a lot...
2015-01-28
260 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