February 8, 2023
  • Knowledge
    • Videos
    • Books
    • Blogs
    • Cheat Sheets
    • SQL Server Updates
    • Azure Heat Map
  • Resources
    • SQL Server Data Tools (SSDT)
    • Azure Data Factory
    • ADF Tools
    • Azure Cosmos DB
    • Azure Synapse
    • Azure
    • Tools
  • News
    • News
    • T-SQL Tuesday
    • Events & Speaking
  • Series
    • Starting as DBA from zero
    • Power BI
    • DevOps
    • SQL Server Data Tools (SSDT)
    • Big Data
      • Azure Data Factory
      • Data Warehousing
    • Green Zone
  • Authors
    • Kamil Nowinski
    • Contact
    • Tweet Activity
  • Log in
Azure Player
  • 👨‍🎓 —- Learn with SQLPlayer —-
    • Cheat sheets for Data Engineers
    • SSDT: Essentials 🇬🇧
    • SSDT: Tips & cheat sheets 🇬🇧
    • Database projects with SSDT 🇬🇧
    • Projekty bazodanowe z SSDT 🇵🇱
  • 📽️ YouTube
  • 🗓️ Events
    • Data Community Event Tracker
    • Azure Data Tech Groups
    • SQLDay (Poland)
    • SQLBits (UK)
    • Data Relay (UK)
    • Data Saturday
    • PASS Data Community Summit
    • Data Grillen (DE)
  • 📢 Podcast
    • Ask SQL Family podcast
    • All posts
    • Trailers (video)

SQL Server Data Tools (SSDT)

QR Code – link to this page

All the following posts are in SSDT series on the blog:

  • New DB project with SSDT and import existing database
  • How to create DACPAC file?
  • #TSQL2sDay – How SQLPackage.exe can spoil your deployment
  • Tokenization of database project in SSDT
  • SSDT (SqlPackage) thread crashes with error when publishing
  • Script and deploy the data for database from SSDT project
  • ? Deployment of Microsoft SQL database with Azure DevOps (video)

Code examples and courses:

  • GitHub: SSDT Training – Free set of code examples database projects with SSDT
  • Course: Projekty bazodanowe w SQL Server Data Tools SSDT (Polish edition)
  • Course: Database projects with SSDT (English edition) – soon! Sign up for free materials (click banner below)

Useful Tools:

  • SALT | GitHub – PowerShell module helps to deploy SQL Jobs in an incremental way
  • DeploymentContributorFilterer – Use this tool to filter SQL objects during DACPAC deployment process by SqlPackage.exe.

Microsoft resources:

  • ?️ SQL Server Data Tools (MSDN)
  • ?️ SQLPackage.exe (MSDN)
  • ?️ Data-tier Application Framework (DACFx)
  • Microsoft SQL Server Data Tools Team Blog
  • GIT – branch organization

Other resources:

  • Continuous Delivery and the Database (Redgate)
  • ? SQL Toolbelt – Redgate’s tool for SQL Server databases CI/CD (Redgate)
  • Database version control and deployment – model or migration scripts (Alex Yates)
  • Version Control tools for SQL Server

Misc:

  • ? Who to follow on Twitter

Upskill yourself

Banner

You can find MVP here

Banner
Banner

Recent Posts

  • SQLPlayer is renaming
  • InvalidAbfsRestOperationException in Azure Synapse notebook
  • Mounting ADLS point using Spark in Azure Synapse
  • Cloud Formations – A New MVP Led Training Initiative
  • Discovering diagram of dependencies in Synapse Analytics and ADF pipelines

Our tweets

Tweets by Azure_Player

Tags

ADF ADFDF adftools AI Azure Azure Cosmos DB Azure Data Factory Azure Function Azure SQL DW Big Data Brent Ozar CI/CD Columnstore cosmosdb Databricks dax deployment DevOps docker ETL installation JSON Ljubljana MCM Microsoft MVP PASS Summit PowerBI Power BI PowerShell python redgate SCD Seattle spark SQLBits SQLDay SQLFamily SQL Server SQL Server 2017 SQL Server 2019 SSDT SSIS video Wroclaw

Archives

Categories

Conferences

SQLDay 2016

META

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Our values

Privacy Policy

Breaking News

01/01/2023 19:26

SQLPlayer is renaming

05/12/2022 20:23

InvalidAbfsRestOperationException in Azure Synapse notebook

18/07/2022 14:04

Mounting ADLS point using Spark in Azure Synapse

22/05/2022 20:47

Cloud Formations – A New MVP Led Training Initiative

24/01/2022 18:24

Discovering diagram of dependencies in Synapse Analytics and ADF pipelines

© Kamil Nowinski 2017-2023 • All Rights Reserved