Browse by Tags

All Tags » PowerShell and SQL Server (RSS)
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:
Mon, Jul 14 2008 13:13

PowerShell and SQL Server

Michiel Wories provides a look at some of the thinking behind PowerShell in SQL Server and future plans - http://blogs.msdn.com/mwories/archive/2008/06/25/what-no-cmdlets-sql-server-powershell.aspx Share this post : Technorati Tags: PowerShell , SQL Server
Posted by Richard Siddaway's Blog
Filed under: