Presenter: Bryan Von Axelson, TechNet Presenter, Microsoft Corporation Bryan Von Axelson joined the SST Team last September as a TechNet Presenter. Before that, Bryan consulted for seven years throughout the Midwest and Western United States, targeting the small and medium business segment. Previously, Bryan worked for Franklin Covey and MCI. Bryan brings 14 years experience as an IT Professional and relates his real-world experiences and best practices into his sessions.

1. Administration Tools

Part one of this series explores the changes to the administration and management tools in SQL Server 2005. The discussion focuses primarily on the new Management Studio tool, which encompasses the Enterprise Manager, Query Analyzer and OLAP Analysis Manager from SQL 2000. Because the tool runs within the Visual Studio interface, we will also look at this interface and the functions it can perform. 3/21/2005 | Duration:60 Minutes

2. Monitoring Tools

In part two of this series, we look at the monitoring tools available with SQL Server 2005. We examine the SQL Profiler, Database Tuning Advisor, Database Maintenance Workflow and Dynamic Management Views (DMVs). 3/28/2005 | Duration:60 Minutes

3. Achieving Greater Concurrency

SQL Server 2005 provides enhancements to enable greater concurrency and significantly reduce lock contention. In part three of this series, we show you how to use Snapshot Isolation to reduce currency contention. Gain an understanding of database snapshots and replication for scaling and read-only views, and learn how Dynamic Management Views can help you proactively monitor locking and avoid deadlocks. 4/4/2005 | Duration:60 Minutes

4. Securing Your SQL Server

Parts four and five in our series highlight the security enhancements in SQL Server 2005. Part four of this series focuses on authentication and authorization while crypto support is covered in part five. We begin with authentication, examining the Security model, endpoint-based authentication and the password policy. Then we move on to explore authorization, covering User Schema separation, module execution context, granular permission control and Catalog security. 4/11/2005 | Duration:60 Minutes

5. Protecting Sensitive Data

Parts four and five in our series highlight the security enhancements in SQL Server 2005. Building upon the discussion of authentication and authorization in the previous session, part five of the series covers the crypto support in SQL Server 2005. We begin with an introduction to the concepts of database encryption including encryption support, keys, certificates and key management. We show how SQL 2005 can protect sensitive data using data encryption and module signatures, and introduce sign modules, what these are and how they work. 4/18/2005 | Duration:60 Minutes

6. Managing Large Databases Using Partitioning

Partitioned tables improve the scalability and manageability of very large SQL Server databases. In part six of this series we look at the table and index partitioning capabilities in SQL Server 2005. The discussion will outline the features and benefits of partitioning, explain how it works, and illustrate how to implement and set up this feature. 4/25/2005 | Duration:60 Minutes

7. Indexing Enhancements

The aim of creating indexes and partitioning data in a database is to yield good performance for users. Part seven in this series looks at the enhancements to the indexing within SQL Server 2005. We begin by outlining the basic changes to the indexing compared to previous versions. We then drill into index management and show how to use the Database Tuning Advisor as the main tool to analyze indexes. 5/2/2005 | Duration:60 Minutes

8. Data Recovery

Part eight in the series covers troubleshooting methods and tools in Microsoft SQL Server 2005 that you can use to recover from various scenarios. Topics include database access problems, such as the database being marked as suspect during recovery; backup and restore failures; database runtime consistency failures, such as checksum; and DBCC CHECKDB errors. Learn how to take advantage of new features in SQL Server 2005 to recover your data in order to make yourself more productive in disaster recovery situations. 5/9/2005 | Duration:60 Minutes

9. High Availability

Database mirroring is a new technology in SQL Server 2005 that provides very fast, automatic failover to a standby system. In part nine of this series we examine this new enhancement in detail, and will show you how to configure and use it. 5/16/2005 | Duration:60 Minutes

10. Moving Data Between Data Sources

SQL Server includes a suite of replication technologies that enable a wide range of distributed database applications. SQL Server 2005 introduces a few new scenarios including Web synchronization of merge replication for mobile and distributed data applications, Oracle publishing for integration with Oracle databases, and peer-to-peer replication. In this final webcast in our ten-part series, learn how you can benefit from these scenarios with an enhanced ability to monitor the entire distributed system. 5/18/2005 | Duration:60 Minutes

Tags:SQL Server 2005 Video Tutorials

Share This

Fritz Onion is a co-founder of Pluralsight. He focuses on Web development using Microsoft ASP.NET. He frequently publishes articles on .NET, and is the author of the book "Essential ASP.NET" published by Addison Wesley, available in both Microsoft Visual C# and Microsoft Visual Basic .NET editions. A second edition will cover ASP.NET 2.0. Fritz is also a regular speaker at industry conferences and is the track chair for Web development at Win-Dev in Boston.

Although many of the topics in this series are similar to Bill Steele's ASP Soup to Nuts Series, Fritz puts a different spin on them, and I have learned a lot by watching both series.

1. Introduction to ASP.NET 2.0 Slides Lab used as Demo Lab

See the core features of Microsoft ASP.NET 2.0. In this webcast we highlight some of the key differences between ASP.NET 2.0 and its predecessor, Microsoft ASP.NET 1.1. This first presentation provides a preview of many of the webcasts to follow and is a useful student guide for the rest of the lectures. Topics introduced in this talk include master pages, themes, membership, profile, and declarative data binding. August 4, 2005 - 68 minutes

2. Architecture Slides Demos Lab

Examine the fundamental architecture of Microsoft ASP.NET 2.0. This webcast will cover page compilation, assembly loading, code behind, and shadow copying. There are several changes in the compilation model from Microsoft ASP.NET 1.1, most notably the use of partial classes in .aspx parsing. This webcast walks you through the details of the new architecture to help you gain a solid understanding of the underpinnings of ASP.NET 2.0. August 11, 2005 - 64 minutes

3. Master Pages, Themes, and Skins Slides Demos Lab

See the two significant user interface features of Microsoft ASP.NET 2.0: master pages and themes. In this webcast you learn how master pages give you a flexible way of defining templates for your site. Master pages make it easy for you to change the look and feel of entire sets of pages from a single source. Themes introduce a way to consolidate user interface features like style sheets, images and control styles in a single location, and simplify the process of "skinning", or changing the appearance of all elements of a site. August 18, 2005 - 63 Minutes

4. New Controls in ASP.NET 2.0 Slides Demos Lab

Examine several of the new controls in Microsoft ASP.NET 2.0. This webcast covers the navigation controls (SiteMapPath, Menu, TreeView), the Wizard control, and the MultiView control. Many tasks that previously required explicit coding or the purchase of third party components are made much simpler with these new controls. August 25, 2005 - 56 minutes

5. Introduction to DataBinding Slides Demos Lab

Explore the new declarative data binding model. In this webcast, we walk through the fundamentals of how to bind data to controls using the new data source controls. This presentation includes an in-depth look at the Microsoft ASP.NET 2.0 SqlDataSource object, and compares the way the new declarative model works with an analogous programmatic approach. Later in the series, we revisit the subject of data binding with a look at the other new data-related features in Microsoft ASP.NET 2.0. Sept 1, 2005 - 60 Minutes

6. Client State Slides Demos Lab

Learn new ways to handle state management in Microsoft ASP.NET 2.0. In this webcast we compare URL mangling to the practice of using cookies for storing session keys. We also look at the new cross-page posting feature, and show you how to use the Microsoft ASP.NET 2.0 Profile service as a generic data-backed per-client store. September 08, 2005 - 59 Minutes

7. Membership Slides Demos Lab

See the new membership features of Microsoft ASP.NET 2.0. This webcast begins with how to implement cookie-based authentication for sites using the new security controls and the site administration tool. We will then go behind the scenes to examine how this authentication works. We help you understand how you can best incorporate these new features into your projects. September 15, 2005 - 46 minutes

8. Webparts Slides Demos Lab

Portal pages and Web Parts are familiar to Microsoft SharePoint developers and have made their way into the core of Microsoft ASP.NET 2.0. In this webcast, we walk you through the basic steps for setting up a customizable site using new Web Part controls, including WebPartManager, WebPartZone, CatalogZone, and EditorZone. October 6, 2005 - 57 minutes

9. Deployment Slides Demos Lab

Microsoft ASP.NET 2.0 fundamentally changes the way developers work with Web applications. This webcast discusses those changes and shows how they affect both development and deployment. Once you understand how ASP.NET 2.0 performs its parsing and compilation, you will see why it is one of the most flexible Web development environments available today. We explore options ranging from complete source deployment to binary-only deployment. October 13, 2005 - 57 minutes

10. Validation Slides Lab used as Demo Lab

Explore several new features in Microsoft ASP.NET 2.0 specific to the validation controls. This webcast shows you how to take full advantage of the validation controls in your Web applications. A portion of the discussion focuses on understanding and using validation groups. October 20, 2005 - 50 minutes

11. Advanced DataBinding Slides Demos Lab

This webcast continues our discussion on data binding that we began in part five of this series. This webcast will dig deeper into the new data-related features of Microsoft ASP.NET 2.0. We cover hierarchical data binding, the ObjectDataSource object, multi-layered architectures with declarative binding, and two-way binding. October 27, 2005 - 58 minutes

12. Resources and Internationalization Slides Lab used as Demo Lab

Learn the fundamental concepts you need to know in order to internationalize your Web applications. In addition to the App_Code directory, Microsoft ASP.NET 2.0 defines two new directories designed to store resources for compilation; App_LocalResources and App_GlobalResources. In this webcast we look at both declarative and programmatic techniques, and discuss when the use of each is appropriate. November 3, 2005 - 53 minutes

13. Diagnostics Slides Demos Lab

Examine how Microsoft ASP.NET 2.0 simplifies the way tracing works, and makes it much easier to redirect trace output to alternate sources. This webcast demonstrates several new diagnostic features, including performance counters and the new Web events. We discuss these features and provide examples of where to apply each feature. November 10, 2005 - 51 minutes

14. Client-Side Features of ASP.NET 2.0 Slides Demos Lab

See the new client callback feature built into Microsoft ASP.NET 2.0, along with other features that make it easier to integrate client-side script into your rendered pages. In this webcast you will learn how simple it is to add sophisticated client-side JavaScript that retrieves data from the server without performing a POST-back request. Both the TreeView and GridView controls have built-in support for dynamic data population with client callbacks. We discuss how to take advantage of this exciting feature in the existing controls, and show you how to build your own callbacks. November 17, 2005 - 61 minutes

15. Caching Slides Lab used as Demo Lab

The most requested caching feature in the first release of Microsoft ASP.NET 1.1 was Microsoft SQL Server cache invalidation, so it should come as no surprise that version 2.0 has a complete implementation of SQL cache invalidation. Even better news is that it is a completely pluggable architecture, so you can now build your own cache dependencies with ease. This webcast covers SQL cache invalidation in both Microsoft SQL Server 2000 and Microsoft SQL Server 2005, and explores new cache management features and the new substitution control. December 8, 2005 - 53 minutes

Tags:

Share This

The presenter of this webcast series is Microsoft's Ron Cundiff. Before joining Microsoft in 2002, Ron designed and implemented a global online commodities exchange system for an ISV. He has also held management and technical leadership positions with a Microsoft partner. His certifications include MCSD, MCSE, MCDBA, MCP+I+SB - and he's working on extending the list.

1. Introduction Download Slide Deck Download Demo Code

In this webcast series, Ron explores the popular programming language, Microsoft Visual Basic .NET. Learn about the basic language constructs and discover the different types of applications you can build using Visual Basic .NET. In this presentation, Ron provides an introduction to our Visual Basic .NET series, which progressively delves deeper into this fantastic language. 2/5/2007

2. Visual Basic 2005 Express Edition Download Slide Deck Download Demo Code

In this webcast, Ron introduces you to Microsoft Visual Basic 2005 Express Edition, a free download from Microsoft that enables you to develop Visual Basic .NET applications. He examines the powerful integrated development environment (IDE) features, like Code Editor, Compiler, IntelliSense, and the Debugger. He also describes the project system that can help you build a collection to keep all the files related to your program together. 2/13/2007

3. Class Libraries Download Slide Deck Download Demo Code

Microsoft Visual Basic .NET is a very powerful language; however, it does not do everything by itself. In this webcast, Ron shows you how Visual Basic .NET relies on a hierarchical set of prewritten functions that enable developers to gain access to standard functionality provided by the host operating system. He describes how these functions are contained in files called class libraries. He also explores some of the basics of class libraries and examines how Visual Basic .NET provides developers with basic functionality through class libraries. 2/19/2007

4. VB.NET Program Structure Download Slide Deck Download Demo Code

Visual Basic is the most popular programming language from Microsoft. So far, in this series, Ron has been exploring the basics of Visual Basic.NET and Visual Basic Express. In this webcast, he begins to dive deep into just what Visual Basic is and how programs written in Visual Basic are structured. He looks at the basics of the language and how Visual Basic assembles the lines of code you write into something meaningful to the runtime. 2/20/2007

5. Language Fundamentals Download Slide Deck Download Demo Code

This webcast teaches the basics of the Microsoft Visual Basic .NET language. In this session, Ron examines specific features in Visual Basic .NET. You will learn about the different types, variables, constants, and statements in the language, and you will also learn how to use them. 3/5/2007

6. Classes and Objects Download Slide Deck Download Demo Code

In this session, Ron examines specific features in Visual Basic .NET, explore classes and objects, and describe how to use them. 3/19/2007

7. Operator Basics Download Slide Deck Download Demo Code

In this webcast, Ron looks at specific Visual Basic language features. He teaches about the different kinds of operators and how to use them. 3/26/2007

8. Branching and Looping Download Slide Deck Download Demo Code

In this webcast, Ron looks at specific Visual Basic language features. He teaches you about iterators, loops and Branching. 4/2/2007

9. Basic Debugging Download Slide Deck Download Demo Code

In this webcast, Ron looks at debugging, and he talks about how the integrated development environment (IDE) enables you to view what is going on inside your application while it is running. 4/9/2007

10. Arrays and Collections Download Slide Deck Download Demo Code

In this webcast, Ron looks at arrays and collections, and he talks about how you can use them to store and organize data within your application. 4/16/2007

11. Exception Handling Download Slide Deck Download Demo Code

Ron discusses how to handle unexpected problems in your application using the robust exception-handling system built into the Microsoft .NET Framework. He talks about try/catch blocks, and he describes how to correctly handle the types of exceptions your application can experience. 4/23/2007

12. Delegates and Events Download Slide Deck Download Demo Code

Ron talks about delegates and events, and he describes how they enable you to build applications that can send alerts to other applications when interesting changes occur within your application. He also teaches how multiple listeners can respond to a single event. 4/30/2007

13. Inheritance and Polymorphism Download Slide Deck Download Demo Code

Ron looks at features that can help you create objects that are "like" other objects. He talks about how you see this type of correlation in everyday objects and often need to model it in your programs. Discover how inheritance and polymorphism can reduce the amount of code you write and make it easier to understand. 5/7/2007

14. Visual Basic and the Web Download Slide Deck Download Demo Code

In this webcast to see how you can use Microsoft Visual Basic to build applications that target Web sites. Ron provides an overview of Microsoft ASP.NET, describes how it relates to Visual Basic, and illustrates how you can build Web pages and controls that enable you to reuse your code. 5/14/2007

15. Custom Web Controls Download the slides Download the code

Ron teaches you about building basic ASP.NET controls in Visual Basic. Visual Basic and ASP.NET together bring us a powerful platform for developing web applications, but sometimes, we need to think about the application as a whole. Code reuse is on of those important features of application development that can significantly reduce our development time. In this webcast, Ron shows how we can use User Controls and Custom Controls to help us trim that development time down. 5/21/2007

16. Visual Basic and Windows Applications Download the slides Download the code

Ron teaches you about building basic Windows Applications. The basic window class we use in Visual Basic is the Form. In this webcast, Ron looks at the System.Windows.Form object and shows how we can expand it and utilize it to suite our exact needs. 5/22/2007

17. Custom Windows Forms Controls Download the slides Download the code

In the previous webcast in this series, Ron talked about using Visual Basic standard Windows form object. However, some applications require a user interface that is unique or different than the standard forms. In this webcast, Ron explores some of the more advanced features of Windows Forms development, such as GDI+ that allow us to tailor the user interface to exactly what our applicaiton needs. 5/28/2007

Tags:

Share This

Bill Steele is my favorite Microsoft instructor. He is featured speaker for Microsoft and NASA, a pilot, inventor, has a great sense of humor, and is very entertaining. Oh yes, did I mention that he also knows C# inside and out? This is the most streamlined video tutorial series on c sharp that I have found.

1. Introduction to C# Download Slide Deck Download Demo Code

Here is an introduction to Microsoft's Newest Programming language, C#. Bill explores the basic language constructs and begin to explore what types of applications we can build. This will be the "front door" to a series of webcasts on C# where we will progressively get deeper and deeper in to this fantastic language. 11/13/2006

2. Visual C# Express Download Slide Deck Download Demo Code

This webcast introduces you to Visual C# Express. Visual C# Express is a free download from Microsoft that allows you to develop C# applications. Learn about the powerful IDE features like Code Editor, Compiler, Intellisense and the Debugger. Also, learn about the project system that allows us to build a collection to keep all the files related to our program together. 11/20/2006

3. Class Libraries Download Slide Deck Download Demo Code

C# is a very powerful language, however, it doesn't do everything by itself. Instead, it relies on a hierarchical set of pre-written functions that allows developers to gain access to standard functionality provided by the host operating system. These functions are contained in files called "Class Libraries." Explore some of the basics of class libraries and learn how C# provides basic functionallity through Class Libraries for developers. 11/27/2006

4. C# Program Structure Download Slide Deck Download Demo Code

C# is the newest programming language from Microsoft. So far, in this series, we've been exploring the basics of C# and Visual C# Express. In this webcast, we will begin to dive deep into just what C# is and how programs written in C# are structured. We'll begin by looking at how the "main" function is defined. We will then look at the basics of the language and how C# assembles the lines of code you write into something meaningful to the runtime. 12/4/2006

5. Language Fundamentals Download Slide Deck Download Demo Code

Learn the basics of Microsoft's C# Language. This webcast examines specific C# language features. It explains Types, Variables, Constants, Statements and more are and how to use them. 12/11/2006

6. Branching and Looping Download Slide Deck Download Demo Code

This webcast covers iterators, loops and Branching. 12/18/2006

7. Classes and Objects Download Slide Deck Download Demo Code

This webcast covers classes, objects and how to use them. 1/8/2007

8. Operator Basics Download Slide Deck Download Demo Code

This webcast covers the different kinds of operators and how to use them. 1/15/2007

9. Basic Debugging Download Slide Deck Download Demo Code

This webcast talks about debugging and how the IDE allows you to view what is going on inside your application while it is running. 1/22/2007

10. Arrays and Collections Download Slide Deck Download Demo Code

This webcast teaches about arrays and collections and how we can use them to store and organize data withing our application. 1/29/2007

11. Creating and Manipulating Strings Download Slide Deck Download Demo Code

This webcast teaches about strings and how to create and manipulate them utilizing basic operators as well as the StringBuilder class. 2/5/2007

12. Exception Handling Download Slide Deck Download Demo Code

This webcast teaches how handles unexpected problems with our application via the robust Exception Handling system built into the .NET Framework. It explains about Try-Catch blocks and how to correctly handle the different types of exceptions that your application can experience. 2/12/2007

13. Delegates and Events Download Slide Deck Download Demo Code

This webcast teaches you about Delegates and Events. Delegates and Events allow us to build applications that can let others know that some type of interesting thing has happened within our application. We will also see how we can even have multiple listeners respond to a single event. 2/19/2007

14. Inheritance and Polymorphism Download Slide Deck Download Demo Code

This webcast examines the specific C# language features that allow us to create objects that are "like" other objects. We see this type of correlation in every day objects and often need to model that in our programs. Inheritance and Polymorphism solve various kinds of problem, including reducing the amount of code we write as well as making it much easier to understand. 2/26/2007

15. C# and the Web Download Slide Deck Download Demo Code

In this webcast, you will see how C# can be used to build applications that target websites. You will learn about ASP.NET and how it relates to C# and see how we can build web pages and controls that allow us to reuse our code. 3/5/2007

16. Custom Web Controls Download Slide Deck Download Demo Code

This webcast covers building basic ASP.NET controls in C#. C# and ASP.NET together bring us a powerful platform for developing web applications, but sometimes, we need to think about the application as a whole. Code reuse is on of those important features of application development that can significantly reduce our development time. In this webcast, we will see how we can use User Controls and Custom Controls to help us trim that development time down. 3/12/2007

17. C# and Windows Applications Download Slide Deck Download Demo Code

This webcast teaches you about building basic Windows Applications. The basic window class we use in C# is the Form. In this webcast, we will explore the System.Windows.Form object and see how we can expand it and utilize it to suite our exact needs. 3/19/2007

18. Custom Controls Download Slide Deck Download Demo Code

C# has a standard Windows form object. However, some applications require a user interface that is unique or different than the standard forms. In this webcast, we will explore some of the more advanced features of Windows Forms development, such as GDI+ that allow us to tailor the user interface to exactly what our applicaiton needs. 3/26/2007

19. C# and Windows Presentation Foundation Download Slide Deck Download Demo Code

This webcast shows how to take advantage of Windows Vista's new presentation system, Windows Presentation Foundation (aka WPF) with C#. WPF allows our applications to include stunning graphics and enhanced user experience functionallity that was unatainable in the past. 4/9/2007

20. C# and SQL Server 2005 Download Slide Deck Download Demo Code

This webcast shows how to include data access features in your applications. It specifically discusses how to integrate SQL Server 2005 database functionality directly into your web and Windows based applications. C# allows us to programatically get direct access to SQL Server data. In this webcast, we will look at the various features in C# that allow us to develop against SQL Server 2005 and other data sources. 4/16/2007

21. C# and Game Development Download Slide Deck Download Demo Code

This webcast discusses game development with C#. C# can be used to build a variety of software, but one of the most overlooked types of programs is games. This webcast looks at XNA Game Studio Express. XNA is a gaming framework available for Windows as well as for the XBox 360. In this session, we'll see how XNA Game Studio and Microsoft Visual C# Express allow you to develop stunning 3D games with ease. 4/23/2007

22. C# Application Deployment Options Download Slide Deck

This webcast discusses the various deployment options for your applications. Writing an application can be a very tedious task, but deploying it can be a greater challenge. In this webcast, we'll look at the various deployment options you have, we'll see how they work and afterwards, you will have the information you need to sucessfully deploy your own applications. 4/30/2007

Tags:

Share This

Excellent SQL Server 2005 Express series of 13 free videos from Bob Tabor at LearnVisualStudio.Net. If you like these, you should check out the lifetime membership deal that he offers where you can get access to over one hundred hours of video tutorials for less than a dollar per hour.

1. What is a Database? - This introduction covers the questions and terminology SQL Server beginners need to create and manage databases, such as: What is a SQL Server database? How is a SQL Server database different from an Excel spreadsheet? What do SQL Server databases do in my website or software applications? What’s SQL Server Express’ relation to Visual Studio Express? What do terms like “ADO.NET” mean?

Duration: 28 minutes, 15 seconds

2. Understanding Database Tables and Records - SQL Server beginners will learn about tables and definitions of data types, properties, keys, etc. in this second video. Find out how table rows, columns, and fields interrelate and whether columns can be empty.

Duration: 24 minutes, 56 seconds

Date: 29 March 2006

3. More about Column Data Types and Other Properties - SQL Server beginners will explore data integrity, learn which data types to use for what, and avoid common data type pitfalls.

Duration: 21 minutes, 37 seconds

Date: 22 February 2006

4. Designing Relational Database Tables - Why are relational databases the most popular? SQL Server beginners will learn to differentiate between primary and foreign keys, design relational database tables, and learn about normalization rules and de-normalization.

Duration: 34 minutes, 10 seconds

Date: 29 March 2006

5. Manipulating Database Data - SQL Server beginners will learn about ADO.NET objects and execution of SQL statement from ADO.NET. Explore SQL and learn about insert, update, and delete statements.

Duration: 40 minutes, 20 seconds

Date: 29 March 2006

This lesson requires Management Studio Express and MSXML

6. More Structured Query Language - SQL Server beginners will discover more SQL statements like sub-select and learn stored procedures and their counterparts in C# and VB methods.

Duration: 23 minutes, 13 seconds

Date: 29 March 2006

7. Understanding Security and Network Connectivity - SQL Server beginners will learn to differentiate between SQL Server database files and SQL Server processes. Explore scenarios for connecting to SQL Server Express databases, enabling and disabling user instances, login permissions, and other security precautions.

Duration: 40 minutes, 59 seconds

Date: 20 March 2006

8. Connecting your Web Application to SQL Server 2005 Express Edition - SQL Server beginners will walkthrough the entire workflow of creating a database driven Web application and use visual tools to quickly create an administration application.

Duration: 1 hour, 5 minutes

Date: 20 March 2006

9. Using SQL Server Management Studio - SQL Server Management Studio Express will typically be your main interface into SQL Server Express. This lesson demonstrates the essential techniques and skills you’ll need to successfully connect to database instances, navigate the query window and scripting database objects, attaching, detaching and backing up databases, and much more.

Duration: 40 minutes, 26 seconds

Date: 23 October 2006

10. Getting Started with Reporting Services - SQL Server Reporting Services allows you to design and deploy nicely formatted and interactive reports representative of your data. Suitable for print or online distribution, these reports and it allows you to get professional results very quickly. This video demonstrates how to set up Reporting Services and the Business Intelligence Development Studio to build reports using the wizards and designers, and deploy them to your Report Server.

Duration: 32 minutes, 51 seconds

Date: 21 October 2006

11. Building and Customizing Reports in Business Intelligence Development Studio - Building on the previous lesson, we dive into building reports from scratch and modifying the reports that were created using the wizards and designers. We also demonstrate how to embed your reports into your ASP.NET Web Form applications.

Duration: 44 minutes, 50 seconds

Date: 22 October 2006

12. Creating and Using Stored Procedures - This video expands on the topic of Stored Procedures which was introduced several lessons ago. In this video we explain the basic syntax to create and update stored procedures, using input and output parameters, return values, declaring variables and adding other T-SQL programming elements into you stored procedures, how to execute your stored procedures from the query window, and finally the Visual Basic and C# syntax required to utilize stored procedures in your own applications.

Duration: 42 minutes, 34 seconds

Date: 14 November 2006

13. Enabling Full-Text Search in your Text Data - Full-Text search allows you to save large portions of text — even Microsoft Word documents, or other file formats — into your database and perform complex queries based on this textual data while expecting great performance. This lesson demonstrates how to set up Full-Text search paying particular attention to the nuances of setting it up within SQL Server Express. Then we move to creating full-text indexes, configuring the index population settings, and performing queries that demonstrate the power of the CONTAINS predicate and its many, many variations.

Duration: 38 minutes, 25 seconds

Date: 14 November 2006

Tags:

Share This

Tags:

Share This