Automation starts by doing something once, very very carefully: T-SQL Tuesday #110
After a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it’s...
2019-01-08
198 reads
After a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it’s...
2019-01-08
198 reads
Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here?
SELECT
IDENTITY(INT,...
2019-01-02 (first published: 2018-12-19)
6,750 reads
Happy New Year! Every year for New Years we all make a big deal of coming up with New Years...
2019-01-02
1,070 reads
I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows...
2018-12-31
426 reads
I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week.
I...
2018-12-18 (first published: 2018-11-28)
2,754 reads
Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error...
2018-12-17
1,009 reads
TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file...
2018-12-12
907 reads
We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016...
2018-12-10
223 reads
A while back I wrote about how to find where your backups are. And I’ve also written about I use...
2018-12-10 (first published: 2018-11-26)
2,076 reads
A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and...
2018-12-05
6,932 reads
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....
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
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