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

Schema-only Backups and Restores

I was reading the blog post Time for a Quick Rant by Grant Fritchey (blog|@GFritchey) about people who choose to not back up a database simply because it is large. I agree wholeheartedly with Grant on this topic. Simply choosing not to back up a database is, well to put it nicely, reckless. The comments that followed brought up some good points about some scenarios where you might choose to not back up a very large database. I performed operations
read more

T-SQL Tuesday #50: Doing More With Less

It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #50 is hosted this month by Hemanth.D (Blog|@SQLChow). You are invited to visit his blog to join the blog party. You are also welcome to write your own participating blog post for the party or just to read more blogs participating in this month’s theme: Automation! For my part in this month’s blogfest, I want to talk about a tricky data transfer
read more