I have a new Passion
Yes, I like to blog, maybe slightly more on Azure than SQL Server. I enjoy it and it probably explains...
2017-11-28
355 reads
All About SQL
Azure SQL Database – Service Tiers
Naturally the cost of Azure SQL Database directly relates to what tier and performance level you are using. Starting from...
2017-11-23
485 reads
SQL Server – DBCC CHECKTABLE
If you know about DBCC CHECKDB then most likely you will know about DBCC CHECKTABLE. Quite simply this command performs...
2017-11-20
447 reads
Azure SQL Database Alerting
It’s good to be proactive and one way is to setup alerts and it is no different when using Azure...
2017-11-16
501 reads
Folks Who Have Made a Difference
TSQL Tuesday time hosted by Ewald (https://sqlonice.com/tsql-tuesday-96-folks-who-have-made-a-difference/) and quite simply one man has morphed me into who I am today...
2017-11-14
306 reads
SQL Server 2017 – Interleaved Execution
I worked on testing interleaved execution with Microsoft back in January, I didn’t do much, just tested the functionality against...
2017-11-20 (first published: 2017-11-09)
842 reads
Azure SQL Database Compatibility Levels
Let’s start off with a quick overview of SQL Server versions and compatibility levels.
100 = SQL Server 2008 and Azure SQL...
2017-11-06
516 reads
Microsoft MVP!?
What? Is probably the most common reply out there and if it is then that is how I felt when...
2017-11-02
402 reads
Azure SQL Database Automatic Tuning – Questions Answered
I used to be on the fence regarding whether or not Automatic Tuning should be on as the default when...
2017-11-01
373 reads
SQL Server Phantom Reads
With Halloween around the corner what better topic to discuss than phantom reads. A phantom read occurs when rows have...
2017-11-08 (first published: 2017-10-26)
1,608 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