A look back from the future. – TSQL Tuesday #100
The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact...
2018-03-13
288 reads
Kenneth Fisher
2018-03-07
518 reads
SQL Homework – March 2018 – Recovery Objectives
My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases...
2018-03-05
286 reads
A day in the life of a Sr DBA/Dev
If you are a Sr DBA or developer you have probably had some variation of this conversation at multiple points...
2018-02-28
408 reads
Double hop error when using SQLCMD
tl;dr; SQLCMD v2014 and up has special requirements for Kerberos.
One of the problems with linked servers (no rude noises please)...
2018-02-26
2,068 reads
Synonyms, how and why.
Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even...
2018-02-26 (first published: 2018-02-15)
3,348 reads
Hobbies, stress relief, and meeting management: T-SQL Tuesday #99
It’s T-SQL Tuesday again! And in fact it’s the 99th one! Given that T-SQL Tuesday runs once a month that...
2018-02-23 (first published: 2018-02-13)
2,007 reads
Windowing without a partition by or an order by
If you’ve never worked with windowing functions they look something like this:
SELECT name, max(create_date) OVER
-- No this isn't meant to...
2018-02-21
1,467 reads
The default filegroup, and why you should care.
You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index...
2018-02-19
483 reads
Backups of backups or How long is my backup really available?
I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important,...
2018-02-15 (first published: 2018-02-07)
1,808 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