Allen White : SMO

New Article on the SQL Server 2012 Backup and Restore PowerShell Cmdlets

AllenMWhite — Mon, 13 May 2013 13:08:00 GMT

While I was on vacation last week in Scotland Simple Talk published a new article I wrote called Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets. Hope you have as much fun with it as I did writing it. Allen...(read more)

T-SQL Tuesday #39: Managing your SQL Server Services with PowerShell

AllenMWhite — Tue, 12 Feb 2013 18:09:00 GMT

This T-SQL Tuesday is about using PowerShell to do something with SQL Server. Now, if you've read any of my blog posts you probably know I've been using PowerShell to do things with SQL Server for a while now, but I'm glad Wayne decided on this topic...(read more)

Speaking - SQL Saturday 173, Washington DC

AllenMWhite — Wed, 28 Nov 2012 19:14:00 GMT

After a great time at the PASS Summit in Seattle I'll be once again presenting on PowerShell for SQL Server at SQL Saturday #173 in Chevy Chase, Maryland. On Friday, December 7 I'll be presenting my full day session Automate and Manage SQL Server with...(read more)

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,...(read more)

[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...(read more)

Scanning the Error Log with PowerShell

AllenMWhite — Tue, 25 Sep 2012 18:33:00 GMT

One of the most important things you can do as a DBA is to keep tabs on the errors reported in the error log, but there's a lot of information there and sometimes it's hard to find the 'good stuff'. You can open the errorlog file directly in a text editor...(read more)

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! Alle...(read more)

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...(read more)

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....(read more)

Script and Migrate Agent Jobs between Servers using PowerShell

AllenMWhite — Wed, 02 May 2012 15:36:00 GMT

I'm nearing the end of a SQL Server upgrade project, migrating from SQL Server 2000 to SQL Server 2008 R2. The company uses SQL Server Agent to run about 150 jobs which execute DTS packages to do the work of moving data around. Now, there are any number...(read more)

System Inventory and Performance Gathering SQL Connections Session

AllenMWhite — Thu, 29 Mar 2012 15:44:00 GMT

Yesterday I delivered a session on maintaining a system inventory and gathering performance data with PowerShell. The session went well and I had great questions and I'd like to thank everyone who attended the session. I've attached the slides and demo...(read more)

Speaking About SQL Server

AllenMWhite — Mon, 12 Mar 2012 18:32:00 GMT

There's a lot of excitement in the SQL Server world right now, with the RTM (Release to Manufacturing) release of SQL Server 2012 , and the availability of SQL Server Data Tools (SSDT) . My personal speaking schedule has exploded as well. Just this past...(read more)

Load Perfmon Log Data into SQL Server with PowerShell

AllenMWhite — Sat, 03 Mar 2012 19:12:00 GMT

In yesterday's post I showed you how I set up performance data gathering in an environment where I can't directly update my analysis database. Today I'll show you how I load that data into SQL Server for the analysis. First, I create tables to contain...(read more)

Setup Perfmon with PowerShell and Logman

AllenMWhite — Fri, 02 Mar 2012 21:34:00 GMT

In a session yesterday I was reminded of the power of a tool on every server, Logman, to manage performance data gathering. It's a pretty amazing tool, and I'm starting to get to know how much more it can do than I've even considered, but here's a simple...(read more)

Getting Job History Correctly

AllenMWhite — Fri, 02 Mar 2012 02:03:00 GMT

In my last blog post I walked through a way to grab the duration from the EnumHistory method of the JobServer/Job object. As I worked through getting a solution in place for a client I found that the duration calculation was only part of the problem....(read more)