Voice of the DBA

Tag: speaking

  • Bringing DevOps to the Database

    Abstract:

    DevOps is a hot topic in today’s software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown.

    Level: 200 – Not to technical, but you should have some idea of how software development works to get something out of this talk.

    Goals:

    1. Conceptually understand how DevOps principles can easily be applied to the database in either state based or migrations based changes.
    2. Learn how databases can be automatically built and tested in a CI/CD environment
    3. Understand how database releases can be automated, but are different than those deployment/releases made for other software.

    Demos:

    This presentation has a few demos where I show how I stored database code in a VCS, perform an automated build, and use a scripted release process to move code from one database to the next. The demos are pre-built, so I just show how they work. I can do this with:

    • git, VSTS Build and VSTS Release
    • git or SVN, Team City, and Octopus Deploy

    Downloads:

    There are a few versions, as this talk has evolved.

    GroupBy – Bringing DevOps to the Database Groupby.pptx

    Live!360/VSLive – VSLive-Orlando 2016.pptx

    SQL Saturday Cambridge – Bringing DevOps to the Database.pptx

  • Learning All About Always Encrypted at DevConnections

    Like the alliteration in the title? I almost removed it, but decided it had a nice ring. Maybe that should be the title of my IT/DevConnections (Oct 10-13, 2016) session other than End to End Always Encrypted in SQL Server 2016.

    I loved seeing encryption being natively built into SQL Server 2005 (and beyond), but the addition of Always Encrypted in Azure SQL and SQL Server 2016 really intrigued me. In fact, I think many people were very excited about this feature. In End to End Always Encrypted in SQL Server 2016, I cover the detailed workings and setup of the feature and how it can be included in your applications. There’s a lot to think about with encryption features, and I hope to both inform attendees as well as ensure they have a healthy respect for the limitations.

    I’ve given variations of this talk in 2016 and quite a few people have walked away excited, but also re-thinking the “it just works” message from Microsoft’s marketing people.

    If you’re looking for some training, some inspiration, and are a full-stack developer, or multi-technology IT worker, think about coming out to DevConnections. There are a slew of technologies being covered (VS, ASP.NET, C#7, Azure, PowerShell, AWS, SQL Server, Sharepoint, Exchange, Hyper-V and more).

    Register today, use 500SPKR to save $500, and I’ll see you in Las Vegas this October.

  • Finding out Who’s Touching Your Database at DevConnections

    I’ve got a session this fall at the IT/DevConnections conference (Oct 10-13, 2016) called “Who’s Touching My Database?” This is something I’ve worked on for a few years, but never really gotten it to the point where I was ready to deliver it.

    Earlier this year, with all the security issues I’ve seen across the last couple years, and having had some questions from customers of Redgate, I decided to finish this talk off. I submitted it to DevConnections and started trying to focus the talk down to showing ways in which you can audit the activity on your database server.

    I’ve worked in a few environments where security was taken very seriously and auditing was critical to proving we were properly managing our systems. These days I slowly see the importance of security and auditing growing to all industries, becoming more and more important. I hope to showcase the flexibility and possibilities (As well as drawbacks) of tracking activity on your database servers.

    If you’re looking for some training, some inspiration, and are a full-stack developer, or multi-technology IT worker, think about coming out to DevConnections. There are a slew of technologies being covered (VS, ASP.NET, C#7, Azure, PowerShell, AWS, SQL Server, Sharepoint, Exchange, Hyper-V and more).

    Register today, use 500SPKR to save $500, and I’ll see you in Las Vegas this October.

  • SQL Saturday–Viking Edition

    I’m off to the Viking Ship Museum for SQL Saturday #532. Actually, the Viking Museum will (hopefully) be a side trip on Friday before the actual event. The actual training will be at the Noroff campus in Oslo.

    This is my first trip to Norway, and while it will be quick, I’m looking forward to wandering another new country for a bit. I’m honored to be on the speaker list at this event, which is the third Oslo SQL Saturday (#414, #317).

    As with most of the SQL Saturdays, there’s quite a selection of sessions to choose from. I’ll be talking about your career, as well as Continuous Integration for databases. However there are Query Store talks, Power BI, HA, PoSh, Azure, R, and more.

    I know many of you don’t live in Oslo, but it’s close to much of Europe, and if you’re looking for a quick getaway to improve your career, come on over on Sept 3.  If you want more training, there are 4 pre-cons to choose from, all taught by some highly skilled SQL Server pros that are worth the effort to see.

    Once again, I’m excited for another SQL Saturday, and hope to see some of you there.