Pages

Tuesday, December 7, 2010

PASS Summit Final Thoughts



I've got to figure out how to get to the PASS Summit every year!  It was AWESOME!


It was great to meet more of the tweeps I follow and reconnect with those that I've met before.
It was my first time to Seattle also.  The weather was better than expected. I had a great time walking around the city when time allowed. I also had the opportunity to try the local restaurants and visit the Space Needle.  Everything was great.  Especially the coffee at Top Pot Doughnuts.


Every time slot had several sessions I wanted to attend. You can't get to all the sessions you would like so buying the Conference DVDs is a must.  


Participating in my local PASS user group, SQL Saturdays, and Twitter made being a FIRST TIMER at this year's PASS Summit a non-issue. I did not feel like a FIRST TIMER. I knew a lot of people because of participating locally.  I just blended right in, had fun, and learned a ton.


Being a FIRST TIMER, I didn't realize I could download the slide decks before the DVDs arrive. A prompt from a co-worker made me aware of this benefit.  I downloaded over a dozen decks so far and reviewed them.  Great benefit. Still tons more to go through.


So, the most significant takeaways for me:
  1. Meeting Ola Hallengren and Paul Randal. Talking to them about Ola's Maintenance Solution was invaluable.
  2. The changes to the MCM programming have me thinking about making it a 2011 New Year's resolution. I'll have a post on that later.
  3. The Separation of Duties Framework that Lara Rubbelke and ll Sung Lee debuted has me thinking how to use it back in the real world.
Suggestions for next year:
  1. Any possibility of getting Youtube videos on the conference DVDs for the Top 10 highest rated sessions?
  2. Put Twitter handles on the conference badges.
  3. Select one of my speaker abstracts.  ;-)
I've told my manager that we should be sending a representative every year. No excuses.
I had a great time at my First PASS Summit! 

Friday, December 3, 2010

PASS Summit Day 3

The final day of the PASS Summit started off with a great keynote speech by Dr. David DeWitt Ph.D talking about SQL Query Optimization.  
Dr. DeWitt is currently a technical fellow at Microsoft leading the Jim Gray Systems Lab.  He said "Rocket Science is easier than query optimization." So, if you fail at query optimization, they send you to build rockets.  This was one of those presentations that will need to be watched multiple times before all the non-Ph.Ds like me assimilate everything. He did a great job explaining an unbelievably complex topic in terms most people can understand. It'll just take me a few passes to totally understand. I hope.


DBA Mythbusters
A fun interactive session with Paul Randal from SQLSkills.com with Buck Woody playing a supporting role. Buck said the interaction with Paul was not rehearsed. Too bad video doesn't make it on the conference DVDs.


The PowerShell Cookbook for the DBA by Joe Webb
Joe did an excellent overview of how a DBA can use PowerShell to automate repetitive tasks. You can download the scripts from the session here.


Consolidating data collection with SQLDIAG and analysing it all with SQLNexus by Chris Bolton
I went to this session because I need to get more comfortable with these tools.
Chris did a very thorough walkthrough of how to use SQLDIAG and SQLNexus.
I need to read his book next.  


Business Intelligence in SharePoint 2010 by Brian Knight
A very well-rehearsed, entertaining and educational session. The presenters were supposedly doing tequila shots the entire 90 minutes but they were still standing at the end of the presentation so I think something else was in the bottle.


My hope for this series of blog posts is to highlight just a few sessions that I found worthwhile.  I think the PASS Summit conference DVDs are a compulsory purchase when attending.  There are too many excellent sessions to attend in three days. I don't think you get the full value of the conference unless you buy the DVDs.





Wednesday, December 1, 2010

PASS Summit Day 2

Day 2 started off with Andy Warren's recommendation of Top Pot Doughnuts.  
I normally exercise in the morning so the walk down to Top Pot was a nice equivalent. 
Top Pot sits right in front of pylon 43 of the Space Needle monorail on 5th Street downtown.
They have the mother of all glazed donuts and excellent coffee.  Coffee so smooth I could drink it black. That's significant. I don't like black coffee. 


Day 2 was to be BI day for me at the PASS Summit but it quickly turned into the search for Ola Hallengren.  


I attended or wanted to attend the following sessions: 


Automate SQL Server Administration with PowerShell by Allen White
I've read a bunch of Allen's blog posts so I wanted to see him in person.  He did a broad overview of how to automate DBA tasks using PowerShell.  If you're a DBA wanting to learn PowerShell, Allen should be on your list of people of blog posts to read and one of your Follows on Twitter. I did see all of this presentation and introduced myself to Allen afterwards.


50 Surprising Features of SQL Server Business Intelligence by Amir Netz, Donald Farmer
I wanted to see this session after hearing Amir Netz speaking during the morning keynote but I really wanted to meet Ola Hallengren at the Summit.  So, I went searching for him. The power of Twitter helped me to get a description and picture of him.


Data Warehouse Design and Architecture Best Practices by Erik Veerman
I sat for the beginning of this presentation but then I heard Ola was in the Experts Area in the Expo hall so I bailed out.  I did find Ola in the Experts Area and we spoke for over an hour about his Maintenance Solution script.  We had a great conversation and I'm all the more convinced that we need to be using his script at my employer.


Business Intelligence End to End by Donald Farmer
This session was cancelled. I'm hoping it ends up on the DVDs somehow.


Another excellent day at the Summit.  It was great to meet Ola Hallengren in person! 

Wednesday, November 10, 2010

PASS Summit Day 1

Started the day off great with breakfast in the Daily Grill with @BrentO after he tweeted that he had three open spots at his table.  Can't let the dude eat breakfast alone.


I attended these sessions on Day 1 of SQL PASS.  Made it through the day with minimal impact from jet lag.


DBA283S "Virtualization and SAN Basics for DBAs" with Brent Ozar.
This man has a gift for imparting information in a funny and entertaining way.
Great stuff I can use to better understand what is happening at my workplace with links to even more information at his blog under his SAN and Virtual tags.
This one was voted most popular yesterday so it's today's Second Chance session. 


AD314 "Database Testing Overview" with Buck Woody and Alex Kuznetsov.
Buck and Alex gave an overview for properly testing a database before deploying new features.  Buck said Microsoft got one of its biggest black eyes from a one line change that had only one word changed.  Wow! You have been warned, test before your production deployments.


DBA448M "Si Se Puede! Achieving Separation of Duties with SQL Server"
Great session by Lara Rubbelke and Il-Sung Lee that introduced the new Codeplex project SQL Server Separation of Duties Framework.  This will be the first thing, I start exploring when I get back to the office.  Downloaded it last night to my laptop.  


PD193S "You're Not Attractive -  But Your Presentations Can Be"
My favorite session of the day!  This session was probably in a room that was the farthest from the main hub of the conference.  Commented on that when I entered the room and @BuckWoody called me an old man for the rest of the hour.  If he insults you, it's only because he loves you.


I'm a FIRST TIMER at the PASS Summit but I don't feel like one because of my participation in SQL Saturdays and Twitter. Glad I ordered the conference DVDs. Too many great sessions to attend all of them.  I think you don't get the FULL value of this conference without purchasing the DVDs. 
A great start to my week.

Thursday, November 4, 2010

SQL PASS Summit - a SQL geek vacation?

I'll be attending my first PASS Summit next week in Seattle, WA!

First, I'd like to thank my managers for sending me. Woohoo!

Second, mere words can't express how much I am looking forward to it but maybe this does...

I asked if I had to take my work laptop with me to the Summit.
The reply, "You're not going on vacation."
To this geek, it's damn near a vacation.
I think it's one of those events that I will need a vacation to recover from given how much is planned.

I attended virtually last year.  I watched all the available streaming events, followed the #sqlpass Twitter hashtag and convinced my manager to buy the conference DVDs.

I and many others are again using the #sqlpass hashtag to prepare for this Summit.  I still need to look at the schedule and plan my days but I do know I will definitely want to see Buck Woody and Brent Ozar in the same room doing their presentation.

I want to attend the session on how to write a speaker abstract, also.  I submitted two sessions for this Summit on PowerShell that weren't accepted.  I've enjoyed speaking at several PASS SQL Saturdays and I've set a goal to some day speak at the PASS Summit.  I've learned so much preparing for and participating in SQL Saturdays.  Also, I've gotten to know a great group of people in the process.  Participating in SQL Saturday and Twitter has prepared me to get the most from the PASS Summit because I already know many attendees and they've shared past experiences via these mediums to help the rookies get the most out of the Summit.

Kendal Van Dyke @SQLDBA has some great advice for first time attendees.  He tipped me off to the Light Rail option from the airport to downtown when I asked the SQL tweeps about getting to/from the airport.  He then wrote a blog post to cover a lot of other relevant topics.  Tom LaRock @SQLRockstar has put together the OC (Orientation Committee) and a preview to help the rookies have the best experience.  We meet on Monday before the Welcome Reception.

I'll be arriving Monday afternoon and leaving Friday morning. I'll be tweeting like everyone else so follow @RonDBA and #sqlpass for the live feed.

I'll be participating in "Where your SQL Saturday Shirt Tuesday". Look for the Florida SQL Saturday participants in their "Florida Print" shirts.  Hard to miss.

Looking forward to meeting you all!  Remember, YOU ARE NOT ON VACATION.  LOL.

Wednesday, October 20, 2010

SQL Saturday #49 - Orlando

My THIRD SQL Saturday of the year is behind me.

I spoke in Tampa #32 and South Florida #40 earlier this year.

Jack Corbett(@unclebiguns), Andy Warren(@sqlandy) and their volunteers did another EXCELLENT job on this event.

What I liked: 

The coverage via the #sqlsat49 Twitter feed.

The constant updates from Jack on the event via e-mail and twitter.

The large schedules on the wall in the hallways even though I stayed in the PowerShell room most of the day.

Liam Fitzpatrick’s Bangers & Mash with Sam Adams OctoberFest beer at Friday night’s speaker party sponsored by Confio Software 

Meeting the ScriptingGuy and ScriptingWife.  Nice people.  Funny guy.

The ScriptingGuy statue that @MaxTrinidad got as a gift. He wouldn’t let me touch it.

I REALLY liked that statue Max.  (c;

Why Learn PowerShell?

The tweet from the @ScriptingGuys while I was doing my session “Why Learn PowerShell” asking if I wanted to do a guest blog post for the Scripting Guy blog.

How about “If the Original Cylons Had Learned PowerShell, Would They Have Been replaced by CGI?”.

Maybe I should have learned PowerShell?

@z_williamson’s tweeting the color commentary for the sessions he attended. Beware don’t make a mistake when he’s in the room. One of the presenters had an incident with a lack of power to his laptop and blurts out “Don’t tweet that!”.  Too late, z_williamson had pulled the twitter trigger well before. I hope he’s going to the PASS Summit to provide coverage. I’d also like to thank him for taking pictures during my sessions.

A few quibbles:

The sponsor area.  Need to find another table arrangement that reduces the bottleneck in the  hallway.

Not enough Ninja T-shirts to go around. Seriously.  LOL. No, I’m kidding.

Moving on…

Hey, Tampa. Let’s do a Kung-fu SQL Saturday in 2011. Orlando is going Ninja next year.

The 2010 PASS Summit in Seattle is next for me. @RonDBA will be there.

I can’t say enough how valuable the SQL Saturday concept is for networking and staying current on SQL Server. If you want to get ahead, you need to attend.

Friday, September 17, 2010

Is PowerShell a Springboard?


I think so.

I've used PowerShell to learn about Automation, SMO, WMI and object-oriented programming for starters.  Also, I've automated compliance reporting and ID administration tasks with it.

On one occasion, I was troubleshooting a connectivity issue involving an app that used C#.
I was able to read the C# code and troubleshoot the issue because PowerShell's syntax is very similar to C#.

If I've piqued your interest, come to my session at SQL Saturday #49 in Orlando on October 16, 2010.

Friday, September 10, 2010

#sqlmovies

Yesterday's Twitter meme #sqlmovies was a lot of fun.

My entries and the movie they were derived from follow.

I, DBA is a play on the movie I, Robot.
The Hurt Blocker obviously from The Hurt Locker.
@WesBrownSQL's RT The Dead Locker was perfect.
Lost In SAN from Lost In Space.
And finally "what a query wants" from Amanda Byne's movie "what a girl wants"

Monday, August 23, 2010

Buy Lunch, Get Training FREE - SQLSaturday #49

I'll be speaking at my THIRD SQLSaturday of the year in Orlando.

I'm doing a mini session and a regular session.

The mini session is a condensed version of my Why a DBA Should Learn PowerShell talk. In 15 minutes, I hope to convince you that learning PowerShell is worth your time.
Powershell is the newest scripting language from Microsoft and it goes across the Windows platform, including SQL Server. So it's new and exciting, but is it ready for prime time? Is it worth the effort to learn? How will it help you? Join PowerShell advocate and user Ron Dameron for a quick discussion of why he thinks knowing Powershell is a key skill for a SQL Server DBA.

My full session for the day is

Automate Login Administration & Compliance Reports

Are your internal auditors asking that the administration of SQL Server logins be handled by a third party other than the DBAs? Is your Compliance and Audit departments asking you to determine if password policies are being enforced, who are sysadmins on your servers, who owns databases? If so, come to this session to learn how to complete these tasks quickly and efficiently using PowerShell and SQL PowerShell Extensions (SQLPSX).

I've said it before and I will say it again. 

SQLSaturday is the best training value for the money.

Buy a lunch, Get a FULL day of SQL training for FREE!





Monday, August 2, 2010

Learn by sharing


SQL Saturday #40 in South Florida recap.

Speaker dinner was great at Longhorn Steakhouse.  Thanks to Confio Software and SQLSkills.com for picking up the dinner and bar tab. Great to meet more SQL Tweeps in person and catch up with previous acquaintances.

Evidently, the organizers did a fantastic job marketing this event because there were a large number of attendees.  The numbers I heard were in the 400 - 500 range. Rooms were full for the talks I saw and the Commons was busy.

Check-in was very smooth.  Speaker room was great.  Plenty of water, refreshments, and food for the attendees.  Technical support from DeVry University staff was very helpful.

The PowerShell room was packed for my first session at 8:30 am on "Why DBAs Should Learn PowerShell".  I think I may retitle this "Why ANYONE Can Learn PowerShell". 

My second session on how to automate database login administration and compliance reporting was also well attended.

Had a great time eating a super lunch from Jason's Deli in the speaker room.  Showed @BrentO and Tim Ford(@sqlagentman) my slides from my first deck. I was inspired by Brent's post on how to find great photos for your slide decks.  Got to see Brent speak in person for the first time.  Smooth as silk he was. Even when the power blinked out at the perfect moment in his talk on DR.  

I still picked up a few tips on DR and Virtualization despite him saying it was a 100 level talk.  He provided guidance on size thresholds for virtualization candidates and he confirmed my thinking on the best HA/DR options for SQL Server.

What makes a SQL Saturday great?  Everyone who pitches in from the community.  

Great job by the organizers, sponsors, and speakers for this event! Awesomesauce all over this event.

Tuesday, July 27, 2010

SQL Saturday #40 South Florida. Here I come!

Need a few reasons to come to this event?

It’s FREE

You’ll learn from a master. A Microsoft Certified Master. 

Brent Ozar will do two sessions. His first at 0945 conflicts with my first session.  I hope they gave me a small room for my session.  I predict most attendees will be in his session, not mine. He’s guaranteed to keep you awake. No cover charge at the door. Costumes optional.

I’ll get to see Brent’s second session on Disaster Recovery in Hurricane Alley.                    

College football hasn’t started.  So, you won’t miss UF, UCF, USF, FSU or The U.

It’s FREE.

Another Microsoft MVP, Tim Ford, will be there to talk about indexes, DMVs, and mistakes to avoid. BTW, great post from him recently on how being involved in the SQL community allowed him to land softly at a new job when he wasn’t looking.

More MVPs, Twitterati and local experts galore. 

Did I say the whole thing is FREE!

I’m on the schedule for two sessions first thing in the morning:

Why DBAs Should Learn PowerShell

I will detail my reasoning why a DBA would benefit from learning PowerShell.

A DBA can use PowerShell in conjunction with SQL, WMI, and SMO to automate repetitive tasks and better manage their workload.

Automating SQL Server Login Administration and Compliance Audits with PowerShell

Are your internal auditors asking that the administration of SQL Server logins be handled by a third party other than the DBAs? Is your Compliance and Audit departments asking you to determine if password policies are being enforced, who are sysadmins on your servers, who owns databases? If so, come to this session to learn how to complete these tasks quickly and efficiently using PowerShell and SQL PowerShell Extensions (SQLPSX). This automation is capable of adding or dropping logins and adding or dropping members in database or server roles on any server. Also, I will demonstrate how to automate compliance reporting via PowerShell and SMO to report on the usage of password complexity/expiration policies, database owner, sysadmin role members, and other security related information defined in the SMO object model.

I don’t think there is a better training or networking value than attending a SQL Saturday.

See you on Saturday bright and early.

Thursday, July 1, 2010

In the works…

Speaker abstracts I've submitted...

SQL Saturday #40 in Miramar, FL.

Automating ID Administration with PowerShell and SQLPSX

I will demonstrate how I automated ID provisioning using PowerShell, SQLPSX, and my company's standard job scheduler.

Database Hardening via PowerShell

I will demonstrate how I use PowerShell to handle the issues encountered in a Fortune 50 corporate environment that has over 500 database servers and 3600 databases.

Why DBAs Should Learn PowerShell

I will detail my reasoning why a DBA would benefit from learning PowerShell.

A DBA can use PowerShell in conjunction with SQL, WMI, and SMO to automate repetitive tasks and better manage their workload.

The bonus for attending SQL Saturday #40, meeting Brent Ozar and Tim Ford in person.

SQL PASS Summit 2010

Why DBAs Should Learn PowerShell

Described above

Automating SQL Server Login Administration and Compliance Audits with PowerShell

Are your internal auditors asking that the administration of SQL Server logins be handled by a third party other than the DBAs? Is your Compliance and Audit departments asking you to determine if password policies are being enforced, who are sysadmins on your servers, who owns databases? If so, come to this session to learn how to complete these tasks quickly and efficiently using PowerShell and SQL PowerShell Extensions (SQLPSX). This automation is capable of adding or dropping logins and adding or dropping members in database or server roles on any server. Also, I will demonstrate how to automate compliance reporting via PowerShell and SMO to report on the usage of password complexity/expiration policies, database owner, sysadmin role members, and other security related information defined in the SMO object model.

Tuesday, May 4, 2010

MCITP Database Administrator 2008!





I passed the 70-450 exam last week and completed the 70-432 exam earlier in April.

I have to say this certification is a much better test of your real world DBA skills then the MCDBA exams.

A lot less memorization required and a lot more critical thinking needed.

I started with Buck Woody's notes for the 70-432 exam and used the book he recommended.

There are no self-study kits for the 70-450 exam.  I prepared for this exam by reviewing the exam's Skills Being Measured outline along with SQL Server Books Online.

For both exams, I will say that practical work experience does help a great deal especially with the 70-450 exam.

I answered a number of questions on the 70-450 exam just thinking about real world issues I have dealt with.

I will also say attendance at my local SQL User Group meetings, SQL Saturdays, Quest Software Virtual Events, 24 Hours of PASS, reading blogs, and twitter contributed to my MCITP success.

While it's always gratifying to earn the certification, I think the most valuable aspect of certification is that it pushes you to learn other parts of the product that you may not get a chance to use regularly.

Also, this success confirms for me the value of the social media, blogs, twitter, and community resources.

I don't think I would have passed the tests without using all of these resources.

Finally, I thank all of you who blogged about your certification experience while I was preparing for my exams.

Friday, February 12, 2010

February Orlando PASS Meeting

Jack Corbett (@unclebiguns) and Andy Warren(@sqlAndy) invited me to speak at this month’s Orlando PASS meeting. First, I want to thank them for the opportunity. I enjoyed it.

For the benefit of those who couldn’t make the trip to Tampa last month for SQL Saturday #32, I did my talk on “Database Hardening via PowerShell”.

I worked a half day and then headed to Orlando around 12:30 PM.  The plan was to speak and to visit my daughters at the University of Central Florida.
I visited with the youngest daughter prior to the meeting.  When I asked if she was available, she asked “Does this mean I get a free lunch?”.  Yes, we had a late lunch
.
After lunch, I headed over to  the meeting location around 4 PM hoping to beat the rush hour traffic. Boy, was I wrong.  The constant rain that day slowed I-4 Eastbound traffic to a crawl.  Plus, I was wondering who let all these people off work early???

I arrived at the meeting location at 5 PM, a full hour before the meeting started.
I’m glad because it took the full hour to get ready and sort out the LiveMeeting setup.  It was the first time I had done a LiveMeeting.
Even with the hour prep time, I forgot to do one thing to prep for my demos.  Did you catch it?
I forgot to import the SQLPSX 2.0 modules prior to starting the first demo.

I should have run the following in the PowerShell IDE prior to starting:
import-module ShowMbrs
import-module SQLServer
import module Agent
import-module Repl
import-module SSIS
import-module SQLParser
I was able to recover pretty quickly because I had a version of the script that didn’t use the SQLPSX modules.

My demos demonstrated:
- How to check the SQL Server version on 600 servers in less than 10 minutes. 
- How to check which Windows groups have access to your database servers.
- How to check for the correct Recovery Model on multiple servers.
- How to list the sysadmins and database owners on multiple servers.
- A script to report on issues raised by our internal Compliance and Audit departments.

If any of this is of interest to you, I’ve provided my deck and scripts to OPASS to share.

As I said, I enjoyed the meeting. Andy and Jack do a great job getting people involved and talking to each other.  The icebreakers were effective and the attendees were friendly and attentive.
As usual, I always learn something new when I speak.  On this occasion, it was attending LiveMeeting as a speaker.  I also appreciated the feedback afterwards of my talk via blogs, Twitter, and e-mail regarding my performance.

After the meeting, I visited my other daughter and made it home to Tampa around Midnight.
It was a fun day.

Monday, January 25, 2010

SQL Saturday #32 Recap

SQL Saturday #32 was a great success this past weekend!

Pam Shaw (@pamshaw) and Jorge Segarra(@SQLChicken) did a great job organizing this event!

Thanks to KForce for hosting the event and to all the sponsors for picking up the costs.

If you missed this event, you also missed out on some of the best food ever at a SQL Saturday!  Spaghetti Warehouse in Ybor City did a great job with the speaker/volunteer dinner Friday night.  The day of the event all attendees got a taste of Ybor from “Latam at the Centro” for lunch.  BEST LUNCH I HAVE EVER HAD AT A SQL SATURDAY! 

Hmmm. Best lunch I’ve had in a while.

It was great to meet the following SQL Tweeps in person: @adam_jorgensen, Argenis Fernandez(@afernandez), David Taylor(@dyfhid), @GarethSwan, Jason Strate(@StrateSQL), Aaron Nelson(@SQLvariant),and Jeff Truman(@jtruman0917). I hope I didn’t miss anybody.

Great to see these tweeps again: @brianknight, @cmille19, @GratefulDBA, @patrickdba, @unclebigguns, @leighfreijo,

Thank you @devfish for REAL Cafe Con Leche in Latam’s Room B during the PowerShell sessions!

Met my first Father/Son DBA duo, Mike Nelson and Aaron Nelson (@SQLVariant). The father is an Oracle DBA, the son does SQL Server.  I wonder if they ever have any Oracle vs. SQL Server debates at home???

My presentation “Database Hardening With PowerShell” went well using my recently won Dell Mini 10v.  No performances issues at all while running PowerPoint Viewer, PowerShell V2, and SQL Server 2008 for my demos. I was the third of three presenters on PowerShell.

I put a plug in for the Tampa PowerShell User Group starting up in March 2010 at the end of my talk.

Why do I go to SQL Saturday events? Because of the people I meet, the variety of sessions, the chance to learn something new, and I enjoy volunteering as a speaker.

If you had attended SQL Saturday #32, a few things you would have learned are:

The MVP Deep Dives book has a PowerShell chapter worth the price of admission.

Ed Wilson’s PowerShell V2 Best Practices book is available.

It’s a good idea for a DBA to learn SSRS for their own reporting purposes.

I had to leave early so I missed some sessions I wanted to attend but all attendees will upload their slide decks in the new few days to the SQL Saturday web site.

I did snag a T-shirt from my favorite vendor Red Gate Software!

My FIFTH SQL Saturday is complete.

If you missed SQL Saturday #32 and my presentation, I will be at Orlando PASS on February 9, 2010 to do it again.

Wednesday, January 6, 2010

List Windows Groups With Access to SQL Servers

A manager posed the question “Can we list all the Windows groups that have access to all of our database servers?”  The answer is “Yes.” 

It is very easy to do with a short PowerShell script via SMO.

The results are written to a CSV file.

   1:  ## List Windows Groups on a server ##
   2:  ## ./get-WinGrps.ps1
   3:  $start = get-date
   4:  write-host "Start: "  $start
   5:   
   6:  [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | out-null
   7:   
   8:  $FilePath = "C:\Output"
   9:  $OutFile = Join-Path -path $FilePath -childPath ("WindowsGroupsOnServers_" + (get-date).toString('yyyyMMdd_hhmmtt') + ".csv")
  10:   
  11:  # Version inventory
  12:  @(foreach ($svr in get-content "C:\Input\TestServers.txt")
  13:  {
  14:      
  15:      $s = New-Object "Microsoft.SqlServer.Management.Smo.Server" $svr
  16:      $s.Logins | ? {$_.LoginType -eq "WindowsGroup"} | select Parent, Name, LoginType
  17:   
  18:  })  | export-csv -noType $OutFile
  19:   
  20:  $end = get-date    
  21:  write-host "End: "  $end