Search Results for “log shipping”

  1. Home
  2. Search Results
  3. (Page 2)

[Video] Office Hours: New Las Vegas Home Office Edition

Videos
2 Comments
It’s the first webcast I’ve done from my new Vegas pad. You posted questions at https://pollgab.com/room/brento/ and I discussed the highest-upvoted ones: 00:00 Introductions 02:15 Jim D: Should I use full backups or log shipping for migrations? 03:53 Sev A: What are the top misuses of SQL Server that are better accomplished without SQL Server?…
Read More

[Video] Office Hours Speed Round: SQL Server Q&A

Videos
0
You posted questions at https://pollgab.com/room/brento and I picked the fastest ones to answer: Here’s what we covered: 00:00 Introductions 00:16 Disgruntled App Developer: Hi Brent a friend was recently reprimanded for running a trace in production. The rationale was perf impact and other ‘potential issues’ that weren’t forthcoming. Any thoughts on why traces have an…
Read More

[Video] Office Hours: Cabo Home Studio Edition

Videos
0
Got questions about SQL Server? Post them at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. This episode was the first live one I shot in my home studio in Cabo: Here’s what we covered: 00:00 Introductions 02:19 Nullpointer: What are your thoughts on temporal tables, I don’t hear you talk much…
Read More

[Video] Office Hours: SQL Server Q&A in Cabo at Sunrise

Videos
4 Comments
Let’s watch the sun rise at Land’s End and cover your top-voted questions from https://pollgab.com/room/brento/. Here’s what we covered: 00:00 Introductions 01:04 Jr Wannabe DBA: Hi Brent, a colleague wants to upgrade from Standard to Enterprise purely for performance gains on several regular servers (up to 8 CPU, 128GB of RAM, SQL 2016 or 2019).…
Read More

[Video] Office Hours in Malibu: Ask Me Anything About SQL Server

Videos
5 Comments
I’m up bright and early in Malibu, so let’s talk through your highly upvoted questions from https://pollgab.com/room/brento. 00:00 Introduction 01:04 JD: Have you ever encountered a very weird case during query / performance tuning that you just couldn’t get the query across the finish line, specifically just because SQL Server didn’t want to behave nicely?…
Read More

[Video] Office Hours at the Eldfell Volcano Crater

Videos
2 Comments
You posted and upvoted questions at https://pollgab.com/room/brento, and I ascended – well, drove into – the Eldfell Volcano in the Westman Islands to answer ’em: Questions we covered in the video: 00:00 Introductions 01:55 Do you notice big improvements for physical servers over virtual servers? 05:14 Why aren’t my SQL Servers using all of the…
Read More

Do You Have to License Your Standby SQL Server?

Licensing
23 Comments
Businesses who need high availability and disaster recovery usually want three servers: A primary SQL Server where all the writes & reads take place A high availability SQL Server sitting right next to the primary, in the same data center, keeping up with its writes, and A disaster recovery SQL Server sitting in another city…
Read More

SQL Server Upgrades and Migrations

Your Microsoft SQL Server had a good run. But it’s getting creaky and old, and you’ve decided it’s time to make a change. You’re trying to decide which version of SQL Server to use, and which cloud options make the most sense. “Hey, I see the problem already!” I can help. I’ve built and rebuild…
Read More
SQL ConstantCare

What SQL ConstantCare® Looks For

“This server’s plan cache smells terrible.” SQL ConstantCare® analyzes your data looking for health and performance issues that cause user pain. Here are the things we check for and the number of servers where we found this problem this month: Backup Back Up Your TDE Certificate – 137 servers affected CRITICAL: Take a Full Backup…
Read More

Can I Offload DBCC CHECKDB To Another Server?

You want to check for corruption, but you don’t want to slow down your primary production server. In this post, I’m specifically talking about offloading the corruption checking process. I’m not talking about doing corruption checking on both the primary and other servers – that’s wonderful, and if you’re doing that, you should hug yourself. You’re doing…
Read More
Menu