It's the second Tuesday of the month which must mean only one thing... We're all skint and payday feels like a long way off??? Not quite, well maybe... but it's also T SQL Tuesday! This month's invitation comes from Steve Jones and he's asking us to write about triggers and our experiences of them. So...... Continue Reading →
For those of you who don't have time to watch the videos, the audio stream of our webcasts are now available on SoundCloud. https://soundcloud.com/sqlundercover
So Microsoft have integrated Python into SQL Server, from the moment I heard that I thought to myself, "wow, this is exciting stuff" and not just for the machine learning, BI guys that it was marketed at. It's exciting for us DBAs too, my head was in a buzz with all the things that we... Continue Reading →
The latest webcast from SQLUndercover.com. In this episode David and Adrian take a look at a few blog posts that have caught their interest, review Minion Backup from Minionware and announce the release of the all new Undercover Catalogue v0.1. Links featured in this webcast are, https://www.sqlrx.com/using-sys-sql_e... http://www.sqlservercentral.com/artic... https://mikesdatawork.wordpress.com/2... http://www.minionware.net/ http://www.midnightdba.com/
Easily Keep Track of All Your SQL Servers We know what it's like when you've got 101 SQL Servers to manage, or even just a couple. It can be almost impossible to keep track of all these servers, their versions, the databases that they host, permissions, dependencies... the list goes on. We developed the Undercover... Continue Reading →
I'm sure that we all know that SQL Server includes all sorts of interesting functionality to allow us to encrypt our data and like with all encryption techniques, that data is encrypted using keys. In SQL Server we've got a number of different keys, we've got the Service Master Key, Database Master Keys, Symmetric... Continue Reading →
I thought I'd give you all a little preview of our latest offering, the Undercover Catalogue which should be available in Preview version very soon. So what actually is it? The Undercover Catalogue will help you to build up a picture of your entire SQL infrastructure. It'll go out, discover and interrogate all of your... Continue Reading →
A couple of times recently I've seen the question asked, 'How can I select a single row at random from a table?'. There are often a few ways of doing this suggested, most seem to rely using CTEs or temp tables. I thought I'd share, in a quick post a very simple and easy way... Continue Reading →
UPDATE Aug 2024: With SQL2022, things have changed and we're now able to backup directly to S3 without the need for third part tools. Check out how to do that here... Backup SQL Server to AWS S3 Bucket (2022 Update) I've been having a little play around with AWS recently and was looking at S3 (AWS'... Continue Reading →
Now this is something that I've seen asked a few times and it's always a question that gets a fair number of different answers. How do we go about converting a positive number to a negative, or the other way around? I'll give you my solution and it uses a little bit of bitwise logic.... Continue Reading →
SQL Undercover 