What version of SQL is SSMS scripting for?
Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server ... Continue reading
2019-03-25
14 reads
Kenneth Fisher
Disabling and enabling triggers
I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now...
2019-03-20 (first published: 2019-03-06)
2,393 reads
Hugo’s SQL Server Execution Plan Reference
I’m a big fan of T-SQL Tuesday. Each month there is a host who comes up with a topic, and...
2019-03-18
445 reads
SQL Homework – March 2019 – Reconfigure tempdb
You’ve heard of tempdb right? It’s one of the system databases. All of the system databases are important but poor...
2019-03-15 (first published: 2019-03-04)
2,410 reads
Dipping into the Cookie Jar: T-SQL Tuesday #112
This month our intrepid host for T-SQL Tuesday is Shane O’Neill (b/t). He’s asked us to talk about our cookies....
2019-03-12
248 reads
DBA Myths: Can a differential backup get bigger than the full backup?
The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one...
2019-03-04 (first published: 2019-02-14)
2,441 reads
Dem queries
Dem queries, dem queries, dem slow queries,
Dem queries, dem queries, dem fast queries,
Dem queries, dem queries, dem big queries,
Now write...
2019-02-27
1,146 reads
Using the Microsoft Authenticator app to log into Azure
So I was trying to work on a blog post about the new truncation error this morning and realized I...
2019-02-25
233 reads
Why do I (they) own that database?
Ever looked at the list of databases and wonder why you own one of them? Or why some other user...
2019-02-20
132 reads
Disabling Indexes
Indexes are probably the number one tool we have to improve performance. That said, there are times when we want...
2019-02-18 (first published: 2019-01-28)
2,453 reads
Blogs
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....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
Forums
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Cannot get KB959420
Hi, since we lost our sql server 2000 server we are trying to restore...
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