This event has ended

Get to Know PowerShell: Analyzing and Managing SQL Server

Data Education

Monday, November 14, 2011 at 9:00 AM - Wednesday, November 16, 2011 at 5:00 PM (EST)

Waltham, MA

Get to Know PowerShell: Analyzing and Managing SQL...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Get to Know PowerShell: Analyzing and Managing SQL Server Ended $1,800.00 $0.00

Share Get to Know PowerShell: Analyzing and Managing SQL Server

Event Details

You have a lot of servers to manage, but less and less time to focus on each one. You've heard about PowerShell, but don't know where to start. That's about to change. In this course with renowned SQL Server DBA, architect, and developer Allen White, you'll learn PowerShell from top to bottom, from how to write and manage your scripts and your environment to how to manage SQL Server using this powerful tool. Students do not require any knowledge of PowerShell, since basics of the language will be discussed at the start of the course, yet experienced PowerShell users will also learn the amazing, foolproof methods that experts are using right now to manage SQL Server.

 

Day 1


Module 1: Intro to PowerShell

  • 1.1 Cmdlets
  • 1.2 Aliases
  • 1.3 The Pipeline
  • 1.4 Variables
  • 1.5 Objects
  • 1.6 Control Flow
  • 1.7 Functions
  • 1.8 Modules
  • 1.9 Error Handling
  • 1.10 Command-Line Arguments
  • Lab

Module 2: Intro to SMO

  • 2.1 Intro to the SMO Library
  • 2.2 SMO Objects
  • Lab

Module 3: Backup and Recovery with PowerShell

  • 3.1 Backup User Databases
  • 3.2 Restore a Database
  • 3.3 Restore the Master Database
  • 3.4 Restore to a Point-in-Time
  • Lab


Day 2


Module 4: Automating and Maintaining Databases

  • 4.1 Automatic Index Maintenance
  • 4.2 Automatic DBCC Checking
  • Lab

Module 5: Importing, Exporting, and Transforming Data

  • 5.1 Importing and Exporting Using CSV Files
  • 5.2 Importing and Exporting Using XML Files
  • 5.3 ADO.NET
  • 5.4 Invoke-SQLCMD
  • Lab

Module 6: Manipulating Database Objects

  • 6.1 Creating and Deleting Schemas
  • 6.2 Creating, Modifying and Deleting Tables
  • 6.3 Creating, Modifying and Deleting Triggers
  • 6.4 Creating, Modifying and Deleting Indexes
  • 6.5 Creating, Modifying and Deleting Views


Day 3


Module 7: Managing the Enterprise

  • 7.1 Registering Servers
  • 7.2 Creating a Central Management Server
  • 7.3 Connecting to a Central Management Server
  • 7.4 Running Scripts Against Multiple Servers
  • 7.5 Defining Policies for Policy-Based Management
  • 7.6 Evaluating Policies for Policy-Based Management
  • Lab

Module 8: Profiling and Monitoring SQL Server

  • 8.1 Gathering WMI Information
  • 8.2 Gathering Performance Counters
  • 8.3 Setting up a Server Side Trace
  • 8.4 Monitor Log Growth
  • Lab

Module 9: Configuring and Tuning SQL Server

  • 9.1 Setting Configuration Options
  • 9.2 Setting Windows Mode or Mixed Mode
  • Lab
Have questions about Get to Know PowerShell: Analyzing and Managing SQL Server? Contact Data Education

When & Where


Microsoft Technology Center
890 Winter Street
Suite 100
Waltham, MA 02451

Monday, November 14, 2011 at 9:00 AM - Wednesday, November 16, 2011 at 5:00 PM (EST)


  Add to my calendar

Organizer

Data Education

Data Education is a full-service training company, specializing in courses targeting DBAs, developers, and business intelligence professionals. Data Education brings the experts in the database field to its students, from bestselling SQL Server authors to the nation’s premier business intelligence consultants.

  Contact the Organizer
Terms and Conditions: If Data Education cancels the course, you will receive a 100% refund. Registration is fully transferable. If you cancel your registration with more than 30 days notice, Data Education will refund the fee minus $250 for processing. If you cancel your registration with between 16 and 30 days notice, Data Education will refund 75% of the fee. If you cancel your registration with between 7 and 15 days notice, Data Education will refund 50% of the fee. Cancellations will not be allowed as of 6 days before the beginning of the course.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.