T-SQL Tuesday 122# Imposter syndrome

My T-SQL contribution for this month discusses imposter syndrome. This month’s T-SQL Tuesday is hosted by Jon Shaulis. Jon invites us all to write about when we have seen, experienced, or overcome imposter syndrome. You can read more about the invite in detail by clicking on the T-SQL Tuesday logo.

My Experience

I’ve had my fair share of experiences with imposter syndrome in my career.

My first time was when I first went on SQL Cruise, now called Tech Outbound, and I had the privilege to meet people like Aaron Bertrand, Grant Fritchey, Kevin Kline, etc.

Read more →

CI/CD for databases: Setting Up The Project

This series has been a long time coming. I have been struggling with continuous integration and continuous development for a while and I want to share my process, techniques, and tips and tricks with you.

I will publish several blog posts about this process because we cannot go through all of it at once. It would lead to a TL;DR article that nobody will read.

  • The first part will be setting up the project/solution for your database.
  • The second part will be about creating unit tests for your database objects.
  • The third part will be to put the project through a build server and eventually a deployment server

Why this series

I never had to do a lot of work with source control, visual studio, and all the related parts because I would get a script, and deploy it in a test. If it worked fine, if not I would have a backup and restore that.

Read more →

Use Azure To Store SQL Server Backups Offsite

You always think your environment is set up correctly and that you’re able to recover in case of a disaster.
You make backups, test your backups, set up DR solutions, and in the end test the DR plan (very important). But have you ever considered a situation where all your data is unusable?

If you get infected with ransomware, and the trojan gets a hand on your backups, all your precautions and preparations have been for nothing.

Read more →

T-SQL Tuesday 116# Why adopt SQL Server on Linux

My T-SQL contribution for this month discusses why you should consider adopting SQL Server on Linux.

This month’s T-SQL Tuesday is hosted by Tracy Boggiano. Tracy invites us all to write about what we think everyone should know when working with SQL Server on Linux, or anything else related to SQL running on Linux. You can read more about the invite in detail by clicking on the T-SQL Tuesday logo on the left.

Read more →

The yes/no e-mail and the rubber duck

I recently read an article about delegation of work and this gave me an idea of the yes/no e-mail and the rubber duck.

What is this article about

This article is about the delegation of work. When you manage a team you could get lots of e-mails from people asking all sorts of questions for you to figure out.

Mostly those questions are along the line of “What do I need to do?” This article describes that situation and how you could handle it in a more efficient way for both you and the employees.

Read more →