It's the end of the year already, 2022 has really flown by. To see what we have left this year, Garry Bargsley (blog|twitter) has asked us what we have planned for the end of the year? It's been quite the year, but that's for another blog. But it does relate to what's planned for the … Continue reading End of year planning: T-SQL Tuesday #157
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Managed Instance tier. Click here for information about the set-upClick here for the scripts I’ve used Intro So far, the blogs were about the really SaaS databases; the database is deployed and … Continue reading Azure SQL Database Performance comparison part 9 of 9: Managed Instance
It's the beginning of 2020. I've been to a number of conferences, gotten a feel for what's going on and what the different sessions are. From the short sessions to the full hour ones where speakers dive deep into a subject or explain in normal words what some feature can accomplish. Usually I'm learning something … Continue reading New Stars of Data
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Business Critical tier. Click here for information about the set-upClick here for the scripts I’ve used Intro My last blog was about the Hyperscale tier, this week we’re back at more regular … Continue reading Azure SQL Database Performance comparison part 8 of 9: Business Critical
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Hyperscale tier. Click here for information about the set-upClick here for the scripts I’ve used Intro So far, my blogs have been on the different Azure SQL DB offerings where there are … Continue reading Azure SQL Database Performance comparison part 7 of 9: Hyperscale
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB General Purpose Compute Optimized tier. Quite a mouth full. Click here for information about the set-upClick here for the scripts I’ve used Intro In my previous blog, I wrote about the General … Continue reading Azure SQL Database Performance comparison part 6 of 9: General Purpose Compute Optimized
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB General Purpose Provisioned tier. Quite a mouth full. Click here for information about the set-upClick here for the scripts I’ve used Intro In my previous blog, I wrote about the serverless tier, … Continue reading Azure SQL Database Performance comparison part 5 of 9: General Purpose
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.
Reitse's blog 