SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag visual studio Rss

Search for any content tagged visual studio

   Items 1 to 15 of 15   
 

SQL Server Unit Testing in Visual Studio

Unit test stored procedures in Visual Studio using an existing database or new SQL scripts  Read more...
By David Fundakowski 2017/05/01 | Source: SQLServerCentral.com | Category: unit testing
Rating: |  Discuss |   Briefcase | 1,442 reads

Redgate Data Tools in Visual Studio 2017 Enterprise

Today during the Visual Studio launch event, we announced that we’ve partnered with Redgate to include Redgate Data Tools in Visual Studio 2017. Redgate Data Tools includes three components that extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database development.  Read more...
By Additional Articles 2017/03/09 | Source: SQLServerCentral.com | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 4,672 reads

Stairway to U-SQL Level 7: More Partition Schemes

Following on from our previous introduction to indexes and partition schemes, we review the distribution schemes used by horizontal partitioning.  Read more...
By Mike McQuillan 2016/08/24 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 846 reads

Stairway to U-SQL Level 4: U-SQL and Data Lake Tooling with Visual Studio

A guide to using Visual Studio to create U-SQL projects and scripts.  Read more...
By Mike McQuillan 2016/07/20 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,324 reads

Using IronPython to talk to SQL Server

IronPython is a Python implementation build on .NET. This article shows how you can use IronPython to access SQL Server Management Objects.  Read more...
By Gerald Britton 2016/06/13 | Source: SQLServerCentral.com | Category: ironpython
Rating: |  Discuss |   Briefcase | 1,455 reads

A Complex Database Project in Visual Studio SSDT

One Way to Handle a Very Complex Database Project with Several Databases and Cross References  Read more...
By Hakim Ali 2015/05/19 | Source: SQLServerCentral.com | Category: ssdt
Rating: |  Discuss |   Briefcase | 6,980 reads

How to create a database backup using visual studio

This article describes how to backup a database using a C# Windows Form.   Read more...
By Daniel Calbimonte 2012/03/30 | Source: SQLServerCentral.com | Category: c#
Rating: |  Discuss |   Briefcase | 8,009 reads

Generating SQL Server Test Data with Visual Studio 2010

As a database developer or tester sometimes you need to have production like data in your environment for your development or testing, but you cannot have the production data because of security and privacy issues. So how you can generate test data or replicate similar data as in production for your development or test environment?   Read more...
By Additional Articles 2010/12/31 | Source: MSSQLTips.com | Category: test data
Rating:  Rate this |   Briefcase | 5,780 reads

Manage Database Projects With Visual Studio 2010

This article demonstrates how to manage database projects with Visual Studio 2010.  Read more...
Rating:  Rate this |   Briefcase | 4,176 reads

SQL Schema Comparison with Visual Studio 2010

we normally do development on the development box; then during the build preparation we compare the development database with the QA/UAT/Production database to identify differences and generate schema objects for synchronization or incremental deployment scripts. How we can compare schema objects between databases and generate synchronization or incremental deployment scripts?  Read more...
By Additional Articles 2010/08/27 | Source: MSSQLTips.com | Category: visual studio
Rating:  Rate this |   Briefcase | 4,226 reads

How to Resolve a BIDS 2005 and SQL Server 2008 Compatibility Issue

Caught in between upgrades, new author Mohan Jumar has an interesting article. Using Visual Studio 2005 to save packages in an SSIS 2008 package store.   Read more...
Rating: |  Discuss |   Briefcase | 4,898 reads

SCOME - Part 4: Using Visual Studio To Develop The Report

Part 4 of this series from Drew Salem shows how you build a report in Visual Studio.  Read more...
By Drew Salem 2009/06/29 | Source: SQLServerCentral.com | Category: scome
Rating: |  Discuss |   Briefcase | 7,494 reads

Deploying Databases From Visual Studio Team System Database Edition

With the GDR release, a whole new set of deployment functionality has become available to VSTS: DB.  Read more...
By Grant Fritchey 2009/06/24 | Source: SQLServerCentral.com | Category: visual studio
Rating: |  Discuss |   Briefcase | 5,188 reads

A first look at Visual Studio 2008 Database Edition

Learn about Microsoft Visual Studio Team System 2008 for database professionals, a useful tool for database development with Microsoft SQL Server.  Read more...
By Additional Articles 2009/02/27 | Source: SearchSQLServer | Category: vsts
Rating: (not yet rated)  Rate this |   Briefcase | 4,420 reads

Multi-Environment Deployments Using Team Edition for Database Professionals

In order to support multiple environments, a number of choices, not readily apparent, need to be made. This article outlines one approach that is working.  Read more...
By Grant Fritchey 2008/01/24 | Source: SQLServerCentral.com | Category: dbpro
Rating: |  Discuss |   Briefcase | 3,072 reads
   Items 1 to 15 of 15