Voice of the DBA

Category: Presentations

  • Automated Build and Test

    Continuous Integration (CI) is a well known process in the software development world, but it’s not often implemented with databases. This is despite the fact that database code could benefit from the practice of checking the changes on a regular basis for potential issues. This talk will show how to implement continuous integration for databases and include more realistic testing of the code for potential issues.

    We will set up CI for a SQL Server database project, using the following tools:

    • Team City (CI Server)
    • Subversion (VCS)
    • SQL Automation Pack (database -> CI integration)
    • tSQLt  testing framework
    • SQL Data Generator

    Slides

  • Team-based Database Development with Version Control

    An efficient development process requires that all of your team members coordinate their efforts. This session shows how a version control system (VCS) and standard development practices help improve the speed and quality of your development process.

    This talk will look at:

    • reasons for using VCS
    • methods for including a database in version control
    • how we share changes from a VCS
    • linking static data in VCS
    • enforcing standards in development

    Length: 60-75 minutes

    Slides:

  • Filestream and Filetable in SQL Server

    This talk is an update of my Unstructured Data in SQL Server talk that looks at the Filestream and Filetable features of SQL Server.

    This session begins by presenting a case why we will manage more binary (unstructured data) in the future. The growth of this data is amazing. From there we delve into the basics of the three main types of data:

    • structured
    • semi-structured
    • unstructured

    The session examines the basics of Filestream and how you get enable this feature, administer it from a DBA perspective, and move data in and out of Filestream columns.

    Filetable is introduced along with demos on how to enable this data, as well as a brief search demo to extract information from documents.

    Level: 200

    Length: 60-75 minutes

    Demo Code:

    Slides:

    Related Blogs:

    Presentation Schedule

    This session has been given at these places.

    Apr 9, 2013 – SQL Intersection Spring 2013

  • Branding Yourself for a Dream Job – The Modern Resume

    This presentation is a career based one designed to help people better market themselves and understand how employers might view them.

    Abstract:

    Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.

    I maintain a blog on this talk at: modernresume.com

    Slides:

    You can download the slides here

    Branding Yourself for a Dream Job 2013