| |
browse.develop.com
Browse.develop.com is a community that was established to collect and
organize valuable web information. Our technical staff have selected and
indexed information and courses that they feel will help you stay
current on best practices across the SDLC.
|
4 Articles match "SQL Server 2005","Visual Studio"
| Related DevelopMentor Courses | MORE | | Entity Framework – Model First: Generating DDL for Complex Types The complex type consists of 4 ‘fields’: CountryCode, AreaCode, Number and Extension: Each ‘field’ has properties set: The great part is that this is fully supported by the DDL generator, so right click on the Entity Framework Designer in Visual Studio 2010 and choose ‘Generate Database From Model…’ and the ‘Artist’ table will be generated as: -- --. -- Entity Designer DDL Script for SQL Server 2005, 2008, and Azure. -- --. -- --. -- Creating all tables. -- --. -- Creating table 'Artists'. CREATE TABLE [dbo].[Artists] Artists] (. ALTER TABLE [dbo].[Artists]. DevelopMentor Courses - Saturday, July 2, 2011 Essential SQL Server 2012 for Developers Training Find out about innovative programming techniques enabled by SQL Server 2012 and Visual Studio 2010. ?xml:namespace Uncover these SQL secrets and more! xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> T-SQL Sets In this exciting first day, we dig into the complex T-SQL language to discuss best practices for our queries for superior functioning. We study new T-SQL operators which can create powerful performance improvements to our code. Also we'll look at FILETABLES introduced in SQL Server 2012. ? DevelopMentor Courses - Wednesday, February 22, 2012 Essential SQL Server 2012 for Developers Training Find out about innovative programming techniques enabled by SQL Server 2012 and Visual Studio 2010. ?xml:namespace Uncover these SQL secrets and more! xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> T-SQL Sets In this exciting first day, we dig into the complex T-SQL language to discuss best practices for our queries for superior functioning. We study new T-SQL operators which can create powerful performance improvements to our code. Also we'll look at FILETABLES introduced in SQL Server 2012. ? DevelopMentor Courses - Wednesday, February 15, 2012 |
7 Articles match "SQL Server 2005","Visual Studio"
| The Latest from DevelopMentor | MORE | | Entity Framework – Model First: Generating DDL for Complex Types The complex type consists of 4 ‘fields’: CountryCode, AreaCode, Number and Extension: Each ‘field’ has properties set: The great part is that this is fully supported by the DDL generator, so right click on the Entity Framework Designer in Visual Studio 2010 and choose ‘Generate Database From Model…’ and the ‘Artist’ table will be generated as: -- --. -- Entity Designer DDL Script for SQL Server 2005, 2008, and Azure. -- --. -- --. -- Creating all tables. -- --. -- Creating table 'Artists'. CREATE TABLE [dbo].[Artists] Artists] (. ALTER TABLE [dbo].[Artists]. DevelopMentor Courses - Saturday, July 2, 2011 Smarter Tx Promotion with SQL Server 2008 A while ago I blogged on a gotcha to watch out for when using System.Transactions with SQL Server 2005. Basically, if you open a second connection to SQL Server from inside a using block in which you create a new TransactionScope, SQL Server will automatically promote the transaction to a distributed one in which the Distributed Transaction Coordinator (DTC) manages the transaction with the two-phase commit protocol. the connections are pooled).rn. Tony and Zuzana's World - Thursday, July 9, 2009 Smarter Tx Promotion with SQL Server 2008 A while ago I blogged on a gotcha to watch out for when using System.Transactions with SQL Server 2005. Basically, if you open a second connection to SQL Server from inside a using block in which you create a new TransactionScope, SQL Server will automatically promote the transaction to a distributed one in which the Distributed Transaction Coordinator (DTC) manages the transaction with the two-phase commit protocol. the connections are pooled).rn. Tony and Zuzana's World - Thursday, July 9, 2009 | -
| The Best from DevelopMentor | MORE | - Entity Framework – Model First: Generating DDL for Complex Types
The complex type consists of 4 ‘fields’: CountryCode, AreaCode, Number and Extension: Each ‘field’ has properties set: The great part is that this is fully supported by the DDL generator, so right click on the Entity Framework Designer in Visual Studio 2010 and choose ‘Generate Database From Model…’ and the ‘Artist’ table will be generated as: -- --. -- Entity Designer DDL Script for SQL Server 2005, 2008, and Azure. -- --. -- --. -- Creating all tables. -- --. -- Creating table 'Artists'. CREATE TABLE [dbo].[Artists] Artists] (. ALTER TABLE [dbo].[Artists]. DevelopMentor Courses - Saturday, July 2, 2011 - Installing Visual Studio Team Systems
So I spent the better part of a day getting a full Visual Studio Team Systems installation running under VMWare. In order to get it all to work together on a single server, you have to have a bunch of components: Active Directory, SQL Server 2005, SQL Server Reporting Services, SharePoint, Team Foundation Server, Office and finally VSTS itself. started with a prebuilt W2K3 server image that already had IIS setup. then turned it into a domain server by installing Active Directory and then followed all the instructions. - Smarter Tx Promotion with SQL Server 2008
A while ago I blogged on a gotcha to watch out for when using System.Transactions with SQL Server 2005. Basically, if you open a second connection to SQL Server from inside a using block in which you create a new TransactionScope, SQL Server will automatically promote the transaction to a distributed one in which the Distributed Transaction Coordinator (DTC) manages the transaction with the two-phase commit protocol. the connections are pooled).rn. Tony and Zuzana's World - Thursday, July 9, 2009 - Smarter Tx Promotion with SQL Server 2008
A while ago I blogged on a gotcha to watch out for when using System.Transactions with SQL Server 2005. Basically, if you open a second connection to SQL Server from inside a using block in which you create a new TransactionScope, SQL Server will automatically promote the transaction to a distributed one in which the Distributed Transaction Coordinator (DTC) manages the transaction with the two-phase commit protocol. the connections are pooled).rn. Tony and Zuzana's World - Thursday, July 9, 2009 - Back to Basics: Agile Object-Oriented Design
Visual Studio Team System. Closer to the Data: Using Managed Code in the Database with SQL Server 2005. Dave, over at extremeplanner.com , wrote a nice summary of the talk I gave at XPSD. completely agree with him that "a review of these fundamentals [is] refreshing." As you can see, I'm doing my part to spread the word: Upcoming Talk in Orange County. Upcoming Talk in San Diego (Tentative). The Rock & Roll Code Camp (details upcoming). XPSD Object Oriented Design Talk (past presentation). January SoCal Code Camp Talk (past presentation). Kennedy. - Visual Studio 2005 Prof & SQL Server 2005 Dev &. are now available for MSDN subscribers
Visual Studio 2005 Professional & SQL Server 2005 Developers edition. I know, I know. haven't posted much lately and promise to better my ways as of 1st of Nov. For now, the good news is that a number of RTM's have arrived in the subscribers section of MSDN. Ohhhh, the joy. XML from the Coffee Shop - Thursday, October 27, 2005 - Like Phoenix Rising … or New Version of SQLCLRProject
As some of you may know, back in the days I developed a tool for deploying.NET assemblies to SQL Server 2005 (or, as it was called then, Yukon). As time went by, it evolved into a project named SQLCLRProject , consisting of the command line tool ( YukonDeploy ), a stand-alone front-end GUI, DeployProperties , and an add-in (with project and item-templates) for Visual Studio, DeployAddIn. The Visual Studio add-in (and templates) supports both VS 2005 as well as VS 2008. Tags: NET Katmai SQL 2008 SQL Server SQLCLR Niels. Managed Data - Monday, January 14, 2008 %>
| |   |
