I work as a SQL Server Administrator near Dallas Texas. I started working with databases over 20 years ago now. Back in the day, when the world was young, I started out working with Foxpro for DOS. It’s been awhile though, so I’m afraid I can barely spell “Foxpro” anymore. I’ve been working in SQL Server for over 15 years now with a fairly even split between administration and development.
This blog is to share some of the interesting bits and pieces I’ve either learned over the years or that I’m just now learning. If anyone has any suggestions for me to write about or questions about what I’ve already written I would love to hear them. I can almost always be found hanging out on twitter so stop by and say hi!
Honored to be considered a Microsoft Data Platform MVP.
My Recent Posts
What’s the difference between Files and Filegroups?
tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct used to store information (log & data) about the database. When creating a database you’ll notice that each database is built of several components. There are two files, one for ...
