Deploy BACPAC to Azure Managed Instance failing from SSMS?

• by Daniel Janik

• Confessions of a Microsoft Addict

Recently I ran into an error when trying to copy a small database bacpac into an Azure Managed Instance. It’s said that SSMS is able to do this task....

2020-04-03

5 reads

Why is the XLOCK table hint broken?

• by Daniel Janik

• Confessions of a Microsoft Addict

Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources...

2020-02-20 (first published: 2020-02-12)

391 reads

Azure Data Studio extension – help wanted

• by Daniel Janik

• Confessions of a Microsoft Addict

I’ve created a sample ads extension that checks TSQL syntax in real-time for potential bad practice. Right now the extension is using regex, which isn’t the best for parsing...

2020-02-13

29 reads

Quick tip: Quickly bulk edit lines in SSMS

• by Daniel Janik

• Confessions of a Microsoft Addict

Have you ever needed to bulk edit a table from excel to change it into a group of insert statements or change multiple query lines? In SQL Server Management...

2020-02-12

28 reads

Taking a gamble on Azure Data Studio Notebooks

• by Daniel Janik

• Confessions of a Microsoft Addict

If you’re a data professional or application developer chances are you’ve run into Microsoft SQL Server once or twice. I would think that the majority of SQL Server professionals...

2019-05-30

45 reads

I’ve added data classifications. Now what?

• by Daniel Janik

• Confessions of a Microsoft Addict

About a year ago I wrote about a new feature in SSMS that allows you to add a data classification...

2019-03-08 (first published: 2019-02-20)

2,507 reads

Free SQL tuning tool: How’s My Database?

• by Daniel Janik

• Confessions of a Microsoft Addict

It’s taken longer than I thought it may and I’ve run into several problems along the way but had a...

2019-02-13

197 reads

Where have I been?

• by Daniel Janik

• Confessions of a Microsoft Addict

Before you read too far, this is going to be a deeply personal post.Where do I begin? As many of...

2019-02-13

139 reads

Where to watch Ignite

• by Daniel Janik

• Confessions of a Microsoft Addict

In case you aren’t familiar with #MSIgnite, it’s a huge event where Microsoft debuts all the new shiny software that...

2018-09-24

260 reads

Are scalar functions really a bad thing?

• by Daniel Janik

• Confessions of a Microsoft Addict

I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog...

2018-09-18 (first published: 2018-09-10)

3,740 reads