Browse by Tags

All Tags » PowerShell and SQL Server (RSS)
Fri, Mar 30 2012 15:47

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
Posted by RichardSiddaway | with no comments
Filed under: , , , , , ,
Tue, Feb 28 2012 23:23

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...
Posted by RichardSiddaway | with no comments
Filed under: ,
Tue, Feb 28 2012 21:29

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...
Posted by RichardSiddaway | 3 comment(s)
Filed under:
Mon, Feb 27 2012 17:07

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
Posted by RichardSiddaway | with no comments
Filed under: ,
Mon, Feb 20 2012 22:34

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
Posted by RichardSiddaway | with no comments
Filed under: ,
Tue, May 3 2011 19:31

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...
Posted by RichardSiddaway | 1 comment(s)
Filed under: ,
Mon, Aug 2 2010 19:05

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...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Wed, Feb 17 2010 19:52

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
Filed under:
Sun, Jan 3 2010 13:30

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...
Posted by RichardSiddaway | with no comments
Filed under: ,
Fri, Nov 6 2009 15:55

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...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Thu, Jun 25 2009 13:06

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
Filed under:
Sun, Apr 19 2009 14:29

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...
Posted by Richard Siddaway's Blog
Filed under:
Sat, Mar 28 2009 15:17

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...
Posted by Richard Siddaway's Blog
Filed under:
Fri, Feb 13 2009 3:48

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...
Posted by Richard Siddaway's Blog
Filed under:
Thu, Jan 15 2009 12:54

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...
Posted by Richard Siddaway's Blog
Filed under:
Fri, Nov 21 2008 6:41

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...
Posted by Richard Siddaway's Blog
Filed under:
Tue, Oct 21 2008 2:27

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...
Posted by Richard Siddaway's Blog
Filed under:
Fri, Sep 26 2008 15:22

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...
Posted by Richard Siddaway's Blog
Filed under:
Thu, Sep 11 2008 13:41

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...
Posted by Richard Siddaway's Blog
Filed under:
Thu, Aug 7 2008 2:28

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
Posted by Richard Siddaway's Blog
Filed under:
More Posts Next page »