I’ve been meaning to post this for months but I’ve been a bit busy. Better the day before than never right? I’m Speaking at TechEd!!!!
In addition to speaking Tuesday morning, I will be answering questions at the SQL Server booths (there’s 12 of them):
Monday from 12-2 and again from 5:30 – 7:30
Tuesday from 3 – 5
Wednesday 10:30 – 1
Thursday 10:30 – 1
If you’re at the conference and you have questions about SQL Server (especially if they involve PowerShell) I hope you’ll stop by!
P.S. The easiest way to find where the SQL Server booths are is to head over to the Porsche the Visual Studio team is giving away.
I did another webcast for the Secrets of SQL Server webcast series today. In the today’s webcast we built on some things I had demoed in a prior webcast and showed how PowerShell in conjunction with SQLPSX can really help you solve some common problems DBAs face.
I showed how you could pull size and free space information from all of your data files, then used the same technique to pull size information from all of your tables across every database on an instance. Later we created a database and some tables, and then showed how to do some basic login comparisons, all with SQLPSX.
In addition, we stored the results of the frees pace and table size information in a database using the Out-DataTable and Write-DataTable functions. Finally we wrapped up with a quick demo on how the new SQL Server cmdlets inside of the SQLPS Module in Denali combined with some new functionality in PowerShell v3 CTP1 can really make backing up a database with PowerShell a lot easier.
Here’s what you’ll need to recreate today’s demos;
I hope I see you next week at the PASS Summit or next month during another webcast, this time on customizing your own functions to work with the SMO.
PowerShell takes the Pole at SQLRally!
PowerShell has taken the Pole for the DBA division at SQLRally! Come see why the organizers have chosen this session to lead the pack to the Green Flag.
We will be covering new ground, not rehashing last year’s PASS Summit presentation. I have developed several new examples for leveraging PowerShell in your everyday DBA role since then. I am promising 6 new scripts for everyone but if I get on a role that number might be closer to 10 when they drop the green flag on this year’s event.
If you’ve never used PowerShell before don’t worry. We will spend a few minutes on a ‘get up to speed lap’ so everyone is going at the same pace when we step on the gas with all this new material. All scripts will be made available for you to download during the session and access later on from pit-row.
After my session here’s what I’ll be checking out:
What sessions I'll be checking out during SQLRally