Search Results for “failover cluster”

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

Failing over an Asynchronous Mirror in SQL Server (video)

Database Mirroring
5 Comments
Will a long running open transaction block you from changing to synchronous mode and failing over to your SQL Server database mirror? Join Kendra to test performing a planned failover from an asynchronous database mirror. Brent Says: Often, when I’m working with developers, they’re totally surprised that SQL Server’s failover methods all break in-flight transactions. No matter…
Read More

The Most Confusing Words, Phrases, and Acronyms in SQL Server

Humor
13 Comments
Words are hard. Acronyms are even harder. Here’s the words that give me the most trouble when talking to people about SQL Server. And thanks to all my Twitter friends quoted here for their suggestions! Replication “I have a question about replication…” “Which kind? Transactional? Merge? Peer to Peer?” “Availability Groups.” Technically, the word “replication”…
Read More

Transactional Replication Architecture: Isolating Subscriber Tables

Replication
4 Comments
The best part about transactional replication is that it’s flexible. And the worst thing about transactional replication is that it’s flexible. A poor replication configuration will cause you performance pains and increase your risks of development and administrative errors. Here’s one important design principle: isolate your replication subscriber tables from one another, and from non-subscriber tables.…
Read More

Oracle HA & DR Basics [With Video]

Oracle
0
Oracle has different availability and recovery options from SQL Server. Being aware of what these options are and how you can use them will go a long way toward keeping your Oracle boxes just as safe as your SQL Server boxes. Here’s my 17-minute video explaining it, or you can keep reading and get your…
Read More

“If You Can’t Do ____, You’re Not a Production DBA”

Recently I saw a tweet that said, “If you can’t read a query execution plan, you’re not a production DBA.” I love execution plans, and there are really great reasons to learn to read execution plans, but I disagree completely. Database Administration is not all about performance Performance is only one component to database administration. Let’s…
Read More

SQL Server 2014 Licensing Changes

Licensing
159 Comments
With the release of SQL Server 2014, we get to learn all kinds of new licensing changes. While I don’t work for Microsoft legal, I do have a PDF reader and a web browser. You can follow along in the SQL Server 2014 Licensing Datasheet… if you dare. Server + CAL Licensing is Still Around It’s…
Read More

After You’ve Been a DBA, What Do You Do?

You’ve been managing database servers for a few years. Now what? Get more technical – every time a new project comes in, sharpen your skills. Get more involved in failover clustering, storage, virtualization, or the cloud. Write technical presentations to teach your own company’s staff, and then the public. Business intelligence – if you’re constantly…
Read More

Frequently Asked Questions About TempDB

SQL Server, TempDB
42 Comments
The questions came fast and furious in one of my recent TempDB webcasts, so here’s the ones I wasn’t able to answer during the live session: Q: Virtualized OS, SAN, no dedicated LUNs, most likely scenario with no gotchas, theoretically: dump TempDB with everything else all on one virtual volume, including logs — or split…
Read More

Performance Tuning kCura Relativity

kCura Relativity, SQL Server
5 Comments
In the e-discovery business, kCura Relativity is the big gorilla, and I’ve been working with kCura and their clients since 2011. I think it’s one of the most interesting businesses I’ve ever worked with – up there with StackOverflow – and like Stack, they’re really open with their customers. George Nedwick and I staffing the…
Read More

You Can’t Kill Transactional Replication

Replication
181 Comments
Repli-Roach If SQL Server’s Transactional Replication was an animal, it would be a cockroach. It’s not pretty, but it’s resourceful and strong. Once you get even a small amount of replication in your environment it starts spreading everywhere. And if it gets out of control– well, in that case you’ve got no choice but to…
Read More