Apr 10 2013
There are No Background Checks SQL Server Management Studio is a lovely product. It’s powerful. It’s feature-rich. It’s not yet been wrapped in a Metro interface. It’s free and easily-accessible. Your kids can download it (probably easier than most adults can.) Your kids can share it with other kids. Heck, the middle-manager in the finance [...]
Jan 8 2013
It’s great that I can start the year off with proactively writing a post for #TSQLTuesday. Normally I find myself on the other side of the multitude of arbitrary deadlines I set for myself – getting things accomplished fast enough for others usually means I fail to meet my expectations. If it’s one point that [...]
Jan 2 2013
January 1, 2013. This date – any January 1 for that matter – is as arbitrary as just about any other day when it comes to making a decision to start anew, set a resolution or set a challenge. Yet this is what many do on the first day of a new year. My Life [...]
Sep 7 2012
For some reason I awoke this morning with the thoughts of Dirty Reads Bulk Inserts Heavy Workloads Big Data on my mind. I’m starting to wonder if SQL is NSFW. Perhaps it’s just the pants-free telecommuting catching up with me or maybe it’s just simply because it’s Friday. In honor of that, and [...]
Jul 17 2012
Woke Early Fueled Up Let’s Go Backstory This month’s T/SQL Tuesday challenge was from Erin Stellato (blog|twitter) of SQLskills. She asked us to document a given day last week and then craft your post around what happened in order to provide an idea as to what a typical Day in the Life for a SQL [...]
Mar 14 2012
Just add another one on there somewhere Bubba… wherever you can find room. Default Behavior By default, new databases are created with the following basic file settings: Data File: 2 MB 1 MB unrestricted growth Log File 1Mb 10% unrestricted growth Just exactly why is this bad? It will assuredly increase the frequency at which files [...]
Feb 28 2012
What Brings a Good Looking DBA Like You to a Place Like This? You’ve most likely found this post because of one of the following reasons: You’ve got this shiny new server and are thinking about installing SQL Server on it. You’ve been following this series from the beginning (thank you by the way) and [...]
Feb 22 2012
The db_owner Database Role Has a Secret The right solution is not frequently the easiest to implement. Avoiding hyperbole as much as possible I’ll simply say that database security is a very fine example of that adage. It is by far easier to … grant all users in a database membership in the db_owner database [...]
