Allen White

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 #41 - Presenting and Loving it!

AllenMWhite — Tue, 09 Apr 2013 15:56:00 GMT

For this T-SQL Tuesday Bob Pusateri asked us to share how we came to love presenting. Before I ever got involved in computing technology I had (and still have) a love for the theatre, specifically musical theatre. When I was little the majority of albums...(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 Women In Technology Luncheon

AllenMWhite — Thu, 08 Nov 2012 19:26:00 GMT

My final stint at the Summit Blogger's Table(tm) is for the annual WIT luncheon. I do appreciate the honor that PASS conferred on me by inviting me to the "table" for the event, it's been a lot of fun (even if there were some moments that weren't.) Newly-elected...(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)

PASS Summit 2012 Day Two Keynote

AllenMWhite — Thu, 08 Nov 2012 16:02:00 GMT

Summit day two is upon us and we're anticipating another exciting keynote. Nice video of international attendees at the start of the keynote focusing on the global community. Doug McDowell came out and talked about how much great content is going on simultaneously...(read more)

PASS Summit 2012 Day One Keynote

AllenMWhite — Wed, 07 Nov 2012 17:53:00 GMT

Today is the official start to the 2012 PASS Summit and I'm honored to have a seat at the Blogger's Table again. This is a set of tables set up in the back of the keynote room for people who blog frequently (I know) to share their thoughts on the keynote...(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)

Search For a Query in RDL Files with PowerShell

AllenMWhite — Tue, 16 Oct 2012 18:58:00 GMT

In tracking down poorly performing queries for clients I often encounter the query text in a trace file I've captured, but don't know the source of the query. I've found that many of the poorest performing queries are those written into the reports the...(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)

Speaking - Red Gate's SQL in the City

AllenMWhite — Wed, 12 Sep 2012 00:43:00 GMT

The great folks at Red Gate have invited me to join the festivities at the SQL in the City events in both Chicago on October 5, and in Seattle on November 5. In both cities I'll be presenting a session entitled Automated Deployment: Application And Database...(read more)

T-SQL Tuesday #34: Help me, Obi-Wan Kenobi, You're My Only Hope!

AllenMWhite — Tue, 11 Sep 2012 01:58:00 GMT

This T-SQL Tuesday is about a person that helped you understand SQL Server. It's not a stretch to say that it's people that help you get to where you are in life, and Rob Volk ( @sql_r ) is sponsoring this month's T-SQL Tuesday asking who is that person...(read more)