T-SQL Tuesday #74: Ch-ch-changes

Welcome to my contribution for T-SQL Tuesday 74 being hosted by me. So special thanks to me for hosting it. Good job me, I’ll buy me a beer next time I see me to thank me properly. But enough about me, my post is about using Query Store in SQL Server 2016 to identify queries or plans that have changed. Visit the blog party page to take part in this month’s T-SQL Tuesday event or to read other blog posts
read more

T-SQL Tuesday #73: Never Made That Mistake Again

T-SQL Tuesday is a monthly community-wide blogging event created by Adam Machanic (blog|@AdamMachanic), and everyone is invited to particpate. This month’s blog post party — I like that phrase, it has a nice ring to it — is being hosted by Bradley Ball (blog|@SQLBalls), and the holiday-themed topic this month is T-SQL Tuesday #73: Naughty or Nice?. For my part, I want to relate a cautionary tale about how I crashed a production server at Microsoft at 3 o’clock in
read more

New Whitepaper: Deciding Between Merge and Peer-to-Peer Replication

Replication is still a major component of SQL Server today even with Availability Groups as an alternative to certain scenarios. Availability Groups does not allow you to have more than one writeable version of the data at any given time. Replication is the only native component or feature in SQL Server that will allow you to have multiple writeable databases that maintain data in sync to any near-real-time degree. Once you have determined that you need a solution that provides
read more

Oklahoma City User Group Presentation Files

Earlier this week, I got the opportunity to present online for the Oklahoma City SQL Server User Group on SQL Server Mythconceptions and Mythteries. The files from my presentation are attached below for download. The zip file contains my slide deck and demo code from the session. SQLServerMythconceptionsAndMythteries.zip (653 KB)
read more

Error Creating Remote Distributor When Creating a Local Distributor

Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some lab servers to test my scripts, I ran into some issues. The thing that confused me at first was that it was complaining about a missing remote login for the replication linked server that gets created when you run sp_adddistributor. The reason the error was confusing at first is because I was creating local distributors (the best practice for peer-to-peer
read more

T-SQL Tuesday #65 – Overcoming Variable Limitations in SQLCmd Mode

It’s time again for that T-SQL blog party T-SQL Tuesday, and this month’s host is Mike Donnelly (blog|@SQLMD). If you want to join in the blog party, take a look at Mike’s announcement for an explanation of the topic and rules for participating: T-SQL Tuesday #065 – Teach Something New. My contribution this week is about overcoming the variable limitations of SQLCmd mode. Most people know what SQLCmd is, the command line SQL client utility for running T-SQL, or perhaps
read more

Performance Counters: Why It Depends

When you’re working through some vague performance issues (e.g., “SQL Server seems slow today”), one of the common things to do is to collect some performance counters. If you are collecting performance counters for the first time on the server, you don’t have anything to compare them against. This usually leads to searching the web for resources that will tell you what numbers the counters should be. And sadly, it quite often ends with either misleading advice or with a
read more

Size Matters: 2 Products to Accelerate SQL Traffic

I talked previously about network pipelines and how to get the most out of a fat network in the post Network Packet Size: to Fiddle With or Not to Fiddle With. If you need to move large amounts of data and have a network infrastructure that can support a larger then normal packet size, you can get tremendous performance boosts by increasing packet size. The big performance boosts can only be realized if every part of the path between server
read more

Why is Your SQL Server Slow? All-for-one and One-for-all

I have one more thing I want to talk about regarding the conversation I had recently with my friends and former colleagues at Idera about the things that slow down SQL Server. Another “quick performance wins” you can take advantage of is segregating the types of files SQL Server uses. If you install SQL Server by just clicking NEXT until you get to the end, you end up with everything running on the same drive. Different files have different types
read more

Why is Your SQL Server Slow? Here's a Hint

I was talking recently with my friends and former colleagues at Idera about the things that slow down SQL Server. Specifically, the discussion was about things that people could change without a lot of trouble to make their SQL Server run faster. I like to use the phrase “quick performance wins” for these easy-to-fix issues that can generate a considerable performance boost. This conversation led to a whitepaper on 5 things that are making your SQL Servers slow. Watch Idera’s
read more