T-SQL Tuesday #88: My Top WTF Moments

Welcome to T-SQL Tuesday #88 being hosted this month by Kennie Nybo Pontoppidan (blog|@KennieNP). This month’s topic is the “daily (database-related) WTF”, and I want to share some of my top WTF moments. If you would like to participate in this month’s blog party, go to Kennie’s invitational blog post: Announcing T-SQL Tuesday #88 – The daily (database-related) WTF. You did what to your database mirroring? I was working on an operations team at Microsoft, when I got a call
read more

2016/2017 Whitepaper Updates

One of the problems with whitepapers is that they get out of date pretty quickly. It’s important to update them regularly to keep them relevant. A few of my older whitepapers have been updated by my friend and colleague Kenneth Fisher (blog|@sqlstudent144). I helped with some technical review and provided the original content, but the rewrites were all his. You can download the updated whitepapers using the links below: DBA Tactics for optimizing SQL Server Network Performance Initializing Replication from
read more

The Costs of Hiring Cheaper Consultants

From time to time, I see posts in forums from people complaining about how much some consultants charge. A really good consultant is never going to be cheap. That’s just the law of supply and demand at work right there. When I was consulting, I had plenty of people balk at my consulting price. I had no problem with someone not wanting to pay that price. If I wasn’t getting clients at that price, I would lower the rate. And
read more

T-SQL Tuesday #87 – New Way to See Wait Stats for a Single Query

Welcome to T-SQL Tuesday #87 being hosted this month by Matt Gordon (blog|@sqlatspeed). This month’s topic is “Fixing Old Problems with Shiny New Toys”. The old problem I’m going to talk about is seeing what wait types are experienced by a particular query. If you would like to participate in this month’s blog party, go to Matt’s invitational blog post: Announcing T-SQL Tuesday #87 – Fixing Old Problems with Shiny New Toys. Why is my query waiting? SQL Server 2005
read more

Warning: Not a valid checkpoint file name

One of the other DBAs I work with noticed a warning message that was flooding the log files on one of our servers. He asked me to look into it. I did a Bing search for the warning message and found no useful links. This is the warning message: [WARNING] HkHostBackupGetCheckpointFileInfoV2(). Database ID: [<database ID>]. Not a valid checkpoint file name. FileName: fffeaca6-ffff519f-fffc.00015359-0000ae60-0003.c1242a5d-8a93-46ec-9e21-cf41c32179fa.0-0.1000016. (d:\b\s1\sources\sql\ntdbms\hekaton\sqlhost\sqlmin\hkhostbackup.cpp : 2958) The database ID was the ID of the database in which we had recently
read more

Finding Automatic Soft-NUMA

If you already know about Automatic Soft-NUMA in SQL Server 2016, then you probably already read the blog post SQL 2016 – It Just Runs Faster: Automatic Soft NUMA by Robert Dorr, who makes up one half of “the Bobs” that run the BobSQL blog. The other Bob, Bob Ward (@bobwardms), followed that up with How It Works (It Just Runs Faster): Auto Soft NUMA…. Lots of great info there. So having read up on automatic soft-NUMA, I was eager
read more

T-SQL Tuesday #85 Part Deux: Backup Myth Restoring Differential Backups

Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”. This is one of my favorite topics, so the hard part was narrowing down what I want to cover .. as you can probably tell by me doing a second post for this month. I call this one T-SQL Tuesday #85 Part Deux. If you would like to participate in this month’s blog party, go to Kenneth’s invitational blog post:
read more

T-SQL Tuesday #85: Backup Log With NoRecovery

Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”. This is one of my favorite topics, so the hard part was narrowing down what I want to cover. If you would like to participate in this month’s blog party, go to Kenneth’s invitational blog post: T-SQL Tuesday #85: Backup and Recovery. NoRecovery Many of you already familiar with the NORECOVERY option for performing restores to allow you to continue
read more

T-SQL Tuesday #83: Resource Governor CAP_CPU_PERCENT: It just runs faster?

Welcome to T-SQL Tuesday #83 being hosted this month by Andy Mallon (blog|@AMTwo). This month’s topic is “We’re still dealing with the same problems”. If you would like to participate in this month’s blog party, go to Andy’s announcing blog post: T-SQL Tuesday #83: We’re still dealing with the same problems. For my part of this blog party, I want to talk about CAP_CPU_PERCENT for Resource Governor. This feature was added to Resource Governor in SQL Server 2012, and Books
read more

T-SQL Tuesday #81 – Migrating Databases with Dell LiteSpeed

It’s time for T-SQL Tuesday again, and this month’s host is fellow Certified Master and Data Platform MVP Jason Brimhall (Blog|@sqlrnnr). Jason has challenged us to spend some time sharpening a skill and then blog about it. For my participation, I found myself needing to get reacquainted with a third-party backup software that I had not used in many years, LiteSpeed for SQL Server by Dell. I worked with LiteSpeed extensively many years ago when I was a DBA at
read more