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 » Database Admini... » SMO   (RSS)
Showing page 2 of 3 (30 total posts)
  • Script and Migrate Agent Jobs between Servers using PowerShell

    I'm nearing the end of a SQL Server upgrade project, migrating from SQL Server 2000 to SQL Server 2008 R2. The company uses SQL Server Agent to run about 150 jobs which execute DTS packages to do the work of moving data around. Now, there are any number of ways to move these jobs from one server to the other, but I wanted to be able to exclude ...
    Posted to Allen White (Weblog) by AllenMWhite on May 2, 2012
  • System Inventory and Performance Gathering SQL Connections Session

    Yesterday I delivered a session on maintaining a system inventory and gathering performance data with PowerShell.  The session went well and I had great questions and I'd like to thank everyone who attended the session.  I've attached the slides and demo scripts from the session for your use. Allen
    Posted to Allen White (Weblog) by AllenMWhite on March 29, 2012
  • Speaking About SQL Server

    There's a lot of excitement in the SQL Server world right now, with the RTM (Release to Manufacturing) release of SQL Server 2012, and the availability of SQL Server Data Tools (SSDT). My personal speaking schedule has exploded as well. Just this past Saturday I presented a session called Gather SQL Server Performance Data with PowerShell. There ...
    Posted to Allen White (Weblog) by AllenMWhite on March 12, 2012
  • Load Perfmon Log Data into SQL Server with PowerShell

    In yesterday's post I showed you how I set up performance data gathering in an environment where I can't directly update my analysis database. Today I'll show you how I load that data into SQL Server for the analysis. First, I create tables to contain the performance counters in my analysis database. Here's what they look like: CREATE TABLE ...
    Posted to Allen White (Weblog) by AllenMWhite on March 3, 2012
  • Setup Perfmon with PowerShell and Logman

    In a session yesterday I was reminded of the power of a tool on every server, Logman, to manage performance data gathering. It's a pretty amazing tool, and I'm starting to get to know how much more it can do than I've even considered, but here's a simple example of what I've done so far. First things first, I'm going to leverage the SMO Server ...
    Posted to Allen White (Weblog) by AllenMWhite on March 2, 2012
  • Getting Job History Correctly

    In my last blog post I walked through a way to grab the duration from the EnumHistory method of the JobServer/Job object. As I worked through getting a solution in place for a client I found that the duration calculation was only part of the problem. First, when EnumHistory() is invoked, it runs the sp_help_jobhistory stored procedure. You can ...
    Posted to Allen White (Weblog) by AllenMWhite on March 1, 2012
  • Use PowerShell to Add a Login to a Database Role in all Databases

    Mark Freeman (@m60freeman) posted a question on Twitter using the #sqlhelp hashtag today, asking ''Does anyone have a script to assign db_backupoperator for all databases in an instance to a login?'' I looked and didn't really have anything that fit, but felt it'd be useful to understand the SMO process to create it. Note: one glaring hole I've ...
    Posted to Allen White (Weblog) by AllenMWhite on June 3, 2011
  • What Encryption Algorithms Are You Using?

    Security is an important consideration when designing a database application. Who can get access to what data? How much damage can someone do if they get at your data? In SQL Server 2005 Microsoft implemented column-based encryption, and in SQL Server 2008 they added Transparent Data Encryption. Both solutions work well for their intended use, ...
    Posted to Allen White (Weblog) by AllenMWhite on May 31, 2011
  • Monitor your SQL Server Agent Proxies Using PowerShell

    Over time it's easy to lose track of the things you set up to get work done. As a consultant, I have to discover what's set up on a client system. In either case, it's important to know what security settings are in place to know if they're appropriate and well managed. One of the hidden gems (and potential nightmares) in SQL Server is the use ...
    Posted to Allen White (Weblog) by AllenMWhite on May 25, 2011
  • Find your Enabled SQL Server Network Protocols Using PowerShell

    Another quick check I like to do when in 'discovery mode' on a client system is to see what network protocols are enabled. Those of us around in 2003 will remember well the headaches caused by the SQL Slammer virus, and know to shut down Named Pipes unless it's absolutely necessary, just as a precaution. As part of my investigation on new ...
    Posted to Allen White (Weblog) by AllenMWhite on May 21, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement