Projects

CI and CD with SSDT and living to tell about it

(deprecated) CI and CD with SSDT Part 2 – SSDT Methodology and Features for DB DevOps

2020-04-28

Meet SSDT (SQL Server Data Tools), that comes with the SQL Database Project as an effective tool for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD: SSDT comes with an answer for all.

In this session, the second of a 2-part series, we will cover the rich tools, features, and methodologies in SSDT that allow DBAs to implement a continuous database development lifecycle. We will also learn about solutions to common fears and objections coming from naysayers, common problems while starting with SSDT for the first time, and various problematic edge cases and how to solve them.

SSDT in general (SQL Server Data Tools), and the SQL Database Project specifically, are very effective tools for integrating the database development with the software development lifecycle. Source control, version history, unit testing, and CI/CD – SSDT has it all – and it’s completely free!

We all know the database is a critical element of your software product. It’s high time for that fact to be reflected in your database development lifecycle!

CI and CD with SSDT Part 1 – Development Lifecycle Basics for DBAs

2020-04-282024-02-29

What is source control? What is version history? What are unit tests? What do CI and CD even mean, and what the heck is an Artifact?? In this new era of Agile development, DevOps, DataOps, and other weird buzzwords, we the DBAs gotta learn to keep up. It’s time to add our monstrous database into the continuous integration pipeline. But first, we need to know what we’re getting into and need to familiarize ourselves with the terms and methodologies of the world of software development lifecycles.

In this session, the first of a multi-part series, we will learn what is Git Source Control? What are CI/CD Pipelines? What are Unit Tests? These are all topics that each DBA must familiarize themselves with before integrating with the software development lifecycle.

Database File Size Maintenance

2020-04-27

This project is for development of a stored procedure, which is to be used as an add-on to Ola Hallengren’s maintenance solution, and retains the same standards and conventions in its implementation of parameters.

The DatabaseFileSizeMaintenance stored procedure focuses on managing database file size growth and shrink, based on specified parameters.

Send calendar invites from within SQL Server

2020-04-24

Looking for a way to send calendar event invitations from within SQL Server?

Did you try that one hack where you use sp_send_dbmail to generate an ics attachment file, and then found that it’s still not being identified as a calendar event in the e-mail program?

Then fret no more, my friends, because I’ve been there, and out of sheer desperation of not being able to find a properly working solution, I’ve decided to build one myself. And now it’s available for your wide consumption as an open source project!

Microsoft SQL Server Page Allocation Reports

2020-04-20

This open-source project aims to visualize your SQL Server data and transaction log file contents. It is currently built with Power BI, but there are plans for implementation in other technologies as well (you’re welcome to contribute!).

GitHub Gists

2019-12-05

Throughout my day-to-day job, I get to write a lot of T-SQL scripts for all kinds of varied needs and scenarios. Every once in a while I get to write something pretty cool which I think other people can also find useful.