Chad Callihan

Latest from the Blog

Are Forced Plans Always Forced?

Query Store is useful for forcing a beneficial plan. What if something changes that makes the forced plan impossible to use? Let’s look at an example of that today. Building a Rep Let’s use the StackOverflow 2013 database and create a test procedure that returns information from the Users table based on a user DisplayName: … Continue reading Are Forced Plans Always Forced?

August 9, 2022

Insert IIS Logs Into SQL Server

Digging for information in IIS logs by opening individual files can be tiresome. Perhaps you’re tracking connections from a certain client. Maybe you were tasked with tracking what browsers are accessing your websites. Regardless of the reason, opening a file in notepad to scroll or pressing CTRL-F to dig for information isn’t fun. Instead, search … Continue reading Insert IIS Logs Into SQL Server

August 3, 2022

Inserting and Exporting MySQL Values with PowerShell

I recently went through an example of making SQL Server changes with PowerShell. To continue on a PowerShell trend, let’s take a look at inserting and exporting MySQL values with PowerShell. Inserting into MySQL with PowerShell I created a local example database called exampledb with a table called Comic. Let’s say we want to connect … Continue reading Inserting and Exporting MySQL Values with PowerShell

July 28, 2022

Get new content delivered directly to your inbox.