Raymond Gallagher

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.
. . .

Read More

April 19, 2019

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 . . .

Read More

May 12, 2018

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, . . .

Read More

May 12, 2018

Data Architecture and Engineering

Here is a recent presentation I did concerning different platforms and technologies related to data architecture and engineering. It discusses traditional relational database management systems, data warehouses, big data, noSQL and streaming data.

Read More

May 12, 2018

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 . . .

Read More

May 12, 2018

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.

Read More

May 12, 2018

SQL Server 2016 – Query Store

I recently created a presentation and a demo for the new Query Store feature in SQL Server 2016. You can access both here.

Read More

May 12, 2018

Archive