Got SQL Server Questions?
December 18, 2009
A Great Idea – #SQLHelp hashtag on Twitter I was following a conversation today between Brent Ozar, who is @BrentO on twitter and Aaron Nelson, who is @SQLVariant on twitter. A great idea was discussed: A twitter hashtag that, as Jorge Segarra (or @SQLChicken on twitter) describes it in his blog post, can act like
One Man’s Trash…
December 7, 2009
Do you live in a town with a dump? I do (well, transfer station). On any given weekend you can find people looking for treasure in the scrap metal or electronics bins. I never thought I’d say it, but over the past couple weeks of visiting the dump, I have found an amazing treasure that
How do -you- (I) use SQL Server?
December 4, 2009
I was recently tagged in an interesting blog post by A Misplaced New Englander, David Taylor. (dyfhid on twitter). The question sounds simple enough, “How do you use SQL Server where you work?” Of course the answer is not simple. I echo Grant Fritchey’s response in his blog post that it would be easier to
How do -you- install SQL Server? (Part 3)
November 30, 2009
Welcome to part 3 in this series on a thought process around SQL Server Installation. In Part 1, we started talking about some basic steps and a thought process for a repeatable success story with your SQL Server installations. Part 2 discussed security, playing around before doing a first install and smoke testing afterwards. Today
How do -you- install SQL Server? (Part 2)
November 23, 2009
Welcome to this series on a thought process around SQL Server Installation. In Part 1, we started talking about some basic steps and a thought process for a repeatable success story with your SQL Server installations. Today let’s continue that story and talk some more about installation planning and success. We’ll finish up talking about
How do -you- install SQL Server (Part 1)
November 17, 2009
No, this is not an installation guide There is documentation for that found in many places. First good place to look is Books Online (2005/2008) but there are plenty of other community resources found at sites like SQL Server Central and SQLServerPedia as well as blogs. What I mean by this post is to ask,
Work Now or Work (And Pay) Later
November 16, 2009
Work costs something whenever you do it… This weekend we had some nice weather on Sunday. In between church activities and family time, I took advantage of the weather to get some work done on our vegetable garden. We chose to try a “no dig” raised bed vegetable garden. Basically you pile various materials (grass
How to use sp_configure in SQL Server
October 20, 2009
2018 Update – Straight Up SQL Server Tips posts – this is an edit as part of our SQL Server tips when we referenced SP_Configure there –> Not much has changed with sp_configure in SQL Server. The below post is still quite current as far as how to use sp_configure or sys.configurations to check and change
Free SQL Training Online – Wednesday 10/21/09
October 17, 2009
Where? Quest Connect is an online series of webcasts on various topics. Some are pre-recorded (like the session that I did.. more on that later…). They have web casts on a variety of topics, not just SQL. You can look at the on demand topic listing here to see all the chats that will be
SQL Server Implicit Conversion: You Could Be Suffering Right Now!
September 1, 2009
SQL Server Implicit Conversion – A Silent Perf Killer I recently had the opportunity to work with a developer at the day job. He was using a loop (for what he was doing, it makes sense 🙂 ), and he had a query that ran great when he stripped the question out of the process,