A couple of years ago I wrote a post on how to generate a random number in SQL Server. https://sqlundercover.com/2017/06/22/generating-random-numbers-for-each-row-over-a-specified-range-and-other-funky-stuff-you-can-do-with-them/ It’s ok and it works, it’s also a method...
2021-03-31
14 reads
Blog posts have been few and far between from SQL Undercover lately but what better to try and get us back in the swing again than with T-SQL Tuesday....
2021-02-09
113 reads
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)
334 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
19 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)
290 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
137 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)
204 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)
445 reads
By Arun Sirpal
Being aligned to a global cloud like Microsoft Azure you have choices. Whether that...
By Steve Jones
I started a poll today on the naming for future SQL Saturdays. You can...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Informes de Expertos (IDE) latest report, titled “Mercado Español de Muebles de Lujo, Informe...
Informes de Expertos (IDE) latest report, titled “Mercado Latinoamericano de los Medicamentos Oncológicos Genéricos,...
We have no prior experience of using XE. Yes, our DBA group uses server...
Ask SSC