100 Things I Hate About Views: Undeclared Data Types in Columns
Views let you do dumb things by accident in SQL Server. Then they make you have to think way too hard to fix them.
Read Moreon • 2 min read
Want a new kind of sample data? Maybe you want to use it to learn, or to do a project with it. Either way, you can blog about to build up your experience, resume, and share it with the community.

Or maybe you’d like to write demos with the sample data for presentations. If you do that, you need a really open license so that you can redistribute the data for people to run the demos themselves later.
One great source is Data.gov. The US Government runs this site and they want to provide “open” data– data with few to no restrictions for use.
Each dataset they host or link to has information about the license (or notes if it’s unclear), so they make it pretty easy to figure out what you can and can’t do. Many of the datasets use the CC Zero license!
The data is interesting stuff, too. Topics include:
Just want data with geospatial info? There’s a filter for that. Just want data in certain file types? You can set a filter for that, too. Happy querying!
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.