SQL Server

T-SQL Tuesday 180 – Good enough is perfect

by

For this months T-SQL Tuesday contribution I cover my attempts to get to a level where good enough is perfect. Before I go any further, I want to thank Josephine Bush (l/x/m) who hosts this months T-SQL Tuesday. Josephine invites us all to discuss how do achieve good enough without compromising the process/product. You can … Read more

T-SQL Tuesday 177 – Managing Database/SQL Pool/Data Warehouse code

by

For this months T-SQL Tuesday contribution I cover managing Database/SQL Pool/Data Warehouse code. To clarify, this post focuses on managing code for SQL Server databases, Azure Synapse SQL Pools and Microsoft Fabric Data Warehouses. Since they all work with T-SQL and this is a T-SQL Tuesday post. Before I go any further, I want to … Read more

T-SQL Tuesday 176 – Advice I would give past me when starting my first data platform job

by

For this months T-SQL Tuesday contribution I cover advice that I would give past me when starting my first data platform job. Before I go any further, I want to thank Louis Davidson (l/x) who hosts this months T-SQL Tuesday. When I first saw the invitation title I mistakenly thought it was a repeat of … Read more

T-SQL Tuesday 174 – My favorite job interview question

by

For this months T-SQL Tuesday contribution I cover my favorite job interview question. Just for good measure I am going to mention a previous favorite as well. Before I go any further, I want to thank my namesake Kevin Feasel who hosts this months T-SQL Tuesday. Kevin invites us all to talk about our favorite … Read more

T-SQL Tuesday 171 – Using SemPy to view DAX in Microsoft Fabric

by

For this months T-SQL Tuesday contribution I cover how I ended up using SemPy to view DAX in Microsoft Fabric. To be more precise, using the new(ish) SemPy library within a notebook to query the DAX used for a measure within a published Power BI report. Before I go any further, I want to thank … Read more

Spreading your SQL Server wings with Microsoft Fabric Lakehouses

by

In this post I cover spreading your SQL Server wings with Microsoft Fabric Lakehouses. As part of a series of posts about spreading your SQL Server wings with the Microsoft Intelligent Data Platform. You can find out more about this series of posts in an introductory post I published about the series. I thought it … Read more

T-SQL Tuesday 165 – Database job titles are in the eye of the beholder

by

For this months T-SQL Tuesday contribution I want to share why I think database job titles are in the eye of the beholder. At least to an extent. Plus, add to the list compiled by Josephine Bush (m/t). In addition, provide a bit of advice about what to do if you are conflicted due to … Read more

T-SQL Tuesday 164 – Code that made me feel something

by

For this months T-SQL Tuesday contribution I want to cover the last time I saw code that made me feel something. Erik Darling hosts this months T-SQL Tuesday. Erik invites us all to talk about the last time we saw code that made us feel something. You can read the original invitation by clicking on … Read more

T-SQL Tuesday 163 – Best piece of career advice ever received

by

For this months T-SQL Tuesday contribution I want to cover the best piece of career advice that I ever received. Which has the potential to raise some eyebrows. Gethyn Ellis hosts this months T-SQL Tuesday. Gethyn invites us to talk about the best piece of career advice we have ever received. You can read the … Read more