SQL Server 2005 Manageability Demos
SQL Server 2005 Video Presentations: Enterprise Data Management
Microsoft SQL Server 2005 provides many new and improved data-management tools that focus on making it simpler and easier to deploy, manage, and optimize enterprise data and analytical applications. The following rich media presentations provide an overview of these new Business Intelligence (BI) capabilities.
SQL Server 2005 Video Presentation: Enterprise Data Management, Introduction
The size and number of databases a company needs to manage is continually increasing. Keeping up with this growth puts a significant burden in IT environments. SQL Server 2005 helps alleviate this pressure by reducing the amount of time spent on routine tasks. This makes IT staff more efficient and helps effectively manage the security, performance, and availability of their database servers.
SQL Server 2005 Video Presentation: Enterprise Data Management, Activity Monitoring and Profiling
When database performance goes down, it can mean unhappy customers and lost revenue for your business. Database administrators (DBAs) can use the SQL Server 2005 Activity Monitoring and Profiler to get a look at what is happening on the server, and then take appropriate action to bring the server to regular functioning quickly.
SQL Server 2005 Video Presentation: Enterprise Data Management, Data Management Views Reports
SQL Server 2005 includes a wide range of new and improved reports called Dynamic Management Views (DMV). DMV Reports give DBAs a greater transparency across multiple aspects of database health and performance. SQL Server 2005 includes over 70 DMV Reports for comprehensive views of performance data and recommendations for improving database performance.
SQL Server 2005 Video Presentation: Enterprise Data Management, Maintenance Plans
Scheduling a maintenance plan is much easier for administrators with SQL Server 2005. DBAs use enhanced tools to set up, create, and manage maintenance plans that provide a workflow of the tasks required to make sure the database performs well, making them more efficient at their jobs.
SQL Server 2005 Video Presentation: Enterprise Data Management, SQL Server Management Studio Walkthrough
The new SQL Server Management Studio saves time and makes it easier for administrators to manage servers, databases, and users. By consolidating many of the tools and functionality previously located in different places in SQL Server, DBAs can effectively manage instances of SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS), as well as objects, tables and views, user accounts, scripts, and maintenance tools in a single, integrated environment.
SQL Server 2005 Video Presentation: Enterprise Data Management, Database Tuning Advisor
When there is a great deal of database activity, the server has to work hard to extract and render all the relevant data quickly. Previously, indexes had to be created while the database was offline, increasing downtime. With SQL Server 2005 Database Tuning Advisor, indexes can now be created, rebuilt, or dropped without taking the database offline.
SQL Server 2005 Video Presentation: Enterprise Data Management, DDL Triggers
In SQL Server 2005, new data-definition language (DDL) triggers can be used to improve security monitoring of a company’s data. DDL triggers can log and audit changes to your database whenever a table has been altered. Administrators can also set up notification whenever a trigger is executed to proactively notify users.
SQL Server 2005 Video Presentation: Enterprise Data Management, Conclusion
Improve the efficiency of database management by using the new and improved tools in SQL Server 2005. This does not just make your IT more efficient, it also provides additional benefits in the form of better security, better performance from your database applications, reduced downtime, and increased availability. DBAs are no longer burdened by mundane tasks, and are able to focus on helping organizations extend their business and take advantage of new opportunities. This saves businesses money and improves the company’s bottom line.
Managing and Administering SQL Server 2005 Webcast
In this session, we look at some of the new features included in SQL Server 2005 for database administrators and IT professionals. We cover the new administration tools in SQL Server 2005, including SQL Management Studio. We take a look at SQL Server Express 2005, which is a light version of SQL Server 2005 designed to replace MSDE. We also look at SQLCMD, the new command-line utility, and its graphical version built into SQL Management Studio. We spend some time on SQLMail, the new SMTP-based replacement for SQLMail, before finally exploring some of the maintenance and performance tools included with SQL Server 2005, including maintenance plans, SQL Profiler, and SQL Server Agent.
Managing and Administering SQL Server 2005: SQL Server Management Studio, Part 1 of 7
In this demonstration, we show how to use the SQL Management Studio to perform common administration tasks.
Managing and Administering SQL Server 2005: Backup and Restore, Part 2 of 7
In this demonstration, we show how to use SQL Server Management Studio to create backup devices, backup databases and transaction logs, and perform restores.
Managing and Administering SQL Server 2005: SQL Server Configuration Manager, Part 3 of 7
In this demonstration, we see how to use SQL Server Configuration Manager to manage local and remote SQL Server configurations.
Managing and Administering SQL Server 2005: SQLCMD, Part 4 of 7
In this demonstration, we show some of the features of the new command-line utility, SQLCMD.
Managing and Administering SQL Server 2005: Database Tuning Advisor, Part 5 of 7
In this demonstration, we show how to use the Database Tuning Advisor to analyze workload and optimize database indexes.
Managing and Administering SQL Server 2005: Database Maintenance Workflow, Part 6 of 7
In this demonstration, we show how to create Database Maintenance Plans in SQL Server 2005.
Managing and Administering SQL Server 2005: Monitoring Tools, Part 7 of 7
In this demonstration, we show some of the monitoring tools available in SQL Server 2005.
