Search Results for &#8220;log shipping&#8221;

Professional Development

What follows are just some of the highlights from an actual job posting. I’m not including the job description, just the requirements that an applicant has to have in order to even throw their hat in the ring: Requires Bachelor’s degree or equivalent experience. Experience running and maintaining a 24×7 production computing environment Hands-on experience…

Pop Quiz: SQL 2000 Bug or SQL 2017 Bug?

Last Updated April 28, 2019

Humor

2002: Me and Bailey, mom’s Great Dane When I was thinking about this site’s 17th birthday, I started wondering: back in 2002, what bug might I have been working with in SQL Server? I started reading back to the list of bugs fixed in SQL Server 2000 Service Pack 1, and it hit me…these bugs…

Which Version of SQL Server Should You Use?

Last Updated May 26, 2023

SQL Server, SQL Server 2016, SQL Server 2017, SQL Server 2019

144

Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version? I know, management wants you to stay on an older build, and the vendor says they’ll only support older versions, but now’s your chance to make your case for a newer version – and I’m gonna help…

20 Questions to Ask About Your Availability Group Design

Last Updated December 26, 2018

Always On Availability Groups

Questions about the overall project: What are your RPO and RTO goals? Are there financial penalties if we miss the goals? (Like contracts, refunds to customers, etc) Does this app have regularly scheduled maintenance windows, or is it 24/7? What’s the ballpark size of the data today? In 3 years? Questions about the team: How…

Have Availability Groups Gotten Easier Lately?

Last Updated December 3, 2018

Erik Darling

Always On Availability Groups, High Availability, SQL Server

Easy Lover I don’t blog a lot about AGs. If we’re being honest (and I do try to be honest with you, dear reader), I just like performance tuning topics way more. When new features get announced for AGs, some of you may ooh and aah, but not me. I Make A Face I don’t…

Index Tuning Week: Fixing Nonaligned Indexes On Partitioned Tables

Last Updated September 28, 2018

Erik Darling

SQL Server

Unquam Oblite This post will not change your life, but it will help me remember something. When you decide to partition a table to take advantage of data management features, because IT IS NOT A PERFORMANCE FEATURE, or you have an existing partitioned table that takes advantage of data management features, because IT IS NOT…

[Video] Office Hours 2018/10/3 (With Transcriptions)

Last Updated October 6, 2018

This week, Tara and Richie discuss database corruption, CLR, DBCC issues, adding identity columns to databases, distributed transactions, tracking how recently a procedure was executed, maintenance plans, recompiling stored procs, parameter sniffing issues, troubleshooting replication with Always On, forecasting database growth and estimating capacity issues, tools for database growth forecast reports, RCSI, and much more.…

[Video] Office Hours 2019/09/12 (With Transcriptions)

Last Updated September 15, 2018

Pavel Amelishko

This week, Brent, Erik, Tara, and Richie discuss syncing logins and database data via log shipping, monitoring page life expectancy, cumulative update issues, when to change MAXDOP, doing SQL Server install on AWS, connecting to SQL Server instance on a virtual box from the desktop where the virtual box is running, and what real DBAs…

[Video] Office Hours 2018/9/5 (With Transcriptions)

Last Updated September 8, 2018

This week, Brent, Tara, Erik, and Richie discuss whether you should keep autoshrink on, AG multisite failovers, next version of SQL Server, SQL Server 2017 Vulnerability Assessment, SELECT INTO vs INSERT INTO, using Node.js with SQL Server, Using PowerShell for DBA tasks, the future of SQL Server for Linux, memory gateway query compile, VB.NET, patching,…

Does your backup strategy achieve RPO and RTO goals of the business?

Last Updated July 20, 2018

Tara Kizer

Backup and Recovery

When deciding on a backup strategy for a database, there are various things we must consider: Does this database need point-in-time recovery? What are the RPO (data loss) and RTO (downtime) goals? No one likes losing data or encountering unplanned downtime, but the business must decide on these goals so that we can setup an…

[Video] Office Hours 2018/7/18 (With Transcriptions)

Last Updated July 22, 2018

Pavel Amelishko

This week, Brent, Erik, and Tara discuss their SQL server specialization, CPU-ready time, making SSIS changes globally rather than one at a time, creating an Always On AG farm, Azure managed instances, going from log shipping to Availability Groups, tracking folks that executed queries, moving databases into Availability Groups, an exciting update to SQL Server…

How to Test Disaster Recovery Before You Go Live

Last Updated July 2, 2018

High Availability

When I build a server, success means not touching the server again for 2-3 years. I already have enough crappy, unreliable servers that fall over when someone walks past. I only wanna build good, permanent stuff going forward. So when I build disaster recovery for something, I want to test it 3 ways: Planned failover…

[Video] Office Hours 2018/7/11 (With Transcriptions)

Last Updated July 13, 2018

This week, Brent, Richie, and Erik discuss best account practices for SQL Server, change tracking, disabled indexes, measuring queries to gauge their speed, overcoming issues between Management Studio and integration services, deadlocks and long-running processes, query tuning, and lock escalation. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to…

[Video] Office Hours 2018/6/27 (With Transcriptions)

Last Updated July 13, 2018

First Responder Kit Updates

This week, Brent, Erik, Tara, and Richie discuss using SQL Server 2016 vs 2017 for production environment, reporting, reindexing jobs, Azure vs Amazon, parameter sniffing, creating custom alerts for agent jobs, activity monitor, troubleshooting SQL Server 2014, replication, turning off auto-updating stats on tempdb, and why Brent can’t get a tan. Here’s the video on…

First Responder Kit Release: Like pssdiag, if pssdiag had parents who cared

Last Updated July 18, 2018

Erik Darling

I went to the PFE and guess what he told me? Guess what he told me? He said girl you better try fix those spinlocks too No matter what you do, now run this tool You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1620: @AAvella schooled us on Group Policy registry settings. Someday, we’ll get our act…

[Video] Office Hours 2018/6/20 (With Transcriptions)

Last Updated June 25, 2018

This week, Brent, Erik, and Richie discuss using foreign keys in a data warehouse, SQL Server virtualization on Hyper-V clusters, having all of your SQL Server instances under the same active directory account, updating stats, changing job ownership, why you would want to go to SQL Azure, and why they have an issue with replication.…

[Video] Office Hours 2018/5/30 (With Transcriptions)

Last Updated June 2, 2018

This week, Brent, Erik, Tara and Richie discuss severity 16 error warning, best way to move databases from SQL 2008 R2 to SQL Server 2014, adding Analysis services to a cluster, taking to higher management, deadlocks in a transaction log shipping setup, syncing date between an on-prem and Azure SQL DB server, log backups, renaming…

[Video] Office Hours 2018/5/23 (With Transcriptions)

Last Updated May 26, 2018

This week, Brent, Tara, and Richie discuss relaying SQL Server performance updates to upper management, differential backups in AlwaysOn Availability environment, replication, Troubleshooting THREADPOOL Waits, an acceptable amount of preemptive waits, Postgres, and the technologies Richie is working with these days. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe…

[Video] Office Hours 2018/4/25 (With Transcriptions)

Last Updated May 20, 2018