(Ranga Babu) In this article, we will review how to configure email notifications in the Azure SQL single database or elastic pool.
Tag: sql server
(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.
(Pinal Dave) Let us discuss a very interesting question recently I received during the 1 FREE consulting hour for SQL Server Performance Tuning Practical Workshop – Recorded Classes. The question was about is there any way to know how many rows each thread execute in parallel operations.
(blobeater) I was generally reading about SQL Server and how things have changed since the days of just having it within a Windows Eco-system only.