Setup New User for AWS RDS SSRS Access
This post will assume that you work in IT OPS and have access and permission
David Speight
https://www.linkedin.com/in/davidspeight/
SQL PERFORMANCE MONITOR – BONUS: Power BI Dashboard
LEVEL: 300 – This quick article assumes that you already have at least one (1)
PowerBI Report Usage Stats
Today my boss wanted a report regarding how often each PowerBI report was being hit.
Shrink Database
Code snippets for shrinking database and database log files for EC2 and OnPrem. This will
SQL Logins and SQL Users
Code snippets for creating new LOGINS and USERS. Remember LOGINS are at the server/instance level
Create RDS database with Cloud Formation
AWS Cloud Formation allows you to programmatically create a template that you can use to
SQL PERFORMANCE MONITOR – PART 10: Snapshots & Fine Tuning
Due to the amount of data collected from dozens of servers at half a dozen
SQL PERFORMANCE MONITOR – PART 9: SSRS DASHBOARD
Today I am putting together my SSRS dashboard. This will be an OVERVIEW page that
SQL PERFORMANCE MONITOR – PART 8: Report Views and Procedures
In this section I will explore some example views that I will be using in