Friday Flyway Tips – Adding the Type of Database Project
There was an update to Flyway Desktop which lets you see the type of database your project is associated with, and this post shows how to get this in...
2023-11-10
94 reads
Blog Posts
Game Night at the PASS Summit
Games Night is back at the Summit, this time on Wednesday night in a large space for 200 people plus to enjoy some fun with friends and colleagues. This...
2023-11-10 (first published: 2023-11-02)
169 reads
PASS Data Summit 2023
Appreciate everyone who has reached out asking if I would be attending the PASS Data Summit out in Seattle this year. Yes, I will be, and I am looking...
2023-11-10
54 reads
Summit 2023 Is Nearly Here!
All week, my phone has been reminding me (via photo memories) of the amazing experience I had at PASS Summit 2017. This can mean only one thing - PASS...
2023-11-10 (first published: 2023-11-03)
115 reads
Advice for 2023 PASS Data Community Summit Attendees
Edwin Sarmiento has a great First Timer Guide for the PASS Data Community Summit, which is updated for 2023. He’s been compiling this since 2016, and it’s worth reading....
2023-11-09
76 reads
Database Concerns – A Poll!
What are you most concerned about in your database platforms? Please pick from the list below, and expand on your choice in the comments if you like: Thanks...
2023-11-08 (first published: 2023-10-25)
222 reads
My data architecture book now has 15 chapters available!
Only one more chapter to go! As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title...
2023-11-08 (first published: 2023-10-23)
639 reads
All the chapters in my data architecture book are now available!
As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering Data...
2023-11-06
29 reads
Common Mistakes in SQL Server – Part 6
In SQL Server, there are various scenarios in which you may want to consider recompiling a query or a stored procedure to ensure optimal query performance. Recompilation generates a...
2023-11-06 (first published: 2023-10-23)
755 reads
Setup Ola Index Maintenance with Azure Runbooks and Terraform
Yes, you still need to do some work to maintain indexes in Azure SQL Database. This post will walk you through setting up statistic updates and index maintenance using...
2023-11-06 (first published: 2023-10-19)
504 reads
Blogs
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers