Tags » SSDT

SSDT

Great video providing context, overview and demo of SSDT.  Taken from Microsoft Ignite New Zealand 2015:

“SSDT for Visual Studio: Bet you can’t tell what your database looked like 6 months ago” by Hannah Gray. 39 more words

Introduction

Download SQL Server Data Tools (SSDT) 17.1 for Visual Studio 2015 (SQL Server Integration Services - SSIS - project template)

Possibly save 1 hour of your time: This is a quick reference guide for getting the SSIS project template within Visual Studio 2015.

Download link here  102 more words

SSIS

SSRS Expressions: Format Dates & Numbers

Aim: To format dates & numbers embedded in text strings in SQL Server Reporting Services.

To embed formatted dates in text strings, set the expression for the text string to: 110 more words

SSDT

How to ignore security settings in SQL Server Database Project (SSDT)

In SSDT project, you could create everything you want and keep them identical with target database. However, security might be an exception, few reason you might want to manage security out side of SSDT project: 192 more words

Rename objects in SSDT

Aim: Rename objects in SQL Server Data Tools (SSDT) without breaking dependencies.

You can rename SSDT objects in their definition (.sql) files however this does not update the name of the object throughout the project. 203 more words

SSDT

SQL Server - Issues I Have With SSDT Based Deployments: Part 4.2

Continuing the section on trying to get a large legacy database imported into an SSDT project that actually builds, we’re at a point now where we should have genuine reference issues to clean up; all our cross database references should be sorted via a database reference to a DACPAC (with or without changing everything to use SQLCMD variables or not). 487 more words

SQL Server

Creating Your First SSIS Project

What is SSIS?  It stands for SQL Server Integration Services which may be used for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing.  1,143 more words

Hints And Tips