SSMS Database Diagrams Locked in Binary Blobs, Incompatible with Git or File Sharing

·1 views

SQL Server Management Studio (SSMS) stores every database diagram as a binary blob inside the sysdiagrams system table of the database it documents, making it impossible to save as a standalone file or track in version control. Because the diagram lives inside the database itself, users cannot share it with teammates, review it in pull requests, or access it without an active server connection. The only official workarounds Microsoft has offered are copying the diagram to the clipboard as an image or printing it to PDF, neither of which produces a reusable or version-controllable artifact. The feature has a troubled history, having been removed entirely in SSMS 18.0 in 2019, restored in 18.1 following user backlash, and still subject to version-compatibility errors with newer SQL Server releases. Third-party desktop ERD tools that reverse-engineer the schema into portable file formats, such as JSON, SVG, or Mermaid, are presented as a more practical alternative for teams needing shareable, diffable database documentation.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

How a Hash Map Trick Cuts Two-Sum Interview Problem from O(n²) to O(n)

A software developer reflects on struggling with the classic Two-Sum coding problem during a technical interview, where an initial brute-force nested-loop approach proved too slow. The key insight was shifting the question from comparing every pair to instantly checking whether a number's complement had already been seen. By storing previously visited numbers in a hash map, each look-up runs in O(1) time, reducing the overall solution to a single linear pass. This space-for-time trade-off also applies broadly to problems involving duplicates, anagrams, and bracket validation. The developer highlights two common implementation pitfalls: storing only values instead of indices, and inserting the current element before checking for its complement.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Recreates Hyderabadi Biryani Dum Ritual as Pure CSS Interactive Art

A developer has submitted an interactive CSS artwork to the Frontend Challenge - Comfort Food Edition, depicting the iconic dum biryani unsealing experience. The piece features Hyderabad's skyline behind a copper handi, with biryani layers hidden until the viewer clicks 'Break the Seal' to trigger an animated reveal. Built using only HTML and CSS — with no JavaScript, images, SVGs, or frameworks — all visual elements including rice grains, mint, and the cityscape are rendered entirely as CSS shapes. A native HTML checkbox control manages the open and closed states, while CSS :has() coordinates the full animation sequence from seal crack to steam settling. The creator used an AI coding assistant for implementation support, but directed all concept, cultural framing, and design decisions personally.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Solo dev grows pet AI app to 15,953 impressions in 28 days using organic SEO

A solo developer building PetSignal, a $2.99 browser-based AI tool that analyzes dog and cat body language from photos, documented 28 days of Google Search Console data showing 230 clicks and 15,953 impressions, with impressions doubling in the second half of the period. Because paid advertising is economically unviable at a roughly $3 average order value, the project relies entirely on organic search traffic to grow. The developer built a content engine of around 35 symptom-focused pages using a single React template and TypeScript data file, allowing site-wide updates and structured data improvements to be deployed in one change. Key lessons included the outsized impact of a single content page driving 54% of all clicks, the importance of internal linking between informational and commercial pages, and the risk of editing titles on already-ranking pages. Rewriting titles on low-performing pages in a clear answer-promise format caused one page to jump from 21 to 533 impressions within two weeks.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

How Rust's Type System and a Single Vec<f64> Shrunk an ML Docker Image 400x

A developer building 'datarust', a Rust-based machine learning library, has detailed how a single flat memory structure called Matrix underpins the entire library's efficiency. The library splits data into two strictly typed structures at the source — Matrix for numeric data and StrMatrix for strings — preventing type mismatches at compile time rather than at runtime. This design means errors like mismatched column shapes are caught during construction, not silently passed downstream to corrupt model training. The approach contrasts with Python tools like pandas and scikit-learn, where type mismatches and ragged arrays can go undetected until deep in the processing pipeline. The result is a binary of just 2.3 MB and a Docker image reduced from roughly 900 MB to 8 MB, a roughly 400-fold reduction.

0 comments Read more at DEV Community