Skip to content

Ryan Adams Blog

Microsoft Data Platform

  • Home
  • About Ryan
  • Presentation Materials

Category: PowerShell

June 19, 2018

Verify Allocation Unit Size for SQL Server

Why Do I Care? Everything in SQL Server is stored on disk in 8K pages.  The Microsoft recommended best practice is to format using a […]

Performance, PowerShell, SQLServerCentral Syndication, SQLServerPedia Syndication, Standards by Ryan Adams
June 8, 2017October 25, 2019

Sync SQL Logins and Jobs

In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option in a video.  If you […]

AlwaysOn AG, Logins, Mirroring, PowerShell, SQLAgent, SQLServerCentral Syndication, SQLServerPedia Syndication, SSIS by Ryan Adams1 Comment on Sync SQL Logins and Jobs
June 22, 2011

syspolicy_purge_history Job Fails

The syspolicy_purge_history SQLAgent job is used by Policy Based Management in SQL server to clear out the policy evaluation history kept by PBM. The job consists […]

Clustering, Policy Management, PowerShell, SQLServerPedia Syndication by Ryan Adams1 Comment on syspolicy_purge_history Job Fails

Categories

Data Platform MVP

Data Platform MVP

Microsoft Certified Trainer

Microsoft Certified Trainer

Copyright © 2022 | All Rights Reserved

Shark Magazine by Shark Themes

 

Loading Comments...
 

You must be logged in to post a comment.