SSDT Overview Tips 27 January 202327 January 2023 SQL Server Data Tools help with the deployment Change the development flow from scripts to develop-compile-publish like OOO languages in an IDE. The project name is the default database name…
SSDT Publishing 27 January 202327 January 2023 FIRST: We're using SSDTDatabase Project and we introduced an error in an earlier post; resolve this error, delete or use the correct column name in the view, to continue. Typically,…
SSDT Verify SQL Objects 21 January 202321 January 2023 SSDT identifies missing database objects. Yes! In a database with many objects, identifying views, stored procedures, and functions that point to a non-existent column, table, or another object throws an…
SSDT Add Data via Scripts 13 January 202313 January 2023 SSDT has can execute two types of scripts: Deployment and Build. This post focuses on Deployment scripts that run on the target database before and after deploying or publishing the…
SSDT What about Existing Databases? 8 January 202313 January 2023 Its easy: Import an existing database into a new SSDT project. We'll use AdventureWorks2017, which can be downloaded from Microsoft, or any database where you can read the Data Definition…
SSDT Create Database Objects 6 January 202313 January 2023 Finally! The exciting and useful part of SSDT - creating the objects in the project and publishing them to the database. This short example shows how SSDT shifts developers' focus…
Get Started… Database Project Properties 1 January 20233 January 2023 After creating a database project, we'll want review and edit two Project Properties pages: Project Settings and Debug. These settings will help configure database properties and development environment. Visual Studio…
Get Started… Visual Studio Solution for SSDT 30 December 20223 January 2023 I understand some experienced developers use SSMS and are unfamiliar with SSDT; to keep our focus, we will start with a new, empty solution and add a SQL Server Database…
Get Started… Getting Started 29 December 20223 January 2023 This blog targets an audience with version control, Visual Studio, SQL Server Management Studio (SSMS), and SQL Server development experience. We're going to discuss the database development pertaining to a…
Rogge Heflin 