Tags » SSDT

Big News!! Skipping Stone Design Team Member

Howdy,

Welcome to my blog! If you are blog hopping with Skipping Stone Designs you are in the right spot.

I have been crafting for 20+ years. 133 more words

Scrappin Hard Adventures

Why should I put my databases in source control?

Originally, I looked into database source control as a means of making sure that the database schema would always be available regardless of the catastrophe. I wanted to have a plan for the worst case scenario. 145 more words

CD

SQL Homework - September 2017 - Create a home lab

As I wrote my post about installing the latest version of SSDT I realized that my homework posts missed something important at the start. It’s pointless to ask someone… 195 more words

SQLServerPedia Syndication

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