(Glenn Berry) On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named “Rome” at the AMD EPYC Horizon Event in San Francisco.
Tag: sql server
SQL SERVER – Error 35296: Log Backup for Database ‘SQLAuthority’ on Secondary Replica Failed Because the New Backup Information Could Not be Committed on Primary Database
(Pinal Dave) One of my clients contacted me for whom I assisted in configuring Always On Availability Groups for the first time. They were getting an error whole taking log backup on secondary replica: Log backup for database “SQLAuthority” on secondary replica failed because the new backup informat
(Ranga Babu) In this article, we will review how to configure email notifications in the Azure SQL single database or elastic pool.
(Daniel Neumann) The issue described here in my blog post has been resolved in the Azure docs with the following pull request.
(James Serra) A brand new product by Microsoft called Azure Data Share was recently announced. It is in public preview. To explain the product in short, any data which resides in Azure storage can be securely shared between a data provider and a data consumer.
(Jim Evans) When analyzing and reporting data occurrences over time with a roll up by a date part like week, day, hour, etc. often you will have gaps in your date values that will need to be accounted for.
(Kenneth Fisher) tl;dr; Temporary stored procedures are excellent for testing pieces of code that are going to go into (or come from) stored procedures. Because parameters are different than variables.
(Benjamin Weissman) PolyBase has been around since 2016, but Microsoft is enhancing it in 2019 with the ability to connect to more data sources. You can now use PolyBase to connect to other SQL Server instances, and it’s easy to set up with a wizard.
(Pinal Dave) Today, I have received a very interesting question from my client with whom I have worked in the past on Comprehensive Database Performance Health Check. The question was really not related to SQL Server Performance Tuning but DBA wanted to know if they can use any custom Quote Characte
(Jignesh Raiyani) SQL Server Merge Replication configuration supports Identity Range options using either “Automatic” or “Manual” to manage Auto Incremented values for a column of a table.