SQL Server Data Tools (SSDT)

External Article

How to Fix Ten SSDT Deployment Snags, With or Without ReadyRoll

  • Article

Even a database development framework like Sql Server Data Tools (SSDT) doesn't get it right all the time, and there are ten deployment 'gotchas' in particular that can cause some head-scratching amongst developers to get right. From his unique perspective of creating a tool to make such deployments in SSDT less stressful, Dan Nolan discusses each pitfall and how to avoid it, whether you have ReadyRoll or not.

2016-12-20

6,355 reads

External Article

SSIS in SSDT: The Basics

  • Article

SQL Server Integration Services (SSIS) is a fast and reliable way of importing and exporting data, but it can be tricky to learn, initially. Rob Sheldon provides a beginner's guide to get you started with using SSIS with Visual Studio and SQL Server Data Tools (SSDT).

2016-08-11

6,766 reads

External Article

Connected Development with SQL Server Data Tools

  • Article

Although SQL Server Data Tools (SSDT) encourages 'disconnected' database development, it also provides the SQL Server Object Explorer (SSOX) tool in SSDT’s Visual Studio shell to connect to a live development instance or view an SSDT project once all references have been resolved.

2016-02-26

3,520 reads

External Article

SQL Server Data Tools (SSDT) and Database References

  • Article

SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database, but also those to other databases even if they are on other servers. Although it is adds an extra level of complexity to deployments, it can increase the probability that deployments will succeed without errors due to broken references or binding errors. Ed Elliot investigates.

2015-12-24

5,389 reads

External Article

Survey on SSDT and Database Projects

  • Article

Red Gate are developing new tools for users of SSDT and Database Projects in Visual Studio. If you use these technologies, help us make our tools ingeniously simple by completing this 10 minute survey.

2014-10-21

14,721 reads

Blogs

Hyperconverged storage tuning tip for SQL Server

By

We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022

By

Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight

By

This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs

Forums

Can someone explain where non - clustered index is stored?

By yourjobismine

I am learning non-clustered and clustered indexing. When reading this article https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/#:~:text=Clustered%20indexes%20only%20sort%20tables,involve%20any%20extra%20lookup%20step. came across this...

Null value when checking unused indexes

By Bruin

I'm using this query to check if I have any unused indexes.. One of...

Retrieve Password from CyberArk using powershell

By Alone

Hi, I am new to Powershell script and i have to create a power...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers