This is one of them little options that I see which quite often gets little consideration or gets set to a user database without consideration of what the consequences...
2020-12-09 (first published: 2020-11-30)
324 reads
All the changes for this release can be found in the Github Project page Mainly bug fixes this time around , but we have also added new functionality: Improvements...
2020-12-01
13 reads
It looks like there was a bug lurking in sp_RestoreScript that was causing the wrong ALTER DATABASE command to be generated when using @SingleUser and a WITH MOVE parameter....
2020-11-23
16 reads
Welcome along to the first module in our Undercover Academy’s SQL Server Backup and Recovery course. In this module we’re going to look at how to take and restore...
2020-10-07 (first published: 2020-09-30)
289 reads
sp_RestoreScript 1.7 has been released. For information and documentation please visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/ Changes in 1.7 New Parameters @IncludeCopyOnly – 1 – Copy only backups are included0 – Copy only...
2020-09-29
136 reads
The merry-go-round scan or advanced scan is something that I’ve seen mentioned a few times recently and it’s a lovely little feature of Enterprise Edition that not all that...
2020-09-23 (first published: 2020-09-16)
197 reads
This is just going to be a quick post but I was asked the question the other day, how can I find all the tables in the database that...
2020-08-20
13 reads
SQL Server has given us the option to backup our databases directly to Azure BLOB storage for a while now but it’s not something that I’ve had all that...
2020-07-08 (first published: 2020-06-22)
441 reads
This month’s T-SQL Tuesday invitation is from Ken Fisher and he’s asking about non-SQL tips and tricks. This had me thinking for a bit and then something popped into...
2020-06-23 (first published: 2020-06-09)
323 reads
BlitzFileStats is the latest addition to our custom module collection for reporting on data logged to tables using the First Responder kit, We created a new project where we plan on...
2020-06-03
8 reads
By Devin-Knight
There are a lot of hot phrases you’ve likely heard thrown around during various...
By Kamil
Azure Data Factory is a fantastic tool which allows you to orchestrate ETL/ELT processes...
By Steve Jones
Today is the last day that the PASS and SQL Saturday websites will be...
Comments posted to this topic are about the item Who is my customer?
Hi, First time poster, and hoping everyone goes easy on me. I am very...
hi all, I need some help here. Recently, I've found a db with error...
Ask SSC