Azure

SQL: GREATEST and LEAST - awesome new additions to Azure SQL Database

I still get really excited when T-SQL has new language elements added. I’m not talking about new data definition or management statements. I’m talking about new functions and logic. So, as expected, I was really happy when I saw some posts saying that GREATEST and LEAST now seemed to be working in Azure SQL Database. They’ve been in other database engines before but weren’t part of T-SQL. I tried them, and sure enough, they work as expected.

2021-01-12

SDU Podcast: Show 80 with guest Pedro Lopes is now available

I was really pleased to get to record a SQL Down Under podcast with an old friend Pedro Lopes recently. Pedro is a Principal Program Manager with Microsoft in the Azure Data SQL Server area. A year or so back, I had Joe Sack on the show telling us where Intelligent Query processing was heading, and Pedro now fills us in on where it’s got to. We recorded the show earlier in this month but I couldn’t release it until after the PASS summit where some of the features were announced.

2020-11-23

SQL: PASS Learning Experience on Making a Cloud Transformation

I’ve been in so many companies lately where new CTOs and CIOs claim to have a cloud focus, but all they want to do is migrate all their existing systems from on-premises VMs to cloud-based VMs. They talk about making a cloud transformation but they’re not transforming anything. I was pleased to get a chance to create a short educational series for the people at PASS to cover some of my thoughts on how to make a real transformation, not just a migration.

2020-10-09

SQL Down Under Podcast 79 with Guest Mark Brown

Hi Folks, Just a heads-up that we’ve just released SQL Down Under podcast show 79 with Microsoft Principal Program Manager Mark Brown. Mark is an old friend and has been around Microsoft a long time. He is a Principal Program Manager on the Cosmos DB team. Mark is feature PM for the replication and consistency features. That includes its multi-master capabilities, and its management capabilities. He leads a team focused on customers and community relations.

2020-04-04

ADF: Changing or removing your Git connection from an Azure Data Factory

I’ve been working a lot with ADF (Azure Data Factory) again lately. If you’ve started to work with ADF and aren’t using Git in conjunction with it, you need to change that now. ADF objects are also represented as JSON objects and lend themselves nicely to being stored in Git. Another key advantage is that if you don’t have Git connected, when you’re working with ADF, you don’t have a Save button.

2020-02-21

SQL: Fix - Login failed for user 'NT AUTHORITY ANONYMOUS' Azure SQL Database Error 18456

At one of my customer sites, I recently started having an issue logging onto an Azure SQL Database. The customer had configured Azure Active Directory (AAD) and were using Multi-factor Authentication (MFA). I had previously been using it OK. I would connect to the server using SSMS, enter my username and password, and then be prompted for the MFA authorization. After I authorized the logon, I would then receive the error shown in the main image: Login failed for user ‘NT AUTHORITY\ANONYMOUS’ and Error 18456.

2019-09-25

DevOps: Are you centralizing your log files?

System configurations are becoming more complex all the time. Each and every server, container, and key application and service today has log files that tell you a wealth about what’s going on under the covers. But how accessible are those log files in your organization? If you aren’t using a log management tool, you probably should be. Here are a few easy ones to get started with: Azure Monitor One thing that I do find frustrating with Microsoft tooling at present is the constant churn of product names.

2018-12-20

SDU Tools: Create a linked server to Azure SQL Database from SQL Server

When I need to move small amounts of data between an on-premises SQL Server system and an Azure SQL Database, or run queries that involve both systems, the easiest option at present is to create a linked server to Azure SQL Database. And the easiest way to do that (or if you can’t remember the commands) is with one of our free SDU Tools for developers and DBAs, called CreateLinkedServerToAzureSQLDatabase. You can read it to check out the code, or use it like this:

2018-06-27

Shortcut: Import and Export Settings in SQL Server Management Studio

Whenever I need to work on a new laptop or server, or whenever I change versions of SQL Server Management Studio, I kick myself for not remembering to export my settings, so I can import them again. I spend quite a bit of effort getting SSMS configured the way I want, so it only makes sense to save the settings. Saving them isn’t perfect but it’s far better than not having done it.

2018-03-01

Opinion: Constant churn breaks community learning for software applications

A current trend that I can’t say that I love is constant churn within software applications. I have no interest to go back to the days where we got a new version of SQL Server or Power BI, etc. every few years. It’s also not a case of who moved my cheese? In fact, I thrive on change. However, I’ve now become really concerned about how anyone: Learns to use a complex application Remembers how to use a complex application when they don’t use it daily I first really struck this issue with Azure.

2018-02-20