T-SQL Tuesday #177–Keeping track of database code

This month’s invitation is from Mala Mahadevan, who has hosted 5 times. This latest one is one that is near and dear to my heart as I use source...

Data (and Humans) At Rest

We talk a lot about data in the data world – imagine that! Sometimes, we talk about data at rest, but when do we all rest? Do we even...

Regular Expressions to Generate Disable/Drop Index Scripts

Earlier this year, I embarked on a bit of a project to tidy up the indexes in a sizeable database. This database has over 900 tables, and there are...

T-SQL Tuesday 177 - Managing Database Code

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Mala Mahadevan
(blog) asks how we manage our database-related code.

Where do you keep...

Your SQL Server is Slow, What To Look At

As a data professional, you’ll often get a phone call, email, or trouble ticket that says “SQL Server is slow, my query is slow, or things are slow”. This...

A New Word: Hiddled

hiddled – adj.  feeling of loneliness of having to keep a secret to yourself. I don’t know I am often hiddled. I don’t tend to keep secrets by myself....

PASS Data Community Summit: A Personal Journey

As someone attending the event since 2011, I would like to share my personal experience, the value of attending, and how the event has helped me throughout my career....

Tech in 2030

What will the technology world look like in 2030? Cloud computing will naturally be the backbone of the world but I think with variants in “decentralising” concepts. By this...

The Fediverse Files: ActivityPub Interview with Evan Prodromou

Doc Pop and Evan Prodromou discuss the past, present, and future of ActivityPub and the fediverse.

WHAT IS A SPV?

Why am I focussing on RWA (real world assets) as the next big thing? The WEF predicted that by 2027, 10% of the world’s GDP could be stored on...