December 21, 2008
24 Hours of SQL Server 2008 presented by Microsoft Experts
Overview: Join this series as we look at Microsoft SQL Server 2008 as a productive data platform. Throughout this series, we use Contoso (Container Overseas Shipping Operation) LTD as our scenario customer while we explore the features that make SQL Server 2008 this platform. Contoso is a shipping company; they arrange the shipping of all kinds of items around the globe, from small individual items to large manufactured items. Contoso has seen growth in its business over the past years, especially in the movement of goods from China around the world. While Contoso is happy with their in-house applications and believe they provide significant business advantage over competitors, Contoso wants to ensure that these applications are running on the best productive platform to maintain this advantage, especially as their business grows worldwide.
Presenter: Ron Cundiff, MSDN Developer Evangelist, Microsoft Corporation
Ron Cundiff has worked in the IT industry for more than 10 years, most recently as a developer evangelist for Microsoft. He is an MSDN developer evangelist whose certifications include MCSD, MCSE, MCDBA, MCP+I, and MCP+SB. Before he joined Microsoft in 2002, Ron worked for an independent software vendor (ISV).
Presenter: Bryan Von Axelson, Partner Solutions Advisor, Microsoft Corporation
Maybe he lived in Kansas for too long, but Bryan Von Axelson (who now resides in Pennsylvania) compares IT professionals to the Wizard of Oz, working behind the curtain to keep everything running smoothly. In addition to his Microsoft credentials and certifications, Bryan has been a national speaker for the tax software industry and participated in several business and computer radio shows. In 2007, he presented a one-hour Microsoft SQL Server webcast that reached more than 800 people a week for 10 consecutive weeks. Bryan brings infectious enthusiasm, excitement, and most importantly, hands-on knowledge to his TechNet presentations.
Presenter: John Pelak, ISV Architect Evangelist, Microsoft Corporation
John Pelak is an Independent Software Vendor (ISV) architect evangelist with the Microsoft United States ISV Team, and is responsible for growing partner satisfaction and accelerating Microsoft platform adoption within the ISV partner community. John has held various technical roles since joining Microsoft in 1995. He has an extensive background in development and server technologies, and has architected and developed many large-scale, high-performance solutions for Microsoft customers and partners.Prior to Microsoft, John worked for AT&T and as an independent software developer for telecommunication and pharmaceutical companies. He holds degrees in electrical engineering and computer science, and is pursuing independent study in biotechnology.
Presenter: Chris Avis, IT Pro Evangelist, Microsoft Corporation
Chris Avis began his career at Microsoft in 1994 working on Microsoft Windows NT networking and later moving to the Microsoft BackOffice Server and Windows Small Business Server support team. Chris is an enthusiastic TechNet presenter who enjoys it when audience members realize, "I did not know I could do that!" If you are lucky enough to see Chris in action, prepare to be entertained. As a Microsoft Certified Trainer, Chris shares his broad knowledge of the installation, networking configuration, and management of Microsoft products while doing his best to make your introduction to new technologies fast-paced and engaging.
Presenter: Mike Benkovich, Developer Evangelist, Microsoft Corporation
Mike Benkovich is a database technology specialist and an MSDN developer evangelist based in Minneapolis, Minnesota. Focusing on the effective use of relational technologies for scalable, high-performance, and mission-critical applications, Mike has worked as an architect, project manager, developer, and technical writer. He speaks regularly at technical conferences and corporations.
Presenter: John Weston, IT Pro Evangelist, Microsoft Corporation
Some may call John Weston a geek, but he prefers the term "technologist." Before joining Microsoft, John spent six years as a Microsoft Certified Trainer (MCT), helping people learn new technologies at a local college and bringing newly hired Microsoft employees up to speed. Though he is an MCSE, MCDBA, MCT, and Cisco Certified Network Associate, John gets the most enjoyment from teaching customers how to take advantage of the powerful capabilities of Microsoft SQL Server. When he is not working, John can usually be found sailing around Texas with his kids.
Presenter: Donald Farmer, Principal Program Manager, Microsoft Corporation and Lynn Langit, Developer Evangelist, Microsoft Corporation
Donald Farmer has worked in the Microsoft Business Intelligence team since 2001. He has worked on both the Microsoft SQL Server Analysis Services and Integration Services product teams. Donald is now a principal program manager for SQL Server Analysis Services, working to build a seamless integration of predictive and exploratory analytics with the Microsoft business intelligence offering. Donald is a popular speaker at international events for both business and technical audiences on a wide range of topics, such as data integration, information quality, metadata intelligence, master data management, and predictive analytics. He is the author of a number of articles and books, including The Rational Guide to Extending SSIS 2005 (Rational Press, 2007). Prior to joining Microsoft, Donald worked not only in business intelligence, but also in fields as varied as medieval archaeology and fish farming.
Need a Quick Way to See These .NET Videos and Monitor Your Progress?Click Here to Use Progress Monitor
|
| May I Also Recommend for Further Study? Bob Tabor also has an excellent 20-part series on LINQ that is entitled: LINQ to SQL 101. Check it out in the video library section of LearnVisualStudio. |
| 1. Using the Microsoft Data Platform for Easy Data Access with SQL Server 2008 |
| Key Concepts:
In this webcast, we look at how Contoso LTD can take advantage of the Microsoft data platform to extend their applications. We concentrate on Microsoft .NET Language-Integrated Query (LINQ) and the ADO.NET Entity Framework with examples of how Contoso can use these technologies to access their data. Join us as we go into detailed coverage of data platform features, LINQ, and ADO.NET Entity Framework. March 03, 2008 60 minutes - Ron Cundiff |
| 2. Reach Your Data with SQL Server 2008 |
| Key Concepts:
In this webcast, we look at how Contoso LTD can increase methods of accessing data without the need for complex connections and filters on firewalls. We concentrate on Service Broker and ADO.NET Data Services in this session. March 05, 2008 60 minutes - Ron Cundiff |
| 3. Streamline Data Access with SQL Server 2008 |
| Key Concepts:
In this session, Contoso developers have identified a number of features that can assist them in improving the applications that Contoso field employees rely on. We explore the new features in SQL Server 2008 that the developers are excited about and we focus on T-SQL improvements, such as MERGE, the Table Valued Parameters feature that lets data rows be passed as parameters to stored procedures, in addition to Date/Time, Intellisense, and multi server T_SQL. March 10, 2008 60 minutes - Ron Cundiff |
| 4. Manage Your Unstructured Data with SQL Server 2008 |
| Key Concepts:
The recent growth at Contoso has been mirrored with the growth of its data, from client voice mails to scanned and e-mail documents. These documents are now common as part of insurance claims or parts of quotes. This growth in unstructured data has led Contoso to look at options for its storage, access, security, and searching needs. Join this session as we look at the FILESTREAM attribute and Remote BLOB Store API features in SQL Server 2008 as potential solutions to this problem. We cover the differences from large unstructured data storage in Microsoft SQL Server 2005 and then explore the new SQL Server 2008 features in detail, while explaining how to implement them. March 12, 2008 60 minutes - Ron Cundiff |
| 5. Simplify Management of Your SQL Server 2008 Data Platform |
| Key Concepts:
In the next two webcasts of this series, we look at the management side of Microsoft SQL Server 2008 and focus on challenges that database administrators face. See how Contoso's business in the Far East has grown rapidly, and as such, their major operations at ports in Los Angeles, Tacoma, Rotterdam, and Tilbury have grown too. This has resulted in an increase in SQL Server deployments to handle the data required to deliver up-to-date information to sales teams and customers. Contoso is looking to SQL Server 2008 to assist in the management of this environment. We cover topics including managing complex and high-value tasks, proactively monitoring and tuning system health, scaling management to multiple data centers, and gaining insight into historical trends and real-time activities. March 17, 2008 90 minutes - Bryan Von Axelson |
| 6. Simplify Management with Policy-Based Management |
| Key Concepts:
In this webcast, we focus on the Policy-Based Management (PBM) and its use to define policies that apply to servers, databases, and other objects in Contoso's data environment. This session is solely focused on PBM and covers the scope, definition, and deployment of policies. March 19, 2008 90 minutes - Bryan Von Axelson |
| 7. Map Your Data with SQL Server Spatial Features |
| Key Concepts:
Contoso now wants to implement a mapping feature into its systems. It sees a number of benefits to this, from assisting in pickup and delivery of consignments by providing maps to the local transports teams, in addition to providing data on consignment locations to customers, and re-routing options for agents. Join us to learn how to use spatial data types within SQL Server to create these mapping features using Microsoft Virtual Earth. March 24, 2008 90 minutes - John Pelak |
| 8. Ensuring Your Data Is Secure with a Trusted Platform |
| Key Concepts:
In this part of the Microsoft SQL Server 2008 series, we focus on IT professionals and the SQL Server 2008 the Trusted Platform. In the first part of the series we spent time looking at how Contoso was using SQL Server 2008 as a productivity platform. Now we change direction from developers and look at how Contoso's IT operations embraced the new and enhanced features to make sure that SQL Server 2008 was a trusted platform. The first two parts address security, which is a main theme for Contoso as they have large amounts of critical data that needs to be protected against both internal and external threats. Either data loss or compromise would be a nightmare scenario. In this session, we look at features such as surface area configuration policies, external key management, and Network Access Protection (NAP), and Windows BitLocker Drive Encryption, which Contoso could use to protect its data. March 31, 2008 90 minutes - Bryan Von Axelson |
| 9. Securing Your System |
| Key Concepts:
While it is extremely important to secure your data, it is also vital to secure your system also. One without the other is not a secure solution. In this webcast, we look at the systems on which Microsoft SQL Server relies and runs. Contoso made two major decisions concerning their data: the first was to use Microsoft SQL Server 2008, the second was to move to Windows Server 2008 at the back end and Windows Vista at the front end. These two operating systems together offered the best solution going forward. In this session, we focus on the Windows Server 2008 part of the combination to look at the features that enabled Contoso to secure their systems that run SQL Server and its required services. Key security features that we cover are: surface area configuration policies, external key management, Network Access Protection (NAP), and Windows BitLocker Drive Encryption. April 02, 2008 90 minutes - Chris Avis |
| 10. Ensuring Business Continuity |
| Key Concepts:
Contoso expansion over the past years increased the challenges the IT organization faced with regard to the increased number of offices and data growth. As jobs come in and consignments travel around the globe, different external organizations require information 24-7. The Microsoft SQL Server systems have to be available around the clock around the world. In this session, we look at high availability options in Microsoft SQL Server 2008 that help ensure that these systems are there when they are needed–regardless of what component has failed. April 07, 2008 90 minutes - Bryan Von Axelson |
| 11. Predictable Response to Your Users |
| Key Concepts:
At any given time, Contoso's servers provide multiple services to users and applications. Using Microsoft SQL Server 2008, Contoso would like to achieve better performance with its workloads. In this session, we look the Resource Governor, which enables administrators to define limits and assign priorities to individual workloads that are running on a SQL Server instance. We also look at Plan Freezing in SQL Server 2008, which enables greater query performance stability and predictability by providing new functionality to lock down query plans. This enables organizations to promote stable query plans across hardware server replacements, server upgrades, and production deployments. April 16, 2008 90 minutes - Bryan Von Axelson |
| 12. Data Warehousing Scale and Performance |
| Key Concepts:
The foundation of Contoso's business intelligence (BI) strategy is the development of a data warehouse using Microsoft SQL Server 2008. Scalability and performance of the data warehouse are important for the successful deployment of Contoso's enterprise data warehouse. In this webcast, we cover the new features in SQL Server 2008 that support Contoso's goals, such as: Partition-aligned indexed views. May 05, 2008 90 minutes - Bryan Von Axelson |
| 13. Data Warehousing Management |
| Key Concepts:
Microsoft SQL Server 2008 includes many new features that Contoso can use to manage the enterprise data warehouse. In this webcast, we cover the following topics: Minimal logging for inserts. May 07, 2008 90 minutes - Bryan Von Axelson |
| 14. Reporting Services Designer Improvements |
| Key Concepts:
The recent growth at Contoso has been mirrored with the growth of its data, from client voice mails to scanned and e-mail documents. These documents are now common as part of insurance claims or parts of quotes. This growth in unstructured data has led Contoso to look at options for its storage, access, security, and searching needs. Contoso wants to allow both IT developers and power users to create reports using the new Report Designer. In this webcast, we review the new features in Microsoft SQL Server 2008 Reporting Services that support both types of developers, in addition to more flexible and richer types of reports. We cover new report designer layout features, tablix, chart features, and variables. May 08, 2008 60 minutes - Mike Benkovich |
| 15. Upgrade Your Database |
| Key Concepts:
Unless you have never deployed Microsoft SQL Server, sooner or later you may look at upgrading to a new version. Contoso would like to move their existing SQL Server databases to Microsoft SQL Server 2008 and, at the same time, take advantage of the latest improvements in Business Intelligence (BI). In this session, we look at the methods that Contoso used to upgrade. May 10, 2008 90 minutes - Chris Avis |
| 16. Performance Troubleshooting |
| Key Concepts:
An area of concern for Contoso is the monitoring and troubleshooting of any performance issues it may encounter on Microsoft SQL Server 2008. In this session, we cover the tools available for IT departments as they troubleshoot performance. We look at Performance Studio, the features available, and how to use them to analyze performance. We also cover how to use the Best Practice Analyzer for SQL Server, and utilizing the results it provides. May 13, 2008 90 minutes - Bryan Von Axelson |
| 17. Scale Your Business |
| Key Concepts:
Contoso, like most firms, found that once one database is deployed, others soon follow. Unless planned, these deployments can scale out of control. Microsoft SQL Server 2008 offers a number of features that provide solutions for Contoso to scale out and up, while maintaining control. In this webcast, we show you how to take advantage of the latest hardware, such as 64-bit, hot add memory, and CPU, as well as software features. Learn to speed up query processing with Partitioned Table Parallelism through backup and compression, and to speed up backup times and replication. May 15, 2008 90 minutes - Chris Avis |
| 18. AS Design and Performance Improvements |
| Key Concepts:
This webcast was designed for IT professionals and developers. To support high-performing ad hoc analysis, Contoso wants to develop a Microsoft SQL Server Analysis Services database. In this webcast, we review the new features in Analysis Services that may help Contoso accelerate development and achieve optimal performance. Topics covered include: - Developing a cube and dimensions using the wizards. May 19, 2008 90 minutes - John Weston |
| 19. Data Mining |
| Key Concepts:
Contoso wants to implement data mining to help the sales department better understand its customer base and forecast future sales based on historical trends. In this webcast, we review the data mining capabilities of the Microsoft business intelligence (BI) platform, including: - Using Microsoft SQL Server Data Mining Add-ins for Excel for table analysis. May 21, 2008 90 minutes - Donald Farmer |
| 20. Streamlining Data Integration |
| Key Concepts:
To load data into the Contoso enterprise data warehouse, Contoso uses Microsoft SQL Server 2008 Integration Services. In this webcast, we review the new features in Integration Services that help Contoso streamline the development and execution of processes to extract, transform, and load data into the data warehouse: ADO.NET connectivity, persistent lookups, pipeline improvements, and data profiling. We also examine alternatives for managing changing data in the data warehouse using the Change Data Capture function and MERGE command. Demonstrations on using an ADO.NET data source, working with lookup caches, identifying dirty data with data profiling, and using Change Data Capture and MERGE for slowly changing dimensions are included in this webcast. May 28, 2008 90 minutes - Bryan Von Axelson |
| 21. Reporting Services Architecture Improvements |
| Key Concepts:
Contoso plans to provide employees with access to standard reports using Microsoft SQL Server 2008 Reporting Services. In this webcast, we review the new features in Reporting Services that enable organizations to easily configure and manage a scalable, high-performance reporting infrastructure, including the new physical architecture of Reporting Services, authentication configuration, the new processing and rendering architecture, and memory management. We also provide demonstrations on configuring Reporting Services, using the Configuration Manager, configuring authentication alternatives, and configuring memory settings. May 31, 2008 90 minutes - Bryan Von Axelson |
| 22. Reach Users with the 2007 Office System |
| Key Concepts:
Throughout this series, we use Contoso as our scenario customer as we explore the features that make up the Microsoft SQL Server 2008 platform. Contoso is a shipping company that delivers all kinds of items around the globe, from small individual items to large manufactured items. Contoso has seen growth in its business over the past years, especially in the movement of goods from China around the world. While Contoso is happy with their in-house applications and believe they provide a significant advantage over competitors, Contoso wants to ensure that these applications are running on the most productive platform to maintain this advantage, especially as their business grows worldwide. The recent growth at Contoso has been mirrored with the growth of its data, from client voice mails to scanned and e-mail documents. These documents are now common as part of insurance claims or parts of quotes. This growth in unstructured data has led Contoso to look at options for its storage, access, security, and searching needs. Microsoft Office Excel 2007. June 03, 2008 60 minutes - Ron Cundiff |
Comments