A woman stands in a library

T-SQL Tuesday Retrospective #014: Resolutions

At the end of 2010, Sean McCown (blog | Twitter) invited us to talk about resolutions: Things like getting certified, or perfecting a process, or taking management classes, etc are all things that are commonly found in your yearly goals at work. So if you’re going to make some kind of resolution to do something,
-> Continue reading T-SQL Tuesday Retrospective #014: Resolutions

listen more

T-SQL Tuesday Retrospective #013: What the business wants

Click here to read previous retrospective entries. From Steve Jones (blog | Twitter) in December 2010 comes the question “What issues have you had in interacting with the business to get your job done?” However a little digging showed that the business didn’t really understand the technology. They were asking for a result, and [the DBA] took them
-> Continue reading T-SQL Tuesday Retrospective #013: What the business wants

T-SQL Tuesday Retrospective #012: Why DBA skills are necessary

This is my ongoing series of answering T-SQL Tuesday posts far too late to be of any use. Click here if you want to read previous entries. Paul Randal asked us in November 2010 why DBA skills are necessary. As a reminder, DBA stands for Database Administrator, and this unleashes a discussion outside of the
-> Continue reading T-SQL Tuesday Retrospective #012: Why DBA skills are necessary

Blue table vise

T-SQL Tuesday Retrospective #011: Misconceptions

(If you would like to read the previous T-SQL Tuesday Retrospective entries, visit this link.) In October 2010, Sankar Reddy asked us which misconceptions we’ve been labouring under when it comes to SQL Server: The possibilities for writing up a post on this topic invloving SQL Server are enormous even if you are a novice
-> Continue reading T-SQL Tuesday Retrospective #011: Misconceptions

A ratty-looking red diskette

T-SQL Tuesday Retrospective #010: Indexes

(You can see previous T-SQL Tuesday retrospectives by visiting this link.) In September 2010, Michael J. Swart (blog | Twitter) invited us to talk about indexes. Indexes are strange things. You never need to explicitly create one to create a fully-functional database, but if you want a database to perform well, they’re indispensable. Many words
-> Continue reading T-SQL Tuesday Retrospective #010: Indexes

network cables coming out the back of a switch

T-SQL Tuesday Retrospective #009: Beach Time

(If you’d like to read my other T-SQL Tuesday Retrospective posts, click here.) In August 2010, Jason Brimhall (blog | Twitter) invited us to discuss preparing for vacations: “Write about what you have done to be able to get a break from the job. Beach time is usually vacation time, but is really anything that
-> Continue reading T-SQL Tuesday Retrospective #009: Beach Time

Female developer at whiteboard with colleagues

T-SQL Tuesday Retrospective #008: Gettin’ Schooled

To view posts about previous T-SQL Tuesday entries, please use this tag. The late, great, Robert Davis invited us on Independence Day 2010 to write about Gettin’ Schooled: We return to our days of youth to take a fresh look at learning. How do you learn? How do you teach? What are you learning or
-> Continue reading T-SQL Tuesday Retrospective #008: Gettin’ Schooled

SQL Server 2008 R2 logo

T-SQL Tuesday Retrospective #007: Summertime in the SQL

This is the seventh post in my retrospective attempt to answer every T-SQL Tuesday invitation. In the beginning of June 2010, Jorge Segarra invited us to write about our favourite hot new feature in SQL Server 2008 or 2008 R2. For me, this would be the introduction of the DATE, TIME, and DATETIME2 data types
-> Continue reading T-SQL Tuesday Retrospective #007: Summertime in the SQL

Glass Door Knob Circa 1931

T-SQL Tuesday Retrospective #006: What about blob?

I am revisiting old T-SQL Tuesday invitations from the very beginning of the project. On May 3, 2010, Michael Coles invited us to write about how we use LOB data, so now you know what this week’s post is about. Let’s go over some definitions and complain a little, because that’s how cranky data professionals
-> Continue reading T-SQL Tuesday Retrospective #006: What about blob?

chart

T-SQL Tuesday Retrospective #005: Reporting

A few weeks ago, I began answering every single T-SQL Tuesday from the beginning. This week it’s the fifth entry, and on April 5th, 2010, Aaron Nelson invited us to write about reporting. You can visit the previous entries here: T-SQL Tuesday #001 – Date/Time Tricks T-SQL Tuesday #002 – A Puzzling Situation T-SQL Tuesday
-> Continue reading T-SQL Tuesday Retrospective #005: Reporting