June 16, 2025
  • Knowledge
    • Videos
    • Books
    • Blogs
    • Cheat Sheets
    • SQL Server Updates
    • Azure Heat Map
  • Resources
    • Microsoft Fabric
    • 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 AzurePlayer —-
    • 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 Toboggan
    • 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

Next Generation Data Platform

Banner

Upskill yourself

Banner

You can find MVP here

Banner
Banner

Recent Posts

  • 10 reasons why IT certifications are still important
  • Last Weeks Reading (2024-02-11)
  • Last Weeks Reading (2024-01-28)
  • Last Weeks Reading (2023-12-17)
  • Last Weeks Reading (2023-11-26)

Tags

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

Archives

Categories

Conferences

SQLDay 2016

META

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

Our values

Privacy Policy

Breaking News

23/02/2024 11:00

10 reasons why IT certifications are still important

11/02/2024 22:00

Last Weeks Reading (2024-02-11)

29/01/2024 07:00

Last Weeks Reading (2024-01-28)

18/12/2023 09:43

Last Weeks Reading (2023-12-17)

26/11/2023 22:47

Last Weeks Reading (2023-11-26)

© Kamil Nowinski 2017-2023 • All Rights Reserved