Podcast Audio Now On SoundCloud
For those of you who don’t have time to watch the videos, the audio stream of our webcasts are now...
2018-09-05
296 reads
SQL Undercover
Installing External Modules into SQL Server’s Python
So Microsoft have integrated Python into SQL Server, from the moment I heard that I thought to myself, “wow, this...
2018-09-03
343 reads
Undercover TV- Episode 2
The latest webcast from SQLUndercover.com. In this episode David and Adrian take a look at a few blog posts that have caught...
2018-08-29
373 reads
Undercover Catalogue 0.1 Released
Easily Keep Track of All Your SQL Servers
We know what it’s like when you’ve got 101 SQL Servers to manage,...
2018-08-28
271 reads
SQL Server Encryption, What’s The Key Hierarchy All About?
I’m sure that we all know that SQL Server includes all sorts of interesting functionality to allow us to encrypt...
2018-08-27 (first published: 2018-08-09)
1,831 reads
A Quick Look At The All New Undercover Catalogue, Preview Release Due Out Soon…
I thought I’d give you all a little preview of our latest offering, the Undercover Catalogue which should be available...
2018-08-06
260 reads
Are your backup files where they say they are?
I was having a cleanup of some old scripts the other day when I stumbled upon a script I wrote...
2018-08-08 (first published: 2018-07-25)
1,989 reads
Selecting a Random Row From a Table
A couple of times recently I’ve seen the question asked, ‘How can I select a single row at random from...
2018-07-26 (first published: 2018-07-20)
718 reads
T-SQL Tuesday #104 – My Undercover Toolbox favourites
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here.
Bert...
2018-07-18 (first published: 2018-07-10)
2,701 reads
Backup Your On Premise SQL Server Directly to an AWS S3 Bucket
I’ve been having a little play around with AWS recently and was looking at S3 (AWS’ cloud storage) when I...
2018-06-18
749 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers