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 →
I was having a cleanup of some old scripts the other day when I stumbled upon a script I wrote some time ago. I remember writing the script because from time to time I would get asked if I can restore a copy of a specific database to a particular point in time... 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 →
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here. Bert has a great topic for this month, he wants us to write about code you’ve written that you would hate to live without. I have found the SQL server community to be extremely helpful... Continue Reading →
SQL Undercover 