Roger Doherty
Check me out on the web at my work blog or my personal blog.
@doherty100
Roger Doherty is a SQL Server Technical Evangelist for Microsoft Developer and Platform Evangelism. Roger joined Microsoft in 1991 from Sybase, Inc. as a SQL Server trainer for Microsoft University. Since then he has filled a variety of roles including pre-sales Systems Engineer for Microsoft Federal in Washington DC, Software Design Engineer for Windows Server, and Technical Evangelist for Microsoft Developer and Platform Evangelism. In his current role Roger focuses on driving adoption of SQL Server with professional developers worldwide. A graduate of Drexel University, Roger is a native Philadelphian and enjoys mountain biking with his family and searching for an edge in games of chance.
| Forum | Thread | Replies | Latest activity |
|---|---|---|---|
| Site Feedback | Hands On Lab: PowerPivot in SQL Server 2008 R2 - Install Issues | 4 | Apr 18, 2012 at 2:51 AM |
Demo 4 - SQL Server Connections Spring 2012 Shawn Bice Keynote
Mar 27, 2012 at 8:48 AMWant more? Check out all the presentations, demos and labs at http://bit.ly/sql2012cookbook.
Demo 3 - SQL Server Connections Spring 2012 Shawn Bice Keynote
Mar 27, 2012 at 8:27 AMYou can see part 4 of this demo in this post.
Want more? Check out all the presentations, demos and labs at http://bit.ly/sql2012cookbook.
Demo 2 - SQL Server Connections Spring 2012 Shawn Bice Keynote
Mar 27, 2012 at 8:00 AMYou can watch part III in this post.
Want more SQL Server 2012 content? Check out all the presentations, demos and labs at http://bit.ly/sql2012cookbook.
Demo 1 - SQL Server Connections Spring 2012 Shawn Bice Keynote
Mar 27, 2012 at 7:54 AMCheck out Part II of the keynote demo here.
Want more? Check out all the great SQL Server 2012 presentations, demos and labs at http://bit.ly/sql2012cookbook.
Presentation: Introducing High Availability and Disaster Recovery with SQL Server 2012 AlwaysOn
Mar 14, 2012 at 6:13 PM@services house:glad you like it!
Demo: A First Look at SQL Server Data Tools
Mar 14, 2012 at 6:10 PM@lsjames:I'd have to dig into your scenario a bit to answer this fully. In general, DAC upgrade will try the most minimally invastive upgrade strategy possible. I'm a bit suprised that it's messing with users, are you using DAC Fx 3.0 (that ships with RTM SQL 2012)?
Demo: A First Look at SQL Server Data Tools
Mar 14, 2012 at 6:07 PM@Borum.NET: thanks for the comments! Here's some answers to your questions:
Q: Is there a managed API (like the SQL SMO) that allows us to include dacpac files in our own installer and subsequently deploy (clean install / upgrade) to on premise SQL Server or SQL Azure?
A: DAC Fx has an API surface, check out http://sqldacexamples.codeplex.com
Q: The scenario I'm thinking of is having a single SQL Server Data Tools project as part of our solution and using TFS builds output dacpac files for SQL Server or SQL Azure (i.e. targetting the two different environments via configuration and then build the dacpacs). Is that possible?
A: Absolutely. Think of .dacpac and .bacpac as a single-file deployment capability for schema (.dacpac) and schema + data (.bacpac).
Demo: Exploring Self-Service Reporting with SQL Server 2012 Power View
Mar 08, 2012 at 7:30 PMCheck out all the related decks, demos and labs at http://bit.ly/sql2012cookbook.
Presentation: Exploring SQL Server 2012 Power View
Mar 08, 2012 at 7:28 PMCheck out all the related decks, demos and labs at http://bit.ly/sql2012cookbook.
Demo: Configuring Data Alerts with SQL Server 2012 Reporting Services
Mar 08, 2012 at 7:25 PMCheck out all the related decks, demos and labs at http://bit.ly/sql2012cookbook.
See more comments…