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?
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
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
- August 2022 (2)
- July 2022 (4)
- June 2022 (5)
- May 2022 (4)
- April 2022 (4)
- March 2022 (4)
- February 2022 (4)
- January 2022 (5)
- December 2021 (8)
- November 2021 (9)
- October 2021 (8)
- September 2021 (9)
- August 2021 (9)
- July 2021 (7)
- June 2021 (9)
- May 2021 (8)
- April 2021 (8)
- March 2021 (8)
- February 2021 (8)
- January 2021 (9)
- December 2020 (10)
Get new content delivered directly to your inbox.