Author: paschott
SSDT, Publishing, and Referenced Databases
Had this catch me today in a series of databases that all work together. In order to resolve all of the cross-database dependencies, I’ve added…
SQL Server: Problems with corrupt files or assemblies
Yesterday I found and fixed a bunch of hard drive issues. One of those issues resulted in my “Microsoft.AnalysisServices” assembly for SQL Server 2012 becoming…
SSDT: Tips, Tricks, and Gotchas
I wanted to add a short post to make sure I highlight some things that will trip people up or otherwise cause issues. When…
SSDT: SQL Project Snapshots
SSDT allows for snapshots to be taken of the project at any point. Just right-click the project name and select the option to “Snapshot Project”….
SSDT: Publishing Your Project
Build the project In order to successfully publish your project, it must first be able to build successfully. Start by building your project. Right-click the…
SSDT: Errors and Warnings
SSDT includes an Errors and Warnings window that is well worth your attention. Ideally, your project should have no errors or warnings. However, sometimes…
SSDT: Updating a Project Manually
Sometimes it’s necessary to modify the project manually. The change might require specific tweaking to include just a couple of new lines in a stored…
SSDT: Updating a Project by Importing Scripts
Sometimes your developers will work on new SQL Objects and give you scripts to alter or create objects. SQL Projects support importing those scripts into…
SSDT: Updating by Using Schema Compare
Sometimes changes are made to a shared database that need to be brought into your SQL Project and there are no saved change scripts for…
SSDT: Pre and Post Deploy Scripts
At some point, you will likely need to release changes that contain more than just schema changes. You may need to update data in a…