THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » powershell » SQL Server 2008 » SMO   (RSS)
  • Change SQL Servers Authentication Mode with PowerShell

    Lately I've been working on scripts to check and set security and configuration settings for SQL Server using PowerShell. One of the settings that I normally set and forget at install time is the Authentication Mode setting. Best practices suggest that you set this to Windows Authentication, but my experience has been that it's always better to ...
    Posted to Allen White (Weblog) by AllenMWhite on May 19, 2011
  • Discover Facets and Properties in PowerShell

    When you're trying to set up scripts to deploy policies to your servers (because you ALWAYS automate with PowerShell, right?), it can be sometimes difficult to determine exactly what facets are there, and when you do know the facet name, what properties are available to you. First, in a native PowerShell window you'll need to load the assemblies ...
    Posted to Allen White (Weblog) by AllenMWhite on September 27, 2010
  • PASS PowerShell/SQL Server PreCon

    PowerShell is an amazing tool to help you automate your administrative processes. There are a lot of books and online sources to help you learn PowerShell, but how do you learn how to use it with SQL Server? Simple, just sign up for my PASS PreCon session. Here's the outline: Use PowerShell to Get the Most out of SQL Server Module 1: ...
    Posted to Allen White (Weblog) by AllenMWhite on August 19, 2010
  • SMO Changes from SQL 2005 to SQL 2008

    A year ago in anticipation of publishing a book on SMO (which never came to be) I wrote a number of chapters demonstrating how to manage specific sets of objects, and I provided examples in VB.Net, C# and PowerShell. As should be expected, I thoroughly tested all of the code samples to make sure they worked. This year I've been part a couple of ...
    Posted to Allen White (Weblog) by AllenMWhite on February 20, 2009
  • Loading SMO Assemblies into PowerShell

    Microsoft included PowerShell with SQL Server 2008, and the new sqlps.exe program which includes the SQL PowerShell drivers including the PS Drives and new cmdlets for SQL Server. I prefer to work from vanilla PowerShell and load the assemblies I need, so I have code at the start of my script to load the appropriate assemblies. When I started ...
    Posted to Allen White (Weblog) by AllenMWhite on December 7, 2008
  • PASS Demonstration Errors

    Errors occur. (I'm sure that's someone's corollary to Stuff Happens.) Errors occur, and that's why we write error handling code in our applications. My least favorite time for the occurrance of errors is when I'm doing demos, and that's what happened in a presentation I did at PASS last week. I try to test everything before giving the demos, ...
    Posted to Allen White (Weblog) by AllenMWhite on November 24, 2008
  • SQL Server 2008 SMO Library Changes

    While preparing for a presentation at PASS next month I tested my PowerShell script to back up user databases on a server. This script has been running flawlessly against SQL Server 2005 for a couple of years, so I was really surprised when PowerShell returned a screen full of errors and no backups. What slipped my mind was something I'd ...
    Posted to Allen White (Weblog) by AllenMWhite on October 18, 2008
  • SQL Saturday 6 - Cleveland August 9

    Wow, it's been a crazy month! Two weeks of Tech Ed in Orlando, where I spent time helping people with questions on SQL Server in the Database Platform area and presented two sessions on SMO and PowerShell (one with my friend Peter Ward from Australia). Then, my last week as a DBA at Advanstar, followed by my first week as a Trainer for ...
    Posted to Allen White (Weblog) by AllenMWhite on June 27, 2008
  • Start PowerShell in Management Studio

    In the February CTP of SQL Server 2008 a new feature has appeared in SQL Server Management Studio. You now have the ability to right-click on an object in the Object Explorer window and open up a PowerShell window. In this window you can navigate the database structures much like you can a disk file subsystem, or like you can navigate the ...
    Posted to Allen White (Weblog) by AllenMWhite on February 20, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement