Entries tagged with sql server 2008 - Channel 9

SQL Server Express: Easy to Manage

Zach Skyles Owens — Mon, 21 Sep 2009 18:28:00 GMT

In this screencast Roger Doherty and Zach Skyles Owens quickly run through the SQL Server Management Studio and show some of the basic functionality of managing SQL Server Express databases such as managing security and Policy Based Management.

>> View the rest of the SQL Server Express Series here

SQL Server Express: Overview

Zach Skyles Owens — Mon, 21 Sep 2009 18:25:00 GMT

In this series Roger Doherty and Zach Skyles Owens will be exploring the SQL Server Express product and its role in the Microsoft data platform. Many people don’t realize that:

SQL Server Express is built on the exact same codebase as SQL Server Enterprise
It’s ready to use in production
It includes SQL Server Reporting Services
It supports Spatial
FileStream data does not count towards the 4GB database size limit

We’ll be exploring many of these topics in following videos in this series.

>> View the rest of the SQL Server Express Series here

Christian Kleinerman: Introduction to SQL Server Project Madison

Charles — Tue, 01 Sep 2009 19:21:00 GMT

The SQL Server team is working on a new project code-named “Madison”. "Madison" is a highly scalable data warehouse appliance that delivers performance at low cost through massively parallel processing (MPP). How does it work? What's the story? Well, "Madison" Product Unit Manager Christian Kleinerman sure knows the answers and he provides an introduction to this new SQL data warehousing technology. Tune in.

More info here:

http://blogs.technet.com/dataplatforminsider/archive/2009/08/24/microsoft-ships-the-first-technology-preview-for-project-code-named-madison.aspx

ToolShed Tooltip #20 - SSIS Data Profiling saves your eyeballs

Russell Fustino — Wed, 22 Jul 2009 16:38:00 GMT

Have you ever eyeballed your data to find an abnormality? Talk about an instant headache! See Guest speaker MVP Jessica Moss show developer tools are now integrated in Visual Studio as part of the SQL Server Client tools install...among them SQL Server Integration Services (SSIS) Data Profiling. This is a must see for anyone working with data.

What is it?
SQL Server Integration Services object and application that allows you to interrogate, analyze, and discover information about existing data

Download Site: Included with SQL Server 2008 at http://www.microsoft.com/sqlserver/2008

Example Problem(s) it solves:

Prevent your data warehouse load from failing due to nulls by finding them before the load
Identify new validation rules needed for a customer user interface
Discover inconsistent or inaccurate code mapping values in your transactional system

Installation Notes:
Install SQL Server 2008 Integration Services client tools

Usage Notes:
Must connect to data in SQL Server 2000 or later

This is the seventh of Tool Shed Tooltips released from Episode 3 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

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.

Show: Episode #3 It's All About The Tools TV Show

Russell Fustino — Fri, 26 Jun 2009 16:35:00 GMT

Got popcorn? Expression Blend 3 SketchFlow and a ton of “GOT TO KNOW ABOUT IT” content is all packed in just 1 hour of Episode 3. Try something different tonight and take an hour break from coding. You know you deserve it. Grab your favorite beverage and pizza and enjoy this entertaining, enlightening and educational Episode 3. If not, you can wait for the Tool Shed Tooltips of clips from the show over the next few days and weeks. Either way ... tune in. All content is current along with sneak peeks at future tools. It will feel like you are at a live event, but in the comfort of your home or office.

In this video, you will find tools to help solve these common developer challenges…

Finding a XAML Editor for your web page
Prototyping tool for great design of your web site
Need authentication on the web?
Some of the pages on my web site load really slowly - how do I figure out what's going on?
Have you ever eyeballed every record in your table to find an abnormality?

Tool Shed Theme Song
Introduction
Demo 1 - Expression Blend 2 , video and animation intro
Demo 2 - Expression Blend 3 SketchFlow ProtoTyping
Demo 3 - Live Services - Live ID
Demo 4 - IE 8 Developer Tools
Demo 5 - SSIS Data profiling by Guest Speaker Microsoft MVP, Jessica Moss
Developer Community Update by Microsoft MVP, Don Demsak

You will love our guest speakers, Microsoft MVP Jessica Moss and Don Demsak ... Jessica amazes us on Data profiling and Don does and incredible job with the latest happenings in Developer Community.

Special thanks to co-host Stan Schultes, recent co-author on his book on DotNetNuke 5, Jessica Moss, Don Demsak, Carl Franklin, Pensacola Junior College, Main Campus, and the SQL Saturday Pensacola 2009 Team, especially Karla Remail, the live studio audience, and the many volunteers who made this show a reality!

I have reposted all of the Tool Shed Tooltips and Episode One and Episode Two with Hi Def default views, so the code and PowerPoint slides are crystal clear. Feel free to comment or email Russ Fustino on what tools you use and love and would like to see on future episodes.

Also, please note all of the resources on right of the page at: http://channel9.msdn.com/toolshed including a link to all Episode PowerPoint’s, demo code and demo scripts! Yes, demos scripts, how often do you see that? So if you are a teacher or student or want to do presentations to co-workers, or at seminars, or just use them as labs to learn, check out this resource at http://code.msdn.com/toolshed . Each release corresponds to an Episode.

Here are some of useful links from the speakers we have had on the shows and more:
Russ Fustino: www.russtoolshed.net
Stan Schultes: www.vbnetexpert.com
Joe Healy: www.devfish.net
Brian Johnson: http://bufferoverrun.net
Jeff Barnes: http://blogs.msdn.com/jbarnes/
Don Demsak: http://donxml.com
Jessica Moss: http://www.jessicammoss.com
Sayed Ibrahim Hashimi: http://www.sedodream.com/
Jason Beres:  http://blogs.infragistics.com/blogs/jason_beres/default.aspx

Stan and I are planning on are filming a live studio audience Episode 4 at the Tampa .NET User group  (signed release form required) on Wednesday, July 22, 2009, at the Tampa Microsoft Office at 6:15PM along with guest speaker Microsoft MVP, Bill Reiss. If you are attending, I can use some volunteers, like camera operators, a sound engineer and door control. I'll teach you at the event, everything to run the camera or sound, if you don't have much experience. Drop me an email if interested at rfustino@microsoft.com Stay tuned.

Note: For those of you new to channel9 viewing, many different formats are available for download besides viewing in the default player; everything from Zune to WMV High Quality. Simply locate the dropdown menu below the embedded player on this page for your desired download selection. If the default view stops to buffer often, then I recommend trying to download WMV High Quality. You can clearly see code, all video and PowerPoint’s in High Def (HD) at full screen. It only takes about 15 to 20 minutes to download this episode at average home speed connections. The high def WMV file is a little over 200 Meg.

Remember, you have to know the code to get into the shed. KNOW THE CODE. Get some popcorn and enjoy the show! Russ

SafeNet - Hardware and Software Security Modules

ashishjaiman — Tue, 23 Jun 2009 18:53:00 GMT

SafeNet is a global leader in information security.

SafeNet provides complete security utilizing its encryption technologies to protect communications, intellectual property and digital identities, and offers a full spectrum of products including hardware, software, and chips.

In this video I sit with Bill Becker, Chief Architect, SafeNet and discuss how SafeNet is leveraging Microsoft platform.

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.

This Week C9 at TechEd 2009 with Jeff Hadfield and Greg Duncan

Dan Fernandez — Sat, 16 May 2009 17:35:00 GMT

This week on Channel 9 at TechEd 2009, Brian is joined by Jeff Hadfield andGreg Duncan to discuss this week's developer news, including:

- Keith Elder - Load XSD Schemas automatically in Visual Studio by editing the Catalog.xml file, via Alvin Ashcraft
- SQL Server 2008 Developer Training Kit - includes demos, presentations and hands on labs on T-SQL, Filestream, Date & Time types, spatial data, and Reporting Services
- Code Project - Michael Ceranski's article on Recreating Frogger in Silverlight
- Philipp Sumi - WPF Notify Icon for the system tray
- ADO.NET Team Blog - Entity Framework 4.0 to support persistence ignorance and Plain-Old-CLR-Objects (POCO) and lots of other enhancements
- Silverlight blog - Project Starlight - Adds Multicast capabilities to Silverlight using Windows Media Services
- Luca Bolognese - C# and VB.NET Co-Evolution
- Ars Technica - Emil Protalinski - Office 2010 Technical Preview coming this summer
- Windows 7 to be released by holiday season
- John Robbins: PDB Files - What every developer must know
- Karsten Januszweski - Archivist - A Twitter Data-Mining app
- Michael James - Scrum Master Checklist, via Greg Duncan
- Full list of games and Web sites that use up-up-down-down-left-right-left-right-B-A for secret features, via Clint Rutkas

Picks of the week
Brian's pick of the week: Jason Zander - New Names for Test and Lab Tools - Visual Studio Team Test 2010, Team Test 2010 Essentials and Lab Management 2010
Greg's pick of the week: TFS Branching Guide 2.0
Jeff's pick of the week: Code Project Addin for Visual Studio 2008 to search CodeProject articles directly from Visual Studio

This Week on C9: Charles Torre on camera, C9 turns 5, and lots of freebies

Dan Fernandez — Sat, 11 Apr 2009 02:31:00 GMT

This week on Channel 9, Dan and Brian are joined by special guest Charles Torre! This week we discuss

- Channel 9 turns 5 Years old and Jamie builds some 5-year anniversary wallpapers

- Nic Fillingham’s Flickr photos from the 5-year anniversary cake

- Where Dan, Brian and Charles were five years ago

Developer News
- Download SQL Server 2008 SP1

- Velocity Team - Velocity CTP3 now available(Download)

- Jesse Liberty – VideoWiki Open Silverlight 3 Project

- Jeroen Ritmeijer - Integrating TextGlow (Silverlight Open XML viewer) into Sharepoint

- Yochay Kiriaty – Walkthrough of the Windows 7 Taskbar .NET Sample Library
- Update to free Azure Services Training Kit and Azure Services Management Tools

- Mohammad Khosravi – CodeProject Range Finder app, via Greg Duncan

- Jon Galloway - Troubleshooting an intermittent .NET High CPU problem

- Bill Ramos - SQL Management Studio Tips Part 1 and Part 2

- Adam Kinney – Video demo of Silverlight Spy to Visually Debug Silverlight applications

- SourceGear - DiffMerge available (free)

- RedGate offers Illustrated C# 2008 eBook for free, via Stefano Mapelli

Picks of the week
- Charles's pick of the week: Jonathan Shapiro, creator of EROS and BitC projects, was hired by Microsoft
- Brian’s pick of the week: Correction on features coming in XNA from Michael Klucher

-Dan’s pick of the week: Silverlight-based Future Desktop in Silverlight (blog post, Codeplex project), via Rishi Oberi

SQL Server 2008 達人に聞く- SharePoint Serverの対応について

Zach Skyles Owens — Fri, 26 Dec 2008 18:06:00 GMT

マイクロソフトデベロッパーエバンジェリストの小高です。
SQL Server 2008について達人と呼ばれる人たちにインタビューを行うシリーズ物のビデオです。今回はSharePoint ServerにおけるSQL Server 2008 の対応と開発について、マイクロソフトのデベロッパーエバンジェリストであり、SharePoint Server開発を中心に担当している松崎に話を聞きました。
9分07秒のビデオになります。

SQL Server 2008 達人に聞く- Visual Studio の対応について

Zach Skyles Owens — Fri, 26 Dec 2008 18:04:00 GMT

マイクロソフトデベロッパーエバンジェリストの小高です。
SQL Server2008について達人と呼ばれる人たちにインタビューを行うシリーズ物のビデオです。今回はVisualStudio2008におけるSQL Server 2008 の対応と開発について、マイクロソフトでVisual Studioの製品を担当している近藤に話を聞きました。
4分39秒のビデオです。

SQL Server 2008 達人に聞く- SQL Server Data Services

Zach Skyles Owens — Fri, 26 Dec 2008 17:51:00 GMT

マイクロソフト・デベロッパーエバンジェリストの小高です。
SQL Server2008について達人と呼ばれる人たちにインタビューを行うシリーズ物のビデオです。今回はSQL Server Data ServicesについてマイクロソフトでSQL Serverの製品を担当している太田に話を聞きました。
5分33秒のビデオになります。

SQL Server 2008 達人に聞く- TransactSQLの新機能

Zach Skyles Owens — Fri, 26 Dec 2008 17:45:00 GMT

マイクロソフト・デベロッパーエバンジェリストの小高です。
SQL Server2008について達人と呼ばれる人たちにインタビューを行うシリーズ物のビデオです。今回は新しいTransactSQLについてPASSJ (SQLサーバーユーザーグループ)理事の小川さんにお話を伺いました。
7分26秒のビデオになります。

SQL Server 2008 達人に聞く- Management Studioの新機能

Zach Skyles Owens — Wed, 24 Dec 2008 00:36:00 GMT

マイクロソフトデベロッパーエバンジェリストの小高です。
SQL Server2008について達人と呼ばれる人たちにインタビューを行うシリーズ物のビデオです。今回は新しいManagementStudioについてPASSJ (SQLサーバーユーザーグループ)理事の小川さんにお話を伺いました。
7分22秒のビデオです。

CRM Accelerators: Analytics

Girish Raja — Fri, 12 Dec 2008 01:10:00 GMT

Reuben decided to take control of things on this channel9 video as we discuss about the Analytics accelerator. <Alert> we recorded this video really early in the development cycle for this accelerator. There are far more cool capabilities and reports in the final version of this accelerator than what we see in this video. </Alert>

The analytics accelerator provides a set of Performance Dashboards and Key Performance Indicators (KPIs) for analyzing the data residing within the CRM platform. It utilizes SQL Server Analysis Services (SSAS) for creating OLAP cubes. SSAS is also used here for creating predictive analysis with some fully functional samples. The analytics accelerator will work with SQL Server 2005 with some components enhanced to take advantage of SQL Server 2008.

Check out more Channel9 videos on CRM Accelerators here and please visit http://www.codeplex.com/crmaccelerators to download the accelerators.

Happy coding!

Optimisations moteur - Cesar Galindo-Legaria

Zach Skyles Owens — Tue, 07 Oct 2008 23:14:00 GMT

Travaille sur la création et l'exploitation des tables de requêtes spatiales et de partition. Trois tâches principales : traitement spécial, tables de partition parallèles et exécution des tables et des types de tables spatiales et géographiques.

Spatialデータ型による空間データのサポート

Zach Skyles Owens — Mon, 29 Sep 2008 01:07:00 GMT

マイクロソフト・デベロッパーエバンジェリストの小高と申します。SQL Server2008では、新たに実装されたSpatialデータ型によって、空間データをより便利に実装することが出来るようになっています。このビデオは、その中のGEOGRAPHY、GEOMETRY型を使用してGISアプリケーションなどの活用方法についてデモと合わせてご説明します。
6分39秒のビデオになります。解像度の関係でデモが見えにくい場合がありますので、FullScreenModeにしていただくか、ビデオをダウンロードすることをお勧めします

ADO.NET DataServicesによる開発

Zach Skyles Owens — Mon, 29 Sep 2008 01:07:00 GMT

マイクロソフト・デベロッパーエバンジェリストの小高と申します。VisualStudio2008, .NET Framework3.5 SP1 ではSQL Server2008での開発が本格化されています。このビデオは、その中で実装されたADO.NET DataServicesについてデモと合わせてご説明します。
7分58秒のビデオになります。解像度の関係でデモが見えにくい場合がありますので、FullScreenModeにしていただくか、ビデオをダウンロードすることをお勧めします。

階層型データの使用

Zach Skyles Owens — Mon, 29 Sep 2008 01:06:00 GMT

マイクロソフト・デベロッパーエバンジェリストの小高と申します。SQL Server2008では、新たに実装されたデータタイプであるHierarchyデータ型によって、階層データをより便利に実装することが出来るようになっています。このビデオは、階層構造を持ったデータ(ツリー構造のような形のデータ)をどのようにSQL Server 2008で実装するのかをデモと合わせてご説明します。
7分10秒のビデオになります。解像度の関係でデモが見えにくい場合がありますので、FullScreenModeにしていただくか、ビデオをダウンロードすることをお勧めします。

ADO.NET EntityFrameworkによる開発

Zach Skyles Owens — Mon, 29 Sep 2008 01:06:00 GMT

マイクロソフト・デベロッパーエバンジェリストの小高と申します。VisualStudio2008, .NET Framework3.5 SP1 ではSQL Server2008での開発が本格化されています。このビデオは、その中で実装されたADO.NET EntityFrameworkについてデモと合わせてご説明します。
7分52秒のビデオになります。解像度の関係でデモが見えにくい場合がありますので、FullScreenModeにしていただくか、ビデオをダウンロードすることをお勧めします。

SQL Server 2008 空間資料 2

Zach Skyles Owens — Sun, 28 Sep 2008 18:57:00 GMT

*空間函數
     使用 "." 來存取屬性，或是呼叫執行個體的方法。例如 @g.STArea()、@g.STX
     使用 "::" 來呼叫類別提供的靜態方法。例如：Geometry::STGeomFromText()
     呼叫方法要加括號，屬性則不需要
     方法、屬性名稱要區分大小寫
     STConvexHull、 STIntersection、STDistance…

SQL Server 2008 空間資料 1

Zach Skyles Owens — Sun, 28 Sep 2008 18:56:00 GMT

*Geometry 資料型態、Geography 資料型態
點(Point)、線(Line string)、多邊形(Polygon)、上述類型的集合(MultiPoint、MultiLine、MultiPolygon、GeometryCollection)
*表現資料的格式：
Well-Known Text(WKT)

以 ADO.NET 存取 SQL Server 2008 新增的資料型態 2

Zach Skyles Owens — Sun, 28 Sep 2008 18:54:00 GMT

*撰寫 ADO.NET 程式碼存取
          SqlDbType 完整表列 SQL Server 2008 新的資料型態
*傳遞資料表值參數
          設定參數型別為 System.Data.SqlDbType.Structured
          參數值為 DataTable