Category Archives: PowerShell and SQL Server

PowerShell in Practice offer today only

Posted on Friday 30 March 2012 by

Manning have PowerShell in Practice on a half price offer today. Go to www.manning.com and use code dotd0330cc when ordering

Posted in Books, Powershell, PowerShell and Active Directory, PowerShell and Exchange 2007, PowerShell and IIS, PowerShell and SQL Server, PowerShell and WMI | Leave a comment

UK PowerShell group–February 2012 recording

Posted on Tuesday 28 February 2012 by

The recording, slides and demo scripts from tonight’s PowerShell and SQL Server session are available as a single zip file for download from https://skydrive.live.com/#cid=43CFA46A74CF3E96&id=43CFA46A74CF3E96%212943 The file is created with jzip but any zip handling program should be able to unzip … Continue reading →

Posted in PowerShell and SQL Server, PowerShell User Group | Leave a comment

Connecting via SMO to a named instance

Posted on Tuesday 28 February 2012 by

A question came up in tonight’s User group session regarding connecting to SQL server instances using SMO If you have just a default instance – just give the server name $server = New-Object -TypeName “Microsoft.SqlServer.Management.Smo.Server” -ArgumentList “W08R2SQl12″ If you have … Continue reading →

Posted in PowerShell and SQL Server | Leave a comment

February UG meeting–Final reminder

Posted on Monday 27 February 2012 by

  The UK PowerShell group presents a Live Meeting tomorrow on using PowerShell with SQL Server Details from http://msmvps.com/blogs/richardsiddaway/archive/2012/02/09/february-powershell-group-meeting-sql-server-and-powershell.aspx

Posted in PowerShell and SQL Server, PowerShell User Group | Leave a comment

UG meeting reminder

Posted on Monday 20 February 2012 by

First reminder for the UG meeting on 28February – PowerShell and SQL Server details from http://msmvps.com/blogs/richardsiddaway/archive/2012/02/09/february-powershell-group-meeting-sql-server-and-powershell.aspx

Posted in PowerShell and SQL Server, PowerShell User Group | Leave a comment

PowerShell Deep Dive: VII using SMO

Posted on Tuesday 3 May 2011 by

SMO  =  (SQL) Server Management Objects.  They first shipped with SQL Server 2005 and continued into SQL Server 2008. They are .NET classes that enable us to manage SQL Server systems programmatically – in our case from PowerShell. The SQL … Continue reading →

Posted in Deep Dive, PowerShell and SQL Server | 1 Comment

SQL Server backup

Posted on Wednesday 17 February 2010 by

An article I wrote for Windows Administration in Realtime has been posted on the Realtime Publishers tech tips site http://nexus.realtimepublishers.com/tips.php then look for Solidifying Your Backup and Recovery Srategy for SQl Server It shows an example of using PowerShell to … Continue reading →

Posted in PowerShell and SQL Server | Leave a comment

SQL Server PowerShell Extensions

Posted on Sunday 3 January 2010 by

If you use PowerShell with SQL Server you will want to check out the 2.0 release of the SQL Server PowerShell Extensions from http://sqlpsx.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=38047 To quote the release notes “Release 2.0 re-implements SQLPSX as PowersShell version 2.0 modules. SQLPSX consists … Continue reading →

Posted in PowerShell and SQL Server | Leave a comment

SQL Server books

Posted on Friday 6 November 2009 by

A couple of SQL Server books that I would recommend having been involved with both of them. First up is SQL Server 2008 Administration in Action by Rod College (Manning – http://www.manning.com/colledge/) which I reviewed several times before publication. It … Continue reading →

Posted in PowerShell and SQL Server | Leave a comment

SQL Server autoclose

Posted on Thursday 25 June 2009 by

Buck Woody blogged about SQL Server autoclose and how it should be set to being off  – http://blogs.msdn.com/buckwoody/archive/2009/06/24/sql-server-best-practices-autoclose-should-be-off.aspx  I’m doing a lot with SQL Server and PowerShell at the moment and it started me thinking that I could easily set … Continue reading →

Posted in PowerShell and SQL Server | Leave a comment