• Azure - Linux - Microsoft - SQLServer

    Linux Scripting, Part III

    In the previous blog posts, we learned how to set up the first part of a standard shell script- how to interactively set variables, including how to pass them as part of the script execution. In this next step, we’ll use those to build out Azure resources. If you’re working on-premises, you can use this type of scripting with SQL Server 2019 Linux but will need to use CLI commands and SQLCMD. I will cover this in later posts, but honestly, the cloud makes deployment quicker for any business to get what they need deployed and with the amount of…

  • DBA Life - GDPR - Linux - Microsoft - Power BI - Thought Leadership

    The Late Spring Speaking Gauntlet

    There are busy times for everyone and if you speak at conferences, the busy times are March,May and November. I am recovering from the early spring rush, and now it’s time to prepare for the late spring one. I’ve been fortunate enough to be accepted to speak at the following regional SQL Saturdays and look forward to speaking and meeting new folks, along with catching up with conference friends: SQL Saturday Raleigh, April 27th Optimizing Power BI, Taming of the Shrew, (Analytics) SQL Saturday Jacksonville, May 5th GDPR, The Buck Stops Here, (data governance) Be a Part of the Solution…

  • Azure - Azure CLI - devops - Microsoft

    Azure Automation of A-to-Z, Part I

    DevOps deployments and automation have numerous tools at their disposal, but most often, scripting is required. Although I’m a Microsoft Azure fanatic, I am also a strong advocate of Linux and with my two decades on Unix, I strongly prefer BASH over PoSH. I find the maturity of BASH and KSH highly attractive over PoSH and with my experience, I’m simply more skilled with shells native to the Linux OS. Before we get too far in, I know some of the text can be difficult to read and/or you want to copy and paste or you want some of the…

  • Azure - Azure CLI - devops

    Use Azure CLI…I Beg You.

    FYI-  this was the one post I had to restore manually after my blog was hacked a week back.  Its intact, but the post may appear a bit different than before, as I copied and pasted from the emailed version that occurs as part of my RSS feed.  Enjoy! Azure CLI made me feel right at home after working at Oracle in the Enterprise Manager CLI, (EMCLI)  The syntax is simple, powerful and allows an interface to manage Azure infrastructure from the command line, scripting out complex processing that would involve a lot of time in the user interface. I’d…

  • Azure - devops - Microsoft Flow - Power BI

    Automation and Analytics

    They say the devil is in the details and as I come from the DevOps side of the house, it would only be natural that I’d be attracted to how Microsoft Flow works with Power BI.  For those that aren’t familiar with Microsoft Flow, think of it like If This Then That, (IFTTT) from Microsoft. I used IFTTT to automate a number of tasks at my previous company-  everything from posting to social media automation, notifications on Slack, creating weekly status reports and other tedious tasks that I hated having to do manually. Microsoft Flow, is a powerful SaaS tool…

  • big data - Copy Data Management - Data Masking - Database - DBA Life - Delphix - devops - Test Data Management - Thought Leadership

    Broadening Your Audience

    I spent this week speaking at two conferences that may not be familiar to my usual crowd: • Techwell StarEast Testing Conference in Orlando, FL • Interop ITX Data Conference in Las Vegas, NV StarEast Testing Conference Techwell’s event is attended by testers and had over 2000 attendees at the Hyatt Regency Orlando’s Convention Center. This is a huge convention center and I won’t lie- I did try to first register at the Mazda event and then the KPMG event. One of the attendees in my session admitted she was crashing my talk from the KPMG conference and I was pretty…

  • big data - Delphix - devops - Oracle - Test Data Management

    StarEast, InteropITX and GDPR

    I’m getting ready to get on a plane between two events today and have been so busy, that there’s been a break in blogging.  That’s right folks, Kellyn has let a few things slide…. For those people on top of all the happenings in Kevlar’s life, I’ve been busy removing 15 years of possessions from my home so we can sell it in the next month, along with the purchase, upgrade and consolidation into a 42Ft. travel trailer.  It’s quite an undertaking, so a few things have had to be put lower on the priority list to complete the rest.…

  • Delphix - devops

    Free eBook: DevOps and the DBA, The Last Frontier!

    The first edition of the free eBook is available for download at Delphix! It took us a bit to get the final updates to the eBook version completed and I want to thank everyone at Delphix who helped get the content updated with the latest additions, including the bossman, Eric Schrock and for helping me keep it all organized and finalized, shoutouts to Rita Rosenberg. If you’re interested in downloading a PDF copy, simply go to this link and get a version for yourself and find out what you need to know as a DBA about where we fit into…

  • Database - DBA Life - Delphix - Oracle - SQLServer

    Latest Delphix Blog Post and Upcoming Webinars

    In my latest blog post on the Delphix site, I continue my conversation with why DevOps is the next step for DBAs and how DBAs can embrace this next step in their evolution. This is an extensive series of blog posts, (four so far) to be followed by an ebook, a podcast and two webinars.  One is to be announced soon from Oracle called, “The DBA Diaries” and the other will be a from Delphix, titled, “The Revolution:  From Databases and DevOps to DataOps“. The goal for all of this is to ease transition for the Database community as the…

  • devops - Oracle - SQLServer

    The $50 Million Hyphen

    There are a plethora of mishaps in the early space program to prove the need for DevOps, but Fifty-five years ago this month, there was one in particular that is often used as an example for all.  This simple human error almost ended the whole American space program and it serves as a strong example of why DevOps is essential as agile speeds up the development cycle.   The Mariner I space probe was a pivotal point in the space race between the United States and the Soviet Union.  The space probe was a grand expedition into a series of large,…

  • devops

    DevOps and Webinars- July 19th and July 25th

    Doing three or four webinars in a month doesn’t seem like a big deal until you actually try to do it…and present at two or three events and make sure you do everything for your job outside of that, too.  Suddenly you find yourself scrambling to keep up, but I’m known for taking on a few too many things at once… 🙂 Tomorrow at I’ll be presenting at 24HOP, also known as the 24 Hours of Pass, which is the webinar preview of The Pass Summit conference.  This is a free web event to anyone who registers, so no matter…

  • DBA Life - devops - Oracle

    DevOps is Ruining the DBA?

    Database Administrators, (DBAs) through their own self-promotion, will tell you they’re the smartest people in the room and being such, will avoid buzzwords that create cataclysmic shifts in technology as DevOps has.  One of our main role is to maintain consistent availability, which is always threatened by change and DevOps opposes this with a focus on methodologies like agile, continuous delivery and lean development. Residing a step or more behind bleeding edge has never phased the DBA.  We were the cool kids by being retro, those refusing to fall for the latest trend or the coolest new feature, knowing that…

  • Delphix - devops

    Its All About the DevOps Roll of the Dice

    Different combination in the game of tech create a winning roll of the dice and other times create a loss.  Better communication between teams can offer a better opportunity to deter from holes in development cycle tools, especially when DevOps is the solution you’re striving for. It doesn’t hurt to have a map to help guide you.  This interactive map from XebiaLabs can help offer a little clarity to the solutions, but there’s definitely some holes in multiple places that could be clarified a bit more. The power of this periodic table of DevOps tools, isn’t just that they are broken…

  • Delphix - devops

    DevOps and Source Control

    The topic of DevOps and and Agile are everywhere, but how often do you hear Source Control thrown into the mix?  Not so much in public, but behind the closed doors of technical and development meetings when Agile is in place, it’s a common theme.  When source control isn’t part of the combination, havoc ensues and a lot of DBAs working nights on production with broken hearts. Control Freaks So what is source control and why is it such an important part of DevOps?  The official definition of source control is: A component of software configuration management, version control, also…