You Have One Job

I’m sure most if not all of you are familiar with the meme “You had one job”. I was reminded of this meme this past Friday when I headed out to run an errand at lunch time. There were 3 guys standing in the middle lane of a busy intersection, 2 were road workers and 1 was a flagger holding a sign that said SLOW on one side and STOP on the other. The flagger was standing in between the
read more

SQLSaturday 461: Join Me For a Full Day of Performance Training in Austin

Join me Friday, January 29, 2016 for a full day of performance tuning training as part of SQLSaturday 461 in Austin, TX. Then stick around for the main event on Saturday where I will be among the many great presenters at the SQLSaturday event. My regular session on Saturday in the last slot of the day will be Strategies for Working with Texas-sized Databases. Learn more about the event: SQLSaturday 461 Register for the pre-con: Performance Tuning Like a Boss
read more

PASS Summit 2015 and SQLSaturday Oregon Sessions

PASS Summit 2015 is over and of course, no PASS Summit is complete without also attending SQLSaturday Oregon. Below are my session files from my half-day session on DBA’s Guide to Administering BI Systems at PASS Summit and Who has What to Which (The Permissions Superset) at SQLSaturday Oregon. PASS Summit Session Files: Demo code and slide deck: RobertDavis_DBAsGuidetoAdministeringBISystems_09012015.zip (1.9 MB) SQLSaturday Oregon Session Files: Demo code and slide deck: WhoHasWhattoWhich_ThePermissionsSuperset_Demo.zip (4 KB) Swag in my PASS Summit Session: Nerds
read more

So Long Seattle and Thanks for all the Fish!

I’ve had some good times in the Seattle area. I’ve lived in the Seattle are since 1987 and graduated high school here in 1988 (South Kitsap High in Port Orchard, WA). That’s 28 years I’ve been here. That’s a long time, but now it’s time to part ways. Likewise, my wife has been in the Seattle area since she was 8 years-old. We’ve both been here for a long time and are ready for a change. So goodbye Seattle. Hello
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

How Many Objects Can Own Pages in a Mixed Extent

I saw an exchange on Twitter this past weekend on the #sqlhelp hash tag about how pages are allocated for a temp table. The replier (blog|@sqL_handLe) — whom you should be following if you’re not already, very smart guy — gave the classic response about mixed extents and how they can be owned by up to 8 objects. The link he provided, Understanding Pages and Extents, agrees with him and says, “Mixed extents are shared by up to eight objects”.
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

Patching Master Data Services

I recently installed my first deployment of Master Data Services (MDS). I installed the SQL Server 2014 (Enterprise Edition) MDS front-end on a new server with the intent to use an existing SQL Server 2014 (Enterprise Edition) database engine for the back-end. Unsurprisingly, I ran into some issues, and as luck would have it, they were not all well documented. I found some help online in places like Microsoft Connect and the TechNet Forums, but much of what I found
read more