SQL

SQL Server 2008 R2 Integration Services includes a powerful data flow engine optimized for ETL processing.  This presentation covers how to build data flow tasks which are a fundamental part of any ETL process. Presenter: Peter Myers, Mentor, Solid Quality Mentors.

The Data-Tier Application Framework (DAC Fx) is a powerful new way to deploy and upgrade database projects for both your on-premise and cloud applications.  Prior releases of DAC Fx only supported side-by-side upgrades.  SQL Server 2012 includes DAC Fx 3.0, which supports the ability to…

This demo introduces the primary development tools used to build Microsoft BI solutions, including Visual Studio / Business Intelligence Development Studio, SQL Server Management Studio.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This demo introduces the concept of control flow in a SQL Server 2008 R2 Integration Services package.  Control flow governs the order and precedence of how tasks are executed.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.

Extending IT to Private and Public Cloud Session Objectives and Takeaways: Steps to Cloud  SQL Server Appliances for Data warehousing, business intelligence, transaction processing, consolidation and private cloud Public cloud and SQL Azure – how it works, what's next and how our current users…

  In this article, I'm going to cover a few ways to harness the power of Visual Studio 2005, SQL Server 2005, and a free foosball table to create the ultimate break room accessory. Kevin Marshall, Clarity Consulting Inc. Kevin's Blog Difficulty: Advanced Time Required: 6-10 hours Cost:…

News: This week in the news for TechNet Edge Show Episode 3 we cover three updated tools from the folks over in the Solutions Accelerators team: Microsoft Deployment Toolkit 2012 Beta 1 Microsoft Security Compliance Manager 2.0 Microsoft Assessment and Planning Toolkit 6.5 Beta Technical Interview:…

Although you might build say, a Sharepoint infrastructure in Windows Azure and leave it deployed as a permanent feature, totally integrated into your enterprise infrastructure, there are a growing number of organisations taking advantage of the temporary nature such infrastructures can have.…

  Arkansas Children’s Hospital Every so often I come across organizations and people that truly blow me away. Pediatric hospitals have always been known for innovative ideas in the care of their young patients. So, it comes as no surprise that a pediatric hospital would rise to the occasion to…

Nope, it stands for structured actually.  But if you are a bit afraid of SQL, MSDev.com has 20 how-to videos about SQL Server 2008 Express!  This series of short how-to-videos will touch on SQL Server Express 2008 features such as: how to backup a SQL Express database, how to backup a…