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
Update Job Step Across Multiple SQL Servers
I recently needed to update the command of a job step for a job existing on multiple servers. Logging into each server to make the same changes can be time consuming. Thankfully, there are better methods. Let’s look at a couple of ways to update a job step more efficiently. Update with Central Management Server … Continue reading Update Job Step Across Multiple SQL Servers
T-SQL Tuesday #152 – A Rant
This month’s T-SQL Tuesday invitation comes from Deborah Melkin. We’re invited to give a good rant about a database topic that we’re passionate about. For the full invite post, click the T-SQL Tuesday image below: Beware The Quiet Ones I’m not usually one for ranting. Don’t get me wrong, I have my moments. Everyone does. … Continue reading T-SQL Tuesday #152 – A Rant
Gotcha When Setting Variable
Did you know there is more than one way to set a variable in SQL Server? You can actually set a variable without using “SET” at all. Let’s look at an example that shows how setting a variable with SELECT can cause a headache when dealing with identical values. One and Only? What if we … Continue reading Gotcha When Setting Variable
SQL Statement Categories
Since you’re reading this blog post, you’re probably used to running different types of SQL statements. Do you ever stop to consider what category those statements fall into? Maybe you’ve heard the acronyms DML and DDL tossed around but don’t know what those mean. Maybe you’re not familiar with the acronyms DCL and TCL. Let’s … Continue reading SQL Statement Categories
SQL Server 2022 – GREATEST and LEAST
Have you had an opportunity to play around with SQL Server 2022 yet? A quick Google search will return plenty of great blog posts and articles about new features. One new feature included in the upcoming release is the pair of GREATEST and LEAST functions. Let’s dig into how GREATEST/LEAST compares with MAX/MIN and look … Continue reading SQL Server 2022 – GREATEST and LEAST
T-SQL Tuesday #151 – T-SQL Coding Standards
This month’s T-SQL Tuesday invitation comes from Mala Mahadevan who asks about T-SQL coding rules and if there are any exceptions to the rules. I had just recently been in a discussion about standards regarding SELECT * so that’s what we’re going to discuss in today’s post. To check out the full invitation, click the … Continue reading T-SQL Tuesday #151 – T-SQL Coding Standards
SQL Server 2022 Public Preview
I’m a little bit behind on this topic so chances are the blog post title and contents aren’t a big surprise. SQL Server 2022 private preview was announced last November. As of a few weeks ago, the public preview is available for download. If you’re interested and want to check it out for yourself, head … Continue reading SQL Server 2022 Public Preview
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
Chad Callihan 