Importing Flat Files into Azure SQL DB

Initially, I thought I would have to use sqlcmd because I’m on a Mac and don’t have SSMS. It turns out Azure Data Studio has a nifty way to...

Beginner's Introduction to PowerShell Remoting

Beginner's Introduction to PowerShell Remoting

...

Microsoft Fabric is now GA!

After more than two years in development and six months in public preview, Microsoft Fabric is now generally available (GA). Here is the announcement made during Microsoft Ignite last...

Changing the Data Type of a Primary Key–#SQLNewBlogger

A client asked this question recently: How do I change my numeric PK to a character type? I decided to write a short blog on how to do this....

Building Upon Your Productivity Momentum: Staying Productive For Life

Note: I found this sitting in my Medium draft. This was a cross-post from my old productivity blog that got lost in oblivion. Productivity is never an accident. It...

Is that the right question to ask?

This is not a “clickbait” title, but an important consideration when it comes to developing technical solutions. Let me give you an example between two questions for SQL Server...

A New Word: Vaucasy

vaucasy – n. the feat that you’re little more than a product of your circumstances, that for all the thought you put into shaping your believes and behaviors and...

Women in Tech: Finding Allies #PASSDataSummit

The WIT panel spoke on an excellent topic today: needing, and finding, allies at work. Afterward and for the first […]
The post Women in Tech: Finding Allies #PASSDataSummit appeared...

Part 1: The Modern Azure Data Warehouse – Choosing The Tech

With reports hitting the transactional databases, we were encountering performance issues. We needed to choose a path forward that would lighten the load on the prod database servers and...

PASS Data Summit 2023 KeyNote 2

Morning from the PASS Data Summit! I will be live blogging the event again today, so check back for announcements and releases throughout the keynote. Today, we will dive...