Search results matching tags 'Speaking', 'User Group Meetings', and 'SQL Server 2008'

PASS PowerShell/SQL Server PreCon

AllenMWhite — Thu, 19 Aug 2010 19:17:00 GMT

PowerShell is an amazing tool to help you automate your administrative processes. There are a lot of books and online sources to help you learn PowerShell, but how do you learn how to use it with SQL Server? Simple, just sign up for my PASS PreCon session. Here's the outline:

Use PowerShell to Get the Most out of SQL Server

Module 1: Introduction to PowerShell

Cmdlets
Aliases
The Pipeline
Variables
Objects
Control Flow
Functions
Modules
Error Handling
Command-line Arguments

Module 2: Introduction to SMO

Introduction to the SMO Library
SQLPS.exe - The SQL Server Mini-Shell
The SMO Object Model

Module 3: Backup and Recovery

Backup
Restore

Module 4: Automating & Maintaining Databases

Automating Index Maintenance
Automating DBCC

Module 5: Importing, Exporting and Transforming Data

ADO.NET
Invoke-SQLCMD
Importing and Exporting using CSV Files
Importing and Exporting using XML Files

Module 6: Manipulating Database Objects

Creating and Deleting Schemas
Creating, Modifying and Deleting Tables
Creating, Modifying and Deleting Triggers
Creating, Modifying and Deleting Indexes
Creating, Modifying and Deleting Views

Module 7: Managing the Enterprise

Registering Servers
Creating a Central Management Server
Connecting to a Central Management Server
Running Scripts Against Multiple Servers
Defining Policies for Policy-Based Management
Evaluating Policies for Policy-Based Management

Module 8: Profiling and Monitoring SQL Server

Gathering WMI Information
Gathering Performance Counters
Setting up a Server Side Trace
Monitor Log Growth

Module 9: Configuring and Tuning SQL Server

Setting Configuration Options
Setting Windows Mode or Mixed Mode

As you can see, we're going to spend the first part of the day learning the basics of PowerShell, but the focus is on how you can manage your own environment using this powerful language, so you can spend your time solving problems instead of the constant point-and-click drudgery of typical DBA tasks.

The all-day session is reasonably priced, and you'll come away with scripts to help you put this tool into use right away. Check out the session details at Use PowerShell to Get the Most out of SQL Server.

See you there!

Allen

Speaking at SQLSaturday #33 in Charlotte

AllenMWhite — Thu, 04 Mar 2010 15:33:00 GMT

I'll be presenting two sessions this Saturday (March 6, 2010) in Charlotte - Automate SQL Server Administration with PowerShell and Gather SQL Server Performance Data with PowerShell. The event takes place at the Microsoft Charlotte Offices on 8050 Microsoft Way, Charlotte, NC 28273. For more information please visit SQLSaturday.com or email us at sqlsaturday#33@sqlsaturday.com.

I hope to see you there.

Allen

Speaking about Indexing

AllenMWhite — Mon, 08 Feb 2010 14:05:00 GMT

I'll be presenting two sessions this week (February 9 and 11, 2010), both on SQL Server Indexing.

The first is for the PASS AppDev Virtual Chapter, and will take place on Tuesday at noon EST.

You can attend the meeting via this link: https://www323.livemeeting.com/cc/usergroups/join?id=8PQHN2&role=attend

The second will be the same presentation at the Northeast Ohio SQL Server Users Group at the Microsoft office in Independence Ohio.

You can reserve a seat here: http://www.bennettadelson.com/seat.aspx?sig=sql&ID=210.

I hope to see you there.

Allen

[Nashville] Presentation: Administering SQL Server 2008

AllenMWhite — Thu, 23 Apr 2009 14:26:00 GMT

As many of you know I run marathons. My next one is on Saturday in Nashville, the Country Music Marathon. Timing sometimes is our best asset, and so it is here in that the Nashville SQL Server Users Group is meeting on Friday at noon.

They were kind enough to ask me to do my presentation on new features and administering SQL Server 2008. In this discussion, I will give an overview of SQL Server 2008 and the wealth of features aimed at the DBA. In this demo-fest of features you will see ways to make administering SQL Server easier and faster such as Centralized Data Management, Performance Data Warehouse, Resource Governor, Backup Compression and more.

I hope to see you there, and then again Saturday morning along the marathon course to cheer me to finish my 24th state, in pursuit of my goal of running a marathon in all 50 states.

Allen

User Group Presentation: Administering SQL Server 2008

AllenMWhite — Tue, 10 Mar 2009 11:32:00 GMT

We are pleased to invite you to the March 12th 2009 meeting of the Ohio North SQL Server Users Group (ONSSUG). The meetings are held on the 2nd Thursday of every month at 5:45 in the Cleveland Microsoft office. The address of the office is below:

Microsoft Corporation
6050 Oak Tree Blvd. Suite 300
Cleveland, OH 44131

Agenda:

Topic: Administering SQL Server 2008 by Allen White

At the March 12th, 2009, Ohio North SQL Server Users Group Meeting, Allen White will present on new features and administering SQL Server 2008. In this discussion, Allen will give an overview of SQL Server 2008 and the wealth of features aimed at the DBA. In this demo-fest of features you will see ways to make administering SQL Server easier and faster such as Centralized Data Management, Performance Data Warehouse, Resource Governor, Backup Compression and more.

Registration:

To register, go to www.bennettadelson.com/sql and click on the link "reserve your seat".

Allen