Search results matching tags 'PowerShell' and 'PASS Summit'

Speaking - Tech Ed, Tech Ed, SSWUG, PASS

AllenMWhite — Wed, 22 May 2013 18:48:00 GMT

I feel like I've hit the speaker's lottery this year, starting with SQL Cruise Miami, and it just keeps getting better! After a great trip to SQL Bits I'm now preparing for my travel to New Orleans for more great SQL fun!

In early June I'll be speaking at Tech Ed North America, this year in New Orleans. I'll be presenting the same session later in June at Tech Ed Europe, in Madrid. Here's the session details:

Maintain SQL Server System and Performance Data with PowerShell
Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

I've also been selected to be part of the SSWUG.org Summer Camp 2013 Conference and will present multiple sessions that you can view online, starting July 9.

Today the announcements were made regarding the PASS Summit 2013 presentations. I'm happy to say that I was selected again this year, and this time I'm presenting a brand new session, in the BI Dev Track!

Automate Your ETL Infrastructure with SSIS and PowerShell
Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.

I have a special fondness for the PASS Summit. My first Summit was in November of 2003, and there I met many amazing and wonderful people, including Johan Bijnens, Morten Baden Rohde, Brian Knight, Steve Jones, Andy Warren, Kevin Kline and many more. Each year I've gone back I've renewed those friendships and made many more. I've been fortunate to have been selected to speak again this year and am excited to see everyone again this year in Charlotte.

I look forward to seeing you there.

Allen

PASS Summit 2012 PreCon - DBA-298-P Automate and Manage SQL Server with PowerShell

AllenMWhite — Thu, 08 Nov 2012 18:56:00 GMT

On Tuesday I presented an all-day pre-conference session on using PowerShell to automate and manage SQL Server. It was a very full day and we had a lot of great questions. One discussion in Module 6 was around scripting all the objects in a database, and I'd mentioned the script I wrote for the book The Red Gate Guide to SQL Server Team-based Development. When putting together the demos for the attendees to download I realized I'd placed that script in the Module 6 folder, so you don't need to go anywhere special to get it, it's there.

I've attached the demo material to this blog post, and those of you who stayed with me until the end of the day know the password for the file, and to the rest of you, please respect that these people paid to attend the session and the material is exclusively for them.

Thanks to everyone who attended!

Allen

[Speaking] PowerShell at the PASS Summit

AllenMWhite — Mon, 29 Oct 2012 14:49:00 GMT

Next week is the annual PASS Summit, the event of the year for those of us in the SQL Server community. We get to see our old friends, make new friends, and learn an amazing amount about SQL Server, and it'll be in Seattle, so it's close to the mother ship. I love having Microsoft close, because it's easier to get to know the people who actually make this amazing product we spend our lives working with.

This year I'm fortunate to have been selected to present three sessions. One is a regular session called Manage SQL Server 2012 on Windows Server Core with PowerShell, where I'll be showing you how to set up and install SQL Server 2012 on Windows Server 2008 R2 and Windows Server 2012 Server Core, with some cool things that make that setup easy to manage. I'm also doing a Spotlight session called Maintain SQL Server System and Performance Data with PowerShell, where I'll show you how to create a database to contain the inventory of the servers you manage, and how to gather performance metrics, all with PowerShell.

On Tuesday, I'll also be doing a pre-conference session all day called Automate and Manage SQL Server with PowerShell. I truly enjoy spending the day with this session. We start out with an introduction to PowerShell, because you really need some basics before the more advanced topics make sense. This is not a comprehensive PowerShell course, because that would take days, but the introduction will give you enough to truly get started.

Once we get the basics down, we'll dive into Server Management Objects (SMO), because the SQL Server team built this interface specifically for managing SQL Server. You may love SMO or you may hate it, but understanding its structure will help you automate your tasks as you manage your environment. We'll get into the various activities a DBA is expected to manage and walk through scripts that solve those problems. As the day goes on we'll get into managing Central Management Server and Policy-Based Management, and we'll cover the topics in the other sessions I'll be doing on Wednesday. We'll also see how much more important PowerShell is in Windows Server 2012 than ever before.

If you haven't sensed the excitement about the upcoming PASS Summit, check it out, and I hope to see you there!

Allen

24 Hours of PASS - PowerShell 101 for the SQL Server DBA

AllenMWhite — Fri, 21 Sep 2012 02:32:00 GMT

Thanks to everyone who came out for the session today. It was a lot of fun and I hope you had a great experience as well. I've attached the demo scripts and slide deck to this post, and I look forward to seeing you in November at the PASS Summit!

Allen

Speaking - 24 Hours of PASS, Summit Preview Edition

AllenMWhite — Wed, 19 Sep 2012 01:26:00 GMT

There's so much to learn to be effective with SQL Server, and you have an opportunity to immerse yourselves in 24 hours of free technical training this week from PASS, via the 24 Hours of PASS event.

I'll be presenting an introductory session on PowerShell called PowerShell 101 for the SQL Server DBA. Here's the abstract:

The more you have to manage, the more likely you'll want to automate your processes. PowerShell is the scripting language that will make you truly effective at managing lots of servers. But it's more than just a scripting language - it's an interactive shell that stores data for you and allows you to implement ad-hoc solutions quickly and easily. Within the PowerShell environment you can easily manage both SQL Server instances and the Windows servers themselves, giving you a 'best of both worlds' environment that puts you in control. This session will introduce you to PowerShell and show you how to use it to manage SQL Server across many instances.

I look forward to seeing you there.

Allen

SQL Rally Presentations

AllenMWhite — Fri, 11 May 2012 13:48:00 GMT

As I drove to Dallas for this year's SQL Rally conference (yes, I like to drive) I got a call asking if I could step in for another presenter who had to cancel at the last minute. Life happens, and it's best to be flexible, and I said sure, I can do that. Which presentation would you like me to do? (I'd submitted a few presentations, so it wasn't a problem.)

So yesterday I presented "Gathering Performance Metrics With PowerShell" at 8:45AM, and my newest presentation, "Manage SQL Server 2012 on Windows Server Core with PowerShell" at 1PM at the conference here in Dallas. The room was packed for both sessions and I truly appreciate every one of you who attended and there were great questions in both sessions.

I've attached a zip file containing the slide decks from both presentations along with the demo scripts. I hope you get as much out of using PowerShell with SQL Server as I have, and Thanks!

Allen