Backup and Restore SQL Database to Azure Blob Storage (2023-09-15)

SQLServerCentral Newsletter for September 15, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Backup and Restore SQL Database to Azure Blob Storage]( - [Generate Test Data Sets for Testing SQL Server Database Applications]( - [Webinar: The Impact of the Cloud on Databases]( - [From the SQL Server Central Blogs - Persisting data for SQL Server on Docker Swarm with Portworx]( - [From the SQL Server Central Blogs - Friday Flyway Tips: Searching Migrations]( - [Big Data Analytics with Spark: A Practitioner's Guide to Using Spark for Large Scale Data Analysis]( Question of the Day - [Tracking Backup to Nul]( The Voice of the DBA  Advice To Be a Better Person As a hobby, I coach volleyball for kids. Each year I meet new kids and parents and talk about my philosophy. Part of that is that I teach skills, athletics, how to compete, and more. However, I do emphasize as well that I'm trying to build better people, not just athletes. I want these kids to be better prepared for life, for job interviews, for future teachers and coaches, and for better relationships. While I'm not perfect, maybe not even a great person, but I do try to improve myself and my life on a regular basis. Or at least learn to be a better person to others. I don't know how much I've accomplished, but I continue to do work on myself. I ran across some advice from [Kevin Kelly]( who helped co-found Wired Magazine. He wrote down 68 pieces of advice for his children on his 68th birthday. A few of them are in [this post]( though he's [written a book with 450 pieces of advice](. A few more items are in his post of [99 pieces]( and [103 pieces](. The advice is about career, life, and more. Some of the more interesting ones I saw are listed below, with my comments: - About 99% of the time, the right time is right now - I struggle with this, but as I think about it, it's been often true - Don’t keep making the same mistakes; try to make new mistakes. - I certainly aim for this. I hate making the same mistakes - If you stop to listen to a musician or street performer for more than a minute, you owe them a dollar. - I love seeing street musicians and I carry dollars/euros/pounds and more I can give out. - If you have any doubt at all about being able to carry a load in one trip, do yourself a huge favor and make two trips. - I find doing this means I drop less things. Not doing this means I drop more. - Recipe for success: under-promise and over-deliver. - Often my mantra at work - It’s not an apology if it comes with an excuse. It is not a compliment if it comes with a request. - This is hard, but I've been working on this. - Learn how to learn from those you disagree with, or even offend you. See if you can find the truth in what they believe. - Important in today's world - Being able to listen well is a superpower. While listening to someone you love keep asking them “Is there more?”, until there is no more. - I need to do this more I grabbed his book, and you can as well. However, I might also suggest you collect your own words of wisdom and advice that you can share with your own loved ones at some point. If you want to see Mr. Kelly speak his advice, [watch this video](. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Backup and Restore SQL Database to Azure Blob Storage]( Almighty from SQLServerCentral SQL databases are crucial for businesses, so it's critical to back them up. A dependable and affordable option is offered by Azure Blob Storage. Let's examine the advantages, the steps involved in backing up to and restoring from a device, recommended practices, and more. [External Article]( [Generate Test Data Sets for Testing SQL Server Database Applications]( Additional Articles from MSSQLTips.com In this tip, we will discuss the process of generating test data to verify query logic without relying on real-life data, along with some helpful guidelines. We will also cover various scenarios and their corresponding solutions. [Technical Article]( [Webinar: The Impact of the Cloud on Databases]( Press Release from SQLServerCentral The PASS Data Community Summit is back in Seattle this November, with hundreds of speakers covering a wide variety of database topics, including cloud computing. We feature two of those speakers in this webinar: Bob Ward of Microsoft and Steve Jones of Redgate. [Blog Post]( From the SQL Server Central Blogs - [Persisting data for SQL Server on Docker Swarm with Portworx]( dbafromthecold@gmail.com from The DBA Who Came In From The Cold In my last couple of blog posts (here and here) I talked about how to get SQL Server running in Docker Swarm. But there is one big (and show-stopping)... [Blog Post]( From the SQL Server Central Blogs - [Friday Flyway Tips: Searching Migrations]( Steve Jones - SSC Editor from The Voice of the DBA When a Flyway Desktop (FWD) project (or Flyway project) has been around for a long time, there can be a lot of migration scripts. That can be a pain... [Big Data Analytics cover]( [Big Data Analytics with Spark: A Practitioner's Guide to Using Spark for Large Scale Data Analysis]( Steve Jones - SSC Editor from SQLServerCentral Big Data Analytics with Spark is a step-by-step guide for learning Spark, which is an open-source fast and general-purpose cluster computing framework for large-scale data analysis. You will learn how to use Spark for different types of big data analytics projects, including batch, interactive, graph, and stream data analysis as well as machine learning. In addition, this book will help you become a much sought-after Spark expert.   Question of the Day Today's question (by Steve Jones - SSC Editor):  Tracking Backup to Nul I have a SQL Server 2019 database and I run this command: BACKUP DATABASE way0utwest TO disk = 'nul' If I check msdb.dbo.backupset, what do I see for this backup? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Using the OPENJSON Type I run this code: SELECT * FROM OPENJSON('{ "key":1 }') and I get these results: key value type ---- ------- --------- key 1 2 What is the type? Answer: This is the datatype Explanation: The third column from OpenJSON gives the data type. Type 2 is a number. Ref: OPENJSON - [ [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2016 - Administration [BCP with ODBC 18?]( - Hello all. My org has identified ODBC driver version 17 as having security vulnerabilities. It looks as though 17.10.4.1 remedies these, but we're considering v18 anyways. It looks as though bcp requires version 17. Is this the case? Surely not, though I don't see otherwise. Administration - SQL Server 2014 [Maintenance Task Failed - how to log the error]( - I've a Multi step Maintenance plan of 5 steps called "Reindex". This automatically created an Agent job called "Reindex..Subplan_1" There's an email alert on failure of the Agent job. Is there any place in maintenance task design to put an alert in or do I always have to use add the alert to Agent task […] Development - SQL Server 2014 [Replace bad characters]( - Hi all I need help to replace bad characters with space in string. select col1, patindex('%[^ !-~]%' COLLATE Latin1_General_BIN,col1) as [Position], substring(col1,patindex('%[^ !-~]%' COLLATE Latin1_General_BIN,col1),1) as [InvalidCharacter], ascii(substring(col1,patindex('%[^ !-~]%' COLLATE Latin1_General_BIN,col1),1)) as [ASCIICode] from myTable where patindex('%[^ !-~]%' COLLATE Latin1_General_BIN,col1) >0 Here is the result: Col1          […] SQL Server 2019 - Administration [Error 500 when accessing SQL Server 2019 database - Need help!]( - I've recently set up a SQL Server 2019 database for a project I'm working on. The issue I'm encountering is that whenever I try to access the database, whether it's through my application or directly using SQL Server Management Studio, I'm getting an "Error 500" message. This error appears to be quite generic and doesn't […] [Event ID 17806]( - We have had SSPI errors across a dozen servers in an hour span. SQL error 17806 : Error code 0x8009030c – How to fix Per the above link : Stuck at the very first point... Cause of SQL error 17806 1.SQL Server engine account running with a Domain service account, and that account locked at […] [disable seeding mode]( - hello , On one of our servers with 4 Replicas 2 synchronous and 2 asynchronous we see too many waits with the "VDI_CLIENT_WORKER" type almost 93% of the wait statst do you have to deactivate the seeding mode to minimize these times ? What do you think of this recommendation? [SQLPackage Import Error]( - Hi After 1h the import fails with the error: Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 155, Level 15, State 1, Line 3 'AUTO_DROP' is not a recognized CREATE STATISTICS option. SQL Server 2019: 15.0.4316.3 sqlpackage.exe: 162.0.52.1 May the sqlpackage is to new but I didn't find the one who fits exactly. Thanks for […] SQL Server 2019 - Development [MS Sync Framework Error - Failed to Execute the command BulkUpdateCommand]( - It turns out that the error is in a trigger on the Transfers table, so this can be ignored. Sorry if you've wasted your time reading this.  Hi, I've got two databases at distant locations that sync evey few minutes using the Ms Sync Framework 2.1. I'm getting this error occurring: ERROR , SyncBPO, […] [Odd columns datatype precisions showing in SSMS View...]( - Okay... haven't posted in a long time and was hoping I'd have a better topic to share but... we're seeing issues when expanding the view columns in SSMS and it's showing the wrong precision. The view is pulling from underlying tables using DECIMAL(11,2) but the view shows the columns as DECIMAL(12,2) - what would cause […] [SQL code help to get one row for each sequential entry]( - Hi, I am looking for a sql help to generate one row per each sequental door_area, for a given employee, based on the sample data that looks like this: Current Output: Desired Output: Here is my code to test for sample data. CREATE TABLE dbo.emp_seq ( emp_id int, product_code int, clock_in datetime, clock_out datetime, door_area […] SQL Azure - Administration [Connecting to SQL Azure - Best practice / method?]( - New to Azure SQL, so I'll start with that! We've had SQL on-premise for years and we're exploring moving to a SQL Instance in Azure (not a VM). A lot of our apps are desktop .Net apps that connect very simply over our internal network currently or VPN. We'd like to ditch that approach and […] Reporting Services [Migrating Reports from SQL Server 2014 to SQL Server 2022 via Visual Studio 2022]( - Migrating Reports from SQL Server 2014 to SQL Server 2022 via Visual Studio 2022 with Reporting Services extension installed. I am having trouble with parameters and the error message: "Must declare the scalar variable @TellMeWhyIdontlikeThisMonday". I'm also getting the error message: "Custom parameter layout was removed from the report. SQL Server 2014 Reporting Services and […] SQL Server 2022 - Administration [Having problems with SQL Server 2022 CU5 (docker ubuntu image) - is it ready?]( - Ubuntu image came from here - DBCC is failing - "can not create database snapshots" syspolicy_purge_history is failing due to a missing PowerShell installation master.sys.dm_server_services - is not listing the engine at all while listing agent running? Can't enable SQL Server Agent Alerts - most likely due to master.dbo.sp_MSsetalertinfo and msdb.dbo.sp_set_sqlagent_properties usage of registry SQL Server 2022 - Development [Running 32 bit SSIS package]( - This is my first post in this forum, so hello everyone! Would be most grateful for help with the following issue: a simple SSIS package (created in Visual Studio 2019) imports a table from an ODBC Source (MySQL Server 5.xxx) into a database in a SQL Server 2022. ODBC Source is 32-bit, the package runs […] [Searching in date field provides inconsistent results]( - I have been working with SQL Server for too many years to count and this is baffling; perhaps someone has a clue on the cause. I am running this on SQL Server 2022. I put together a simple function to return a primary key integer for a lookup table that has mileage rates that are […]   [RSS Feed]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -