Complicated linked servers and a bunch of head-desks: T-SQL Tuesday #104
Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started...
2018-08-14
373 reads
Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started...
2018-08-14
373 reads
Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the...
2018-08-13 (first published: 2018-07-30)
1,496 reads
This crossword is based on terms you might come across in an article about Dynamic SQL.
2018-08-08
618 reads
A while back I was given the advice Move your tabs (Object Explorer etc) to the right side of SSMS....
2018-08-08
288 reads
The other day I was given a truly horribly formatted piece of SQL. Something a bit like this only worse,...
2018-08-06
412 reads
I have a presentation I do every now again on security basics that I’m actually quite proud of. One of...
2018-08-02 (first published: 2018-07-12)
1,963 reads
This month’s homework is pretty simple to say, not necessarily easy to do. Set up database mail.
Why database mail?...
2018-08-01
330 reads
Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the...
2018-07-31 (first published: 2018-07-18)
2,981 reads
Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the...
2018-07-25
235 reads
As always with something like this, I like to start with a definition so we are all starting in the...
2018-07-23
170 reads
By Chris Yates
I get asked a lot about why or how I began working with databases...
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Hi, we lost our sever sql2000 To restore database to a new one we...
Comments posted to this topic are about the item Do You Really Need HA?
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers