Blame it on Connect
Some weeks ago I blogged about the discouraging signals coming from Connect and my post started a discussion that didn’t...
2015-02-02
549 reads
Blog Posts
How to Rebuild MSDB database?
I suggest to have regular full backup of your system database along with user database. But if you do not...
2015-02-02
10,559 reads
How to Rebuild MSDB database?
I suggest to have regular full backup of your system database along with user database. But if you do not have system database & your MSDB got corrupted then...
2015-02-02
2 reads
Mentor blog
I have been following a few blogs for a number of years now, and one of the most enjoying blog...
2015-02-02
286 reads
Parsing SQL Saturday Data – Getting the Titles
I wrote about downloading the SQL Saturday data with Powershell, and that has worked well. However, I also need to...
2015-02-02
930 reads
PowerPoint Slides Available for Download
I promised that I would post the slide decks for my presentations, and now I have finally followed through on...
2015-02-02
684 reads
SQL #58–Where are my own templates in SQL Server Management Studio 2012
The secrete SQLFile.sql
We are all so used to clicking on the New Query icon (or the keyboard shortcut Ctrl+N). We know it...
2015-02-02 (first published: 2015-01-27)
13,433 reads
Importance of Best Practices in database programming
For any programming language, just writing the code is not well enough. It should be written using the best practices....
2015-02-01
4,148 reads
Importance of Best Practices in database programming
For any programming language, just writing the code is not well enough. It should be written using the best practices. This article will try to explain the disadvantages of...
2015-02-01
4 reads
Friday Followup For January 30, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-01-30
924 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