SQL Insider Series: Azure SQL DB – Automating scale up and down (2022-07-09)

Database Weekly for July 9, 2022 Problems displaying this newsletter? [View online](. [Database Weekly]( The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com Hand-picked content to sharpen your professional edge Editorial  The Home Setup For many years, a home setup has been something us geeky people built to experiment, have fun, maybe play games, maybe for some career learning away from work. I've written about various [workstations](, as has [Glenn Berry](. Then the pandemic hit and many of us were sent home to work. I've seen people working on dining tables, coffee tables in living rooms, and even on a spare dresser in a bedroom. I see big and small offices, many of which were thrown together to just get by in the spring of 2020. It's a few years later, and while I wrote about the [ultimate home office]( in July 2020, I know that there are plenty of you still at home, at least part-time. While some companies want to get people back into the office, I don't know how many people end up working full time in an office with the need for some setup at home. I saw recently that [Andy Yun was building a home lab]( for himself and his wife, [Deborah Melkin]( (send congrats to the newlyweds! Hopefully, Andy and Deborah have nice working spaces at home, and they don't interfere with each other. My wife and shared an office for a few years, and we both had to learn to grab a laptop and leave if the other was on a call first. This week I wonder how you've changed your setup at home? Have you set up a dedicated space for work, a desk, a new chair, better lighting or larger monitors? What tips do you have for making a home office a real office? Let us know what has worked, and maybe what hasn't. Or better yet, what do you wish you had known in the spring of 2020 when you first moved into your home instead of the office? Steve Jones - SSC Editor [Join the debate, and respond to the editorial on the forums](  The Weekly News All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. Vendors/3rd Party Products [Why a leading bank with over 1,400 databases chose to think again about Redgate SQL Monitor]( Headquartered in Louisville, Kentucky, Republic Bank is one of the most innovative and forward-looking banks in the US, with 42 full-service banking centers across five states and assets of $6.2 billion. Find out why they chose Redgate SQL Monitor. [Cross-RDBMS Version Checks in Flyway]( How does one check that a database is definitively at the version that Flyway says it is? Or that a test teardown procedure leaves no trace in the database? Or verify that an undo script returns a database's metadata to that state it should be in for the version to which you're rolling back? This article shows how to do high-level version checks, by comparing JSON models. AI/Machine Learning/Cognitive Services [Using AI-generated synthetic data for easy and fast access to high quality data]( From AllAnalytics Data is crucial for the development of artificial intelligence (AI) applications. However, the rapid availability of data is a challenge due to increasingly strict privacy regulations. A possible solution... [The Role of AI Ethics in Network Monitoring]( From Past News - RSS Feeds According to the Pew Research Center, 68% of technology innovators, developers and business leaders expect that ethical principles focused on the public good will continue to be overlooked in... [How to set Workspace inside Azure ML SDK]( From RADACAD Working With Azure ML workspace can be more flexible with Azure ML SDK. In this section, we are going to see how to set a workspace via AzureML SDK... [Artificial Intelligence Eases Network Challenges]( From Past News - RSS Feeds Many technology vendors have used artificial intelligence to transform their products. This is evident in areas like unified communications, contact centers and cybersecurity. Yet one area of IT that... [New AI Readiness Report Reveals Insights into ML Lifecycle]( From IT Pro - Microsoft Windows Information, Solutions, Tools Data quality problems must be addressed since they have a "significant downstream impact" on ML efforts, the report finds. Administration of SQL Server [Columnstore Indexes are Finally Sorted in SQL Server 2022.]( From Brent Ozar Unlimited There’s a widespread misconception that SQL Server’s columnstore indexes are like an index on every column. I debunk that myth in the first 30 minutes of my Fundamentals of... [Extended Events for Anything But Query Tuning: Unique Constraint Violations]( From SQLServerCentral Blogs Most of the time when I talk about or demo Extende... [Understanding SQL Server T-SQL Configuration Functions]( From MSSQL Tips Learn about SQL Server configuration functions and how these can be used to return information about SQL Server, sessions, configuration settings and more. Azure Databricks, Spark and Snowflake [Snowflake Data Cloud]( From SQLServerCentral Blogs Time to shift gears away from the world of relational databases whether that is in the cloud, on-prem, Linux-based, containers or even sitting within Kubernetes. Everyone has heard of... The... Azure SQL [SQL Insider Series: Azure SQL DB – Automating scale up and down | Data Exposed]( From Azure SQL In this episode of Data Exposed: SQL Insider Series, Stephen Giles and Anna Hoffman will take a look at how to use Transact SQL and various methods to automate... Azure Synapse (SQL Data Warehouse and Data Lake) [BigQuery vs. Snowflake: Data Warehouse Comparison 2022]( From Past News - RSS Feeds Google BigQuery and Snowflake are both leading dat... [Building Lakehouse Dashboards Using Azure Synapse Analytics Serverless Pool]( From MSSQL Tips In this tip we explore ways to build reporting based on the Lakehouse data when using Azure Synapse Analytics. Career, Employment, and Certifications [T-SQL Tuesday #152 – Invitation]( From Deb the DBA Hi there, T-SQL Tuesday community – long time poster, first time hosting… That’s right, I’m hosting T-SQL Tuesday this month and I’m super excited about it! So, what shall... [SQL Homework – July 2022 – Update your resume.]( From SQLStudies Resumes have been on my mind a lot recently. I’ve been thinking that I wish I’d kept mine up to ... Continue reading [Who’s Hiring in the Database Community? July 2022 Edition]( From Brent Ozar Unlimited Is your company hiring for a database position as of July 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid... Computing in the Cloud (Azure, Google, AWS) [How to enable and run SQL best practices assessments on multiple SQL Servers on Azure VMs]( From MS SQL Server Blog You can evaluate your SQL Server on Azure VM for configuration best practices using SQL best practices assessment feature on Azure portal. GA announcement post explains how to use... [Choosing optimal Azure disk storage for SQL Server running on Azure VMs]( From SQLShack This article will explore various Azure disk storage available for SQL Server workload running on Azure virtual machines. Suppose you have been tasked to migrate your on-premises SQL Server... [How to Remove a Data Disk from an Azure VM (How not to blow your leg off)]( From The SQL Herald (Joey D'Antoni) I was working with a client recently, were we had to reconfigure storage within a VM (which is always a messy proposition). In doing so, we were adding and... [Azure's capacity limitations are continuing. What can customers do?](RSSbaffb68) From All about Microsoft Blog RSS | ZDNet As supply-chain constraints continue to impact Microsoft's cloud capacity, there are some steps customers can take to try to lessen the impact. Conferences, Classes, Events, and Webinars [Here’s What I’m Teaching at the 2022 PASS Summit.]( From Brent Ozar Unlimited The lineup for the PASS Data Community Summit is o... [Join Me at the PASS Data Community Summit 2022!]( From AndyLeonard.blog() I am honored to deliver two training sessions at the PASS Data Community Summit 2022: A Day of Azure Data Factory is a full-day pre-conference session scheduled for Monday,... [My First DataIQ Event]( From Paul Andrew DataIQ 100 – 2022 On Wednesday 6th July I attended my first DataIQ event. A small group closed event, by invitation only, and all about networking with C-level business... [From the archives] Your guide to choosing the right monitoring tool [Video]( Join Grant Fritchey in this 35 minute video to learn his top tips for evaluating monitoring tools and vendors, the common pitfalls when implementing a new solution, and how you can demonstrate Return on Investment (ROI) to the business post-purchase. [DevOps 101 webinar: Unlock the value of frequent deployments]( Frequent deployments can give you greater flexibility in meeting changing business requirements, but if code quality is poor this may cause major headaches for your customers and your whole organization. Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover the benefits of, and best practices for frequent deployments. DMO/SMO/Powershell [#PowershellBasics: Expanding the column width to avoid truncation]( From SQLServerCentral Blogs I was recently asked to get a list of all of the services running on one of the boxes we ... Continue reading The post #PowershellBasics: Expanding the column width... [How to Sign PowerShell Scripts, Part 3]( From IT Pro - Microsoft Windows Information, Solutions, Tools This guide explains how to sign PowerShell scripts. In Part Three, you will learn the final steps of the process. [PowerShell for the DBA - Performing DBA tasks using SQL Server CMDLETs]( From MSSQL Tips Learn how to use these PowerShell scripts in SQL Server to get instance details, create backups, manage SQL Server jobs, start an instance and more. Data Visualisation [what’s the story behind my KPIs?]( From Storytelling with Data Through virtual and in-person workshops around the globe, we have taught tens of thousands of people how to communicate effectively with data. This series captures some of the noteworthy... Database Design, Theory and Development [Using a “Goal Posts” Table to Reduce Scan Impact]( From SQLBlog.org Logging tables can grow unchecked for years, and date range queries against them get more and more expensive if they don't use the clustered index. Read about one way... ETL/SSIS/Azure Data Factory/Biml [Using DILM Deployment Utility to Restore SSIS Catalog Folders]( From AndyLeonard.blog() In this video, I demonstrate using DILM Deployment Utility 2022 – part of SSIS Catalog Compare 2022 Enterprise Edition – to restore the contents of an SSIS Catalog folder... Hardware [PCIe 4.0 SSD With Russian Controller Pictured: Up to 16TB, Speeds over 1,500 MBps]( From Tom's Hardware US Kraftway shows off the company's latest PCIe 4.0 S... [Corsair TC200 Gaming Chair Review: Stylish Seat for Work or Play]( From Tom's Hardware US Corsair's TC200 looks good and is solidly built. But the lack of adjustable lumbar support means it's not the best option if you have back issues. [Alder Lake-Powered Linux Laptop Arrives With 14 Hours of Battery Life]( From Tom's Hardware US Other attractions of this 14-inch laptop, which comes with Pop!_OS 22.04 LTS or Ubuntu 22.04 LTS, are its 180-degree hinge, 14Hr battery, and 1.15kg weight. [ASRock Intros Wi-Fi 6E Upgrade Kits for AM4, LGA1700 Motherboards]( From Tom's Hardware US ASRock recently unveiled two new Wi-Fi 6E upgrade kits for AM4 and LGA1700 platforms. The kit will be optimal for users running on older Wi-Fi 5 or Wi-Fi 6... MDX/DAX [[DAX] Anti-Patterns Episode Thirteen - Variables & Comments (with Daniil Maslyuk)]( From Havens Consulting A lot of videos and articles teach you how to write [DAX]. In this series Daniil Maslyuk and I will show you you how avoid bad [DAX] patterns, and... Oracle/PostgreSQL/MySQL/other RDBMS [How to troubleshoot and fix PostgreSQL performance issues]( PostgreSQL database performance is critical for application performance. EzzEddin Abdullah shows how to get information about a query’s performance from the execution plan. Performance Tuning SQL Server [Improve scalability with Buffer Pool Parallel Scan in SQL Server 2022]( From Microsoft SQL Server Blog Buffer Pool Parallel Scan is a new feature in SQL Server 2022 that improves the scalability of several common scenarios in SQL Server and as a result, could significantly... [Lesson Learned #219:Hands-On-Labs: What do I need to do in case of high CPU wait time]( From Azure Database Support Blog We used to have cases where our customers reported a performance issue that is causing delay in their business. Working on this issue we saw that the CPU was the most... [SQL Server 2022 Parameter Sensitive Plan Optimization: Does Not Care To Fix Your Local Variable Problems]( From Erik Darling Data –To Fix Parameter Sniffing There are some code comments you see that really set the stage for how tuning a query is going to go. Usually one misgiving about how SQL... [Scary Scalar Functions - Part Two: Performance]( In the second part of this series, we’ll look at how Scalar functions (or UDFs) affect performance. If you want to follow along, start with the code from part 1. [SQL Server 2022 Parameter Sensitive Plan Optimization: Sometimes There’s Nothing To Fix]( From Erik Darling Data Best Intentions After seeing places where the Parameter Sensitive Plan (PSP) optimization quite stubbornly refuses to kick in, it’s somewhat amusing to see it kick in where it can’t possibly... PowerPivot/PowerQuery/PowerBI [Upload Power BI Reports using PowerShell]( From Purple Frog Systems In this blog post, I will be sharing a PowerShell script that allows multiple Power BI reports to be uploaded at once. In a previous blogpost, I shared a... [(Livestream Replay) The Future of Power BI! - with Mohammad Ali]( From Havens Consulting Join Power BI Desktop's global program manager (Mohammad Ali) as we get insights and forecasts all about the future of Power BI desktop, the platform, and maybe even discover... [Hiding measures by using object-level security in Power BI]( From Sqlbi This article describes how to hide measures from a... [Power BI Connection Types: DirectQuery, Live, or Import? Tough Decision!]( From RADACAD Power BI supports different methods for connecting data. That is why the decision to choose the right method is always a tough decision. You have heard of DirectQuery, Live... [Hiding measures by using object level security in Power BI]( From Sqlbi This article describes how to hide measures from a group of users by leveraging object-level security in Power BI and Analysis Services. [Dynamic X and Y Axis in Power BI visuals? Yes please!]( From Guy in a Cube Have you wanted both dynamic X and Y axis within a Power BI visual? Patrick shows you how you can use Field Parameters to accomplish it! Let report readers... Product Upgrades and Releases [New – Amazon EC2 M1 Mac Instances]( From AWS News Blog Last year, during the re:Invent 2021 conference, I wrote a blog post to announce the preview of EC2 M1 Mac instances. I know many of you requested access to... [SQL Server Diagnostic Information Queries for July 2022]( From Glenn Berry Introduction These are my SQL Server Diagnostic Information Queries for July 2022, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration... [General availability: Azure Database for PostgreSQL—Hyperscale (Citus) supports PostgreSQL minor versions]( From Azure Updates Benefit from the latest PostgreSQL minor versions for Azure Database for PostgreSQL – Hyperscale (Citus). [Generally available: Azure Digital Twins Data history]( From Azure Updates Data history is an integration feature of Azure Digital Twins. [Public preview: Container Insights now supports Windows Server 2022]( From Azure Updates Container Insights now supports the Windows Server 2022 operating system. SQL Server Security and Auditing [The simple guide to column-level encryption]( From SQLServer-DBA.Com SQL Server column level encryption example - although easy to setup requires some planning & management of master keys to allow movement and recoverability [Column-level encryption vs Always encrypted]( From SQLServer-DBA.Com Cell level encryption , Column level encryption and Always Encrypted - which one to use ? and under what circumstances? v Security News and Issues [Apple’s Lockdown Mode]( From Schneier on Security Apple has introduced lockdown mode for high-risk users who are concerned about nation-state attacks. It trades reduced functionality for increased security in a very interesting way. [Microsoft Detects Raspberry Robin Windows Worm in Hundreds of Enterprise Networks]( From Petri IT Knowledgebase Microsoft has warned customers about a new high-risk worm called... [Cloud Misconfig Exposes 3TB of Sensitive Airport Data in Amazon S3 Bucket: 'Lives at Stake']( From Dark Reading: Dark Reading News Analysis The unsecured server exposed more than 1.5 million files, including airport worker ID photos and other PII, highlighting the ongoing cloud-security challenges worldwide. [Marriott Data Breach Exposes PII, Credit Cards]( From Dark Reading: Dark Reading News Analysis The hospitality giant said data from 300-400 individuals was compromised by a social-engineering scam targeting the Baltimore airport. [Apple Debuts Spyware Protection for State-Sponsored Cyberattacks]( From Dark Reading: Dark Reading News Analysis Apple's new Lockdown Mode protects devices targeted by sophisticated state-sponsored mercenary spyware attacks. Software Development [Should the Database and Application projects be in the same Repository?]( From Eitan Blumin Should your SQL Database project be in the same solution as the App project? Or maybe they should be in the same source control repository but separate solutions? Or... T-SQL and Query Languages [Fun With KQL – Now]( From Arcane Code Fun With KQL - Now [What’s new in T-SQL in SQL Server 2022]( From Simple Talk There are many new features in SQL Server 2022. In... [JSON_PATH_EXISTS gives you more power over JSON documents in SQL Server]( From Hasan Savran    Schemas can easily change if you save your data in JSON format. It is very easy to add or remove properties from JSON documents. When the data... [Summarizing data using GROUP BY and HAVING clauses]( You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows you how. Tech News [NIST Announces First Four Quantum-Resistant Cryptographic Algorithms]( From Schneier on Security NIST’s post-quantum computing cryptography standard process is entering its final phases. It announced the first four algorithms: For general encryption, used when we access secure websites, NIST has selected the... Tools for Dev (SSMS, ADS, VS, etc.) [How to build custom widgets on Azure Data Studio]( From SQLShack In this article, we will learn how to build a cust...  [RSS Feed]([Twitter]( 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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -