Browse by Tags

• Database Administration
• PASS Summit
• Service Broker
• SMO
• SQL Server 2008
• User Group Meetings

• Speaking - SQL Saturday 173, Washington DC

  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... Posted Wednesday, November 28, 2012 3:14 PM by AllenMWhite | 1 Comments Filed under: Database Administration, PowerShell, SMO, Speaking

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

  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... Posted Thursday, November 08, 2012 2:56 PM by AllenMWhite | 8 Comments Filed under: Database Administration, PASS Summit, PowerShell, SMO, Speaking Attachment(s): DBA-298-P Automate and Manage SQL Server with PowerShell Demos.zip

• [Speaking] PowerShell at the PASS Summit

  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... Posted Monday, October 29, 2012 11:49 AM by AllenMWhite | 2 Comments Filed under: Database Administration, PASS Summit, PowerShell, SMO, Speaking

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

  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... Posted Thursday, September 20, 2012 11:32 PM by AllenMWhite | 1 Comments Filed under: Database Administration, PASS Summit, PowerShell, SMO, Speaking Attachment(s): PowerShell101ForTheSQLDBA.zip

• Speaking - 24 Hours of PASS, Summit Preview Edition

  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... Posted Tuesday, September 18, 2012 10:26 PM by AllenMWhite | 1 Comments Filed under: Database Administration, PASS Summit, PowerShell, SMO, Speaking

• SQL Rally Presentations

  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... Posted Friday, May 11, 2012 10:48 AM by AllenMWhite | 4 Comments Filed under: Database Administration, PASS Summit, PowerShell, SMO, Speaking Attachment(s): 2012SQLRally.zip

• System Inventory and Performance Gathering SQL Connections Session

  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... Posted Thursday, March 29, 2012 12:44 PM by AllenMWhite | 0 Comments Filed under: Database Administration, PowerShell, SMO, Speaking Attachment(s): SQL325-Maintain SQL Server System and Performance Data with PowerShell.zip

• Speaking About SQL Server

  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... Posted Monday, March 12, 2012 3:32 PM by AllenMWhite | 1 Comments Filed under: Database Administration, PowerShell, SMO, Speaking

• [Speaking] Manage SQL Server 2012 on Windows Server Core with PowerShell

  This evening I'll be presenting a brand new session on installing and managing SQL Server 2012 with PowerShell. Here's the abstract: Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 Read More... Posted Tuesday, January 17, 2012 1:26 PM by AllenMWhite | 1 Comments Filed under: Database Administration, PowerShell, Speaking, User Group Meetings

• Speaking about Performance and PowerShell

  I'll be presenting at the South East Michigan SQL Server User Group (SEMSSUG) tonight. The session will be Gather SQL Server Performance Data with PowerShell . We all know how important it is to keep a baseline of performance metrics that allow us to Read More... Posted Thursday, December 08, 2011 12:37 PM by AllenMWhite | 1 Comments Filed under: Database Administration, PowerShell, Speaking, User Group Meetings

• SQLBits Presentation Materials

  After a week of data recovery (see my blog post here ) and travel via train with no internet access, I've finally been able to get my presentation materials together from the Training Day and two regular sessions I did at SQL Bits #9 in Liverpool last Read More... Posted Sunday, October 09, 2011 12:35 AM by AllenMWhite | 3 Comments Filed under: PowerShell, Service Broker, SMO, Speaking Attachment(s): Use PowerShell to Get the Most out of SQL Server.zip

• Getting Excited: SQLBits is Coming

  Other than changing planes once at Heathrow Airport, I've never been to England, so I'm getting really excited about traveling there next week for SQLBits 9 - Query across the Mersey ! My wife and I will be spending a couple of days in London first, and Read More... Posted Monday, September 19, 2011 11:59 AM by AllenMWhite | 1 Comments Filed under: PowerShell, Service Broker, SMO, Speaking

• [Speaking] Lots of Speaking Engagements in September and October

  As Adam Machanic said, Fall is the busy season for speaking, and it will be for me. Here's a brief list of what's coming up: On Saturday, September 17 I'll be in Kalamazoo, Michigan for SQL Saturday #84 , where I'll be presenting my Automate Policy-Based Read More... Posted Monday, August 22, 2011 9:38 AM by AllenMWhite | 0 Comments Filed under: PowerShell, Service Broker, Speaking, User Group Meetings

• Speaking at SQL Saturday 61 in Washington DC

  The organizers of SQL Saturday #61 in DC (actually Reston, VA) created an Advanced DBA/Dev track for their event, which I think is cool. Both of the presentations I'll be doing there on Saturday are in that track. (In fact, they're the first two sessions Read More... Posted Thursday, December 02, 2010 10:34 AM by AllenMWhite | 1 Comments Filed under: PowerShell, Speaking, SQL Server 2008

• [Speaking] Scripting SQL Server Objects with PowerShell

  In conjunction with the launch of Red Gate's SQL Source Control product, I'm presenting a webinar on Thursday, November 18 at noon EST. I'll present an introduction to PowerShell for those who've never seen it, walk through the basics of the SQL Server Read More... Posted Wednesday, November 17, 2010 9:21 AM by AllenMWhite | 2 Comments Filed under: PowerShell, SMO, Speaking