Search results matching tags '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

[Ohio] A Day in the Life of the DBA 2008

AllenMWhite — Mon, 06 Oct 2008 12:37:00 GMT

We are pleased to invite you to the October 9th 2008 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:

5:00 - 5:45 PM - Early Arrival/Discussions

Deepak Puri offered to present information that he found interesting from the 2nd Annual Microsoft BI Conference. Deepak has presented to the group following SQL Pass and other conferences and does an outstanding job of synthesizing the most important highlights from the conference.

5:45 - 6:00 PM - Dinner

6:00 - 7:00 PM - A Day in the Life of the DBA 2008 by Buck Woody, Microsoft

This presentation details a typical DBA's day, demonstrating the new improvements of the Management Platform made for Microsoft SQL Server 2008. These improvements include more efficient system management, multi-server management, performance tracking, policy creation, state detection and enforcement, and using both graphical and command-line tools. We will cover everything from the new Management Interfaces to Policy Based Management, including a practical demonstration of PowerShell integration in SQL Server administration tasks.

About Buck

As a program manager for Microsoft SQL Server, Buck Woody provides leadership on feature sets within SQL Server, as well as leads team of developers and testers. Buck is also responsible for the documentation, user-experience, and the legal and marketing professionals for the feature sets. Find out more at http://buckwoody.com/BResume.html.

7:00 - 7:30 PM - Wrap up / Ongoing discussions

Registration:

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

Allen

SQL 2008 Data Compression - Linchi Shea

AllenMWhite — Fri, 26 Sep 2008 14:07:00 GMT

Last night at the NYC SQL Server Users Group meeting Linchi Shea presented a session on Data Compression (not Backup Compression) in SQL Server 2008.

By understanding how the compression algorithm works, and tuning your clustered indexes based on that understanding, you can achieve some pretty incredible space savings on disk, and performance benefits due to the increased amount of data loaded into cache. His analysis is available from his blog post SQL Server 2008 Data Compression: Impact of Data Distribution.

His explanation was clear and I learned a lot from his session. (I am in New York to do some performance testing at the Microsoft Technical Center, where the meetings are held every Fourth Thursday of the month.)

If you happen to be in New York and can spare the time, I highly recommend this group. It was well worth my time.

Allen

Introduction to the New Data Types in SQL 2008

AllenMWhite — Tue, 09 Sep 2008 17:57:00 GMT

We are pleased to invite you to the September 11th 2008 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:

5:00 - 5:45 PM - Early Arrival/Discussions

Due to technical difficulties we did not get to see the Demonstrations of Excel 2007 BI. These technical difficulties will be remedied and Deepak will show the Excel Demos from the August Meeting.

5:45 - 6:00 PM - Dinner

6:00 - 7:00 PM - Introduction to the New Data Types in SQL 2008 by Sarah Dutkiewicz

SQL 2008 introduces 7 more data types. Come see Sarah Dutkiewicz as she walks us through the new datetime, hierarchical, and geospatial data types and see how they can be used.

About Sarah

Sarah Dutkiewicz has been developing database-driven applications over the past few years. When she isn't working as a developer for a Cleveland-based company, she's looking into new technologies and staying involved in the .NET community. Her blog is at http://www.codinggeekette.com.

7:00 - 7:30 PM - Wrap up / Ongoing discussions

Registration:

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

Allen

SQL Saturday 6 - Cleveland August 9

AllenMWhite — Fri, 27 Jun 2008 11:42:00 GMT

Wow, it's been a crazy month! Two weeks of Tech Ed in Orlando, where I spent time helping people with questions on SQL Server in the Database Platform area and presented two sessions on SMO and PowerShell (one with my friend Peter Ward from Australia). Then, my last week as a DBA at Advanstar, followed by my first week as a Trainer for Scalability Experts! Wow.

So I wanted to get the word out about our upcoming SQL Saturday event in Berea, Ohio, on the campus of Baldwin-Wallace College. If you're going to be in the area, or if this will provide motivation to come to Cleveland, it should be a great event. I'm hoping to have about 30 sessions on SQL Server, both how to do things now, and how you'll be able to do things much easier with SQL Server 2008.

The Call for Abstracts is open, so if you're interested in presenting, please submit your session idea here.

If speaking isn't your strong suit but you'd like to attend we'll be happy to have you. The link to register is here.

The morning sessions will each be an hour long, in the Math and Computer Science building, and the afternoon sessions will be 75 minutes each, and be held in larger rooms in Strosacker Union. We'll have a box lunch on the picnic tables behind the Union (weather permitting) and a nice wrapup after the sessions with some great giveaways, including a full MSDN Team Suite subscription!

I look forward to seeing you at SQL Saturday, and perhaps meeting some of you in my teaching assignments with Scalability Experts!

Allen

Ohio North SQL Server Users Group February Meeting - Moved to February 21

AllenMWhite — Mon, 11 Feb 2008 13:58:00 GMT

Normally our meetings are on the second Thursday of the month, but this year that falls on Valentine's Day, so we've moved the meeting to Thursday, February 21.

Here's the agenda for the February meeting of the Ohio North SQL Server Users Group:

5:00 - 5:45 PM - PASS Chapter Acceptance/SQL 2008 Heroes Happen Here: Presentation Tips and Tricks - Allen White

The Ohio North SQL Server Users Group is now officially a PASS chapter. We'll present the PASS Welcome presentation, followed by a "Heroes Happen Here" presentation on how to deliver quality presentations, because you have something interesting to share with the rest of us, and this presentation will show you some of the ways the top presenters get their message across effectively.

5:45 - 6:00 PM - Dinner

6:00 - 7:00 PM - Change Tracking and Change Data Capture in SQL Server 2008 - Bill Wolohan, Bennett-Adelson

SQL Server 2008 has 2 new features that can notify you when your data changes. Both are easy to set up and do not require you to create triggers on each table. Change Tracking requires less overhead, but Change Data Capture gives you more detail. This presentation will explain how each of these features works and when you might use one or the other.

Registration: Go to http://www.bennettadelson.com/sql and click on the link "reserve your seat".

I look forward to seeing you there!

Allen