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

Get new content delivered directly to your inbox.