Browse by Tags

Powershell and SQL Authentication
01 January 10 03:25 PM | MartinBell | 2 comment(s)

How much use is Powershell to a DBA when Windows Authentication is not available?...

Filed under: POWERSHELL, SMO, WMI

Starting/Stopping SQL Server using Powershell
31 December 09 07:58 PM | MartinBell | 1 comment(s)

One thing I would like to see is more examples of using Powershell in Books Online!...

Filed under: POWERSHELL, WMI

Powershell 2.0 has slipped out!
12 December 09 01:31 PM | MartinBell | with no comments

If you missed it like I did and were still running the RTM version, then you may want to check out the RTM release of Powershell 2.0...

Filed under: POWERSHELL

An issue when enabling protocols with Powershell
09 October 09 07:01 PM | MartinBell | 1 comment(s)

If you every had problems changing protocols in Powershell then this may be the cause.....

Filed under: POWERSHELL

Slide Deck - Scottish Area SQL Server User Group Meeting, Edinburgh - Thursday 8th October
09 October 09 10:44 AM | MartinBell | 1 comment(s)

Thanks to everyone who came to the user group meeting in Edinburgh last night. We had a great atmosphere and lots of interaction made a great meeting. Congratulations to the competition winners I hope you enjoy the books and find them useful. Rob gave...

Filed under: User Group, POWERSHELL

Using SQL Server in Powershell outside of SQLPS
06 September 09 05:54 PM | MartinBell | 1 comment(s)

If you want to use all the power of Powershell and also access SQL Sever you will need to load the SQL Server assemblies, which can be a pain if you need to use them regularly. This will show you what to load and how to automatically have them loaded when you start powershell....

Filed under: POWERSHELL

Powershell and SMO scripting – Part 3
22 August 09 05:04 PM | MartinBell | 2 comment(s)

In SQL Server 2008 Management Studio you can now script a table definition plus the data as INSERT statements, so how can you do that programatically with Powershell? In the third in my series of investigations I will look at how it can be done....

Filed under: POWERSHELL, Scripting, SMO

Powershell and SMO scripting – Part 2
15 August 09 06:00 PM | MartinBell | 3 comment(s)

In the post I look further into using SMO and Powershell to script table constraints and indexes.....

Filed under: POWERSHELL, Scripting, SMO

Powershell and SMO scripting – Part 1
13 August 09 09:18 PM | MartinBell | 2 comment(s)

One of the great things you can do with Powershell is that you can use the classes from SMO. ...

Filed under: POWERSHELL, Scripting, SMO

Executing all .SQL files in a directory with Powershell
30 July 09 07:30 PM | MartinBell | 2 comment(s)

Some time ago I published a blog post on how to execute all files in a directory against a given database. As I’ve recently been looking at improving my Powershell skills, I thought it would be a good idea to try an produce a solution using that, and here is what I came up with: ...

Filed under: SQLCMD, POWERSHELL