Browse by Tags

All Tags » SSC Article (RSS)
05 September 2008 01:16

Renaming Databases Posted on SQLServerCentral.com

Renaming Databases was just published on SSC, another in my lastest effort to expose some of the hidden complexities in seemingly routine operations. Definitely read the discussion thread attached to the article as there were several very good additional...
Posted by Andy Warren | 1 comment(s)
Filed under: ,
19 August 2008 01:38

Building a Security Philosophy Posted on SQLServerCentral.com

This was actually posted about a week ago, fell behind a little during travelling. Building a Security Philosophy was written to get people to think about they approach security. Do you give the proverbial Junior DBA only partial access? Do you believe...
Posted by Andy Warren | with no comments
Filed under: , ,
04 August 2008 07:06

Moving TempDB Posted on SQLServerCentral.com

Moving Tempdb isn't a common operation, and mercifully a simple one if it comes to that. As in much of the stuff I write about I wanted to put down a nice detailed answer to a pretty simple question. Think you know how it works? What happens to the...
Posted by Andy Warren | with no comments
Filed under: ,
30 July 2008 01:31

Rebuilding Stats: Twice or Not at All Posted on SSC

Rebuilding Stats was published yesterday on SSC, some nice comments posted to it as well. The main point of the article was that if you're rebuilding indexes with the default options you're automatically getting stats update on those columns as...
Posted by Andy Warren | with no comments
Filed under: , ,
22 July 2008 07:44

Disabling Indexes Published on SQLServerCentral.com

It's been a while since I had anything up on SSC, a combination of Steve being in good shape on content and me being busier than usual, but early July I had a break and got 4 articles done. Disabling indexes isn't a complicated option of course...
Posted by Andy Warren | with no comments
Filed under: ,
18 April 2008 01:44

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 by Andy Warren | with no comments
Filed under: ,
26 February 2008 08:29

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...
Posted by Andy Warren | with no comments
Filed under: ,
18 February 2008 10:18

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...
Posted by Andy Warren | with no comments
Filed under: ,
12 February 2008 07:57

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...
Posted by Andy Warren | with no comments
Filed under: , ,
29 January 2008 08:11

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 by Andy Warren | with no comments
Filed under: ,
17 January 2008 07:49

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...
Posted by Andy Warren | 2 comment(s)
Filed under: ,
08 January 2008 09:56

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...
Posted by Andy Warren | with no comments
Filed under: ,
30 November 2007 10:21

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...
Posted by Andy Warren | with no comments
Filed under: ,
21 November 2007 13:54

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 by Andy Warren | with no comments
Filed under: ,
13 November 2007 12:40

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 by Andy Warren | with no comments
Filed under: ,
More Posts Next page »