Browse by Tags

All Tags » SQL Server (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: ,
04 September 2008 01:21

Performance Tuning Tips From the Consultant Perspective

I do very little consulting these days, perhaps 4-5 weeks per year, and that only to make sure I maintain 'real world' skills that I need to stay credible in the classroom. Much of that consulting is basic performance reviews of existing code...
Posted by Andy Warren | with no comments
Filed under: ,
29 August 2008 01:28

Insufficient Space for a Side by Side Restore - What Do You Do?

I was recently working with a student in a one on one format and one the scenarios he wanted to learn to handle in SQL Server (he was an Oracle DBA cross training) was how to recover from the proverbial accidentally dropped table when there wasn't...
Posted by Andy Warren | with no comments
Filed under:
25 August 2008 01:13

Assessing DB Changes

One of the things I teach in our admin course is that it's not enough to just be the gatekeeper/central point of change when it comes to being a DBA, we should be adding value: Look at each change and ask ourselves 'is this obviously stupid?'...
Posted by Andy Warren | with no comments
Filed under: ,
21 August 2008 01:02

Troubleshooting High Connections & What's The Application Name?

I was visiting with a client recently when they asked me to come take a look at an incident in progress, the number of connections to the server had just about doubled over what they were normally. As far as troubleshooting this scenario I always start...
Posted by Andy Warren | with no comments
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: , ,
29 July 2008 01:23

IP6 Addresses Could Break Your DB

I saw this post from Rick Strahl about IP6 Addresses in Vista breaking some code, and it immediately made sense that we're probably going to feel some pain on the db site. While all it may take is altering a column on our side (which increases space...
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: ,
21 July 2008 01:29

Why Are Stored Procedures Too Hard?

Recently I was going through the buy or build process on a small segment of functionality needed for a project, and ran across something that looked like it would work, price point was realistic, and when I looked at the source they made available was...
Posted by Andy Warren | with no comments
Filed under:
17 July 2008 01:54

Comments on Dissecting SQL Server Execution Plans by Grant Fitchey

Long time SSC participant Grant Fitchey has published a great book on reading/understanding execution plans. I finally had the chance to read it last week (on vacation) and was pleased with it, he did a great job covering the concepts and I noted that...
Posted by Andy Warren | with no comments
Filed under: ,
14 July 2008 01:30

What is an MVP?

My friend Steve Jones posted an article called What's an MVP on SSC that in turn led to a moderately interesting discussion about the MVP program . If you're interested in how the program works or what it takes to get in, it's worth reading...
Posted by Andy Warren | with no comments
Filed under:
08 July 2008 01:59

Listening on a Non Standard Port

I had a note to myself to write up some notes about listening on a non standard port, but it turns out my friend Greg Larsen has already done a nice job of it in an article he wrote last year called Using Non-Standard Port for SQL Server . The reason...
Posted by Andy Warren | 1 comment(s)
Filed under:
30 June 2008 01:17

Why Format TSQL?

Recently I had the chance to help a student debug a problem on a production server. It appeared to be failing because duplicate uniqueidentifiers were being created. Thinking that unlikely because the G in GUID stands for global, we dug in but found the...
Posted by Andy Warren | with no comments
Filed under: ,
More Posts Next page »