Create an HTML Report on the Status of SQL Server Agent Jobs
Learn how to query your jobs to produce a report that is formatted to make consuming the data easy for DBAs.
Practice Until You Don't Get It Wrong
We will all make mistakes, but practice can help reduce the errors we cause.
Which Should You Use: VARCHAR or NVARCHAR?
You’re building a new table or adding a column, and you wanna know which datatype to use: VARCHAR or NVARCHAR?
Regular Expressions in SQL Server 2025
This article examines the new regular expression functions added to T-SQL in SQL Server 2025.
The Selfish Case for Learning AI
Steve has a good reason to spend time working with and learning about AI technology.
Static Versus Dynamic Bulk Insert Imports of Multi-File Datasets
There are numerous use cases for multi-file imports of CSV files into a SQL Server table:
Reducing Cloud Cost
Cloud costs are high and growing. Some orgs think they're out of control and are trying to limit spend. Some orgs are looking to leave the cloud. A lot of IT spend over the years has been seen as a cost center, with many executives trying to limit the growth or spend, even while they […]
Stairway to Azure SQL Hyperscale Level 4: Log Service and Transaction Management
Learn about how the Log Service helps manage transactions in the Hyperscale Tier.
DevOps is DevOps
DevOps includes a lot of practices, but no matter which technology that you use, the ideas are the same.
Blogs
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Forums
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers