Presenting you with an updated version of our sp_snapshot procedure, to easily create database snapshots. This new version adds more flexibility to the procedure, allowing you to specify the...
2024-02-14 (first published: 2024-02-01)
402 reads
Picture this, you’re happily backing up your database to a Azure blob storage until suddenly it starts mysteriously failing with the error… Write to backup block blob device https://******...
2023-12-13 (first published: 2023-11-27)
408 reads
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking quite a bit about security. Do we really know how secure our SQL Servers are?...
2023-10-09 (first published: 2023-09-26)
732 reads
This is a question that’s come up twice this morning, firstly where can we find a history of database snapshots and secondly where can we find a history of...
2023-08-30 (first published: 2023-08-14)
198 reads
xp_cmdshell is an extended SQL stored proc that allows users to run Windows command prompt commands from within SQL. Sound scary? It might, but is xp_cmdshell really a security...
2023-04-26 (first published: 2023-04-12)
573 reads
SQL doesn’t really give us too many tools out of the box to allow us to spot when someone may be up to no good. We can look at...
2023-04-12 (first published: 2023-03-29)
533 reads
The question of encryption seems to be coming up a lot recently. I’ve had a number of people asking me about how to go about encrypting SQL Server. SQL...
2023-01-25 (first published: 2023-01-17)
416 reads
Here’s a quick one for today and is an issue that had me stumped for a while. It’s not one that I’d come across before and there isn’t really...
2022-11-28 (first published: 2022-11-16)
286 reads
This was an interesting question that I was asked yesterday and something that I’d never really thought of before. Can you delete the top x number of rows based...
2022-09-30 (first published: 2022-09-15)
873 reads
Have you ever had the need to attach a large number of database in one go? There’s no way to attach multiple databases in SSMS or via script, so...
2022-08-24 (first published: 2022-08-15)
278 reads
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
This is a quick blog post, mainly so I have the code available if...
I'm using PowerQuery in Excel on my desktop. (Yeah, I know you can do...
Here's my data... I am trying to return total days in status for each...
Here's my data... I am trying to return total days in status for each...
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers