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
This month, Steve Jones (T) invites us to write about the way dynamic SQL helped us solve a problem. Case For one of our customers, we've had an interesting case. They have multiple schemas in the database and the schema's contain a lot of tables with different use cases. To grant user groups (not individual … Continue reading T-SQL Tuesday 155, Dynamic SQL
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
Last saturday I was speaking in Göteborg at the local data saturday, hosted by Mikael Wedham (T | B). The day before a speaker dinner was organised at an island with a very nice restaurant. After a boat ride of about an hour (where we picked up some late arrivals along the way) we got … Continue reading Speaking experiences at Data Saturday Göteborg
For a few weeks I'm facing an issue where an application on an Azure VM has a slow network connection to an Azure SQL database. I've tried different tiers and SKU's but the speed is just not there. When the application is running, it can push about 250 to 500 kb/s to the database. As … Continue reading Increase network performance between your VM and Azure SQL Database
Next week (Thursday 4th of august 2022) I've been invited to speak at the Microsoft data platform group Birmingham. This is a very active user group that hosts monthly sessions on the data platform, and this month I'm honoured to talk about monitoring Azure SQL with Zabbix. In this session I'll walk you through monitoring, … Continue reading Speaking at Microsoft Data Platform Group – Birmingham
Now that's a title! Here's the problem I've ran into. Setup Customer has an Azure environment with an Azure SQL Server database that can be reached through a private endpoint. There's a VPN in place to connect on-premises networks with the Azure VNet and the private endpoint is in one of the subnets, the VPN … Continue reading Connect your on-premises SSMS to Azure SQL DB over a VPN
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