AWS IAM Basics using AWS Tools for Windows PowerShell – Wrap Up

Over the last few blog posts I have quickly gone over AWS IAM Users, Groups and Roles. Specifically the PowerShell cmdlets to interact with these IAM identities inside of your AWS account. To end the AWS IAM Basics series, I’ll demonstrate how to put them altogether. Users Let’s create 2 users, junior and senior. Groups Let’s create a group
Continue reading AWS IAM Basics using AWS Tools for Windows PowerShell – Wrap Up

AWS IAM Basics using AWS Tools for Windows PowerShell – Roles

So far I’ve covered IAM Users and Groups. Today I’ll be looking at IAM Roles. Here is a brief description of what roles are from the AWS IAM Roles User Guide. An IAM role is similar to a user, in that it is an AWS identity with permission policies that determine what the identity can and
Continue reading AWS IAM Basics using AWS Tools for Windows PowerShell – Roles

AWS IAM Basics using AWS Tools for Windows PowerShell – Groups

Last post I wrote about how to use AWS Tools for Windows PowerShell to create, get, update and remove IAM users in your AWS account. In this post I will show you how to create, list, edit and remove IAM groups. Let’s jump straight in! Create Groups To create a new IAM group we call the New-IAMGroup cmdlet,
Continue reading AWS IAM Basics using AWS Tools for Windows PowerShell – Groups

AWS IAM Basics using AWS Tools for Windows PowerShell – Users

This year I’ve started studying towards the AWS Certified Solutions Architect Associates exam. As a side to my studies, since I also use PowerShell a lot, I thought it’d made sense to also look into the AWS Tools for Windows PowerShell and see what cmdlets they provide. The first module as part of my studying was on
Continue reading AWS IAM Basics using AWS Tools for Windows PowerShell – Users

Add a database filegroup and file to an existing database using PowerShell

Majority of the examples I could find online to add database filegroups and/or files using PowerShell were for new databases. They made use of methods that didn’t work for what I was after. What I needed to do was add a database filegroup and file to an existing database. Examples, and until recently, documentation, I
Continue reading Add a database filegroup and file to an existing database using PowerShell

Permissions required for SQLjobvis

SQLjobvis is a tool I’ve blogged about before. For more info on what SQLjobvis is and how it can help you you can read my blog post here. A reader had commented on that post and mentioned that they didn’t have the necessary permissions to run SQLjobvis. But what are those permissions? The website doesn’t appear to
Continue reading Permissions required for SQLjobvis

The EXECUTE permission was denied on the object ‘xp_cmdshell’, database ‘mssqlsystemresource’, schema ‘sys’

A user will usually receive this error message when trying to execute xp_cmdshell and does not have sufficient permissions. To grant permissions to execute xp_cmdshell using TSQL, run the query below. To test this works I usually run the query below. To test the granted execute permissions work for the intended user, I impersonate them
Continue reading The EXECUTE permission was denied on the object ‘xp_cmdshell’, database ‘mssqlsystemresource’, schema ‘sys’