Browse by Tags

Professional Development Links

Someone asked me for these recently as they predate the blog. All were posted on SSC over the past couple years. Professional Development Beginning Professional Development Time for Training

Posted to It Depends (Weblog) by Andy Warren on 04-17-2008
Snapshots Part 1 Published on SSC

Snapshots Part 1 covers the basics of doing a snapshot regardless of what type of replication is being used. In Part 2 coming up in the next couple weeks I dig a little more into the underlying process - not critical to know but helps dispel the black box syndrome.

Posted to It Depends (Weblog) by Andy Warren on 02-26-2008
Management Article Posted on SSC

I wrote Management because we typically get it so wrong in our line of work. Nothing better than working for a great manager except working for one that is also a great leader, and perhaps nothing worse than working for a terrible manager. The tragedy of our profession is that too often we take the superstars...

Posted to It Depends (Weblog) by Andy Warren on 02-18-2008
Computed Columns Published on SSC

I wrote this article on computed columns to support some of the teaching I do for my beginner to intermediate level performance tuning class . It's not a technique you'll apply that often, but I think it's used less often than perhaps it should be. Hope you'll take a look and add a comment...

Posted to It Depends (Weblog) by Andy Warren on 02-12-2008
IT Transparency Posted on SSC

As I mentioned yesterday the article I wrote on IT Transparency is finally live today and now the wait to see what the response is! I hope you'll drop me a comment after you read it, either here on the blog or in the SSC forum attached to the article.

Posted to It Depends (Weblog) by Andy Warren on 01-29-2008
Partitioning Part 4 Posted on SSC

Partitioning Part 4 concludes the series with a look at 'real' partitioning in SQL 2005 Enterprise Edition. Overall the series worked out reasonably well, accomplished my goal of introducing the technology and options without getting into dense technical detail. There is definitely more to explore...

Posted to It Depends (Weblog) by Andy Warren on 01-17-2008
Partitioning Part 3 Posted on SSC

Part looks at using views for partitioning, still a valid technique even in the SQL 2005 world. I added in some basic performance tuning information as well, looking at the query plan when partitioning is done correctly vs incorrectly. The final installment has been submitted and will cover the SQL 2005...

Posted to It Depends (Weblog) by Andy Warren on 01-08-2008
The DBA Routine Posted on SSC

This was fun to write, though it's hard to boil everything down to 10 big steps. I thnk as an industry we tend to forget that there are a LOT of us wearing multiple hats, working solo, just trying to get things done - and while we want to do things the right way, there isn't always clear guidance...

Posted to It Depends (Weblog) by Andy Warren on 11-30-2007
SQLSaturday Article Posted on SSC

I wrote up some more notes (in addition to what's available here on the blog) to try to raise the awareness level of what might be possible for a SQL Server event. Article is at http://www.sqlservercentral.com/articles/User+Groups/61534/ .

Posted to It Depends (Weblog) by Andy Warren on 11-21-2007
Trigger Trivia Posted on SSC

A short article but interesting I think, with some good comments already. I think in general triggers are under used, except in the cases where they are abused of course. Here's the article: http://www.sqlservercentral.com/articles/T-SQL/61483/

Posted to It Depends (Weblog) by Andy Warren on 11-13-2007

Page 1 of 3 (23 items) 1 2 3 Next >