This coming April 16 - 20, the Spring 2016 SQL Intersection conference will be held at the Walt Disney World Swan hotel, and I'll be presenting two sessions this year.Get Near Realtime ETL with Service Broker Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? You need to get the ...

On Saturday I'll be presenting one of my favorite sessions, Manage SQLServer Efficiently w/PowerShell Remoting, at the Las Vegas SQL Saturday.  Here's the abstract:You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell ...

This morning I presented my session Manage SQL Server System and Performance Data with PowerShell at Tech Ed NA in New Orleans. We had a good sized audience who were very responsive and had many great questions. I had a great time presenting and the feedback I've gotten so far tells me the audience enjoyed it as well. I really appreciate ...

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 PowerShell. Here's the abstract: This soup-to-nuts all day session will first introduce ...

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 ...

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 ...

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

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 ...

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 ...

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 scripts from the session for your use. Allen