• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

PowerShell – Change SQL Server Login Password

January 14, 2014 by John Sansom 12 Comments

Powershell

Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server Login. Regular readers know that I practice the philosophy of Automate Everything and DBA administrative tasks are no exception. I don’t want to be doing the same task by hand twice, if I can help […]

Filed Under: Administration, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Powershell

Restart the SQL Server Agent Service using PowerShell

February 26, 2013 by John Sansom 3 Comments

Powershell

Just a quick one today chaps, to show how you can restart the SQL Server Agent Service using PowerShell.

Filed Under: Administration, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Automation, Powershell, Scripting

Script SQL Server Agent Jobs Using PowerShell

February 12, 2013 by John Sansom 46 Comments

Powershell

Here’s a handy PowerShell script to script-out all SQL Server Agent jobs for a given instance.

Filed Under: Administration, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Automation, Powershell, SQL Server Agent

PowerShell Script to Configure SQL Server Storage

May 8, 2012 by John Sansom 4 Comments

Powershell

Following on from the popularity of my last PowerShell post Script SQL Server Agent Jobs Using PowerShell, I thought I would share another script I created to make life being a DBA that little bit easier, in the hope that you too may enjoy the benefits. You regular readers will know that I’ve been endeavouring […]

Filed Under: Administration Tagged With: Automation, Disk Alignment, Powershell, Storage Configuration

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy