SQL Server 2008 Videos

Sign Up for the SQL Server 2008 R2 CTP

2009-07-05T11:21:00.000-07:00

SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 by providing a wealth of new features and capabilities that can benefit your entire organization. This release will further improve IT Efficiency with new and enhanced management capabilities and empower business users to access, integrate, analyze and share information using business intelligence tools they already know.

What's New in R2

With this new release, IT professionals, developers and business users will experience the following benefits:

Capitalize on Hardware Innovation

Increase in the number of logical processors supported from 64 up to 256. This will provide customers with more choices for obtaining single system scalability with high performance.

Optimize Hardware Resources

Dashboard viewpoints provide insight into utilization and policy violations to help identify consolidation opportunities, maximize investments and maintain healthy systems.

Manage Efficiently at Scale

Through new extensions in SQL Server Management Studio, organizations will gain insights into their growing applications and databases and help ensure higher service levels through policies and dashboard viewpoints.

Enhance Collaboration Across Development and IT

Streamline Application Lifecycle Management through integration with Visual Studio. A new project type enables a single unit of management for packaging database schema with application requirements. This ensures higher quality application development while also accelerating deployments, moves, and changes over time.

Improve the Quality of Your Data

Centralized approach to defining, deploying, and managing master data can ensure reporting consistency across systems and deliver faster more accurate results across the enterprise.

Manage User-Generated Analytical Applications

Comprehensive management thru Microsoft SharePoint gives IT the ability to manage and secure all BI assets, thus freeing the original authors to focus on the priorities of the business.

Report with Ease

Decrease time and costs developing reports by giving users the ability to design their own queries, reports and charts through powerful and intuitive authoring and ad hoc reporting capabilities.

Get More Out of Your Data

New support for geospatial visualization can produce new insights and discoveries when geospatial data is combined with corporate data for reporting and analysis.

Build Robust Analytical Applications

With the in-memory analytics add-in for Microsoft Excel 2010, business users can quickly access, analyze and summarize vast amounts of data directly in Excel without the assistance of the IT department.

Consolidate Your Data

New “data mash up” capabilities will simplify time consuming data gathering and consolidation tasks. Integrate data from multiple sources, including corporate databases and external sources, using powerful tools within Microsoft Excel.

Share and Collaborate with Confidence

New collaboration tools make it easy to share analytic applications and reports through Microsoft Office SharePoint, where they are refreshed automatically, maintained, and made accessible to others.

During the summer of 2009, Microsoft will offer a Community Technology Preview (CTP) of SQL Server 2008 R2. Sign up now to receive an e-mail notification of the availability of the CTP.

Register for Notification of SQL Server 2008 R2 CTP

Create and Modify Reports Using the Report Builder Tool

2009-06-28T10:21:00.000-07:00

This video shows us how to use SQL Server 2008 Business Intelligence Studio to create a report model. We then use the report model and the Report Builder tool to create a report. The report is saved to the SQL Server Reporting Services reporting site where it can later be run or modified by other users who want a slightly different report.

Download Video

Length: 20 Minutes 41 seconds

Create a Report with Visual Studio 2008 and Deploy it to SQL Server Reporting Services 2008

2009-06-28T10:16:00.000-07:00

This video shows how to build a report using Visual Studio 2008 and then deploy it to SQL Server Reporting Services.

This demo shows how to:

Create report project in Visual Studio

Create an shared data sources

How to design a report

How to add interactive sorting

Change the project settings to deploy the report

Deploy the report

Run the report in SSRS

Download Video

Length: 9 Minutes 7 seconds

Enable Transparent Data Encryption

2009-06-28T10:12:00.000-07:00

This video shows how to use the transparent data encryption (TDE) feature of SQL Server 2008 Enterprise Edition. In addition to showing how to create the keys and certificates necessary to enable TDE, the AdventureWorks sample database is encrypted. After encrypting the database, the effect encryption has on your server is dicussed and what happens with database restores when the proper keys are not available is demonstrated.

Download Video

Length: 19 Minutes 41 seconds

Using the Database Engine Tuning Advisor

2009-06-28T10:01:00.000-07:00

Ensure top performance by using the Database Engine Tuning Advisor the database any workload can be analyzed for changes to the database that will increase performance. By taking advantage of the database engine tuning advisor, administrators can reduce the amount of time they spend analyzing the database to increase performance. Watch this video and know how to use a SQL script as the input to the database engine tuning advisor to determine how to increase performance in certain tables in the Adventureworks sample database.

Download Video

Length: 13 Minutes 42 seconds

9cqau7pt2n

2009-06-28T09:59:00.001-07:00

9cqau7pt2n

Setting up a Maintenance Plan to Backup Databases

2009-06-28T01:35:00.000-07:00

Create database maintenance plans using the Maintenance Plan wizard and SQL Server Integration Services (SSIS). This video also shows you how to customize plans that were created with the wizard.

Download Video

Length: 14 Minutes 29 seconds

User Agreements: Do not violate the copyright law

2008-02-02T09:41:00.000-08:00

Authors of this blog are not responsible for any kind of copyright violation. Please do not download anything which is illegal by the territory, country or domain you live in. We are not responsible if you download and distribute files or links. It is to be noted that no file is uploaded on our servers. We just collects (by using google) links hosted or posted by other server/people. The creator of this page or the ISP(s) hosting any content on this site take no responsibility for the way you use the information provided on this site. These Videos/Ebooks/Materials here are for educational purposes only and SHOULD BE VIEWED ONLY. If you download any files to view them, you are agreeing to delete them within a 24 hour period. It is strictly recommended to buy the products from the original owner/publisher of the products.

Disclaimer

2008-01-01T09:39:00.000-08:00

This blog is maintained for the personal use of the author, with the intention of creating a list of bookmarks of free e-books, tutorials, educational videos and other materials available on the net on SQL Server 2008. The author of this blog respects the copyright law and did not upload any of these materials. You can download materials from the links posted in this blog only if you agree with the User Agreements found at the bottom of this blog. Link will be removed as soon as any complaint received from the original publisher/author of the book/material.