SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

Hiring Heterogeneously

I wrote recently about tech interviews and hiring, and even on an interesting interviewing technique for senior people. However we need to hire more than just senior people. We need to hire junior people, and intermediate people. Those roles are important for both growing the experience of your staff, and not getting caught with a "" as a bottleneck or single point of failure. Not that's not Brent Ozar, though someone with his talent might be the single point of failure in many organizations. 

Not everyone can be a superstar-expert-architect that decides how the system is built. Not all architects should spend time coding basic insert/update/delete code or adding clustered indexes to tables. We need a variety of talent levels that can get complete different types of tasks. There is tedious administrative work, supporting roles, necessary, though unexciting work like reviewing security, logs, audits, and more. While you can automate much of this busy work, there are still tasks that we must assign to people.

There's another consideration as well in hiring that all too often people overlook. Hiring too many people that are too similar, who may think alike, who may view problems the same way can lead to an environment that doesn't grow and expand, that loses it's creativity over time. There's a great quote that says "Where all men think alike, no one thinks very much" (Walter Lippmann). It's important to have a diversity of opinions, and when you hire new people, you should consider this. You want talented people, and people that get along, but not necessarily all thinking about problems in the same way.

The world is a richer place for the diversity we have, and varying opinions, thoughts and ideas. We don't all get along, but many of us can work together with mutual respect, considering each others' viewpoints as we work to build solutions to the problems we face.

Steve Jones

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

Video and Audio versions

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

Follow Steve Jones on Twitter to find links and database related items and announcements.

Steve Jones

Windows Media Video ( 14.8MB) feed

MP4 iPod Video ( 19.6MB) feed

MP3 Audio ( 3.6MB) feed

Feeds are available at iTunes and Mevio

To submit an article, rant or editorial,
log in to the Contribution Center


Disaster Recovery tip no.5: Have spare hardware. Stuff will break.

SQL Search

How do you search your database schema?

"I use SQL Search regularly and think it's great." Gregor Suttie, Senior Software Engineer, Pulsion Technology. Download Red Gate SQL Search while it's free.


Deployment Manager 2 is now free!

The new version includes tons of new features and we've launched a completely free Starter Edition! Get Deployment Manager here.

SQL Monitor

Get your priorities straight with SQL Monitor

“SQL Monitor gives me the ability to quickly see what my priorities should be, and delivers the information I need to make the right decisions,” Aaron Kolysko, DBA. Start monitoring with a free trial.

Featured Contents


Tables and Clustered Indexes Part 2

Hakim Ali from SQLServerCentral.com

A table does not so much 'have' a clustered index as a table 'is' a clustered index. More »


SQL Monitor Custom Metric: Top Buffer Cache Object

Press Release from Red-Gate

This metric measures the amount of memory used in the buffer cache by the largest object (based on the number of pages). It checks the sys.dm_os_buffer_descriptors to identify the object, and returns the relative percentage used. You should use this metric if you want to monitor what is in the buffer area, or if you are having performance-related disk read problems. More »


SQL Server 2012 Analysis Services XMLA

Additional Articles from MSSQLTips.com

Cube developers often flippantly use the term XMLA in their discussion of maintaining, scripting, backing up, and restoring cubes and other SSAS objects; what exactly is XMLA and how can it be used? Check out this tip to learn more. More »


From the SQLServerCentral Blogs - Scripting a partitioned table or index, a caution.

Kenneth Fisher from SQLServerCentral.com

I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting. First here... More »

Question of the Day

Today's Question (by pramod singla):

If "order by" clause is not used in a query then in which order is the result set returned?

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: T-SQL.

Did you miss yesterday's question, What's in a name?? Answer now.

We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the Contribution Center.


SQL Server 2012 Integration Services Design Patterns

SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution. Get your copy from Amazon today.

Featured Script

View Deadlock Graphs

Wayne Sheffield from SQLServerCentral.com

Run this script on the server that is generating deadlock traces. It assumes that the trace file will have the name "Deadlock" somewhere in it's filename.

You can optionally set the file to be loaded.

When you run this script, it will shred the XML deadlock graph, and display information contained within it in a table format.

More »

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2005 : Administering

Sql agent job or Maintainace plan? - I am the only DBA in my job. I am starting from the scratch. First thing I can think of...

Best Index Rebuild/Reorganize and Update Statistics Strategy - I have a several databases in full recovery model around 200 GB. As soon I run maintenace plan, log fills...

BACKUP WITH NORECOVERY - CAN Any one clarify my doubt please, What exactly BACKUP ......... WITH NORECOVERY will do Difference b/n BACKUP... AND BACKUP...WITH NORECOVERY thanks

SQL Server 2005 : SQL Server 2005 Integration Services

Import Export Wizard error - I'm trying to import data from Oracle table to SQL Server table using Import Export Wizard and getting below error: Please...

SQL Server 7,2000 : T-SQL

Need Split delimiter string into columns Solution - Hi All, I need help with a string with delimiter that needs to be split into column names. I have been...

SQL Server 2008 : SQL Server 2008 - General

Do you allow Entity Framework? / Database Security Permissions - I know this topic has been talked a lot but, i'm having this issue right now, the Developers team at...

SQL 2008 - LInked Server performance woes - We had a linked server from SQL 2008 to SQL 2005 and perfroming inserts/updates/deletes in SQL 2008. Almost always, it...

Help with SQL query - Hello all, I am not sure whether this is the right thread to post this or not. Anyways, I have one...

Need A Help in DATA MASKING in SQL SERVER 2008 - Hello Friends, I want to mask certain fields in employee_bank_account_info table, which are very sentive information. I searched for it , i found...

Force SQL jobs to run serially, not in parallel - In SQL 2008 R2 (sp2) our vendor requires that thier 14 SQL database FULL backups execute in a sequential order....

Tempdb issue - we are facing issue in tempdb file size , initial size we allocate 2 GB , but after restart sql server , size...

SQL Server 2008 : T-SQL (SS2K8)

Substring takes 100%CPU - SELECT CASE WHEN substring(column_name, 1, 2) = '44' THEN column_name ELSE '44' + column_name END 'column_name', min(col2) 'date' FROM DBNAME..TABLENAME(nolock) WHERE col3...

Perfomance issue.. TO otimize Joins - I was joining nearly 5 inner joins and 2 left outer join Final with group by Here i am facing perfomance...

Parsing XML using SQL Server 2008 - [code] DECLARE @X XML = <Movies> <Movie Name = "Titanic"> <Genres> <Genre Name="Romance"/> <Genre Name="Tragedy"/> </Genres> <Rate Value = "10"/

SQL Server 2008 : SQL Server Newbies

Count and Percentage of skill ratings - Hi all-- I have a program which brings in Skill ratings for an assessment people with the title of "Worker” have...

SQL Server 2008 : SQL Server 2008 Administration

Can't reclaim space on log files - I have a separate drive just for my log files that is 40GB in size. The total size of all...

Career : Employers and Employees

Client does not want to pay overtime. How to deal with it ? - I am hourly-paid employee of a consulting company, but work all the time at client site. Sometimes I have to...

SQLServerCentral.com : Anything that is NOT about SQL!

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...

Reporting Services : Reporting Services

Launching a Report from the URL link - Hello All, I'm using SSRS 2008 R2. After rendering a report, I want to be able to copy the URL link...

Data Warehousing : Integration Services

Roll back .AddRow() in Script Component? - Hi all I have an asynchronous script component which does something like this: [code="vb"] try { this.DataOutputBuffer.AddRow(); this.DataOutputBuffer.ETLLogPackageExecutionId = ETLLogPackageExecutionId; //other columns defined here } catch...

Data Warehousing : Analysis Services

MDX Newbie: How to combine some members to create a new member at same level (but not a calc. member) - I have a Dimension Items with first level ItemType. I want to create a member which combines some of the existing...

To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2013 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com