Daily Coping 19 Sep 2022
Today’s coping tip is to make time to remember if you’re busy, allow yourself to pause and take a break. I’m in the UK today, and at the Redgate...
2022-09-19
13 reads
Blog Posts
Extended Events for Anything but Query Tuning: bulk_insert_usage
Wouldn’t it be great to be able to directly monitor specific behaviors within SQL Server, like, oh, I don’t know, knowing exactly when, and how, someone is using BULK...
2022-09-19
36 reads
Mental Health Bullet Journal – Collect Data to Help Your Mental Health
Purpose This blog and bullet journal was specially created to help me with my tendency to have suicidal ideation, depressive, and manic episodes related to
The post Mental Health Bullet...
2022-09-19 (first published: 2022-09-06)
272 reads
Unexpected Blocking during the Indexed View Creation
The problem
There was a need to make changes to a table with an Indexed View. Since Indexed Views must be created with SCHEMABINDING, the View must be dropped and...
2022-09-19 (first published: 2022-09-05)
323 reads
Comment might be free, but that doesn’t mean I have to listen
I have turned off comments on this site. All existing comments have been removed. Even the nice ones from awesome people, and the helpful ones, and the ones answering...
2022-09-16
73 reads
Daily Coping 16 Sep 2022
Today’s coping tip is to make time to aim to be good enough, rather than perfect. I find that many of us that work in technology want a solution...
2022-09-16
7 reads
Future Data Driven
I was honored to speak at Future Data Driven last year. This year has a great lineup with some fantastic sessions on data related topics. Register today for the...
2022-09-16 (first published: 2022-09-02)
180 reads
Web Hosting SQL Database Management Made Easy With Linux
If you’ve never used Linux before, you might wonder how to manage a database on a server. Managing a database can be simple or complex, depending on the needs...
2022-09-16 (first published: 2022-09-01)
256 reads
Daily Coping 15 Sep 2022
Today’s coping tip is to make time to do something you really enjoy. I do enjoy life, and I’m lucky that I have the chance to do a lot...
2022-09-15
16 reads
Making the mouse pointer easier to see.
I know this is way off my usual content but the other day someone was mentioning how easy it is ... Continue reading
2022-09-15
24 reads
Blogs
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...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
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