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

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

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.

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.

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...

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...

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...

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...

Data quality problems must be addressed since they have a "significant downstream impact" on ML efforts, the report finds.

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...

Most of the time when I talk about or demo Extende...

Learn about SQL Server configuration functions and how these can be used to return information about SQL Server, sessions, configuration settings and more.

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...

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...

Google BigQuery and Snowflake are both leading dat...

In this tip we explore ways to build reporting based on the Lakehouse data when using Azure Synapse Analytics.

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...

Resumes have been on my mind a lot recently. I’ve been thinking that I wish I’d kept mine up to ... Continue reading

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...

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...

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...

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...

As supply-chain constraints continue to impact Microsoft's cloud capacity, there are some steps customers can take to try to lessen the impact.

The lineup for the PASS Data Community Summit is o...

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,...

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...

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.

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.

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...

This guide explains how to sign PowerShell scripts. In Part Three, you will learn the final steps of the process.

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.

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...

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...

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...

Kraftway shows off the company's latest PCIe 4.0 S...

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.

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 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...

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...

PostgreSQL database performance is critical for application performance. EzzEddin Abdullah shows how to get information about a query’s performance from the execution plan.

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...

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...

–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...

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.

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...

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...

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...

This article describes how to hide measures from a...

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...

This article describes how to hide measures from a group of users by leveraging object-level security in Power BI and Analysis Services.

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...

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...

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...

Benefit from the latest PostgreSQL minor versions for Azure Database for PostgreSQL – Hyperscale (Citus).

Data history is an integration feature of Azure Digital Twins.

Container Insights now supports the Windows Server 2022 operating system.

SQL Server column level encryption example - although easy to setup requires some planning & management of master keys to allow movement and recoverability

Cell level encryption , Column level encryption and Always Encrypted - which one to use ? and under what circumstances? v

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 has warned customers about a new high-risk worm called...

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.

The hospitality giant said data from 300-400 individuals was compromised by a social-engineering scam targeting the Baltimore airport.

Apple's new Lockdown Mode protects devices targeted by sophisticated state-sponsored mercenary spyware attacks.

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...

Fun With KQL - Now

There are many new features in SQL Server 2022. In...

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...

You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows you how.

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...

In this article, we will learn how to build a cust...