Archives for posts with tag: SQL

This week on Channel 9, Brian and Dan discuss the week’s top developer news, including:

Picks of the week:

To win a copy of Brian’s book:
To win an autographed copy of Brian’s book, be the first person to post a comment with the right answer to this question:

  • What was the original code name for the application lifecycle management capabilities which shipped in Visual Studio 2010?

 

 

Update: We have a winner! Mohammad Jalloul correctly guessed “Rosario.” Read more about the selection of this code name here.

Join Ryan and Steve this week as they cover the Microsoft cloud.  You can follow and interact with the show at @cloudcovershow

In this episode:

  • Learn how to host other web servers in Worker Roles.
  • Hear about some new tools for working with SQL Azure.
  • Find out how to calculate the size of your database and objects in SQL Azure.

Show Links:

CloudHarmony Cloud Storage Shootout
LinqPad for SQL Azure
SQL Azure ASP.NET Provider Scripts
Incarnate Avatar Service
Using Other Web Servers on Windows Azure
Calculating the Size of Your SQL Azure Database

Watch Zach Owns in this introductory video about how a free upgrade to SQL Server Express will give your data, and your business, room to grow.  Whether you manage your company’s database, build applications for it, or both, the features and benefits of Microsoft SQL Server Express will take the pains out of growing. And unlike other free database software, there are absolutely no hidden or future costs.

Learn more at www.migrateyourdata.com

Dave Campbell is a Technical Fellow at Microsoft and long time database architect. Today, Dave works on the hardest problems facing SQL’s foray into the new world of cloud computing. His latest project in this space takes the form of SQL Azure. What is SQL Azure? What’s the different with the cloud and what we already experience with SQL server running in a clustered environment and reachable via the Internet? How does this focus on cloud computing and impact the evolution of database design? What’s going here? What’s next? Erik Meijer, de facto E2E host and language designer, interviews Dave to ge answers to some of these questions. Erik works for Dave, by the way, and as you can see that doesn’t stop Erik from asking more than softball questions.

Dave will be presenting at PDC09 in the Technical Leaders track. His talk will focus on ambient data and what this means for the evolution of ways to understand and shape the data this all around us using software. You should attend his session and come with questions if you are going to be at PDC. If you’re not going to be there, then make sure to ask Dave questions when he appears on Channel 9 Live!

Enjoy!

DBAs and developers alike find it hard to effectively develop, deploy and manage a data-tier application throughout its lifecycle. SQL Server developers today want to create a data-tier application they can test, declaratively deploy across multiple instances while the system deals with version upgrades. SQL Server DBAs on the other hand want to know deployment requirements a priori and they too want the system to perform some of the mechanical upgrade operations instead of managing data-tier applications via a bunch of scripts. In this video we will dive into Microsoft’s investments in the SQL Server data-tier application space and demonstrate the concepts and tools that simplify development and deployment of data-tier applications using Visual Studio 2010 and SQL Server Management Studio in SQL Server 2008 R2.

 

NOTE: Visual Studio 2010 Beta2 currently supports deploying Data-tier applications only to SQL Server 2008 R2. Please download and install the upcoming CTP3 of SQL Server 2008 R2 in order to use Data-tier Application Projects in Visual Studio 2010 Beta2.

As part of our lead-up to PDC09, I am joined today by Omri Bahat who is going to share with us some of the aspects of SQL Server 2008 R2 which will provide a more efficient way to develop, deploy, and manage applications which rely on an integrated data tier.

The session itself will be presented at PDC09 by Sanjay Nagamangalam and S Murali.

You can find more details about this session here:

This week on Channel 9, Dan is joined by Christian “Littleguru” Liensberger to discuss the week’s top developer news, including:

- SQL Team – SQL Azure Feature Complete, now supports bulkcopy
- Sarah Perez – Integrate Twitter into PowerPoint, via Scott Hanselman
- Systernals utility - Disk2VHD – Create a virtual hard drive from a physical hard drive, via Greg Duncan
- Virtual PC Guy - Virtual PC + XP mode RTM on MSDN/Technet
- Ayende Rahein – Choosing between Active Record, Fluent NHibernate, and XML mapping files, via Alvin Ashcraft
- Eric Lippert – The difference between“as” and “cast” operators
- Kirk Evans - Eric Schupps on TDD in SharePoint
- Jeff Brand – 5-part video series on Peer-to-Peer programming
- Rudi Grobler – Create your own IDE, with colorization, in 10 minutes using AvalonEdit
- Shivprasad Koirala – CodeProject – Multipart .NET 4.0 FAQ, part 1 is the DLR
- Wade Wegner – Video – How to run ASP.NET MVC applications in Windows Azure

Picks of the week
- Christian’s pick: Sony Vaio Windows 7 Notebook
- Dan’s pick: Family Guy meets Windows 7

This week on Channel 9, Dan and Brian reunite to go through the week’s top developer news including:

- The Visual Studio Documentary – Learn the history of Visual Studio, including Alan Cooper Scott Guthrie, Jason Zander, Anders Hejlsberg, Soma Somasegar, and many more
- Phil Haack – Details on the just released ASP.NET MVC 2 Preview 2
- Channel 9 Lectures: Erik Meijer teaches Functional Programming, including a 20% discount on Programming in Haskell
But Why Series – Get answers to questions on design decisions, branding, and other Microsoft lore
- C# FAQ - Using the ExpandoObject with Dynamic C#
- Why you should never prank Clint Rutkas (photo, video)
- Jaime Rodriguez – Q&A from the Microsoft internal WPF discussion alias
Four free chapters on Visual Web Developer Express 2008
- CodeProject – Convert Podcast RSS to Playlists
- James Senior - Seadragon Ajax Control Quick Start video
- Coding4Fun – Rick Barraza’s tutorials on fluids and edge detection in Silverlight
- SQL Server 2008 Express How-To Videos
- CodePlex - SQL Azure Explorer project gives you great built-in tools for Visual Studio to visually explore your SQL Azure databases

Picks of the week:
- SharePoint blog – SharePoint.com using Aptimize, improves performance by up to 50%
- Charlie Calvert walks through using the XNA Role Playing Starter Kit

Join thousands of SQL Server & BI professionals at the Washington State Convention & Trade Center in Seattle from Nov. 2-5 for the largest SQL Server conference in the world! PASS Summit offers 168 technical sessions presented by SQL Server experts, one-on-one time with Microsoft’s SQL Server engineering team, free troubleshooting & design architecture guidance from Microsoft consultants, keynotes from Microsoft’s senior executives and much more!

 
Senior Data Platform Technology Specialist Buck Woody stopped by the Channel 9 studio to talk to Julie Strauss, Program Manager in SQL Server Engineering Team, and Herain Oberio, Group Product Manager, about upcoming sessions you won’t want to miss this year’s PASS Summit conference.

Register today at http://summit2009.sqlpass.org/

Join thousands of SQL Server & BI professionals at the Washington State Convention & Trade Center in Seattle from Nov. 2-5 for the largest SQL Server conference in the world!  PASS Summit offers 168 technical sessions presented by SQL Server experts, one-on-one time with Microsoft’s SQL Server engineering team, free troubleshooting & design architecture guidance from Microsoft consultants, keynotes from Microsoft’s senior executives and much more!

 

Senior Data Platform Technology Specialist Buck Woody stopped by the Channel 9 studio to talk to Michael Rys, Principal Program Manager in SQL Server Engineering Team (Azure), and Liam Cavanagh, Senior Program Manager, about upcoming sessions you won’t want to miss this year’s PASS Summit conference.

 

Register today at http://summit2009.sqlpass.org/