Database Configuration Management
I've uploaded a collection of projects and code related to database configuration management for use in managing and reporting on multiple SQL Server instances and databases across multiple environments.
Stargazer
Stargazer is a metadata support solution that also collects information on Sql Agent jobs for reporting.
. . .
Business Intelligence with Idera – Update
In October, I discussed how to set up a business intelligence (BI) solution with Idera data using the Microsoft BI stack. This includes Integration Services (SSIS), Analysis Services (SSAS) and PowerBI. Today, I would like to share a minor update to that solution that helped me solve a business problem.
When you have multiple SQL . . .
Business Intelligence with Idera
This post will talk about how to build a business intelligence solution for Idera SQL Diagnostic Manager data using the Microsoft BI stack of software. This includes SQL Server, Integration Services, Analysis Services and PowerBI. As Idera comes with its own suite of software to display dashboards for data, this project as a bit of overlap, . . .
SQL Server All in One Partitioning
Following up on my earlier post about partitioning management and how to automate it, this post will cover some steps to convert existing tables to a partitioning structure.
I will include the code below and talk about the relevant sections. We will create a database, add filegroups and files, build partition functions and schemes . . .
Database Architecture and Platforms
Below is a presentation highlighting various database platforms and architectures. It’s based on the book Next Generation Databases by Guy Harrison. I found the book to be a very good read and subsequently decided to make a presentation with the key takeaways. You can access the presentation here.