June 11, 2023
  • 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
  • Fabric
  • batman lego
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 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
Tweet

Next Generation Data Platform

Banner

Upskill yourself

Banner

You can find MVP here

Banner
Banner

Recent Posts

  • Multitasking = chaos
  • Stellar Repair for MS SQL – Product Review
  • Synapse Analytics workspace – deployment challenges
  • SQLPlayer is renaming
  • InvalidAbfsRestOperationException in Azure Synapse notebook

Our tweets

Tweets by Azure_Player

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 Data Warehouse dax deployment DevOps docker ETL installation JSON Ljubljana MCM Microsoft MVP PASS Summit PowerBI Power BI PowerShell python redgate Seattle spark SQLBits SQLDay SQLFamily SQL Server SQL Server 2017 SQL Server 2019 SSDT SSIS SSMS video Wroclaw

Archives

Categories

Conferences

SQLDay 2016

META

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

Our values

Privacy Policy

Breaking News

02/05/2023 21:32

Multitasking = chaos

15/03/2023 00:17

Stellar Repair for MS SQL – Product Review

07/03/2023 07:44

Synapse Analytics workspace – deployment challenges

01/01/2023 19:26

SQLPlayer is renaming

05/12/2022 20:23

InvalidAbfsRestOperationException in Azure Synapse notebook

© Kamil Nowinski 2017-2023 • All Rights Reserved