Develop SQL Server Databases with Visual Studio SSDT

I’ve been using Visual Studio with SQL Server Data Tools (SSDT) to develop and maintain SQL Server databases since 2008 for top companies in oil & gas, healthcare, and defense industries. I’ll be sharing how SSDT’s power and convenience helps develop databases.

Why use Visual Studio SSDT?

1) Speeds development. 2) Reduces coding errors. Visual Studio with SQL Server Data Tools (SSDT) transforms the SQL Server Database development process from single-object creation and editing to solution-based database development, maintenance, and deployment. Solutions based paradigm brings the same features and tools available with object oriented languages: version control,…Continue reading “Why use Visual Studio SSDT?”

13 January 202313 January 2023

Add Data via Scripts

SSDT has can execute two types of scripts: Deployment and Build. This post focuses on Deployment scripts that run on…

30 December 20223 January 2023

Visual Studio Solution for SSDT

I understand some experienced developers use SSMS and are unfamiliar with SSDT; to keep our focus, we will start with…

29 December 20223 January 2023

Getting Started

This blog targets an audience with version control, Visual Studio, SQL Server Management Studio (SSMS), and SQL Server development experience.…

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

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…

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…

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

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…

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…

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…