Attaching Database Using SMO & Powershell

• by Sheldon Hull

• Sheldon Hull

Steve Jones wrote a great article on using this automation here titled The Demo Setup-Attaching Databases with Powershell. I threw...

2016-11-18

679 reads

Parallel Powershell for Running SQL

• by Sheldon Hull

• Sheldon Hull

This is just a quick look. I plan on diving into this in the future more, as I'm still working...

2016-11-16

1,800 reads

Parallel Powershell for Running SQL

• by Sheldon Hull

• Sheldon Hull

This is just a quick look. I plan on diving into this in the future more, as I'm still working...

2016-11-16

205 reads

Data Compare on Temporal Tables

• by Sheldon Hull

• Sheldon Hull

I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went...

2016-11-02 (first published: 2016-10-28)

2,484 reads

Get Backup History for All Databases in Server

• by Sheldon Hull

• Sheldon Hull

Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions...

2016-10-31

861 reads

Get Backup History for All Databases in Server

• by Sheldon Hull

• Sheldon Hull

Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions...

2016-10-31

479 reads

Data Compare on Temporal Tables

• by Sheldon Hull

• Sheldon Hull

I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went...

2016-10-28

524 reads

Centralized Management Server 101

• by Sheldon Hull

• Sheldon Hull

Registered Servers
I've used Central Management Server registered servers in SSMS for primarily one purpose, saving connections. 🙂 This is definitely not...

2016-10-24 (first published: 2016-10-16)

2,441 reads

Fixing Untrusted Foreign Key or Check Constraint

• by Sheldon Hull

• Sheldon Hull

Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax....

2016-10-22

531 reads

Fixing Untrusted Foreign Key or Check Constraint

• by Sheldon Hull

• Sheldon Hull

Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax.If...

2016-10-22

224 reads