THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

UPDATED: Use Amazon’s Alexa to Create a Copy of a Database Using Redgate SQL Clone…

Please help: If you commented below please email me by clicking the Email link and sending me an email. Redgate wants to notify the winners!

Thank you,


CMYK_SQL Clone col 1

…and win an Amazon Echo Dot and one lucky winner will score a free SQL Clone license!

About SQL Clone

SQL Clone

I can hear you thinking, “What’s SQL Clone, Andy?” I’m glad you asked!

SQL Clone is a database provisioning tool that removes much of the time and disk space needed to create multiple database copies. With SQL Clone, database copies can be created in seconds and each copy uses around 40MB of disk space, no matter the size of the original database. Provisioning requests can be dealt with very quickly, and teams can work locally on up-to-date, isolated copies of the database to speed up development, accurately test code, and fix issues faster.

About the Amazon Echo Dot

I can hear you thinking, “So how do I win an Amazon Echo Dot, Andy?” I’m glad you asked!

Amazon’s Alexa Voice Service is the engine behind the Amazon Echo, Tap, and Dot devices. The talented developers at Redgate built an Alexa Skill – a capability that enables interaction between people and devices and services – to facilitate voice-activated database cloning using SQL Clone. You can view a cool video of SQL Clone in action via Alexa here!

“How Do I Enter to Win?”

To enter the competition, post a comment stating what “skill” you would build with an Echo Dot (if time and money were no object). Maybe you’d like to know when a backup fails or how many deployments have been made to a database. Or maybe you would like to a reminder to record your favorite TV show! It doesn’t necessarily have to be database-related.

The contest ends 30 April. Winners will be announced 5 May on the Redgate blog. Please check the Redgate blog on May 5 to see if you've won.  See the full contest terms and conditions are here.

So have at it! Leave a comment to enter to win a free Amazon Echo Dot. Redgate is giving away five Dots! And one lucky winner will receive a SQL Clone license!


PS – Learn how Redgate created an Alexa skill for SQL Clone.

Published Tuesday, May 2, 2017 5:18 PM by andyleonard



RichB said:

I'd like to see a voice activated 'Remove cleanly all 30 individual Redgate Installs from my over UAC'd machine please' command.

Yeah, I'm planning to put some back, but for now I need to whip em off.  

March 6, 2017 7:42 PM

Sean Forgatch said:

Allow end users to "query" datasets. Similar to how bots are being used to do the same thing in Skype. A quick insights sort of solution. Right now I'm happy with the ability to schedule appointments in Outlook, not sure if that will stick yet or not.

March 6, 2017 11:11 PM

Martin I said:

Set up a "Flash" report that will you tell you which servers are not running normally and what is wrong. Something like "Alexa, give me a DB flash report for <servergroup>." That way you could group servers and and either get info on one, a group, or all.

Some of the information would include perfmon metrics, wait stats, network issues and such.

March 7, 2017 12:29 PM

Jim Donahoe said:

Alexa to receive alerts from monitoring tools and audibly alert when a performance condition/security alert/any alert happens that is deemed critical. Then with said functionality be able to tell Alexa to acknowledge the alert.

March 8, 2017 7:33 AM

Julie said:

I would create an Alexa skill to read through all of my AWS CloudWatch stats for a given period in time and report on changes in trends, and any areas which require further investigation to prempt issues.

March 13, 2017 6:55 AM

Eric said:

I'd like Alexa to give a current status of all my SQL Agent Data Load Jobs - completed, failed or running. Would be handy to start my day with that vs. checking email.

March 14, 2017 2:11 PM

Mohammed Khaja Mohiuddin said:

Alexa need to stay updated with latest REDGATE versions and update me with the details for further actions.


March 15, 2017 6:08 AM

Praveen Ganji said:

I would like a skill to call Stored procedures and read the output. For example.. Get database/application mapping information. Or ask Alexa if a database exists and when is the db created and current stats like size,params etc.

March 15, 2017 11:53 AM

Roman said:

Clone production db with scrubbed data!

March 15, 2017 3:18 PM

Lee Hawthorn said:

Alex - tell me the name of the users in the top 5% percentile based on rates of long running queries

March 17, 2017 8:49 AM

Paul Rosenberg said:

I'd get Alexa to understand my SQL Prompt snippets and let me dictate SQL code directly, without the need to actually type.

March 29, 2017 2:03 PM

Andrew Pirie said:

I'd like Alexa to remind me to look for opportunities to spend time with family members when I haven't seen them in a while.

April 3, 2017 8:13 PM
New Comments to this post are disabled

This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement