(Kenneth Fisher) Occasionally I’ve seen date and time stored separately as integers. This had some practical applications back before we had date and time data types but there’s still lots of legacy code out there that use them (I’ll give you a really really common example in just a minute).
Tag: sql server
Backup Techniques Available Exclusively When Using Azure VMs
(Marcin Policht) Running SQL Server in Azure VMs offers a number of benefits directly associated with the very nature of the Infrastructure-as-a-Service (IaaS) platform, such as simplified scalability, enhanced agility, and the operational cost model.
Azure Data Factory Stored Procedure Activity Transformation Activities
(Fikrat Azizov) In these series of posts, I am going to explore Azure Data Factory (ADF), compare its features against SQL Server Integration Services (SSIS) and show how to use it towards real-life data integration problems.
AMD EPYC 7002 Series Processors and SQL Server
(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.
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
Configuring email notifications in Azure SQL database
(Ranga Babu) In this article, we will review how to configure email notifications in the Azure SQL single database or elastic pool.
AKS – Authentication issues real-time container logging solution
(Daniel Neumann) The issue described here in my blog post has been resolved in the Azure docs with the following pull request.
New product: Azure Data Share
(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.
Fill In Missing Dates for SQL Server Query Output
(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.
Temporary stored procedures
(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.