Adding a Database with Polybase External Tables to Always On Availability Group
Learn how to ensure your PolyBase objects are accessible from all nodes in an Availability Group.
2020-05-26
2,709 reads
Learn how to ensure your PolyBase objects are accessible from all nodes in an Availability Group.
2020-05-26
2,709 reads
While you’re stuck inside wondering if you’ll ever be able to attend a user group meeting again, I’m giving you free access to training materials that your boss probably wouldn’t have been nice enough to buy you anyway. So far this week, we’ve covered DBCC CHECKDB, how to set up Ola Hallengren’s maintenance scripts, and restoring for oops deletes. Today, let’s talk about two common configuration issues. Don’t dilly-dally on these though: these blog posts will be online during May only, and they’ll disappear on June 1.
2020-05-22
2020-05-12
653 reads
You want to attach a SQL Server database that does not have the transaction log files and get the following error: "The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure." In this tip I will help you to successfully attach the transaction log to the problematic SQL Server database.
2020-05-07
2020-04-28
730 reads
A morning checklist is a good thing, but an automated one is better.
2020-04-06
28,005 reads
2020-03-23
679 reads
Introduction A popular joke about DBAs and database backups goes like this. There are two types of DBAs: DBAs that do backups DBAs that will do backups The joke is only stating the obvious – lack of database backups might be the end of a DBA career and/or the supported business. Unfortunately, that joke fails […]
2020-01-07
8,541 reads
2019-12-26
480 reads
Being proactive in trying to improve your system is good, but sometimes your team might cause you problems with their efforts.
2019-12-04
374 reads
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers