Entries tagged with sql 2008 - Channel 9

Media Business Intelligence - Decentrix and BIAnalytix - Part 2

Kirk Evans — Tue, 14 Jul 2009 19:52:00 GMT

In this episode, host Kirk Evans talks with Dr. Michael Ludwich, VP of Consulting at Decentrix, where Dr. Ludwich provides a demonstration of the BIAnalytix solution. This quite an interesting demonstration, helping to show the value of BI in a media organization.

In Part 1 of this interview, we talked with Wayne Ruting, CEO of Decentrix, about the importance of business intelligence in a Media & Entertainment company. Decentrix has quite a client roster, including some of the largest broadcasters, cable operators, and telcos in the US. We talk about why BI matters, how BI is not simply providing reports in a transactional application, and we learn more about Decentrix and their BIAnalytix offering.
In part 2 of this interview, we will see a demo of BIAnalytix.

Media Business Intelligence - Decentrix and BIAnalytix - Part 1

Kirk Evans — Mon, 13 Jul 2009 16:18:00 GMT

In this episode, Kirk Evans talks with Wayne Ruting, CEO of Decentrix, about the importance of business intelligence in a Media & Entertainment company. Decentrix has quite a client roster, including some of the largest broadcasters, cable operators, and telcos in the US. We talk about why BI matters, how BI is not simply providing reports in a transactional application, and we learn more about Decentrix and their BIAnalytix offering. I learned a lot during this interview about the importance of BI in M&E, and Wayne is a very interesting guy to listen to.

In part 2 of this interview, we will see a demo of BIAnalytix.

Strategy Companion- BI tools for SQL Server

Suresh Sreedharan — Mon, 22 Jun 2009 15:19:00 GMT

Suresh Sreedharan ISV Architect Evangelist sits down with Bob Abernethy, SVP & GM at Strategy Companion to talk about their BI offering.

Toolshed Tooltip #10 - SQL Reporting Services from Episode 2

Russell Fustino — Sun, 21 Jun 2009 20:05:00 GMT

Do you have another, yet another, reporting assignment? Is an output requirement PDF format, or Excel, or Word? Do you need built-in printer functions like print preview? See the answers and much more in the Tool Shed Tooltip clip.

What is it?
Microsoft SQL Server 2008 Reporting Services (SSRS) provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your reporting functionality.

Download Site: http://www.microsoft.com/sqlserver/2008/en/us/default.aspx

Example Problem(s) it solves:
Reporting Services includes a complete set of tools for you to create, manage, and deliver reports
APIs that enable developers to integrate or extend data and report processing in custom applications.
Reporting Services tools work within the Microsoft Visual Studio environment

Installation Notes: VS integration is installed with SQL Server Client Tools

Usage Notes: 180 day trial available

This is the third of Tool Shed Tooltips released from Epsode 2 of the TV Show Russ Tool Shed presents... "It's All About The Tools" hosted by Russ Fustino and Co-Host Stan Schultes. Download code, ppt and demo script from http://code.msdn.com/toolshed for all episodes. Also, use the links on http://channel9.msdn.com/toolshed to download tools. Finally, check out some more great videos on the Developer Evangelist East site: http://channel9.msdn.com/dpeeast

Toolshed Tooltip #9 - VSTS DB Pro from Episode 2

Russell Fustino — Sat, 20 Jun 2009 17:21:00 GMT

Did you ever wonder how to maintain the truth of your data while updating schema definitions on a production database? How about wondering what will be impact by a rename of something in your database? How do I easily generate Test Data? DB Pros have had many headaches over answering these DB Developer and DBA concerns. Watch this Tool Shed Tooltip to learn the anwers and more with Visual Studio Team System DB Professional Edition (VSTS DB Pro).

What is it?
Incorporate the database professionals into the software life cycle and provide them with a foundation for change management and process integration.

Download Site: http://msdn.microsoft.com/teamsystem

Example Problem(s) it solves:
Refactor item name changes
Create test data
Create unit tests
Isolated environment – keeps the truth in your data

Installation Notes: Install 2008 SQL Database edition.
Uninstall the DB power tools if they’re installed on your machine.
Install VS 2008 SP1.
Install the DB edition GDR.

Usage Notes: trial available, with VSTS Developer SKU you now get DBPro for free.

This is the second of Tool Shed Tooltips released from Epsode 2 of the TV Show Russ Tool Shed presents... "It's All About The Tools" hosted by Russ Fustino and Co-Host Stan Schultes. Download code, ppt and demo script from http://code.msdn.com/toolshed for all episodes. Also, use the links on http://channel9.msdn.com/toolshed to download tools. Finally, check out some more great videos on the Developer Evangelist East site: http://channel9.msdn.com/dpeeast

Tool Shed Tooltip #2: Live Services, Virtual Earth, SQL 2008 Geospatial, from Episode 1

Russell Fustino — Sun, 14 Jun 2009 01:40:00 GMT

Learn about Live Services and see how to hook up Virtual Earth to the new SQL 2008 Geospatial support.

What is it?
Windows Live Web Services enable developers, designers, and enthusiasts to quickly create compelling web and desktop applications.

Download Site: http://dev.live.com

Example Problem(s) it solves:
Add Search, Mapping, and rich media (Silverlight) to your apps and websites.
Integrate blog, photo and contact management into your apps.

Installation Notes: Live Services are a set of web services, SDKs, samples and documentation that help you get up and running quickly.

Usage Notes: requires Live ID authentication.

This clip is Russ' Tool Shed Tooltip #2, the second of the clips from Episode One of the TV Show, Russ' Tool Shed presents... It's All About The Tools hosted by Russ Fustino and Co-Host Stan Schultes. Download code, ppt and demo script from http://code.msdn.com/toolshed for all episodes. Also, use the links on http://channel9.msdn.com/toolshed to download tools. Finally, check out some more great videos on the Developer Evangelist East site: http://channel9.msdn.com/dpeeast

MSDN TV - Spara pengar genom att migrera till SQL Server, del 2

Johan Lindfors — Tue, 09 Jun 2009 09:15:00 GMT

SSMA- SQL Server Migration Assistant. Hur använder man den?

Lyssna till Dmitry Balin, DBBest, som utvecklat verktyget SSMA dela med sig av sina erfarenheter. Dmitry är en av de främsta i världen när det gäller migrering från Oracle, Sybase och IBM DB2 till SQL Server och hans företag har genomför ett stort antal riktit stora migreringsprojekt

Det här är andra delen av två, och Dmitry pratar engelska!

MSDN TV - Spara pengar genom att migrera till SQL Server, del 1

Johan Lindfors — Tue, 09 Jun 2009 09:15:00 GMT

SSMA- SQL Server Migration Assistant. Hur använder man den?

Northeast Roadshow - Top Things Developers Should Know About SQL Server - Execution Plans

Brian Johnson — Sat, 23 May 2009 16:08:00 GMT

Jim O’Neil, Developer Evangelist, closes out his five part series covering topics on SQL Server for developers with an overview of execution plan generation. Using SQL Server Management Studio it’s easy (and fun) to watch how queries are optimized and thereby get a better insight into application performance. The session covers how to read a query plan and offer some general guidelines on what characterizes an efficient query versus an inefficient one.

Northeast Roadshow - Top Things Developers Should Know About SQL Server - SQL Server Profiler

Brian Johnson — Thu, 14 May 2009 22:17:00 GMT

SQL Server Profiler is a tool every developer should have in their repertoire. With the use of frameworks and abstractions, we often lose sight of what is actually hitting the database, and there’s no better way to get that information than SQL Server Profiler. It has a few knobs and dials that we’ll cover here, and we’ll look at a sample scenario to ‘debug’ a faulty Entity Framework expression.

Northeast Roadshow - Top things developers should know about SQL Server - Error Handling

Brian Johnson — Tue, 12 May 2009 13:54:00 GMT

Jim O’Neil, Developer Evangelist, continues his five-part series on what developers should know about SQL Server. In this third segment, he takes a look at the components of a SQL Server error as well as some of their nuances and suggests techniques for handling errors on both the server-side in Transact-SQL and on the client-side in .NET code.

The complete slide deck for the series is available at Code Gallery.

Northeast Roadshow - Top things developers should know about SQL Server - Understanding SQL Injection

Brian Johnson — Sat, 09 May 2009 15:12:00 GMT

In this second of a series on what developers should know about SQL Server, Jim takes a brief look at SQL Injection attacks, how they occur and what types of things you can do (as well as things you shouldn’t do!) to eliminate your susceptibility to them. Also mentioned are a number of third-party applications and tools available to help with assessing the vulnerability of your site to SQL Injection and other attacks.

The complete slide deck for the series is available at Code Gallery.

Northeast Roadshow - Top things developers should know about SQL Server – Leveraging the SQL CLR

Brian Johnson — Fri, 01 May 2009 11:45:00 GMT

It’s rare that a developer doesn’t need some familiarity with the database his or her applications are targeting, so this session (divided in to five parts) provides a bit of insight into features of SQL Server 2008 (and 2005) that they should be aware of when building .NET applications. The series is a “top 5” countdown, and in this first segment, we talk about how to leverage the .NET CLR inside of SQL Server, including an introduction to the new data types in SQL Server 2008 (hierarchyid, geometry, and geography).

Complete slides and a SQL demo script are available at Code Gallery.

ARCast.TV - Luke Chung on Access Db and Migration Challenges

Bob Familiar — Mon, 02 Mar 2009 22:46:00 GMT

In this interview, Luke Chung, founder and president of FMS, shares his view on Microsoft Access database solutions -- where they fit well, what challenges users and developers often face in creating and maintaining them, and how they have evolved from standalone desktop solutions to having the capability to be integrated with web-based and SharePoint centric solutions. He further explains primary reasons why some Access database solutions are migrated to SQL Server database based solutions, what different approaches are used to carry out migrations, and how to get started with the migration process when a large number of Access databases are involved.

You can get more info here.

This Week on C9: New Live Search features, freebies, why TDD fails and Duke Nukem

Dan Fernandez — Sat, 27 Sep 2008 00:53:00 GMT

This Week on Channel 9, Dan and Christian "LittleGuru" Liensberger go through this week's news including:

- Powerset features now in Windows Live, via Channel 10.
- Four new Application Lifecycle Management (ALM) videos on Visual Studio 2008.
- Mike Snow: How to add snow effects in Silverlight (live demo), via Alvin Ashcraft.
- Roy Osherove: Why Test Driven Development fails
- Andy Dunn: API changes from XNA 2.0 to XNA 3.0
- Popfly adds tracking ripped projects.
- Resource Guide to Free Microsoft Software and Online Services
- Updated version of Snippet Editor/Designer now available on Codeplex
- Take the .NET Framework deployment and redist survey to give feedback to the team.
- Steve Sinofsky, Scott Guthrie and David Treadwell to keynote at Professional Developer's Conference.
- Larry Osterman and Raymond Chen to give Windows sessions at PDC
- Video clip of Lisa Olson on how to write a killer resume .
- Christian's pick of the week: Xbox Live Arcade adds Duke Nukem 3D including multiplayer and co-op modes.
- Dan's pick of the week: TweetSQL that adds CLR stored procedures that enable your database to automagically send tweets to Twitter, via Greg Duncan

TSQL Merge Statement - SQL Server 2008

ashishjaiman — Mon, 30 Jun 2008 21:07:00 GMT

In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement.

The MERGE statement allows you to join a data source with a target table or view, and then perform multiple actions against the target object based on the results of that join.