Home » Uncategorized » Currently Reading:

Friday Funtime: Contest, Powershell, Preview!

May 7, 2010 Uncategorized 1 Comment

Hi guys!  Here are your new and exciting updates for today, plus a PowerShell tip:

  • Contest: We haven’t announced the prize yet, but dont let that stop you from getting a big celebrity to Tweet about @MidnightDBA!  Biggest celebrity wins (the president, Bill Gates, and anyone from the cast of Star Trek Next Generation are instant wins!) Deadline is next Wednesday.
  • New house update: More of the same paperwork tango with the mortgage company. Who knew they’d want so much proof of income for a lousy six figure loan?
  • SQL Saturday #35 is filled to the brim with sponsors, and we’re insanely grateful. REALLY looking forward to a great conference.
  • On the web: David Levy has been kind enough to compile a list of Powershell links here. He’ll be adding a link to our Powershell videos tonight.
  • Powershell Tip: Did you know you can open Powershell from SSMS? Just right click any object in the Object Explorer window and select Start PowerShell. A PS window will open, and the file path will be set to the level of that object! For example, if you right clicked the database AdventureWorks in your default instance, your Powershell prompt would be set at PS SQLSERVER:\SQL\Default\ServerName\Databases\AdventureWorks>   That’s mighty convenient!
  • DBAs@Midnight webcast – We got lots of new talking point ideas from you guys last night on Twitter.  Keep them coming, in comments, email, or Twitter! I also just posted our first webshow preview on YouTube, showing scenes from this coming Monday’s show:


Happy, happy days!

Currently there is "1 comment" on this Article:

  1. [...] This post was mentioned on Twitter by Jen & Sean McCown. Jen & Sean McCown said: Blog: Friday Funtime: Contest, Powershell, Preview! http://bit.ly/bLUYqz Exciting updates for today, plus a #Powershell tip! #dbasat0000 [...]

Comment on this Article:

Minion Reindex by MidnightDBA is here!


Excellent Index Maintenance

Download Minion Reindex, log feature requests, read documentation, and sign up for the newsletter at MidnightSQL.com/Minion!

Monday, Oct 27 12:00PM CDT: Attend the Minion Reindex Intro Webinar.

MidnightSQL Consulting

Need help? Got an emergency? Write us at Support@MidnightDBA.com!

We can schedule time to help with your backup/restore issues, high availability and disaster recovery setup, performance problems, and a great deal more. Very often, we're even available on the moment for downtime issues and emergencies.

For more information about MidnightSQL consulting, email us or check out www.MidnightSQL.com. Happy days!

Where are We?

November 3-7: PASS Summit, Seattle, WA

PASS Summit: Jen is presenting How to Interview a DBA: A Panel Debate on Thursday 11/6 1:30pm, room 401 (along with Adam Machanic, Sean McCown, Bob Pusateri, and Michelle Ufford).

PASS Summit: Sean is presenting Performance Tuning Your Backups on Wednesday 11/5 3:00pm, room 602-604.

December 11: Presenting "Powershell Cmdlets.." at Alaska SQL Server User Group

January 30: "Become an Enterprise DBA" precon at Austin SQL Saturday

Blog Posts by Category


How to Eat Pop-tarts
Watch DBAs@Midnight live on Fridays,m 11pm Central time

The best database career advice you’ve never heard!


The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!

Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)

Become a DBA. Become a BETTER DBA. Use the Roadmap.

Visit www.DBARoadmap.com for info, forums, and more!

Add to Cart View Cart

Cunningham’s Law

"The best way to get the right answer on the Internet is not to ask a question, it's to post the wrong answer."
Relevant: http://xkcd.com/386/