Multi-server admin, storytelling, and more (Database Weekly 2020-11-07)

Automatic Install of Azure Data Studio

Microsoft recently announced that you’ll get Azure Data Studio (ADS) when you install SQL Server Management Studio (SSMS) starting with version 18.7.1. Azure Data Studio has been around for a couple of years, and it has some great features that most of us never imagined for SSMS, like the ability to connect to PostgreSQL databases and work with SQL Notebooks. Microsoft and third parties can develop extensions to add new functionality easily, so you can customize ADS with only the features you will use. There are extensions for Machine Learning and Azure Arc among others in the latest release.

I’ve used ADS in my T-SQL intro classes because it can be installed on multiple platforms. In the past, I’ve had to make sure that my students were all running Windows; now I can teach T-SQL to macOS and Linux users as long as I supply sample databases in Azure for them. Students are able to prepare for the classes quickly with less time spent on installations and troubleshooting.

Even though ADS has some great new features, there is a lot that’s missing, especially for administrators. My favorite thing about SSMS is that there is a dialog for just about anything you need to do, but you can click “Script” instead of performing the action once the options are filled out. That way, you can use the generated script to learn the commands and start automating the process. Some of that is found in ADS. For example, the database backup dialog has a script option. Many dialogs are missing, however, and others bring up SSMS dialog boxes if it is installed. This happens when you try to look at the database properties, for example.

I think that many SSMS-only features will eventually find their way into ADS since that is the tool where Microsoft is investing the most resources. This makes sense as SQL Server now runs in Linux and in containers. More DBAs could be running Ubuntu in Linux shops, and ADS will be the tool they need.

I’ve seen differing opinions about the automatic installation of ADS when installing SSMS. It does seem a bit strange, since most installs let you select the components you need. Those who do not want or care about ADS could be annoyed. In my own case, I always install both, so it saves me a bit of time.

Where is ADS heading? We’ll just have to sit back and watch!

Kathi Kellenberger

Join the debate, and respond to the editorial on the forums

Tony Maddonna, BMW’s SQL Server Enterprise Architect, writes about the challenges of database monitoring. Drawing on experiences throughout his career, this blog covers manual vs third party, proactive monitoring in dev and test, and managing expectations of the cloud. To learn more, and read his tips on how to build a business case for third-party tooling, check out his blog.

Are you new to Version Control and not sure where to start? Visit the Redgate University and check out Steve Jones' Introduction to Version Control course. In just 20 minutes Steve will give you a rundown of what version control is and what the benefits are.

Phil Factor's take on the best ways to reverse or accelerate your way out of the problems caused by a failed database update.

Jeremiah Peschka, a tech lead for SQL Monitor development, explains the new SQL Server configuration options available for the data repository, and how enabling them might improve SQL Monitor performance, when reading and writing monitoring data.

Imagine having at your fingertips all the metadata queries you need to explore your SQL Server databases and then, a few clicks later, all your diagnostic queries to troubleshoot their performance. Phil Factor demonstrates how it can be done, by storing each set of snippets in a standard JSON collection and using PowerShell to convert them to SQL Prompt snippet files.

Ami Adler, a Software Development Manager at Datafaction explains how they used Redgate tools, and others, to introduce automation and testing into their Database DevOps processes and so achieved a faster and more reliable deployment process for their application.

A few weeks ago I had a pleasure to talk about MSX...

I recently ran into a situation where a new SQL Server would crash hard...

On October 27, 2020, Microsoft released SQL Server Management Studio (SSMS) 18.7.1. This is a minor bug fix release...

Woohoo! My annual Black Friday Sale is on now.

It is a really common requirement to add specific libraries to databricks. Libraries can be written in Python, Java, Scala, and R...

I was in a webinar recently and saw a note about v...

Finally, I got my certification Azure Database adm...

If you’re familiar with database management systems, you will know how important statistics is. Using statistics (“stats” for short), the database knows the cardinality...

A question that I have been hearing recently from customers using Azure Synapse Analytics (the public preview version) is what is the difference between using an external table versus... The...

One of the most important responsibilities for a DBA is to ensure that a database can be restored in case of corruption, a dropped table, or another disaster. In this article, Greg Larsen explains the different types of backups available with SQL Server.

Click to learn more about author Irfan Ak. Artificial intelligence and big data are two of the hottest and most discussed topics in the tech circle. Despite this, there...

Deloitte recently published the report, A demanding Future: The Four trends that define insurance in 2020. Join Redgate Solutions Architect, Chris Unwin and Coeo Commercial Director, James Boother live on November 11th, as they discuss how a Database DevOps approach can help overcome the key challenges within these trends.

Join Microsoft Data Platform MVP, Grant Fritchey to discover actionable strategies you can implement to bridge the divide between data management and DevOps in your organization.

Recently a folder within a SMB share on the Window...

Who Am I Talking To You use bash or python. PowerShell seems wordy, extra verbose, and annoying. It’s a windows thing, you say… why would I even look at it. Pry bash out...

Click to learn more about author Bernard Brode. Once upon a time, humans communicated meaning through stories. Epic tales of adventure and intrigue, memorable myths of heroes and their...

It’s common knowledge that data-driven decisions are critical to any organization. It has also been established that “data is the new oil.” So, why are so many institutions just...

The purpose of a foreign key is to ensure data int...

Building a tech startup is an exciting yet challenging process to navigate...

More organisations are adopting DevOps, but what happens as the codebase grows? In this article, Siddharth Rao gives advice on how to implement continuous deployment at scale.

Total: 1 Average: 5This article explains how to create an SSIS package using SQL Server Data Tools, deploy it with the Integration Service deployment wizard, and automate its execution...

First, please do not misunderstand. You should bac...

For quite some time now, there’s been the possib...

Are you using DAX Studio with Power BI? Patrick sh...

Recreating If you have a copy of the StackOverflow2013 database, this query should produce a parallel deadlock. SELECT c.Id, c.UserId, c.CreationDate, c.PostId, c.Score INTO #ohno FROM dbo.Comments AS c WITH (TABLOCKX); If...

Last month, I presented at year 4 of SQL Trail, a ...

I decided to dedicate this short blog post on how to make better use of Power Query and all the M functions inside...

Note: This article was first written in March 2019, then updated in Nov 2020 to update the changing licencing information that is available to me. I have long been...

Generating password is a hustle and I don’t want to go into the philosophy of passwords. Strong password, lengthy password, automatically generated password, etc. For me, they are all...

Not many disaster recovery or SQL migration/upgrad...

If you ask any senior IT person What is the most ...

I've had this blog post in draft for quite some time now, adding little bits to it as the opportunity presented itself.

Development workflow, especially ...