Entries tagged with sql - Channel 9

Upcoming SQL PASS Summit: SQL

Larry Larsen — Sat, 03 Oct 2009 00:25:00 GMT

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/

Upcoming SQL PASS Summit: Azure

Larry Larsen — Fri, 02 Oct 2009 17:13:00 GMT

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.

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.

Margus Veanes and Pavel Grigorenko - Qex - Symbolic SQL Query Exploration

Peli de Halleux — Tue, 02 Jun 2009 23:59:00 GMT

Margus Veanes and Pavel Grigorenko present a new exciting project: Qex. Pavel did an internship in the Research in Software Engineering team (RiSE) investigating automatic data generation methods for parameterized SQL queries. In this video, he shows the result of his 3-month work. Qex translates SQL queries to logic formulas and give to our in-house constraint solver, Z3. When Z3 finds a solution, Qex translates that solution back to SQL code that can be executed in the database. This is similar to how Pex works.

Find more about Qex at http://research.microsoft.com/qex or read the technical report.

The Research in Software Engineering team (RiSE) coordinates Microsoft's research in Software Engineering in Redmond, USA.

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.

AWS Weatherbug DataCenter Lighting Network

ashishjaiman — Wed, 01 Apr 2009 17:11:00 GMT

WeatherBug, the leading provider of weather information services, manages and operates a proprietary network of over 8,000 WeatherBug Tracking Stations and more than 1,000 cameras that are strategically placed at schools, public safety facilities and television stations throughout the U.S. These professional-grade weather stations generate live neighborhood level reports every second (unlike other weather providers; their data is up to an hour or more old).
In this video Ashish Jaiman talks with Charlie Liu, AWS Weatherbug new lighting network and how they are leveraging Microsoft technologies in their datacenter.

geekSpeak recording - SQL Data Services with James Johnson

Brian Johnson — Fri, 20 Feb 2009 10:46:00 GMT

Microsoft SQL Data Services (SDS) offers highly scalable and Internet-facing distributed database services in the cloud for storing and processing relational queries. In this geekSpeak webcast, James Johnson provides an overview of working with SQL Data Services—what it is, how it works, why you would want to use it, and why it is so cool. James highlights how to get started, shows to interact with the service, and steps through building an application.

The geekSpeak webcast series brings you industry experts in a "talk-radio" format hosted by developer evangelists from Microsoft. These experts share their knowledge and experience about a particular developer technology and are ready to answer your questions in real time during the webcast. Your hosts for this geekSpeak are Lynn Langit and Lindsay Rutter. To ask a question in advance of the live webcast, or for post-show resources, be sure to visit the geekSpeak blog.

Guest Presenter: James Johnson, President, Inland Empire .NET User’s Group

James Johnson is the founder and president of the Inland Empire .NET User's Group. He has a great affinity for all things Web, data, user experience, and building community. James' passion is getting people access to experts, experiences, and technologies they never thought they would have access to or could achieve. James is a frequent blogger at www.duringlunch.com, and he is constantly working on the next big thing.

Introducción a LINQ 2 de 4

Jaime Sanchez — Tue, 25 Nov 2008 20:05:00 GMT

Este es el video 2 de 4 donde Christian Strevel nos da una introducción a LINQ. Conoceremos la evolución del lenguaje y aprenderemos a utilizar LINQ en sus diferentes escenarios como LINQ to SQL, LINQ to XML, LINQ to DataSets y una combinación al final de ambos. Esta es una plática muy amena para poder entender cómo funciona LINQ y el porqué de su creación.

Para más información puedes visitar http://team.intellekt.ws/ y para descargar los demos y presentaciones.

Introducción a LINQ 3 de 4

Jaime Sanchez — Tue, 25 Nov 2008 20:04:00 GMT

Este es el video 3 de 4 donde Christian Strevel nos da una introducción a LINQ. Conoceremos la evolución del lenguaje y aprenderemos a utilizar LINQ en sus diferentes escenarios como LINQ to SQL, LINQ to XML, LINQ to DataSets y una combinación al final de ambos. Esta es una plática muy amena para poder entender cómo funciona LINQ y el porqué de su creación.

Para más información puedes visitar http://team.intellekt.ws/ y para descargar los demos y presentaciones.

Fundamentos de LINQ 4 de 4

Jaime Sanchez — Tue, 25 Nov 2008 20:01:00 GMT

Este es el video 4 de 4 donde Christian Strevel nos da una introducción a LINQ. Conoceremos la evolución del lenguaje y aprenderemos a utilizar LINQ en sus diferentes escenarios como LINQ to SQL, LINQ to XML, LINQ to DataSets y una combinación al final de ambos. Esta es una plática muy amena para poder entender cómo funciona LINQ y el porqué de su creación.

Para más información puedes visitar http://team.intellekt.ws/ y para descargar los demos y presentaciones.

Introducción a LINQ 1 de 4

Jaime Sanchez — Tue, 25 Nov 2008 18:33:00 GMT

Este es el video 1 de 4 donde Christian Strevel nos da una introducción a LINQ. Conoceremos la evolución del lenguaje y aprenderemos a utilizar LINQ en sus diferentes escenarios como LINQ to SQL, LINQ to XML, LINQ to DataSets y una combinación al final de ambos. Esta es una plática muy amena para poder entender cómo funciona LINQ y el porqué de su creación.

Para más información puedes visitar http://team.intellekt.ws/ y para descargar los demos y presentaciones.

geekSpeak recording - ASP.NET Dynamic Data with Rachel Appel

Brian Johnson — Thu, 02 Oct 2008 03:59:00 GMT

In this geekSpeak, Microsoft Most Valuable Professional (MVP) Rachel Appel introduces you to the Microsoft ASP.NET Dynamic Data framework, discusses how it came to be, and shows how ASP.NET Dynamic Data makes it easy to maintain your Web sites. Rachel also covers creating customizations at the application, page, and field levels, so you can get the most out of this exciting technology.

This geekSpeak episode was recorded on October 1, 2008.

Your hosts for this geekSpeak are Glen Gordon and Lindsay Rutter.

To ask a question in advance of live webcasts, or for post-show resources, be sure to visit the geekSpeak blog.