T-SQL Tuesday #158–Implementing Worst Practices
Not that I’m looking to do this, but that’s the invitation from Raul Gonzalez this month. This is the monthly blog party where we write on a topic chosen...
2023-01-10
151 reads
Creating a PostgreSQL Docker Container with a Volume on Windows
This post looks at how to set up a PostgreSQL container on Windows using Docker for Windows. I’ve seen a few posts, but I had to cobble together some...
2023-01-20 (first published: 2023-01-09)
337 reads
Microsoft SQL Server Management Studio Error
I came across an issue with SSMS not loading properly recently. Regardless of launching from the start menu with or without administrator, SSMS would error out. Due to this...
2023-01-18 (first published: 2023-01-09)
559 reads
Daily Coping 9 Jan 2023
Today’s coping tip is to look back at a previous coping tip that required planning and evaluate how it helped. One of my tips in December was to listen...
2023-01-09
29 reads
Data Céilí Dublin 2023
Today we have launched Data Céilí (pronounced kay-lee) Dublin 2023, Ireland’s free, community led, Microsoft Data Platform event. We tried in 2020 but certain global events prevented us from...
2023-01-16 (first published: 2023-01-09)
242 reads
Speaking at Data Community Austria Day 2023
Let me start by wishing everyone the best for the year 2023! We’re going to kick off the new year with a virtual conference: the Data Community Austria Day...
2023-01-09
41 reads
Securing the Root Keys for TDE
In this quick post we’re going to look at an additional step you should take to secure your TDE databases. This is a step you won’t find in any...
2023-01-09
43 reads
Help! My tempdb is full and I can’t access SQL Server!
I got a call saying the database server is inaccessible because tempdb is full. I get online and try to connect because I want to see the error for...
2023-01-18 (first published: 2023-01-06)
1,112 reads
Goals for 2023
This is the goal setting post for 2023. The previous ones were: 2022 2021 2020 2019 2018 As with previous years, I’ll break these into three categories: career, personal,...
2023-01-06
27 reads
Outlining Goals in 2023
Last year I set a bunch of goals, and I thought I did pretty good working on them. Not amazing, but pretty good. This year, I want to attack...
2023-01-06
24 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers