Search Results for “failover cluster”

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

[Video] Office Hours 2016/07/13 (With Transcriptions)

SQL Server, Videos
0
This week, Erik, Tara, Jessica, Doug, and Angie discuss queries, installing multiple instances of SQL server on a Windows VM, using DENY Database rules, migrating databases to Amazon RDS, availability groups, using filtered indexes, and more! Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen…
Read More

[Video] Office Hours 2016/06/22 (With Transcriptions)

This week, Brent, Richie, Doug, and Tara discuss Growing databases, most useful SQL certifications, replication issues, group discounts, backup software and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Office Hours Webcast – 2016-06-22   Brent Ozar: All right, we…
Read More

Are You Getting the Benefits of Virtualization?

Here’s some of the reasons companies usually virtualize their SQL Servers: Cost savings on hardware Cost savings on Windows OS licensing Cost savings on SQL Server licensing Protect against the failure of a single hardware element Leverage extended features for Disaster Recovery Automatic load balancing across multiple hosts Easier hardware replacement/migration When we perform a SQL Critical…
Read More
Pocket Square

Performance Tuning kCura Relativity

Let’s make Relativity faster and more reliable together. You use kCura Relativity to host your e-discovery data, and you’re relying on Microsoft SQL Server for fast query response times. Your users complain that their saved searches take forever and that doc-to-doc navigation is slow. The IT teams say they don’t see any performance problems. You’re…
Read More

Generating Identities

SQL Server
21 Comments
The only thing you ever need to use for database identity is an IDENTITY, right? Well, maybe. There are a lot of different options and they all have different pros and cons. IDENTITY columns The default way to identify objects in SQL Server is to use an INT or BIGINT column marked as an IDENTITY. This guarantees relatively sequential numbers, barring…
Read More

Update on Stack Overflow’s Recovery Strategy with SQL Server 2014

Back in 2009 (wow, seems like only yesterday!), I wrote about designing a recovery strategy for Stack Overflow. Back then, I wrote: With these answers in mind, Stack Overflow’s decisions not to do transaction log backups, offsite log shipping, database mirroring, and so on make good business sense. Us geeks in the crowd may not like it,…
Read More

Many Masters, One Truth

As businesses grow, many teams start considering scale out database solutions but they’re cautious – they want to know how to keep data up to date in multiple places. In theory, you can use log shipping, mirroring, or AlwaysOn Availability groups. While this answers the literal question, what people really mean is usually very different.…
Read More
Pocket Square

SQL Server AlwaysOn Availability Groups

SQL Server’s coolest new feature gives you high availability, disaster recovery, scale-out reads, and much more.  Here’s our posts and tutorials on how to use it. Introduction to AlwaysOn Availability Groups – Brent explains why this new feature in SQL Server is better than any high availability or disaster recovery feature we’ve had before and…
Read More
My Coffeemakers

How I Make Coffee and Servers

16 Comments
I’ve got a disturbing array of coffeemaking gear: My Coffeemakers From left to right: Bialetti Moka – stovetop espresso maker.  Great for making powerful hot chocolates in the dead of winter. Burr grinder – the best way to get very consistent grinds.  The grinders with spinning blades just randomly slice and dice your beans, but…
Read More

I’m Going to Disn-errr, #SQLPASS!

#SQLPass
0
Woohoo!  I’m presenting three sessions at the PASS Summit in Seattle this year.  I’m doing one with Jason Massie (Twitter – Blog) on Social Computing for the Database Professional (I don’t have the abstract handy for that one), and these two: Session: Yes, I’m Actually Using The Cloud Security in the Cloud There’s a lot…
Read More

Why Would You Virtualize SQL Server?

Virtualization
16 Comments
I talked about why sysadmins want to virtualize servers, and today it’s time to talk about why you as a DBA or developer might want to virtualize some of your SQL Servers. Virtualization Means Cheap High Availability Yo momma was an early adopter. That’s right – you’re adopted. In a perfect world, every SQL Server…
Read More

PASS Summit 2007: Day Two Notes

#SQLPass
4 Comments
Tom Casey: Keynote Tom covered basic SQL Server marketing slides about the BI stack. Yawn. Good presenter, but couldn’t overcome the dry material. Then he handed it off to a Dell woman to announce that they’ll be selling packaged BI solutions with hardware, software, storage, etc all in one bundle. They’re targeting customers in the…
Read More