SQL SERVER DBA ATTEMPTING TO BLOG
What a great topic for the start of the year as we’re all thinking about goal setting and personal improvement. Thanks to Jon Shaulis (b|t) for hosting this first monthly blog party of the decade. Imposter syndrome is mentioned so often in our community, and it’s really interesting to me the wide number of people,…
This is a time for material gift giving, for many of us. It might also be a time to consider the many gifts we have received through the year, and perhaps use this opportunity to appreciate people or situations that we were blessed with. When I first saw Mala’s post last week for the last…
I’ve been thinking about the cloud a lot lately, and I feel it’s an area that I would benefit from learning more about. I’ve attended a couple of presentations on SQL Managed Instances and have read enough to be dangerous (or accidentally spend a lot of money, one of my biggest fears when working in…
Today, October 11th is National Coming Out Day in the United States. This (2019) will be the 31st anniversary of its founding by Robert Eichberg and Jean O’Leary. The idea was to raise awareness and support for the LGBT community. If you know someone who identifies as LGBT you are more likely to support equal…
It’s time for our monthly T-SQL Tuesday blog party again and we have another interesting prompt to write about. Thanks goes to Alex Yates (b|t) for hosting this month. I’ve thought about this a lot over the last few days and really wanted to find a technical topic to write about, but over and over…
This month our T-SQL Tuesday host, Kevin Chant (b|t), has challenged us to propose a new fantasy feature for SQL Server. Firstly, thanks to Kevin for hosting this month’s blog party. When I first read the invitation I didn’t have any ideas jump straight into my mind. Since then, I’ve come up with two. I’m…
When you enact a configuration against a target node by default the process runs as the local system account. For most of your DSC resources this is fine. However, if you need to access something like a file share, active directory or user registry settings, you might start to run into permission issues. DSC Resources…
Sometimes it’s best not to ask why. However, if for some reason you have a number of triggers on tables within a database that you would like to temporarily disable, read on. I came across a situation recently while automating a process to refresh test environments where this exact scenario came up. As part of…
This month’s T-SQL Tuesday is all about Memory Optimized Tables (MOT), a topic I will admit I know almost nothing about. When they first came out in 2014 I was excited about the new technology and the options that would bring, however I never found a good reason to implement them. Thanks to Steve Jones…
As a SQL Server DBA, aggregating data is first nature. I can easily throw together some T-SQL if I need to get the average sales per product group, or perhaps the number of employees hired per month. Yesterday I was writing a little PowerShell when I came across a problem. I needed to get the…