Query Store – SQL Server 2017 vs Azure SQL Database
I love the query store, it is powerful (can be dangerous) , easy to use and packed full of information. I...
2017-11-02 (first published: 2017-10-24)
2,051 reads
All About SQL
Connecting to Azure SQL Database Primary Endpoint – Failover Groups
When you have setup a Failover Group in Azure for your SQL Databases connecting to the R/W (Read / Write) endpoint...
2017-10-19
682 reads
SQL Server: What will REPAIR do?
So I had a corruption issue and I was thinking about running repair but I wanted to know what would...
2017-10-24 (first published: 2017-10-16)
2,071 reads
When Things Go Wrong in Azure
Things go wrong in IT, it is no different with the cloud. When I say cloud I am thinking quite...
2017-10-12
462 reads
Azure SQL Database Level Firewall Rules
I have written about Azure SQL Database LEVEL firewall rules before during my blog series, more specifically the security blog...
2017-10-20 (first published: 2017-10-11)
1,697 reads
SQL Server 2017 Encrypted Backups And Compression
Let’s work through some code to do an encrypted backup. This feature is available to you if you are using...
2017-10-18 (first published: 2017-10-09)
3,085 reads
Azure SQL Database Data Integrity Checks
If you remember last month I wrote about DBCC CHECKDB and Azure SQL Database, more specifically whose responsibility (Microsoft’s) it...
2017-10-04
508 reads
SQL Server Tracking Tempdb Size
Here is a quick Extended Events script I knocked up where I wanted to track Tempdb file size changes for...
2017-10-03
483 reads
SQL Server – Pause VS Stop
You have the ability to actually pause SQL Server, if you are in SQL Server Management Studio (SSMS), you might...
2017-10-02
354 reads
SSMS 17 Dark Theme
Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual...
2017-09-29
2,704 reads
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