Define a publish profile for SSDT
Learn about setting up a publish profile so each time the database is deployed from the SSDT Project it uses these settings.
Tools
Valuable SQL Server Tools tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.
Overview of SSDT SQL Project Tutorial
In this tutorial we will examine the steps in creating a SSDT SQL Project.
SSDT SQL project using Visual Studio 2012
In this section we go over creating the initial SSDT SQL project using Visual Studio 2012.
What files are generated from SSDT?
In this section we look at the various files that are generated from the SSDT Project.
Defining Post Deployment Scripts in the SQL Server Data Tools
Maybe I jumped the gun a bit, but I've started using SQL Server Data Tools (SSDT) in Visual Studio 2010. Since then I've become SSDT's biggest fan. The tool is just so much easier to use than the old VS 2010 database projects. But unfortunately, for some
SQL Server Data Tools Connected Database Development
SQL Server Data Tools (SSDT) comes with SQL Server 2012 and is the replacement for Business Intelligence Development Studio (BIDS). In the earlier tip Introduction to SQL Server Data Tools I covered what is referred to as Project-Oriented Offline Databas
Introduction to SQL Server Data Tools
I am starting to work with SQL Server 2012. One of the first things I noticed after installing it is that Business Intelligence Development Studio (BIDS) is no longer included. Instead there is something called SQL Server Data Tools (SSDT). Can you pro
Troubleshooting Windows Remote Desktop Connections
Everyday throughout the course of their work, system administrators, DBAs, developers and IT support personnel remotely log into different servers in their network. The tool that most people use is Remote Desktop Connection, a nifty little application tha
Visual Studio 2010 Overview Tutorial
In this tutorial we will examine the several aspects of creating a Visual Studio 2010 Database Project.
Creating A New Database Project
Learn how to create a new database project in Visual Studio 2010.
Defining Database Properties
In this section we cover the different components of building a database project and the property settings in Visual Studio 2010.
Defining Deployment Properties
Learn about the various deployment properties for a database project in Visual Studio 2010.
Adding Tables To A Database Project
This section covers ow to create and add new tables to a database project in Visual Studio 2010.
Adding Additional Objects To A Database Project
Learn about how to create other database objects such as schemas, stored procedures and more in a database project in Visual Studio 2010.
Working With Pre and Post Deployment Scripts
This section covers scripts that can be part of the database project deployment that get run pre or post depolyment in a database project in Visual Studio 2010.
Setting Build and Deploy Properties
Learn how to check the build and deploy settings in a database project in Visual Studio 2010.
Building and Deploying a Database
This part of the tutorial shows how to acutally deploy a database project from Visual Studio 2010.
Refactoring A Database After Deployment
Learn about the steps to take to make changes and how to roll out these changes when working with a database project in Visual Studio 2010.
Connecting to SQL Server Using SQLCMD Utility
In this tip, we cover how to use SQLCMD to connect to a SQL Server Database with Windows Authentication and SQL Server Authentication.
Using the Services applet to Administer SQL Server Services Remotely
I am a SQL Server Database Administrator responsible for multiple SQL Servers. To perform administrative tasks on these SQL Servers, I login to those servers, using Remote Desktop. In doing so, my desktop is overlapped with the remote Server's desktop. T
Insert Extended Characters into a SQL Server Table Using OSQL and TSQL
The OSQL utility uses ODBC to communicate with SQL Server. The user’s problem is that the ODBC driver he is using to connect to the database is performing translations on the character data in the T-SQL script. Extended characters, which are not in the st
Free Microsoft Tools to Help Setup and Maintain PerfMon for SQL Server
Everyone knows that PerfMon is a great tool to monitor and maintain metrics about SQL Servers. Perfmon offers a great way to collect a baseline then compare it to current statistics when there is a problem in order to find the bottleneck. Everyone agrees
SQL Server Product Selection Checklist
I have seen the recent addition of SQL Server product listings on your web site and see the value in being able to find all of the SQL Server products per category in one place. Going to your web site rather than having to search all over the Internet to
Web Based Database Administration for SQL Server
I am working at an organization where I need to have access to my SQL Servers around the clock. I do not have a company laptop to check into the environment and troubleshoot issues directly so I am looking for alternatives to meet the need. We are on a