DBCC USEROPTIONS: See Your Session Settings in SQL Server
Category:
database-administration
This is a super old command, but it still comes in handy when working with SQL Server.
kendra little
DBA Confession: Sometimes Everyone's the Slow Kid
Category:
database-administration
I’ve been working with SQL Server databases, Windows administration, and software development an awfully long time. Once you have a lot of experience with something, it’s easy to forget what’s not obvious to newbies. But some things you have to learn the hard way.
Conference Prep List: Pick Your Workout
Category:
database-administration
I got an email recently from a first time attendee to the SQL PASS conference that made me squeal with glee. The email asked the question: do you know a good place to go do Crossfit in Seattle?
I somehow hadn’t realized that I could plan workouts for the conference, and I was so glad I got that tip!
Forms of Database Torture (Illustrated)
Category:
database-administration
Many forms of disasters can happen to a database. Here are three I’ve seen lately.
Are You Following Your Dream?
Category:
database-administration
I got my first “real” job working with databases in New York City in the early 2000’s. The woman who hired me was incredibly smart, and a pleasure to work for. She understood how mainframes processed data, the need and challenge to create web interfaces and relational databases that would work well with mainframes, and she could solve problems like crazy.
Complaining Doesn't Help, Even When Your Office Smells Like Pee
Category:
database-administration
I’ve had a problem for a little while: my office smells like pee, and it gives me a headache sometimes.
Correction: my office smelled like pee. Past tense. The problem has been resolved.
Free Webcast on SQL Server Isolation Levels: (NOLOCK) or YESFUN?
Category:
database-administration
Tomorrow evening I will be presenting for the SQL PASS Application Development chapter. Stop by and say hello!