SQL Server Reporting Services Report Performance Comparison
In my career I have had to upgrade the SQL Server Reporting Services (SSRS) platform multiple times in various environments. Often, I need to compare report performance from one instance of SSRS to another, to identify reports that perform worse on a newer platform. Often, Microsoft will introduce features or change how reports are executed, . . .
Create-ADSQLPermissions
This code takes a set of business requirements and creates Active Directory (AD) groups and members as well as SQL Server logins, users and permissions. The code is Powershell based and can be run with only a few parameter changes. The business requirements are based on an Excel spreadsheet which can be used as a template.
In order . . .
Page Life Expectancy Using Idera SQL Diagnostic Manager Data
This process uses Idera SQL Diagnostic Manager (Idera SQLDM) to generate persisted information about sessions running whenever the Page Life Expectancy (PLE) counter falls below a threshold set in SQLDM. I built this process as I needed to know what was running on a given server whenever the PLE fell below a set value. I wanted the active . . .
SQL Server Automated Partitioning
SQL Server partitioning is a feature that allows you to physically and logically partition data in tables to different files and filegroups. I won’t go through a tutorial of how partitioning works here because that exists in a variety of locations, both online and offline. What I will do is walk you through a solution for automating . . .
Capacity Planning and Linear Regression
When using Idera SQL Diagnostic Manager to monitor your SQL Server environment, you’ll probably find yourself using their built in reports and dashboards for capacity planning. Although they are good, I found myself building some additional reports to better answer the questions I was after. Specifically, when will a drive fail due to an out . . .
