Message Queues in Software
Steve Jones talks about Service Broker and messaging and how these techniques can help you build a more robust application.
SQL Server T-SQL Tuning – NOT IN and NOT Exists
Following on from the previous TSQL performance tuning article in this series, we now focus on the important topic of T-SQL “Not IN” And “Not Exists “
Cramming for Interviews
Today Steve Jones talks about the questions people ask on the Internet about interviews. Are they ok? Should you cram for an interview this way?
SQLServerCentral Runs sp_Blitz - Reliability
The second article that examines the output of the sp_Blitz script™ run against SQLServerCentral's database servers.
Creating SSIS Package Templates for Reusability
We often need to create similar SSIS packages which contain some common components such as connection managers, data flow components, log providers, event handlers, etc... So do we really need to create a package from scratch each time and add all these commonly used components in each package again and again. Is it possible to create a SSIS package with a basic structure/workflow and common components which can be used as template to create subsequent packages?
How to write a custom metric
You can extend SQL Monitor to track whatever you need to watch on your own system with custom metrics. Grant Fritchey shows us how.
Global Insecurities
The various security scans of 2012 reported lots of potential problems in companies. Why don't vendors make it easier for us to install and configure their software securely?
The Java Danger
This week a vulnerability in Java has prompted a large scale notice to the general public.
Developing a SQL Server Backup Strategy
Developing a backup procedure that makes sure you can do restores should be one of your top priorities as a DBA. In this article Greg Larsen discusses some of the concepts to consider when developing, building and testing a backup strategy.
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