We all had those calls, it's the middle of the night and we get that phone call that a customer is getting error messages due to their tempDB being full. My first step is usually going to be to have a look and see what sessions have allocations in TempDB, we can do that quickly... Continue Reading →
For one reason or another data security and encryption has been coming up quite a bit in my day to day work recently and I've started to realise that it seems to be one of those things that people aren't all that aware of. As I've been meaning to write a little series on encryption... Continue Reading →
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 that I used for quite a while. Why not use RAND() I've heard people say, well the issue with RAND() is that it will generate the... Continue Reading →
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. This month's invitation comes from Mikey Bronowski https://www.bronowski.it/blog/2021/02/t-sql-tuesday-135-the-outstanding-tools-of-the-trade-that-make-your-job-awesome/ There are so many tools that I use day in and day out to make my life easier... Continue Reading →
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 #263 If you centralize your Servers' collections into a single database, you may be interested in the latest addition, we added the ability to override most... Continue Reading →
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 may be if that default database becomes unavailable. There are going to be situations where setting a default database other than the master database is essential.... Continue Reading →
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. 1.8 fixes this issue. 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/
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 a full and differential backup. https://youtu.be/rVUuXvJK8XY
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 backups are excluded @SingleUser - Put the database into single user mode before restoring @StopAtMark - Append stopatmark clause to any log restores @StopBeforeMark - Append... Continue Reading →
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 many people seem to know about. The thing to remember here that this is only available in Enterprise Edition, so unfortunately those of you on Standard... Continue Reading →
