Deborah's Developer MindScape






         Tips and Techniques for Web and .NET developers.

Archive for July, 2013

July 31, 2013

Publishing a Database Project

Visual Studio 2012 introduced a new SQL Server Database Project. This post first covers what happens when you publish a Database Project. It then details how to publish your Database Project. See this link for an introduction to the Visual Studio 2012 SQL Server Database Project. What Does Publish Do? When publishing a Database Project, […]

DAC and DACPAC

When you work with a SQL Server Database Project in Visual Studio 2012, two terms you will come across are "Data-tier application" or DAC, and "Data-tier application package" or DACPAC. Data-tier application (DAC) A data-tier application defines the database schema and associated database objects that are required to support an application. When you create a […]

July 30, 2013

My First Online Course Went Live Today!

Filed under: C#,VB.NET,Visual Studio @ 6:37 pm

I am happy to announce that my first Pluralsight course: "Mastering Visual Studio 2012" went live today. Check it out and let me know what you think! http://blog.pluralsight.com/2013/07/30/new-course-mastering-visual-studio-2012/ If you don’t have a membership, you can get a free trial. Enjoy!

Creating a Table Script in a Database Project

Visual Studio 2012 introduced a new SQL Server Database Project. This post details how to create a new table script in your Database Project. See this link for an introduction to the Visual Studio 2012 SQL Server Database Project. To create a new table in a SQL Server Database Project: 1) In Solution Explorer, drill […]

SQL Server Database Projects

Visual Studio 2012 introduced yet another new database project. This new database project not only manages your scripts, it also provides GREAT features for deploying your database changes. In my prior posts on the SQL Server Data Tools (SSDT), I focused on the SQL Server Object Explorer. The SQL Server Object Explorer allows you to […]

Creating a Database Project From a Database

Visual Studio 2012 introduced a new database project. This post details how to create one of these new database projects from an existing database. See this link for an introduction to the SQL Server Database Project. To create a new database project, you could use Solution Explorer. Right-click on the solution in Solution Explorer, select […]

July 29, 2013

Executing a Stored Procedure With Parameters using SSDT

As detailed in this prior post, you can execute SQL Server stored procedures using the SQL Server Object Explorer that is part of the SQL Server Data Tools (SSDT). But in that example, the stored procedure had no parameters. This post goes one step further to show how to call stored procedures with parameters. See […]

Executing Stored Procedures with SSDT

As part of your development or debugging process, you may need to execute a stored procedure from your development database. That’s easy to do using the SQL Server Object Explorer that is part of the SQL Server Data Tools (SSDT) in Visual Studio 2012. See this link for an introduction to SQL Server Object Explorer. […]

Entering Data with SSDT

When developing an application, it is often useful to have test data in the tables of your development database. You can then try out your stored procedures or write automated code tests using your sample data. With the SQL Server Object Explorer that is part of the SQL Server Data Tools (SSDT) in Visual Studio […]

Adding Stored Procedures with SSDT

The SQL Server Object Explorer in Visual Studio 2012 is part of the SQL Server Data Tools (SSDT). You can use the SQL Server Object Explorer to design your database, tables, stored procedures, and other SQL Server objects. This post focuses on creating a stored procedure See this link for an introduction to SQL Server […]

Next Page »

© 2014 Deborah's Developer MindScape   Provided by WPMU DEV -The WordPress Experts   Hosted by Microsoft MVPs