-
The #MS_DatabaseConnector## Role: #SQLNewBlogger
I had seen these roles in various instances, but never dug into the new Fixed Server roles added to SQL Server. They are supposed to help ensure the principle of least privilege is followed. In this post, I look at one of these, the ##MSDatabaseConnector## role. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Users and Logins This role is a new one that…
-
Planning for Change
Update: My apologies to Randolph for the incorrect pronouns. They should be correct now. Over the last year, I’ve been asked numerous times when I’m plan to retire. This question has come from friends, parents of kids I coach, coworkers at Redgate, and even from Microsoft. A few people have asked about my succession plans for leaving, as I have a public site at SQL Server Central, and the charity in SQL Saturday. I’d like those things…
-
Great Things
“Great things are done by a series of small things brought together.” – Vincent van Gogh, Dutch Post-Impressionist Painter. I ran across this quote recently and it struck me that it’s expresses a thought I’ve had for some time. Instant, magical success isn’t often what it appears. Anyone that seems to have sprung up overnight with success in anything has often spent a lot of time getting ready. Outside of lottery winners, of course. If you bought…
-
Cleaning Up Azure MS Defender Billing
I have a few Azure subscriptions, which are fairly small and not used that often. Mainly I do some SQL Server or Azure SQL experimentation. Sometimes I might create another resource, but I try to not waste resources and disable them quickly (or drop them) when I’m done. However. I hadn’t done much in the last couple of months on Azure. For some reason, I decided to check my bill. What I found was that there were…
-
PostgreSQL 19 Is Late
“All software contains bugs.” That’s a quote from Robert Haas’s “Postgres 19 is late” post. He goes on to say that PostgreSQL has lots of bugs in it. It’s the way it’s been for a codebase that’s over 40 years old. He goes on to note that it’s easier to find bugs with LLMs, and easier to fix them. It’s not, however, as easy to do the latter as the former. The impact on PostgreSQL 19 is…
Currently Reading
administration AI Azure Backup/Recovery career career2 car update Cloud Computing coping database design databases Database Weekly DevOps disaster recovery encryption Flyway Friday Poll goals hardware Humor life Microsoft misc PASS powershell Redgate republish sabbatical security software development software development speaking SQL in the City SQLNewBlogger SQL Prompt SQL Saturday sql server syndicated T-SQL T-SQL Tuesday travel vacation windows words work
