Tags » SSDT

Embrace DevOps as a Database Administrator

I have been writing posts related to embracing new trends like Cloud/NoSQL/Business analytics etc. Currently, I have been speaking about DevOps and containers in various events and this will be a great learning to share. 751 more words

SQL DB Engine

ETL with Microsoft SSIS

ETL represent three different processes on database those are Extract, Transform and Load. Main purpose ETL is to pull data from one database source and push it to the other. 229 more words


Using the Analysis Services Execute DDL Task

My grandfather used to say, “There’s more than one way to skin a cat.”  I always thought it was a disgusting saying, I mean who would ever want to “skin a cat”?!  917 more words

SQL Server

SSDT #001 is a wrap!

We did it! Number one is done! Now it’s time for us to take our first #2 and drop this podcast on you. We started with a little about why we decided to do this, touched on legal weed and it’s ramifications on fatherhood, and why we each choose to use pot. 92 more words

SSDT Podcasts

Compare SQL Database Schema and deploy changes using Visual Studio

Many a times, you would need to identify the difference in database schema for two SQL databases so that you can take certain course of action. 793 more words


Continuous Integration and Deployment for SQL Database using SSDT and VSTS

The combination of technical and cultural processes behind databases makes automation difficult. Databases has a state associated with them, so you cannot blow them away like application code and create again from scratch without losing the data. 1,117 more words


SSISDB Database Reference in SSDT

I was recently writing some stored procedures in the SSISDB to monitor some integration services package failures etc., and as we know this database is what is automatically created when we create an Integration Services Catalog in SQL Server Management Studio. 368 more words