Browse by Tags

All Tags » PowerShell and SQL Server (RSS)

PowerShell in Practice offer today only

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

UK PowerShell group–February 2012 recording

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...

Connecting via SMO to a named instance

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...

February UG meeting–Final reminder

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

UG meeting reminder

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

PowerShell Deep Dive: VII using SMO

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...

PowerShell Tech tips

Two tech tips that I’ve contributed to the Realtime publishers site are now available Go to http://nexus.realtimepublishers.com/tips.php and look under Disaster Recovery for How to Configure a Windows Server 2008 R2 Failover Cluster with Windows...

SQL Server backup

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...
Posted by RichardSiddaway | with no comments

SQL Server PowerShell Extensions

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...

SQL Server books

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...

SQL Server autoclose

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...
Posted by RichardSiddaway | with no comments

PowerShell for DBAs

Chad has a very interesting post on “The Value Proposition of PowerShell to DBAs” - http://chadwickmiller.spaces.live.com/blog/cns!EA42395138308430!347.entry where he discusses the results of a poll of DBAs regarding PowerShell. On initial reading it...

SQLPSX 1.5

If you use PowerShell and SQL Server you should at the very least look at SQLPSX which is a big library of PowerShell functionality. Version 1.5 has just been released. See http://chadwickmiller.spaces.live.com/blog/cns!EA42395138308430!315.entry for...

Compare Database Schemas

One of the great things about PowerShell is the strength of the PowerShell community. This is shown by the number of people sharing their PowerShell scripts. A good example is the script to compare the schemas of two SQL Server databases that Steven has...

SQL Server scripts

Idera have published a set of PowerShell example scripts for working with SQL Server. They can be downloaded (free) from www.idera.com Check the bottom of the products menu for PowerShell scripts. They give a good introduction to working with Powershell...

Loading SQL Server Provider

Last night at the User Group meeting I showed a script to load the required assemblies and snapins that enabled the SQL Server 2008 PowerShell provider to be accessible through a normal PowerShell session. In response to requests at the meeting the script...

SQL Server PowerShell provider

I have been looking at PowerShell in SQL Server again recently as I'm working on chapters involving PowerShell and SQL Server for a couple of books. I had had a vague understanding that the PowerShell provider could access remote machines but had...

PowerShell reading SQL Server logs

Thanks to Dmitry - http://dmitrysotnikov.wordpress.com/2008/09/26/more-sql-cmdlets/ - and Jacob - http://mspowershell.blogspot.com/2008/09/read-transactionlog-of-sql-server-from.html - for pointing out the PowerShell cmdlets in Quest's SQL Lite Speed...

PowerShell scripts for SQL Server

I recently mentioned the PowerShell scripts for SQL Server on codeplex - http://richardsiddaway.spaces.live.com/blog/cns!43CFA46A74CF3E96!1602.entry There has been a new release so now you can work with Tables, Stored Procedures, Views, User Defined Data...

SQL Server 2008 RTM

SQL Server 2008 has RTM'd. It should be available for download from TechNet\MSDN. PowerShell included. Share this post : Technorati Tags: PowerShell , SQL Server 2008
More Posts Next page »