med-mastodon.com is one of the many independent Mastodon servers you can use to participate in the fediverse.
Medical community on Mastodon

Administered by:

Server stats:

408
active users

#databases

5 posts5 participants0 posts today

What's new with Postgres at Microsoft? The 2025 edition of our annual blog post is now live.

Over the past year, the team at Microsoft who work on Postgres has contributed across multiple fronts:

🛠️ New features in Azure Database for PostgreSQL - Flexible Server
🧠 Code contributions to Postgres 18 (including async I/O!)
📦 Open source work on the Citus extension
🌍 Contributions to the Postgres open source community—things like @posetteconf, helping make @pgconfdev happen, the Talking Postgres #podcast, and sponsoring #PostgreSQL conferences around the globe

This year's blog post includes a hand-made infographic that maps out the major workstreams—plus highlights, explanations, links, and shout-outs to some of the many people behind the work.

If you care about PostgreSQL—as a user, contributor, or fan—I hope you'll give it a read.

📝 Read the full blog post on Microsoft Tech Community: techcommunity.microsoft.com/bl

Continued thread

Other govt #databases contain secret #whistleblower data. At the Dept of #Veterans Affairs, you’ll find granular #MentalHealth info on fmr service members, including notes from #therapy sessions, details about #medication, & accounts of substance abuse. Govt agencies including the #IRS, #FBI, #DHS, & Dept of #Defense have all purchased #cellphone-#location data, & possibly collected them, via secretive groups such as the National Geospatial-Intelligence Agency.

#Trump#law#privacy
Continued thread

The federal govt is a veritable cosmos of #information, made up of constellations of #databases: The #IRS gathers comprehensive #financial & #employment info from every taxpayer; the Dept of Labor maintains the National Farmworker Jobs Program (NFJP) system, which collects the #personal info of many workers; #DHS amasses #data about the movements of every person who travels by air commercially or crosses the nation’s borders; the #DEA tracks license plates scanned on American roads.

I am amazed at how thoughtless the operators of the critical infrastructure sectors #IT , #TK and especially for #OT still are. #dataprotection #datasecurity protection of #databases and especially production facilities seems irrelevant.

This hardware from an automotive supplier would have been a set table for any attacker, there were valid credentials, ssh keys + valid IP addresses from the krb5.conf. This would have meant an undisturbed outflow of data from the company's own data center. 1/2

A couple of nice database victories today. Two large tables each had one column storing DATETIME data and another column storing UNIQUEIDENTIFIER (aka GUID) data. Both columns were incorrectly using data type VARCHAR.

Changing to the appropriate types dropped table sizes from 10.62GB to 4.91GB and from 8.56GB to 6.44GB.

#SQLServer
#Databases