Author: Tracy Boggiano

TSQL Tuesday #93: Interviewing Patterns & Anti-Patterns

This month’s T-SQL Tuesday is brought to us by Kendra Little (blog | @Kendra_Little). Kendra asked to write about interviewing patterns and anti-patterns and to be careful to protect our past/current employers and candidates.  I’m going to talk about things I should have done better for interview that are really technical things but more soft things you …

Read More “TSQL Tuesday #93: Interviewing Patterns & Anti-Patterns”

Setting Custom Fill Factors Based on Page Splits

Introduction There is a lot of talk about what fill factor should be set for an index.  We know for indexes that are ever increasing the fill factor should be set to 100% but for those indexes that are on things like last name or birthday it gets a bit trickier to decide a fill …

Read More “Setting Custom Fill Factors Based on Page Splits”

Monitoring Availability Groups Part 3 – Extended Events

This entry is part 3 of 3 in the series Monitoring Availability Groups

This entry is part 3 of 3 in the series Monitoring Availability GroupsIn last part of the series, we will touch on how to monitor availability groups using extended events.  I prefer this method over using SQL Agent alerts just because I don’t like relying on the individual servers to send me emails.  I like …

Read More “Monitoring Availability Groups Part 3 – Extended Events”

First Time Advise for Attendees of SQLSaturday or Other Pass Events

Recently I came across on Twitter a question from Chad Smith asking for advise on attending his first SQLSaturday.  The fact is asking means he is already ahead of the game and he is on Twitter.  I got him to follow me on Twitter and offered him the following the following advise via a DM …

Read More “First Time Advise for Attendees of SQLSaturday or Other Pass Events”

How to Install SQL Server PowerShell 2017 Remotely to Your Servers

As part of upgrading our SQL Servers to 2017 CTP 2.1 we have a process that runs afterwards that uses Invoke-Sqlcmd cmdlet but with SQL Server 2017, SQL Server PowerShell 2017 is a separate install from the PowerShell Gallery.  So I wrote a process to that will install the SQL Server PowerShell remotely to the …

Read More “How to Install SQL Server PowerShell 2017 Remotely to Your Servers”

Check Backup Encryption Sizes

I had a recent project to enable backup encryption on all our servers.  Then question from the storage team came up will this required additional space.  Well by then I had already enabled in all our test servers so I wrote a query that would compare the average size of backups before encryption to after …

Read More “Check Backup Encryption Sizes”

PowerShell Function to Get Query Store Data Across Multiple Databases

In SQL Server 2016, Microsoft introduced to us the Query Store.  This has been proven to be a very beneficial feature especially at my job, saved the day on Christmas Eve. One of the limitations if see is when you have server with several databases on it trying to find the one that has the …

Read More “PowerShell Function to Get Query Store Data Across Multiple Databases”

Uploading New R Library Packages

Somehow I have become the R DBA at my job which I don’t mind, I plan on taking Microsoft’s Professional Program on Data Science to be familiar with it.  But recently I’ve had to upload files to our R servers which the first time wasn’t too bad.  Copy these files to six different servers but …

Read More “Uploading New R Library Packages”

Monitoring Availability Groups Part 2 – SQL Agent Alerts

This entry is part 2 of 3 in the series Monitoring Availability Groups

This entry is part 2 of 3 in the series Monitoring Availability GroupsIn my last post on monitoring Availability Groups I covered looking at Perfmon Counters now we take a look at getting alerts from SQL Agent. When it comes to checking on your Availability Groups one of the easiest ways to keep track at …

Read More “Monitoring Availability Groups Part 2 – SQL Agent Alerts”

T-SQL Tuesday #90 – Shipping Database Changes

At my first official DBA job, I was being trained the current DBA on deploying stored procedures.  They had system where you received a ticket with the SQL file attached.  You proceed to see if the procedure existed and if it did.  You right click on it and look at who had access to it …

Read More “T-SQL Tuesday #90 – Shipping Database Changes”