Monthly Archives: July 2010

Ready, Set, Go SQLSaturday !!! Come to see us…

Posted on July 29, 2010 by admin

Yes! The stage is set, and we are ready to give some Awesome presentations.  Please, don’t be a stranger!! Come to both upcoming SQLSaturday events: South Florida (SQLSat40) and Orlando (SQLSat49).   We finally organized a full day of PowerShell.  It’s … Continue reading →

Posted in Events | Comments Off

Invoke-SQLCmd minor issue running some SQL Stored-Procedures…

Posted on July 22, 2010 by admin

First time I notice something strange with “Invoke-SQLCmd”, I was when executing the system Stored-Procedure “SP_Who2” and got the following error message: PS C:\Users\Max> $sqlWho = Invoke-Sqlcmd “SP_Who2″ Invoke-Sqlcmd : The pipeline has been stopped. At line:1 char:24 + $sqlWho … Continue reading →

Posted in PowerShell, SQL Server | Tagged , | Comments Off

QuickBlog: Build a list of SQL Server without SMO…

Posted on July 20, 2010 by admin

Here I’m sharing a piece of PowerShell  code snippet which allow you to create a string array of all your SQL Server with their instances.  This code is a .NET namespace and use the enumerator class “SqlDataSourceEnumerator” to give you … Continue reading →

Posted in PowerShell, SQL Server | Comments Off

PowerShell Modules – How to create Aliases for my functions?

Posted on July 18, 2010 by admin

There’s tons of information about PowerShell Modules on the internet.  Then I realized, in my PowerShell Modules, How do I create Aliases for my functions?  I couldn’t find any information on the internet about Aliases in modules.  So, thanks to Ed Wilson … Continue reading →

Posted in PowerShell | Tagged | Comments Off

South Florida SQL Server User Group (SFSSUG) is proud to announce the following:

Posted on July 14, 2010 by admin

USER GROUP MEETINGS Meetings are from 6 pm to 8:30 pm unless otherwise indicated. West Palm Beach: CompTec, 1750 North Florida Mango, Suites 302 and 303, West Palm Beach, FL 33409 Miramar: DeVry University, 2300 SW 145th Avenue, Miramar, FL … Continue reading →

Posted in Events | Comments Off

Some Good Twitter and SQL Server PowerShell resources

Posted on July 14, 2010 by admin

I’m not forgetting all the hard working MVP’s and non-MVP’s DBA’s that are blown away with PowerShell.  Here’s my favorite web list and twitter names: Chad Miller (@cmille19): http://sev17.com/ Ron Dameron (@RonDBA): http://www.simple-talk.com/author/ron-dameron/ Aaron Nelson(@SQLvariant): http://sqlvariant.com/wordpress/ Laerte Junior (@LaerteSQLDBA): http://laertejuniordba.spaces.live.com … Continue reading →

Posted in Resources | Comments Off

Free PowerShell Resources:

Posted on July 14, 2010 by admin

Here’s some other resource information about PowerShell in general that you should miss: SAPIEN Technologies – from their Community Tools page (free): PowerShell TFM V1 eBook – A most to have book. (Acrobat Reader requiered) Windows PowerShell Help 2.0 iPowerShell … Continue reading →

Posted in Resources | Comments Off

Two for Two – SQLSaturdays #40 & #49 SQL PowerShell Tracks !!

Posted on July 10, 2010 by admin

Finally, after 2 years of speaking about PowerShell working with SQL Server, everyone has realized to give it a try and enjoy the benefits it brings in automation and productivity.  In Florida, thanks for all the organizers of SQLSaturday to … Continue reading →

Posted in Events | Comments Off

Wind of changes in the PowerShell front!!

Posted on July 10, 2010 by admin

I’m finally making the move from Live.Spaces to WordPress. There’s a lot going on with PowerShell that sometimes it’s hard to keep up. The good thing about it is that everyone have finally realized that they need to catch up … Continue reading →

Posted in PowerShell | Tagged | Comments Off