Confessions of a Microsoft Addict

Azure Data Factory trigger tip

• by Daniel Janik

• Confessions of a Microsoft Addict

This tip comes from my DBA days working with SQL Agent Job schedules. If you’ve ever worked on a server where many people created job schedules you’ll know exactly...

2020-05-19 (first published: 2020-04-30)

254 reads

SSMS Quick Tip

• by Daniel Janik

• Confessions of a Microsoft Addict

Today’s quick tip is for SQL Server Management Studio (SSMS). From time to time when I’m speaking I’ll get a question on how I pulled up help for a...

2020-05-14 (first published: 2020-04-30)

963 reads

Tech Chat with a Microsoft MVP Data Platform

• by Daniel Janik

• Confessions of a Microsoft Addict

I figured it would be nice to start up a weekly chat while everyone is on lock down. If it goes well I’m up to make this a regular...

2020-04-16

18 reads

It’s 2020, Do I really need to DBCC CHECKDB?

• by Daniel Janik

• Confessions of a Microsoft Addict

I’ll start by saying that I swear I posted this at some point in the past but I don’t see it looking back at old posts. This is from...

2020-04-27 (first published: 2020-04-15)

1,437 reads

Database classifications have changed

• by Daniel Janik

• Confessions of a Microsoft Addict

Some time back I wrote about the new data classification features in Azure and SQL Server Management Studio. If you’ve done quite a bit of work classifying your data...

2020-04-24 (first published: 2020-04-11)

857 reads

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-16 (first published: 2020-04-03)

249 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

51 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

46 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)

412 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

47 reads