# Kay On Data
> Easier insights with better data, automatization and thought leadership
Public Ghost content for AI and LLM tooling. Use `/llms-full.txt` for consolidated page and post context.
Append `.md` to any post or page URL to get the content in Markdown (for example, `/example-post.md`).

## Pages
- [About Me](https://www.kayondata.com/about.md) - About Kay Sauter, data strategy, Microsoft data platforms, community work, and the perspective behind Kay On Data.
- [Advisory](https://www.kayondata.com/advisory.md) - Data strategy, data quality, architecture, and Microsoft data platform advisory for decisions people and AI can trust.
- [Archive](https://www.kayondata.com/archive.md) - A chronological overview of Kay On Data articles.
- [Community Engagement + Speaking](https://www.kayondata.com/community-engagements.md) - Speaking, organizing, writing, and community work around data quality, Microsoft data platforms, automation, and inclusion.
- [Contact me](https://www.kayondata.com/contact.md) - Use the contact form for advisory work, speaking, live captions, community work, or thoughtful blog feedback.
- [Live Captions Should Be Normal](https://www.kayondata.com/live-captions.md) - Why live captions should be a normal part of technical talks, online sessions, meetups, and conferences.

## Posts
- [A Shout-Out to Synaps Media: My Blog Has a New Home](https://www.kayondata.com/a-shout-out-to-synaps-media-my-blog-has-a-new-home.md) - For about a year, my blog lived on Hashnode, but I never saw the SEO results I was hoping for. At the same time, my Substack was quietly gaining subscribers without any advertising. So I decided to take back full control, and go self-hosted again. Ghost CMS has been a dream to use so far. The writi…
- [AzureSqlVmToolkit Is Becoming Azure Data Lab Toolkit](https://www.kayondata.com/azuresqlvmtoolkit-is-becoming-azure-data-lab-toolkit.md) - AzureSqlVmToolkit is becoming Azure Data Lab Toolkit, a PowerShell-first project for building repeatable data labs across Azure SQL, Microsoft Fabric, PostgreSQL, and more.
- [Publishing Powershell Azure SQL VM Toolkit](https://www.kayondata.com/coming-soon.md) - In 2021, I wrote a PowerShell script to automate most of the steps for deploying a SQL Server VM on Azure, but not everything. Also back then, the whole deployment process with the script took almost one hour to deploy, including database restores and installing chololatey and some tools. Today, I…
- [Deploying Azure SQL VMs with PowerShell Azure Bastion + dbatools](https://www.kayondata.com/deploying-azure-sql-vms-with-powershell-azure-bastion-dbatool.md) - Update of my older post after the breaking changes by Microsoft! What happened? About a year ago, my original script from my blog post “Deploy Azure Sql Server Vm With PoSh” (blog, substack) from 2021 broke due to a change in the underlying model. In last August, Microsoft updated its documentation…
- [How to fix the red lines in MS Fabric notebooks](https://www.kayondata.com/how-to-fix-the-red-lines-in-ms-fabric-notebooks.md) - In my last article (hashnode, LinkedIn, Substack) of this series, I covered on how to load csv files in a lakehouse automatically in MS Fabric. In this article, I am going to discuss how we can find and fix errors with notebooks easily. Firstly, we want to get a nice overview over all csv files tha…
- [I've moved my blog on kayondata.com to Hashnode!](https://www.kayondata.com/ive-moved-my-blog-on-kayondata-com-to-hashnode.md) - I was actually quite happy with Hugo CMS, for it is a great blog system. Unlike the most popular CMS out here, it doesn’t really need any frequent updates to be secure. It uses Markdown which I love, and I love to use within my favorite code editor, VSCode. However, Hugo had its downsides. Because…
- [Loading files automatically to bronze lakehouse](https://www.kayondata.com/loading-files-automatically-to-bronze-lakehouse.md) - In my last post on LinkedIn, I explained how to export AdventureWorks2022 tables to csv files. If you don’t want to generate them, you can get them here, as stated in the last post (after my edit in which I realized I made a mistake). My actual blog https://kayondata.com is currently being moved to…
- [Getting Adventureworks to Fabric](https://www.kayondata.com/getting-adventureworks-to-fabric.md) - Today, I am starting a series of blog posts on how to get the AdventureWorks database to Fabric. This is a series of blog posts that will cover a journey from exporting the AdventureWorks database to csv files, to getting the data to Fabric Lakehouse and then to the Data Warehouse. Along the way, I…
- [T SQL Invite December 2023](https://www.kayondata.com/t-sql-invite-december-2023.md) - T-SQL Tuesday No. 169 – December 2023 I’ve got the honor to invite you to the blog party SQLTuesday, tagged as #tsql2sday, for this December 2023. Many thanks to Steve Jones (blog, twitter) for letting me host this month’s blog party! December is the last month of a year. I believe December is the…
- [Fabrics OneDrive](https://www.kayondata.com/fabrics-onedrive.md) - OneLake Sorry, my title indeed said "OneDrive" and that is actually by intention. It is really easy to mix them up, just look at this screenshot I did on my Laptop. It shows the file explorer and it very much looks the same. OneLakes logo is also shown in the taskbar in the bottom right corner next…
- [Getting into Fabric](https://www.kayondata.com/getting-into-fabric.md) - Finally, I've found time to dig deeper into Microsoft Fabric So finally I've found time to dig deeper into Microsoft Fabric, the newcomer in Microsofts data platform family. I've played a bit with it and I thought I should blog about some distinct differences in between Azure Synapse Analytics and…
- [My week at SQLBits 2023: Why You Should send your Employees to Conferences](https://www.kayondata.com/my-week-at-sqlbits-2023-why-you-should-send-your-employees-to-conferences.md) - This post was first published on my LinkedIn Newsletter on 20 March 2023. As I'm now tired, but happy and heading back on my bus of national express to Heathrow airport and taking a plane there back to my hometown Zurich, Switzerland, I'd like to wrap up my days here in Wales for the extremely fant…
- [T-SQL Tuesday #159](https://www.kayondata.com/t-sql-tuesday-159.md) - My friend, Deepthi Goguri, invited everyone to blog about two topics as a request for T-SQL Tuesday. T-SQL Tuesday is a once a month occurring event, a so-called blog party, for which someone invites others to blog about a topic. You can learn more about this on this website of tsqltuesday itself.…
- [Sql Tuesday: Azure Data Groups](https://www.kayondata.com/sql-tuesday-azure-data-groups.md) - Every second Tuesday of a month, there's a T-SQL-Tuesday. This is a blogging event that everyone can participate. The idea was created by Adam Mechanic, but nowadays, it's hosted by Steve Jones. For this month, Rie Merritt called for advices for running a user group. I know, I'm a quite late to joi…
- [Bye-bye 2021](https://www.kayondata.com/bye-bye-2021.md) - Looking back So the year 2021 is history. For me, it was a quite eventful year although exactly one year ago, I hoped that the pandemic situation would improve. It kind of did, true. However I hoped it'd be better than it turned out to be. Nevertheless, I hope on January 1st 2023, I'll have a bette…
- [Speaking Engagements September 2021](https://www.kayondata.com/speaking-engagements-september-2021.md) - This post was originally published on my employers blog first. September marks the end of this summer but we've got some exciting news about new events that we'll be joining this month. This post is giving you an overview over these! We hope you've enjoyed your summer break and are ready for the ne…
- [Why We Like to Recommend Dbatools](https://www.kayondata.com/why-we-like-to-recommend-dbatools.md) - This post was first published for my employer, OneDigit AG, here. dbatools really has the ability to change a DBAs work life. It is a free, very powerful and feature rich open source PowerShell module that offers you 550+ commands that allows you to take backups, restore them or just do a lot in SQ…
- [Starting DataTGIF](https://www.kayondata.com/starting-datatgif.md) - This post was first published on my employers website/blog here. I just started to organize a free to join MeetUp called Data TGIF that will be scheduled once a month on a Friday afternoon. This MeetUp organizes free data events for Friday afternoons to celebrate the start of the weekend by meeting…
- [Moving to Hugo](https://www.kayondata.com/moving-to-hugo.md) - I've moved from WordPress to Hugo. Just because I've never really made very good experience with WordPress. Yes, it is easy, but one has just to hope that all plugins will work together and keeps working together in the future. My move to Hugo was inspired by Kendra and Justin. Furthermore, the int…
- [SQL Server Management Studio and Azure Data Studio](https://www.kayondata.com/sql-server-management-studio-and-azure-data-studio.md) - If you’ve installed SQL Server Management Studio (SSMS) recently, chances are that you’ve noticed that Azure Data Studio (ADS) was installed too. Since SSMS Version 18.7, ADS gets installed alongside with SSMS by default. But you might not be familiar with ADS. What is it and how does it set apart…
- [My journey to my first speaking](https://www.kayondata.com/my-journey-to-my-first-speaking.md) - To give a speaking in public for the first time is always scary. At the DataWeekender in October last year, Angela Henry who was moderating some sessions together with me, mentioned that there is a website where you can look for mentors and recommended it to me if I would want to pick up speaking.…
- [Deploy Azure Sql Server Vm With PoSh](https://www.kayondata.com/deploy-azure-sql-server-vm-with-posh.md) - This post was first published on my past employers blog here. I thank OneDigit AG for the permission to publish my article also here. Especially in this time of COVID-19 caused lockdowns, working from home is widespread. Therefore, working together on a developing VM in the cloud may be an attracti…
- [I'm moderating at DataWeekender conference](https://www.kayondata.com/im-moderating-at-dataweekender-conference.md) - The Dataweekender conference is coming up again this Saturday Oct 17! After the very successful first Dataweekender conference on May 2nd 2020 with more than 1000 sign-ups and with an excellent speaker lineup, the 6 founders of Dataweekender decided to setup another one this year. Just like the fir…
- [Introduction Into Window Functions on SQL Server](https://www.kayondata.com/introduction-into-window-functions-on-sql-server.md) - Why window functions may come in handy Let us dive directly into a real world example. You’ve got a table with salaries of different job functions and you are asked to find out what the n-tiles (quantiles, mean etc.) are of each function within a company. So this means you’ve got many people that h…
- [Hello World!](https://www.kayondata.com/hello-world.md) - This is my first post, testing syntax highlighting here: write-output "Hello World" SELECT * FROM TABLE WHERE A = B print("Hello World!")

## Optional
- [RSS Feed](https://www.kayondata.com/rss/)
- [Sitemap](https://www.kayondata.com/sitemap.xml)
- [Full content of pages and posts](https://www.kayondata.com/llms-full.txt)