Database Schema Samples

Barry Williams' library of 'Kick-Start' Data Models is a great resource to check when starting work on designing a database schema (Thanks ScottGu)


Comments

Post a Comment

Popular posts from this blog

20 SQL Server 2005 Keyboard Shortcuts

What is the bored mother of a geek called? Motherboard There are a bunch of SQL Server 2005 Keyboard Shortcuts on MSDN , but I find these 20 super convenient & use it very often. Description Shortcut Create a New File CTRL+N Toggle full screen mode SHIFT+ALT+ENTER Set or remove a bookmark at the current line CTRL+K, CTRL+K Next bookmark CTRL+K, CTRL+N Previous bookmark CTRL+K, CTRL+P Clear bookmarks CTRL+K, CTRL+L Make the selected text a comment CTRL+K, CTRL+C Uncomment the selected text CTRL+K, CTRL + U Make the selected text upper case CTRL+SHIFT+U Make the selected text lower case CTRL+SHIFT+L Toggle between query and results pane F6 Display Object Explorer F8 Output results in text format CTRL+D Output results in a grid CTRL+T Cancel the executing query ALT+BREAK Display the estimated execution plan CTRL+L Display the Replace dialog box CTRL+F Display the Find dialog box CTRL+H Start incremental search CTRL+I Find the next occurrence of the previous search text F3 Related link...
Read more

HOW TO Read Linux ext4 Files on Windows with 7-Zip (No Drivers Needed)

Image
File systems are the organizational systems that decide how data is stored, named, located, and protected on a disk, SSD, USB drive, or partition. They handle directories, file metadata (permissions, timestamps, ownership), free space tracking, and more. Windows side Windows primarily uses: NTFS — the modern default. It supports journaling (for crash recovery), large files and volumes, fine-grained permissions, encryption, and compression. FAT32 and exFAT — simpler, widely used on removable media (USB sticks, SD cards) because they are highly cross-compatible with other operating systems. Windows has no native support for the main Linux file systems. When you connect a drive formatted with ext2/3/4, Windows typically sees it as “RAW” or unknown and may offer to format it (which would destroy the data). Linux side Most Linux distributions default to the ext family: ext2 — the older, non-journaling version. ext3 — added journaling for better reliability. ext4 — the current standard. It a...
Read more

This Week I Learned - Week 37 2026

Image
This Week I Learned -  * Anthropic's Claude AI now generates 80% of their code. AI-driven coding has moved bottlenecks downstream , exploding tests by 10x and CI jobs by 25x in six months. * Only Apple Intelligence-capable newer models starting with the iPhone 15 Pro will get Siri AI and other AI-powered features.  * As of early 2026, 820 LLMs had been registered with China’s cyberspace authority. Free models drive AI adoption which drives demand for complementary products that China dominates — energy, cloud and physical infrastructure. Alibaba’s cloud revenue grew 34% year-on-year while it gave Qwen away. "China’s open models cut India’s AI costs, but create future dependencies. India should leverage the open ecosystem while pricing in the switching costs. Government departments and regulated sectors should be built on model-agnostic architectures such as abstraction layers and harnesses that work across stacks. Instead of offering compute subsidies on GPU slices, the Minist...
Read more