Search the blog
18 results for “"sql server" or mssql”
Working With Lists In SQL Server
This post takes a look at using STRING_AGG() and STRING_SPLIT() as alternatives to XML functions to work with lists In SQL Server
On-Premises Data Warehouse With SQL Server
Let's take a look at how to build a data warehouse on-premises using Microsoft SQL Server.
SQL Server TRY_CAST()
This post takes a look at TRY_CAST() on Microsoft SQL Server.
DST Conversion Functions In SQL Server
Generating Daylight Savings Time and Standard Time Conversion Functions For Multiple Time Zones In SQL Server
Generating ID fields in views in SQL Server
Taking a look at using ROW_NUMBER() vs. HASHBYTES() for generating unique ID fields in views.
Generating DST Conversion Table In SQL Server
Generating Daylight Savings Time and Standard Time Conversion Table For Multiple Time Zones
Installing PolyBase on SQL Sever 2019
A guide to install PolyBase in SQL Server 2019 on a Windows Server.
A Native macOS and Linux Semantic Model Editor
There is finally a Semantic Model editor that runs native on macOS and Linux called Semantic Modeler from Fact Foundry! It's compatible with Tabular Models for Microsoft Fabric, SQL Server Analysis Services and Azure Analysis Services!
Beyond Gold: Why the Medallion Architecture Needs a Platinum Layer
The Medallion Architecture's Gold layer is widely accepted but poorly defined. In this post I explore the gaps I encountered implementing Gold across SQL Server, Synapse, and Microsoft Fabric — and why adding a Platinum layer solves problems that Gold alone cannot.
Writing Custom Applications Using AI
A real workflow for building apps with AI — how to use one AI to write prompts and another to write code. Covers requirements gathering, phasing for token limits, git safety, and keeping your sanity, without becoming a prompt engineering expert.
Installing PostgreSQL 17 on openSUSE Leap 16
This post we will be installing PostgresSQL 17 on openSUSE Leap 16
Introduction to Power BI Licensing
We will take a look at what kind of licensing you will need for getting started with Microsoft Power BI.
Windows Desktop On Linux
This opinion piece is my thoughts on why Microsoft should create a Linux Desktop Environment.
.NET 6 Is Here
I am excited for the release of .NET 6 and some of the enhancements it introduces.
Entra Groups For AS RLS In Fabric & PBI Service
Learn how to implement Row Level Security in SSAS Tabular Models using Microsoft Entra ID users and security groups for Power BI & Microsoft Fabric, including how to format Group and Tenant IDs for role membership.
PolyBase External Table Schema Tips
A few simple PolyBase tips to figuring out the External Table schema.