mikefrobbins.com
open-menu closeme
Home
About
mikefrobbins.com
twitter github linkedin rss
  • Use PowerShell to Identify the Process ID for SQL Server Services

    calendar Apr 25, 2019 · PowerShell SQL Server  ·
    Share on: twitter facebook linkedin copy

    I recently saw a blog article on How to Identify Process ID for SQL Server Services? – Interview Question of the Week #185 written by Pinal Dave. While his answer is simple with TSQL, what if you're not a SQL guy? You can also retrieve this information with PowerShell from Windows itself. When it comes to retrieving …


    Read More
  • Run SQL Server PowerShell Cmdlets as a Different User

    calendar Apr 11, 2019 · PowerShell SQL Server  ·
    Share on: twitter facebook linkedin copy

    One of the ways I practice the principal of least privilege is by logging into my computer as a domain user who is also a standard local user. I typically run PowerShell as a domain user who is a local admin and elevate on a per command basis using a domain account with more access only when absolutely necessary. The …


    Read More
  • Resolving Microsoft SQL Server Error 4064 with PowerShell

    calendar Jan 11, 2019 · PowerShell SQL Server  ·
    Share on: twitter facebook linkedin copy

    Recently, a fellow IT Pro contacted me and stated they were unable to login to one of their SQL Servers using Windows Authentication. The following error was generated when attempting to login to SQL Server Management Studio (SSMS). Their exact words were "I think we have a permissions problem". Clicking on …


    Read More
  • PowerShell One-Liner to Disable Active Directory Accounts and Log the Results to a SQL Server Database

    calendar Feb 16, 2017 · Active Directory PowerShell SQL Server  ·
    Share on: twitter facebook linkedin copy

    The new PowerShell cmdlets that are part of the SQLServer PowerShell module that's distributed as part of SSMS (SQL Server Management Studio) 2016 make it super easy to write the output of PowerShell commands to a SQL Server database. The ActiveDirectory PowerShell module that's part of the RSAT (Remote Server …


    Read More
  • Write a GUI on Top of Existing PowerShell Functions with SAPIEN PowerShell Studio 2016

    calendar Nov 24, 2016 · PowerShell PowerShell Studio SQL Server  ·
    Share on: twitter facebook linkedin copy

    This blog article will demonstrate how to write a GUI on top of your existing PowerShell functions using SAPIEN PowerShell Studio 2016. I've previously written a couple of functions for managing SQL Server agent jobs. These two functions, Get-MrSqlAgentJobStatus and Start-MrSqlAgentJob can be found in my SQL repository …


    Read More
  • PowerShell Function to Check the Status of a SQL Agent Job using the .NET Framework

    calendar Nov 23, 2016 · PowerShell SQL Server  ·
    Share on: twitter facebook linkedin copy

    My previous blog article demonstrated how to start a SQL agent job using the .NET Framework from PowerShell to eliminate the dependency of needing the SQL Server PowerShell module or snap-in on the machine where the command is being run from. There's not much use of blindly starting a SQL agent job without being able …


    Read More
  • Start a SQL Agent Job with the .NET Framework from PowerShell

    calendar Nov 22, 2016 · PowerShell SQL Server  ·
    Share on: twitter facebook linkedin copy

    As of this writing, the most recent version of the SQLServer PowerShell module (which installs as part of SQL Server Management Studio) includes cmdlets for retrieving information about SQL agent jobs, but no cmdlets for starting them. 1Get-Command -Module SQLServer -Name job I recently ran into a situation where I …


    Read More
  • Video: Automate Operational Readiness and Validation Testing of SQL Server with PowerShell and Pester

    calendar Nov 17, 2016 · Operational Validation Pester PowerShell SQL Server  ·
    Share on: twitter facebook linkedin copy

    I recently presented a session on "Automate Operational Readiness and Validation Testing of SQL Server with PowerShell and Pester" for the PowerShell Virtual Chapter of SQL PASS. The video from that presentation is now available: Both the code and slide deck from the presentation can be found in my …


    Read More
  • Store and Retrieve PowerShell Hash Tables in a SQL Server Database with Write-SqlTableData and Read-SqlTableData

    calendar Sep 22, 2016 · PowerShell SQL Server  ·
    Share on: twitter facebook linkedin copy

    In my blog article from last week, I demonstrated using several older open source PowerShell functions to store the environmental portion of the code from operational validation tests in a SQL Server database and then later retrieve it and re-hydrate it back into a PowerShell hash table. Earlier this week, a new …


    Read More
  • Video: Building Unconventional SQL Server Tools in PowerShell

    calendar Apr 15, 2016 · PowerShell PowerShell Summit SQL Server  ·
    Share on: twitter facebook linkedin copy

    Last week, on Wednesday (April 6th, 2016), I presented a session at the PowerShell and DevOps Global Summit 2016 on "Building Unconventional SQL Server Tools in PowerShell with Functions and Script Modules". The video from that presentation is now available: Here's the abstract or synopsis for this …


    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • »
    • »»

Mike F. Robbins photo

Mike F. Robbins

Scripting | Automation | Efficiency
Read More

Disclaimer

All information and code on this site is for informational purposes only and provided as-is. This site does not provide any warranty, either express or implied. All thoughts and opinions are my own.

Recent Posts

  • What does sudo apt update on Linux do?
  • How to configure Azure PowerShell global settings with the *-AzConfig cmdlets
  • Opening specific panes in system settings from the command line on macOS
  • Determine disk usage from the command line on macOS
  • Splitting the PowerShell PSModulePath Cross-Platform
  • Sync VS Code Settings between Computers with Different User Profile Paths
  • Rendering Images in Markdown Preview of Hugo Site
  • Enable PowerShell remoting on ArcoLinux

Categories

POWERSHELL 335 ACTIVE-DIRECTORY 34 SCRIPTING-GAMES 32 SQL-SERVER 20 DESIRED-STATE-CONFIGURATION 18 AZURE 10 HYPER-V 10 LINUX 8 POWERSHELL-SUMMIT 8 VSCODE 8 IIS 6 OFFICE-365 6 PESTER 6 GIT 5 WINDOWS-10 5 ARCOLINUX 4 AST 4 OPERATIONAL-VALIDATION 4
All Categories
ACTIVE-DIRECTORY34 ALTARO-VM-BACKUP2 APPASSURE1 ARCOLINUX4 AST4 AWS1 AZURE10 AZURE-POWERSHELL2 CENTOS1 CROSS-PLATFORM1 DEBIAN1 DESIRED-STATE-CONFIGURATION18 DHCP-SERVER2 EXCHANGE-SERVER2 EXCHANGE-SERVER-20102 GIT5 GROUP-POLICY1 HARDWARE1 HUGO2 HYPER-V10 IIS6 LINUX8 MACOS3 MARKDOWN1 MICROSOFT-SQL-SERVER3 NANO-SERVER1 OFFICE-3656 OPERATIONAL-VALIDATION4 PACMAN1 PAMAC1 PARU1 PESTER6 PLASTER2 POWERSHELL335 POWERSHELL-CORE3 POWERSHELL-STUDIO1 POWERSHELL-SUMMIT8 POWERSHELL-WEB-ACCESS1 RASPBERRY-PI1 REGULAR-EXPRESSIONS1 SAPIEN-TECHNOLOGIES3 SCRIPTING-GAMES32 SERVER-CORE2 SQL-SERVER20 STORAGE-AREA-NETWORK2 TRAINING-VIDEOS4 UBUNTU1 VERSION-CONTROL4 VIRTUALIZATION1 VSCODE8 VWORKSPACE1 WINDOWS1 WINDOWS-105 WINDOWS-81 WINDOWS-8.11 WINDOWS-SERVER-2003-R21 WINDOWS-SERVER-20081 WINDOWS-SERVER-2008-R21 WINDOWS-SERVER-20123 WINDOWS-SERVER-2012-R22 WINDOWS-SERVER-20161 WINDOWS-SERVER-20192
[A~Z][0~9]

Tags

POWERSHELL 328 ACTIVE-DIRECTORY 32 SCRIPTING-GAMES 30 SQL-SERVER 21 DSC 19 DESIRED-STATE-CONFIGURATION 18 HYPER-V 11 VIDEO 11 AZURE 10 PESTER 10 AST 8 LINUX 8 POWERSHELL-VERSION-5 8 VSCODE 8 IIS 6 OFFICE-365 6 POWERSHELL-SCRIPT-MODULE-DESIGN 6 POWERSHELL-SUMMIT 6
All Tags
ACTIVE-DIRECTORY32 ALTARO-VM-BACKUP2 APPASSURE1 ARCOLINUX4 AST8 AWS1 AZ1 AZURE10 AZURE-POWERSHELL2 AZURERM1 CENTOS1 CROSS-PLATFORM1 DEBIAN1 DEDUPLICATION1 DESIRED-STATE-CONFIGURATION18 DHCP1 DHCP-SERVER2 DSC19 EQUALLOGIC1 EXCHANGE-20101 EXCHANGE-SERVER2 EXCHANGE-SERVER-20101 GIT5 GITHUB3 GROUP-POLICY1 HARDWARE1 HUGO2 HYPER-V11 IIS6 LINUX8 MACOS3 MARKDOWN1 NANO-SERVER1 NIMBLE1 OFFICE-3656 ONEGET5 OPERATION-VALIDATION-FRAMEWORK1 OPERATIONAL-VALIDATION4 PACMAN1 PAMAC1 PARU1 PESTER10 PLASTER2 POWERSHELL328 POWERSHELL-CORE3 POWERSHELL-SCRIPT-MODULE-DESIGN6 POWERSHELL-STUDIO1 POWERSHELL-SUMMIT6 POWERSHELL-VERSION-58 POWERSHELL-WEB-ACCESS1 POWERSHELLGET2 PRODUCTIVITY-HACKS1 PSBLOGWEEK1 RASPBERRY-PI1 REGULAR-EXPRESSIONS1 SAN2 SCRIPT-ANALYZER1 SCRIPTING-GAMES30 SERVER-CORE2 SOURCE-CONTROL4 SQL-SERVER21 STORAGE-AREA-NETWORK2 UBUNTU1 VERSION-CONTROL4 VIDEO11 VISUAL-STUDIO-CODE3 VSCODE8 VWORKSPACE1 WINDOWS1 WINDOWS-106 WINDOWS-82 WINDOWS-8.11 WINDOWS-SERVER-2003-R21 WINDOWS-SERVER-20124 WINDOWS-SERVER-2012-R21 WINDOWS-SERVER-20192 WMI2
[A~Z][0~9]
mikefrobbins.com

Copyright  MIKEFROBBINS.COM. All Rights Reserved

to-top