Files from PowerShell Power Breakfast Kickoff Meeting
Here is zip file containing the scripts, notes, slides, and some online books used for today’s introduction to PowerShell. Thank you Shauna Theobald and the

PowerShell Power Breakfast in Utah – Kickoff Meeting 8:00am-9:00am, Wednesday, November 25, 2009
Buy your breakfast at the East Bay Cafe, have a seat, and learn about PowerShell for one hour.  That’s the basic premise of the monthly PowerShell Power Breakfast.  PowerShell provides for Windows what shells like Bash provide in Linux – a command line for one-off tasks or automation, be they simple or complex.  Schedule this event on your calendar, and bring your manager and/or coworkers. I’ll be presenting a rapid-fire introduction to PowerShell, and will be followed by Ben Miller, current president of the Salt Lake City SQL Server Users Group.  Ben will p

List all SQL Server-Related Service Accounts using WMI under PowerShell
Ever wanted to know which service accounts SQL Server is using? Fast PowerShell WMI Method(doesn’t work with boxes running Windows 2000) 1. Make a text file containing all the machine names of your SQL Servers – don’t worry about multiple instance names or virtual names, just put the machine names, one per line.  This file will be used to populate the service account info once for each server listed. 2. Create a text file with the following, and save it as  get-sql-svcaccounts-wmi.ps1 to be run in PowerShell. $erroractionpreference = "SilentlyContinue"

T-SQL to generate all rights for the current database as valid T-SQL statements
Tested on SQL Server 2005 & SQL Server 2000 I wrote up a post on sp_helprotect2 previously, but I like this method better, even though they both use stored procedure sp_helprotect to populate the table. --T-SQL to generate all rights for the current database in valid T-SQL statements create table dbo.##protect ( [owner] sysname, [object] sysname, [grantee] sysname, [grantor] sysname, [protectype] sysname, [action] sysname,

What’s my NTFS Cluster Size?
Maybe you’re a SQL Server DBA and you prefer 64K cluster sizes for optimizing disk I/O to read an extent at a time, or you just need to know how a volume was formatted.  The command line can help using fsutil: fsutil fsinfo ntfsinfo c: Sample output: