In a blog from a few weeks ago, I wrote about getting data from your on-prem SQL Server into Fabric. At the time, the only option for a copy dataflow was using a direct connection over the internet. It still is, but now you can also use the PowerBI Data Gateway to get data from … Continue reading Getting on-premises data into Microsoft Fabric using the data gateway
I was teaching a class and during an interesting discussing an attendee told me that views with a filter took a long time to produce results, even if the result set itself was quite small. I wanted to test this out for myself to see what was happening. I'll take you along this short journey … Continue reading View with a where clause
This month, I hosted the Tsql2sday where I asked you to write about the most funny things you did with T-Sql. I'll happily admit it was a bit of a cheesy subject but you came out in numbers to write! Thanks for that. Before I dive into the blogs I found, send me a message … Continue reading Tsql2sday #161, the writeup
This month Deepthi Goguri invites us (the community) to write about two topics: our favourite new feature of SQL Server 2022 and your new years resolutions. You can find her blog here, her LinkedIn profile here and she's also on Twitter here. Favourite new SQL Server 2022 feature Most of my work is in data … Continue reading T-SQL Tuesday #159 – What’s Your New Favourite Feature?
I'm a huge fan of the Ola Hallengren maintenance scripts. They have incredible power and, when you've read the documentation, are easy to use. But one thing he can't prepare the scripts for, is different settings for each database on the instance. Allow me to show you how I've fixed that. Setup Suppose I've got … Continue reading Dynamic SQL Maintenance Scripts
Last week, one of my coworkers had a nice case. From a dataset, he needed the third row based on an indicator and a timestamp. That sounded a bit vague so I started out with creating a table that contained some records with the columns he'd have to filter on. CREATE TABLE dbo.demo ( id … Continue reading Fun ROWNUM() case, get n’th row from dataset.
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Premium tier. Click here for information about the set-upClick here for the scripts I’ve used Intro In my previous blog I wrote about the standard tier, one that has 9 SKU’s and … Continue reading Azure SQL Database Performance comparison part 3 of 9: Premium
A short blog on how to get Always Encrypted to work in your app and in the ODBC connection.
Testing out if you can use preceding and following in the same windowing function @Microsoft @SQLServer #zekerweten
My short thoughts on migrating/upgrading SQL Server for #tsql2sday #tsql2sday147
Reitse's blog 