SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: December 2009

Top 10 Lists for SQL Server

I have always liked information presented to me in lists. Lists are simple, straight-forward, and to the point. If you are like me, then you may want to check out two sources of top 10 lists on SQL Server.

The first one is from PASS, while offers top 10… Read more

0 comments, 588 reads

Posted in SQL Aloha on 23 December 2009

That was weird

Windows 7 just dropped off the network, acting like a cable had been unplugged. I rebooted the machine after trying a few things before finally rebooting the router and then using the Windows troubleshooter to reset my IP configuration.

Very strange and disturbing, especially as I was in the middle… Read more

0 comments, 593 reads

Posted in The Voice of the DBA on 23 December 2009

A Lack of Excitement

I usually use all the problems, crashes, and issues that I run into at work as grist for my mill, aka, material to blog about. But lately, we haven’t been crashing & burning much <knock wood, turn three times, throw salt over my left shoulder, spit>. But it was suggested…

Read more

0 comments, 599 reads

Posted in The Scary DBA on 23 December 2009

Speaking at SQLSaturday #32 – Tampa

I just found out that I’ve been accepted to speak at SQLSaturday #32 – Tampa on January 23, 2010.  My session will be:

Why Should I Use Stored Procedures?

With the proliferation of ORM Tools like Linq To SQL, NHibernate, there has been a move to no longer use stored…

Read more

0 comments, 352 reads

Posted in Wise Man or Wise Guy on 23 December 2009

Teaching and Learning

You learn a lot when teaching someone else, whether that be writing articles or books or actually teaching a class. But, at least for me, I find I am spending so much time on these activities, that I am not growing myself enough in other areas. I realize that I… Read more

2 comments, 523 reads

Posted in Advice from Aunt Kathi on 23 December 2009

Holiday gift for your favorite SQL Server Professional

If you have been putting off ordering your copy of "SQL Server MVP Deep Dives", now is your chance to order the book at 50% off or $15 off. I am forwarding a message from the publisher:

This month, there are two more chances for readers to buy SQL Server Read more

2 comments, 438 reads

Posted in Advice from Aunt Kathi on 23 December 2009

The Problem with Striped Backups

I noticed a post recently from Bru Medishetty on Striped Backups. I commented, but thought I should explain a little more. There is a problem with striped backups in SQL Server.

They work great, they increase the speed at which you can perform a backup (possibly) and they can… Read more

2 comments, 3,324 reads

Posted in The Voice of the DBA on 23 December 2009

Keyboard Shortcuts

I’m perusing things I’ve in the ‘blog about someday’ category of my list and found this one – a very nice PDF from Quest Software that has a ton of shortcuts for Management Studio. Free is good, and sometimes just finding the one shortcut can make the download and reading… Read more

1 comments, 559 reads

Posted in SQLAndy on 22 December 2009

Deploying Reports on Windows Seven

Recently I tried to deploy a report to a Report Server on my laptop, which is running Windows 7 Ultimate. Unfortunately I received the following error:

The permissions granted to user ‘MachineName\SomeUser ‘ are insufficient for performing this operations.

This confused me a bit since my account was an administrator.… Read more

1 comments, 477 reads

Posted in SQLDownSouth on 22 December 2009


I’ve been somewhat light in my blogging of late. Unfortunately, I just haven’t hit any interesting or difficult problems lately that were worth sharing. I’ll try to break one of our production systems in an interesting way very soon so that I’ve got something to write about, even if it’s…

Read more

0 comments, 491 reads

Posted in The Scary DBA on 22 December 2009

SSIS - Single Package Deployment from BIDs

I have read several articles about deploying SSIS packages.  Most focus on using the deployment wizard or simply copying the files and their dependent properties onto the server.  For companies with a small number of SSIS packages the later appears to be the method of choice.  Recently, I was asked… Read more

7 comments, 1,941 reads

Posted in SQLDownSouth on 22 December 2009

Getting Your Blog Started

I realized that I haven’t written enough recently on this blog myself, being occupied with other projects for work. Recently I noticed that a friend, Andy Leonard, had written a few posts on blogging and I wanted to point them out. First he had Blog (Durnit!) , which got some… Read more

1 comments, 655 reads

Posted in The Voice of the DBA on 22 December 2009

Sql Server- Difference between Stored Procedure and Function

In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to complete a task, but still there are many differences between Stored procedure and Functions.

These differences can be summarized as follows:-

1) A stored procedure can return a value or…

Read more

1 comments, 1,672 reads

Posted in Vivek's SQL Notes on 22 December 2009

The Exceptional DBA’s Code of Conduct

This is a reprint of chapter 11 of my book, How to Become an Exceptional DBA, 2nd Edition, which is available as a free e-book here.

Physicians, attorneys, accountants, engineers, realtors, and many other professionals have written guidelines designed to discourage misconduct and illegal activity, and to promote the… Read more

0 comments, 677 reads

Posted in SQL Aloha on 21 December 2009

Give Your Employees Business Cards

I was reminded of this again recently during a class when the students exchanged cards and one student didn’t have them – the company didn’t provide them. Now yes, I think professionals should have cards and if your employer doesn’t provide them (and maybe even if they do), it’s a… Read more

3 comments, 580 reads

Posted in SQLAndy on 21 December 2009

A Busy/Accidental DBA’s Guide to Managing VLFs


Properly managing VLFs can make or break the performance of your databases. There is a ton of information out there on the proper management of VLFs, but nothing I have found that tries to boil it down to the most important parts. So here it is, my attempt at… Read more

1 comments, 784 reads

Posted in Adventures in SQL on 21 December 2009

Two Tools For Discovering Hardware Information About Your Servers

One thing that I think is very important for a successful DBA to be aware of is their hardware environment.  Database servers typically place more demands on their hardware resources than the more common web or application server, and if a database server is under pressure, it can cause lots… Read more

0 comments, 1,231 reads

Posted in Glenn Berry's SQL Server Performance on 21 December 2009

Great Resource On SQL Server Wait Types

Microsoft's Bob Ward has updated his blog post about documenting SQL Server wait types, that came out of his work at PASS 2009. He is planning on updating his post further as he gets comments and questions on his blog.

You can query your SQL Server 2005/2008 instance to get…

Read more

0 comments, 855 reads

Posted in Glenn Berry's SQL Server Performance on 21 December 2009

Webcast: SQL Server 2008 R2 Support for Up to 256 Logical Processors

If you are a low-level, bare-metal type of SQL Server geek, you will probably enjoy watching this 60 minute webcast by Microsoft’s Madhan Arumugam and Fabricio Voznika. It has a lot of interesting and useful information on how Microsoft was able to scale up beyond 64 logical processors to 256… Read more

0 comments, 612 reads

Posted in Glenn Berry's SQL Server Performance on 21 December 2009

Cumulative Update 7 For SQL Server 2005 SP3

Microsoft has announced the release of CU7 for SQL Server 2005 SP3, which is Build 4273. The link to request the CU from Microsoft is not live yet, but should be pretty soon, hopefully.  I count 23 fixes included in this release.

Read more

2 comments, 452 reads

Posted in Glenn Berry's SQL Server Performance on 21 December 2009

Newer posts

Older posts