Search Results for &#8220;disaster recovery&#8221;

This week, Erik, Tara, and Richie discuss disaster recovery, Python vs C# for SQL Server, whether you should perform log backups on primary or secondary on AGs, why Postgres is so popular, using mount points for tempdb, attention events, database corruption, MERGE statements, restoring a table from a database, features they look forward to in…

What Azure SQL DB Managed Instances Don’t Support (Yet)

Last Updated June 13, 2019

Managed Instances

Whenever a new product or feature comes out, I like keeping an eye on its support forums to understand the challenges users are facing. I went through Azure SQL DB’s Managed Instance feedback forum, and here are some of the interesting issues that have been raised: Support for other collations – sounds like right now…

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

Last Updated November 15, 2018

This week, Tara, Erik, and Richie discuss using Docker in dev environment, in-place upgrades, disaster recovery, the minimum amount of CPU and RAM for new SQL Server VMs, troubleshooting long-running SQL agent jobs, dbcc checkdb running longer than normal, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe…

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

Last Updated November 11, 2018

This week, Tara and Richie discuss offline file database and log backup solutions, VSS database backups, monitoring products, parameterization, page latch waits, SQL ConstantCare™, and Availability Groups on 2017 Standard Edition. 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. Enjoy the…

What’s New in SQL Server 2019’s sys.messages: More Unannounced Features

Last Updated September 24, 2018

SQL Server 2019

The system table sys.messages holds error messages that SQL Server needs to return to end users. When a new build comes out, I love checking this table to see what features Microsoft has coded, but isn’t quite ready to announce yet. When SQL Server 2017 came out, that’s how I unmasked snapshot materialized views, a…

[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…

Thoughts On Microsoft’s Azure Outage Post-Mortem

Last Updated September 10, 2018

Architecture

Last week, Azure suffered a day-long outage. One of the services involved was Visual Studio Team Services (aka Azure DevOps), and that team just published their outage postmortem. The postmortem is FANTASTIC: open, honest (at least it reads that way), and goes into enough technical detail to satisfy a wide variety of readers from managers…

What’s Different About SQL Server in Cloud VMs?

Last Updated August 24, 2018

Cloud Computing

When you start running SQL Server in cloud VMs – whether it’s Amazon EC2, Google Compute Engine, or Microsoft Azure VMs – there are a few things you need to treat differently than on-premises virtual machines. Fast shared storage is really expensive – and still slow. If you’re used to fancypants flash storage on-premises, you’re…

[Video] Office Hours 2018/8/8 (With Transcriptions)

Last Updated August 11, 2018

This week, Brent, Tara, Erik, and Richie discuss troubleshooting port blocking, page life expectancy issues, problems with turning off CPU schedulers, coordinating two jobs across servers, adding additional log files to an almost-full partition, tips for getting a new SQL Server DBA job, using alias names for SQL Servers, database going into suspect mode during…

[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…

[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.…

Fundamentals of Database Administration

Last Updated March 19, 2021

You’re a systems administrator or developer who’s been stuck in charge of the SQL Server. You have a couple of production SQL Servers, no high availability or disaster recovery, and around 100GB of data or less on each server. You’ve never been to a “real” SQL Server training class, and you’ve been Googling your way…

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

Last Updated May 20, 2018

SQL Server, Videos

This week, Brent, Erik, Tara, and Richie to discuss cloud server disaster recovery, Availability Groups troubleshooting, SQL Server deadlocks, slow tempdb latency, migrating to Azure, SQL Server 2017 gotchas, how to set up your dev environment when looking for a job, best allocation unit size for disks hosting data files and good replacement for linked…

[Video] Office Hours 2018/4/11 (With Transcriptions) with Special Guest Edwin M Sarmiento

Last Updated April 17, 2018

This week @EdwinMSarmiento joins Brent, Tara, Erik, and Richie to discuss high availability disaster recovery, migrating from on-premises server to Amazon’s RDS, AlwaysON Availability Groups, auto-growth issues, rebuilding vs dropping/re-creating indexes, log shipping, using Service Broker with Always On Availability Groups, updating stats issues, VLF counts, measuring transaction log usage, upgrading versions, and much more.…

Training Week: Announcing Edwin’s New Class on Failover Clustered Instances

Last Updated April 11, 2018

Clustering, Company News

This week, we’ve got a bunch of announcements about new training classes. Next up, Edwin Sarmiento: his 3-day Always On Availability Group class has been getting great reviews: “This class is fantastic. There is no filler, and no needless repetition, so be prepared to pay attention the entire duration. Edwin clearly is very passionate about…

[Video] Office Hours 2018/4/4 with Special Guest Pinal Dave

Last Updated April 7, 2018

This week, Pinal Dave joins Brent, Tara, and Richie to discuss replication latency, partitioning tables, transactional replication, troubleshooting 3-rd party application performance, SQL ConstantCare® update, SQL Server errors, copying data over from a database with read-only access, reducing blocking timeouts, backups to the cloud, and more replication questions! Here’s the video on YouTube: You can…

“But I don’t need to back up that database.”

Last Updated May 9, 2018

Backup and Recovery

You’ve got this database that you swear doesn’t need to be backed up, like: Read-only databases Schema-only databases with no data in ’em Archive databases that haven’t changed in years Maybe even system databases like master/model/msdb And you think you’re going to save some time in your maintenance windows by skipping backups and corruption checks…

Azure SQL Managed Instances and Database Corruption

Last Updated March 18, 2018

Backup and Recovery, Managed Instances

Disclaimer: I love Azure SQL Managed Instances (MIs) so far. They’re really cool, and I’m having a fun time playing with them. I’m about to describe a bug, and I’m sure this bug will be fixed soon, so it shouldn’t stop you from previewing Managed Instances. This post is not “MIs are t3h suxxors” –…

How to Back Up SQL Server to Azure Blob Storage

Last Updated March 12, 2018