Redgate has released a new product, SQL Clone. I’ve already talked about how excited I am about it. Now, it’s your turn to get excited.
Our developers evidently had too much time on their hands after building SQL Clone. They created a skill in Alexa that lets you clone a database using voice commands. In fact, I was recently visiting Redgate HQ and was able to try it out and you can watch here.
Now, in celebration of the launch of SQL Clone, we want to enable you to do some voice commands of your own. We’re giving away five Amazon Echo Dots and one copy of SQL Clone to an overall winner. To enter, go into the comments and let us know what skill you would like to build for Alexa (you don’t have to actually do it). You may want to automate provisioning a development server, refresh your QA instance, or simulate a launch of all the nukes, any of this through voice commands. Just let me know in the comments below and you’ll be entered into the contest.
I think that SQL Clone is going to rapidly expand the kind of work you can do within your Database Lifecycle Management processes in support of DevOps. Download a copy and try it out for 14 days to see if I’m right.
Alexa, turn on the shower to 100 degrees and when it’s ready turn on the coffee maker and notify me (while I hit snooze and get a few more minutes of sleep)
Alexa, please turn this vague idea for a new presentation into an exciting and professional abstract…
Alexa, mow the lawn please.
Alexa format my code plz
Alexa, build operations and deploy to test. Notify the user community when completed. Oh, Alexa, do not forget to restart the print spoolers while your at it.
Alexa: please identify all user queries containing “nolock” or “read_uncommitted” and drop those users from the SQL Instance then log into their Amazon accounts and order 2 tons of creamed corn for overnight delivery to their homes.
Alexa, please refresh dev environment XYZ with version 123.
Alexa – “Enable ScaryDBA (tuning recommendations) mode on my SQL Server and check his twitter feed while you are there”…
Alexa — Please ask Red Gate for a complimentary license of the SQL Tool Belt and SQL Clone. 🙂
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.
Alexa, fluctuate the shower water temperature between 120 and 30 degrees F after 15 minutes of daughter in it.
Alexa, please push these changes from dev to test and create all required procedural documentation.
SqlClone — considering this if our Netapp Flexclone option doesn’t materialize. What about other Redgate products? We’ve been using Quest Spotlight and Foglight for quite a while but I’m open to jumping to another line.
SQL Monitor would be the thing to look at. You can go to sqlmonitor.com to check it out.
Alexa, create docker image from test environment and deploy it on production.
I would create a skill for Alexa, so that she can find and maybe even book the best flights and hotels possible, within a certain budget, to a preferred destination, with a set of preferred parameters and maybe even with an itinerary. It would save hours of trawling holidays sites and leave more time for relaxing and coffee!! *upgrade planning and house chores*
Alexa, please run the new production instance setup on server PRD-ServerB.
Alexa – users are reporting the database is slow – please identify root cause(s) and correct.
Alexa, email my team as soon as SQL Clone has finished provisioning a database.
Alexa, delete clone
Alexa, take over this argument with my daughter and let me know when I’ve lost my temper and sent her to her room.
Alexa, stress test my database simulating 500-1000 requests per minute and make recommendations based on results.
Alexa, build an SSIS package to import data and output a monthly report.
Alexa, run a mandatory full security audit and performance analysis on all instances and databases, auto-correct and report, then go wash my car.
I’d keep Alexa in my kitchen and have her keep track of what I have in my fridge, freezer, cupboards etc. I’d get Alexa to order items for home delivery when they’re running low or the use by date is about to expire. I’d also use Alexa’s knowledge of what I currently have in my kitchen to suggest recipes that I could cook based on what items I have available.
I would give Alexa all my passwords to all my emails, social networks, and will have it respond to emails, post statuses and communicate with other people’s Alexas (just because I think everyone will eventually end up doing the same thing!) and in the meantime I will go to an island in Greece or the Pacific and will get a small farm without internet and will start building a self-sustained farm where I can enjoy the taste of food and the bliss of sleep, uninterrupted by electronics. This way, the world will enjoy my presence, as virtual as it is (oh, wait, it is virtual enough today as it is!) and if I ever wanted to get back one day, all I would need to do would be to rename my self Alexa.
Alexa, drive me to work.
Alexa, rollback the latest database code deploy
Alexa, let’s get real here… Please protect me from my stupid self. Take whatever measures needed. And for the final time, I don’t want to play chess, let’s play Global Thermonuclear War! 😉
Alexa, Please make that the “Alexa and SQL Clone – It Just Works” video.
When I asked Alexa for “SQL Clone and a Little Competition†she was quick to correct me!
Did they post the outtakes?
Sir, If I am fortunate enough to win one of the Echo Dots, can I talk you into autographing it? I think that would be really cool! All the Best!
LOL, I didn’t want to bring those up!
Alexa, Please launch Grant Fritchey’s Youtube video “SQL Clone and a Little Competition” on my iphone and play repeatedly!
Alexa, please write my blog post for me and insert appropriate funny memes or images where I say . =) Here’s hoping I win a Dot! I tried SQL Clone during the beta and enjoyed it, great for deploying dev/test DBs.
Alexa, Call my wife and tell her I’m cloning tonight
Alexa Play some 80’s Music and create a clone of risbeta as risbeta2 and begin load test.
It removed my placeholders. Trying again with different place holders.
Alexa, kill spid [session id]
Alexa, kill all spids for login [login]
Alexa, kill all spids for application like [app name snippet]
Alexa, kill all spids for database [database]
Alexa, kill all spids with runtime greater than [time length]
Alexa, kill all spids with runtime greater than [time length] except login [login]
Alexa, kill all spids with runtime greater than [time length] except login is sysadmin
Alexa, kill all spids with runtime greater than [time length] except application like [app name snippet]
Alexa, kill all spids with runtime greater than [time length] except for database [database]
Alexa, kill spid
Alexa, kill all spids for login
Alexa, kill all spids for application like
Alexa, kill all spids for database
Alexa, kill all spids with runtime greater than
Alexa, kill all spids with runtime greater than except login
Alexa, kill all spids with runtime greater than except login is sysadmin
Alexa, kill all spids with runtime greater than except application like
Alexa, kill all spids with runtime greater than for database
Thanks Grant! Just saw that I was one of the winners. You rock!
Hey everyone. The winners have been posted: https://www.red-gate.com/blog/sql-clone-alexa?utm_campaign=SQL%20Clone&utm_content=53815942&utm_medium=social&utm_source=twitter
Congratulations. Thanks for taking part. I’ll also be putting up a blog post with their names. The overall winner here on my blog…. Josh!
Creamed corn & NOLOCK… HA! That was excellent.
Again, thanks to everyone for taking part.