T4 Templating within SSDT using SQL Server 2014

Development has been moving to automatic build and continuous integration. It has been difficult for Database and Business Intelligence project to align with these processes.  SQL Server Data Tools and the Visual Studio Environment are now enabling database and BI projects to embrace automatic builds.  This session takes you through an example warehouse project and shows how you can automate the build and deploy process.  The session is demo rich and will shows by example how you can use T4 and SSDT (with SQL Server 2014) to build and deploy projects automatically.  This session is useful to both BI and Database developers.
Presented by Geoff Clark at SQLBits XII
  • Downloads
    Slide deck available Slide Deck 344 KB
    Samples available Demo Code 796 KB
    Video available MP4 Video HD 535 MB
  • SpeakerBIO

    Geoff has architected SQL systems with high throughput and availability for business in many sectors including media and finance. Geoff has been involved with SQL Server since the beginning having been the technical architect at BAA for one of the earliest SQL database project. Geoff began his professional career as a consultant for ICL based in the City of London, designing and capacity planning mainframe systems before moving to Ingres relational databases on Sun and more recently Microsoft .Net technology including SQL Server.

    MCM SQL Server 2008, MCPD Azure.

  • Video