Browse by Tags

Powershell and SQL Authentication

In my last posting I mentioned that not everyone could use the SQL Server Provider when using Powershell. Why should this be so? To use the SQL Server Provider requires Window Authentication and uses the account running the Powershell session (see the topic “Using the SQL Server PowerShell Provider”...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Fri, Jan 1 2010
Starting/Stopping SQL Server using Powershell

One thing I would like to see is more examples of using Powershell in Books Online! For instance the topic Managing Services and Network Settings by Using WMI Provider doesn’t have an example using WMI. So here is one! # Get an instance of the ManagedComputer object that represents the WMI Provider services...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Thu, Dec 31 2009
Powershell 2.0 has slipped out!

Thanks to Anthony for point this out at Thursday’s User Group meeting. Windows Powershell 2.0 was released as part of the the Windows Management Framework release at the end of October. If you are not a Windows admin you may have missed it! See here for more details.

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Sat, Dec 12 2009
An issue when enabling protocols with Powershell

I was looking at the topic “How to: Enable or Disable a Server Network Protocol (SQL Server PowerShell)” books online to enable the TCP protocol for a SQL Server instance using Powershell. So I started up SQLPS from object explorer and posted the following script into the window. $wmi = new-object ('Microsoft...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Fri, Oct 9 2009
Slide Deck - Scottish Area SQL Server User Group Meeting, Edinburgh - Thursday 8th October

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 a very interesting talk on SQLDiag, SQL Nexus and...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Fri, Oct 9 2009
References + Deck + SQL Samples from my System Management presentation on 20090929 @ MS Data Management Conference in London

Note that I will be going into more detail in a series of 30-40 minute LiveMeetings starting towards the end of October, please see sqlserverfaq.com for more information - I'll be posting the info this weekend so check back after then. The session abstract: This predominately demo based session explores...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Fri, Sep 25 2009
My Systems Management session (20090929 in London) - Management Data Warehouse (Data Collector), Powershell, SQLCmd, Event Notifications and Extended Events, Policy Based Management

Quite a lot to cover in 45 minutes but my plan is to overview the areas in demo and a one slider and then attack each area from the beginning of October in more detail on LiveMeeting - going to sort the dates over the weekend. Here is the new abstract: SQL10 - Systems Management This predominately demo...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Fri, Sep 25 2009
Using SQL Server in Powershell outside of SQLPS

Up to now I have only shown scripts that use SQL Server’s Powershell minishell (SQLPS.exe) and not the full-blown Powershell (Powershell.exe). If you want to use the scripts I have shown so far, you will need to load the appropriate SQL Server Assemblies. Michael Worries has blogged about which assemblies...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Sun, Sep 6 2009
Powershell and SMO scripting – Part 3

Madhivanan posted a blog entry on how to script table definitions and data the other day. For SQL 2008 this gave a link that showed you how to use the scripting wizard to generate this script . If you have ever posted a problem on the newsgroups or forums when you can't get a SELECT statement to...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Sat, Aug 22 2009
Powershell and SMO scripting – Part 2

In my last post I created a script that will generate files for each view that contain a drop and create statement for the view. If you wished to script all tables in the database then all you would have to do is change the location you have set: cd SQLSERVER:\SQL\localhost\DEFAULT\Databases\AdventureWorks...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Sat, Aug 15 2009

Page 3 of 4 (32 items) < Previous 1 2 3 4 Next >