SQLServerCentral - www.sqlservercentral.com

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

The Voice of the DBA

Hiring Guitarists

Hiring good people is hard, though in some cases it might not matter as much as others. If I am hiring entry level developers or DBAs, I have a lot of candidates, I'm not investing a lot, and I shouldn't be too concerned if I have to let someone go and find a new employee. Given the fact that the people are often unproven in this case by definition (they're junior levels), I should be prepared as a manager to make more mistakes at this level.

However at the senior level, hiring needs to be done more carefully. The high costs, the limited number of candidates, the responsibilities I give senior people, along with the trust I need to bestow upon them means that I can't afford to make the same percentage of mistakes at the senior level. Most importantly, I don't want to hire expert beginners instead of experts at this level.

I ran across a post on a way to hire senior developers that I thought was very interesting. In particular, I was struck by the analogy of hiring a guitar player. For the most part, I'd agree that if I wanted an experienced guitar player, I'd want the expert, not the expert beginner. If for no other reason than I don't want to argue with an employee that does things my way, including making the same mistakes I'd make, and then explaining to me this is how I had specified things to be. I want a senior people to warn me, and influence me to do better.

I'm not sure how I'd devise a similar level of test for a senior level DBA, though I do like the idea of giving them some scenario or simulation that has flaws or problems and seeing if they'd correct them, point them out, or leave them in place as they moved on to "play" the scenario. I'm sure there's a way to do this, and a balance between how to evaluate the responses. 

Ultimately I want senior people to fix things, make them better, and provide a smooth path to increase quality. I want them to point out flaws, and warn me about issues. If I insist on making poor choices, I want their support, but if they can influence me to do better, I'd prefer they did. That's one mark of a senior person.

Steve Jones from SQLServerCentral.com

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


The Voice of the DBA Podcasts

We publish three versions of the podcast each day for you to enjoy.

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com with  comments definitely appreciated. Overall RSS Feeds:  

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.

 You can also follow Steve Jones on Twitter and find links and database related items and announcements.


ADVERTISEMENT

Use Deployment Manager for free! For up to 5 projects. Try it out and deploy software and databases faster and easier than ever.

ADVERTISEMENT
SQL DBA Bundle

‘10 Tips for Efficient Disaster Recovery’

Steve Jones gives the final lesson in the ‘Top 5 Hard-earned Lessons of a DBA’. Read now and learn from the best.

SQL Toolbelt

Want to work faster with SQL Server?

If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download the SQL Toolbelt here.

SQL Backup Pro Hosted

Have you got your 5GB free hosted storage yet?

Back up your SQL databases to the cloud using SQL Backup Pro. You’ll get your first 5GB of storage free. Try it now

Featured Contents

 

Dynamically Truncate a Partitioned Table

Steven Rao from SQLServerCentral.com

Wouldn't be great if you could truncate any partition of a partitioned table with one T-SQL statement? This article shows you how. More »


 

How to Post Performance Problems

Gail Shaw from SQLServerCentral.com

How do you get help? You can post a question on SQLServerCentral, but to get the most help you can, read this article from MVP Gail Shaw. More »


 

SQL Server: How Important Are Index Statistics

Additional Articles from Database Journal

In this article Greg Larsen will show you how to identify when your index statistics were updated last, what method was used to gather statistics, and how to update your statistics. More »


 

From the SQLServerCentral Blogs - A Page-Splitting Headache - Page Split Mini-Series

Robert Pearl from SQLServerCentral.com

Page splits are a normal occurring process in an OLTP system.  However, too many page splits can cause performance issues... More »

Question of the Day

Today's Question (by RUPESH PATEL):

declare @value int
set @value = 5555555
PRINT CONVERT(varchar(6), @value) 

What will be the output?

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: Convert.

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

ADVERTISEMENT

SQL Server 2012 Data Integration Recipes

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Naseer Ahmad):

What will be the result of this batch, assuming that Change Tracking is enabled on database?

Use ChangeTrackingDemo
GO
CREATE TABLE CT
(
ID Int,
Name varchar(10)
)
/****Enable ChangeTracking****/
USE ChangeTrackingDemo
GO 
ALTER TABLE CT
 ENABLE CHANGE_TRACKING 
GO

Answer: The batch will create a table and give an error while enabling Change Tracking

Explanation: We cann't enable change tracking on any table without having primary key on that table.

Ref: http://msdn.microsoft.com/en-us/library/cc305322.aspx


» Discuss this question and answer on the forums

ADVERTISEMENT

Microsoft SQL Server 2012 T-SQL Fundamentals

Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft® SQL Server® 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you’ll quickly learn how to write effective code—whether you’re a programmer or database administrator.

Get your copy from Amazon today.

Featured Script

Show Database and Log sizes, free space and location

Leonid Sheinkman from SQLServerCentral.com

This script helps to identify which database/log takes most of the disk space and how much is free. It helps to identify candidates for file shrink when running out of space on particular disk.

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

Error while executing DTS package in SQL server agent - Hi i have a DTS package which runs successfully if done manually . I tried scheduling in SQL server 2000 Agent .I...

Backup log shipping target database? - On a log shipped database, my client wants to be able to backup the target database as well as the...

Linked server using windows authentication - We are planning to change sql 2005 server to windows authentication mode. everything is working fine except linked server. when set the...

How to clean up my master database? - I am not a DBA, but an application developer. After I ran some database creation script against my SQL Server...

SQL Server connectivity Issue - I am able to connect the server but not to the SSMS. getting the below error: " The client was unable to...

After having moved a .mdf when SSMS would not start - We had run out of space on a drive that was storing several .mdf files and I could not start...

SQL Server 2005 : Backups

SnapManager for SQL job - Hi....I am new to Snapmanager for SQL jobs trying to find a solution for my issue. I run the SnapManager...

SQL Server 2005 : Business Intelligence

how to run SP which internally conatain Temp tables in ssis - Hi, I have one sp which internally using 10 temp tables. I need to load the result set from sp into one...

SQL Server 2005 : SS2K5 Replication

Adding a new a third node into an existing two nodes SQL 2005 cluster. - I want to know if I add a new node that is on a newer dell 620 server with Win...

transactional replication - hello experts, please help to identify whether my replication type is [b]"transactional publications enabled for queued updating subscriptions" [/b] ?? please help

Queue reader agent - Hello experts, please let me know how do we check whether queue reader gaent and distribution agent down ? its urgent thanks

SQL Server 2005 : SQL Server 2005 Integration Services

SQL job failed - I did an SFTP to command the job via winSCP. I manage to run execute it in SSIS. When I try to...

Logon failure: unknown user name or bad password - Hi, I'm completely lost here... I have a SQL Server Agent job that execute a SSIS package. The same job...

SQL Server 2005 : T-SQL (SS2K5)

reading XML in a loop. - I want to read through an xml document with a loop. I've removed the extraneous code. I get this error:...

Deleted items still appears in output - Hi All, I'm a real newbie in SQL. My job demands me to learn it which I found out to really...

State County City Problem - Im dealing with address data, and based on the schema I have, I can't query to answer the following question:...

ORDER BY in a cursor - Is there a limitation on being able to order the select statement you are using for a cursor? In the query...

SQL Server 2005 : SQL Server Newbies

Help me guys. CARRIER CONFUSION!! MS SQL or ORACLE - Hi guys , I live in INDIA. For one year i have been working in sql server 2005 as a developer...

Order of rows in a Table with Identity Column. - I have a table with an Identity Column as TransactionId and also it is a primary key. The table has around...

SQL Server 7,2000 : General

Neighboring counties - I need some data that lists neighboring counties. Does anyone know of any 3rd party software that does this type...

SQL Server 2008 : SQL Server 2008 - General

Red lines under third occurance of a table name - Hello. I have an annoying problem and I can't find anything about it. In scripts I have, that are templates created...

Sql server Mirroring without witness Server - HI, I need to start mirroring the databases without witness server, Can i please have instructions from scratch to end kind of...

find session - Hi friends, Our database server(windows 2008R2 4GB 64-bit) goes up to 98% physical memory and about 3.5G from sqlservr.exe. Max...

linked server issue - Hi Can anybody advise on the following error : [quote]OLE DB provider "SQLNCLI10" for linked server "server1" returned message "The partner transaction...

Updating SQL table using SSRS - Hi everyone I have the following table in sql server: CREATE TABLE [DBO].[SHIFTS] ( [WEEK_ENDING] DATETIME NULL ,[FORENAME] VARCHAR(50) NOT NULL ,[SURNAME] VARCHAR(50) NOT...

How to update Flag for maximum amount in a a group - Create Table #Temp ( Pk_Id Int Identity(1,1), Lnno Int, Amount Int, Flag Char(1) ) Insert Into #Temp(Lnno,Amount) Values (1,5),(1,10),(2,20),(2,25) Select * from #Temp Hi, My requirement is,I want to update Flag...

Schema Diagram - Hi Has anyone ever had to reverse engineer a schema diagram from a database before? If so, what tool did...

script - i would like to find the above details DB names, last backup finished date , backup size of all the databases...

Import data from multiple Excel sheets to multiple Tables using SSIS - Hi, I have a excel file that has multiple sheets and I need to import data from each seperate sheet to...

Need a Subquery to delete the previous dates - I have created one table like below create table Verification(id int,date datetime) inserted values like insert into Verification values(1,'2013-07-10 03:12:05.397') insert into Verification values(1,'2013-07-09...

Procedure or function not working correctly - Hi Professionals I have a procedure which calls a function, the function checks to see if the 3 columns exist, if...

Log Shipping and the very last Tran Log backup - I hope this is not a silly question, I will first give some background... I am heading a project to migrate...

install SQL cluster - Hi Folks, i need assistance regarding installing SQL cluster. i need comprehensive step by step guide.

Partitioning a table with primary key - We have a table that we are going to recreate on partition scheme. Its clustered index is a primary key....

Sorting based on user input.. - Hi, I have one requirement and need help. I have a table: CREATE TABLE MiscItems(ID INT, Description VARCHAR(50), DisplayOrder SMALLINT) INSERT INTO MiscItems(ID,Description,DisplayOrder) SELECT...

Minimum rights required to add users to a DB - Hi All We run both SQL 2008/2012 but this question stands for both versions. I would like to delegate permissions to our...

ERD Normalization and DeNormalization - I am developing a very big project with a huge data to be store in database.I have more than 10...

calculate working hours between 1 year ? - I have limited table like : FUL NAME DATE ali sever 01-01-2013 12:50 ali sever 01-01-2013 18:30 ali sever 01-01-2013 15:30 ali sever 01-01-2013...

MSDTC errors - SQL server stopped responding to any request - Hi Rather a strange issue with multiple SQL server instances - SQL server abruptly not responding to client applications for a brief...

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

Replication DB - Dead lock issue - Hi, We have One Database which is a Replication Db, sometimes during beginning of the month, lot of user activities going...

Rounding issue - Hi everyone, I have problem with rounding. There is a table [code="plain"] CREATE TABLE [dbo].[Fin3PaymentDisb]( [PaymentID] [bigint] NOT NULL, [Currency] [char](3) NOT NULL, [Amount] [money] NOT...

Unable to open Alerts in SQL Server Agent / Cannot view properties - I am unable to open Alerts in SQL Server Agent and Cannot view the properties using GUI. Although I am...

SQL Server 2008 : T-SQL (SS2K8)

which version sp should i install on my SQL Server 2008 r2 (RTM); 64 bit. - current version is Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Developer...

multipart identifier could not bound - hi i have query like this select ra.column, r1,column2 from emp ra inner join emp1 r1 on r1.empid = ra.empid . i need to add 1more field...

What was erroe in my code? - Hai friends, i ve the table like users: -===== create table users ( users_id varchar(10) primarykey, username varchar(10), pwd varchar(10) ) insert into users('001','A','ra@123') insert into...

We've all seen it ... - OK folks. You've seen me (and many others) use Tally tables often enough. You generate a ROW_NUMBER() and you don't care...

Check if Function EXISTS before adding - I'm trying to write of script that checks if a certain Function exists, and if it does not, create it....

SQL Server 2008 : SQL Server Newbies

non identity auto increment field - Hi all, I"m very new to SQL and have been searching the forums but haven't found what I'm looking for....

Distinct Keyword - I am wanting to add a distinct keyword to this statement and I am not sure how or where exactly...

Dynamic WHERE statement if stored procedure parameter is null - I have the stored procedure with @StartDate and @EndDate parameters my WHERE statement is using those parameters to filter out data WHERE...

Query Reporting Services subscription start time? - Hi All - I'm trying to gather information regarding the schedules for my subscriptions. Some of the data I need is...

Upgrade SQL Server 2000 to SQL Server 2008 - I'm looking to upgrade 4-5 SQL Server 2000 database instances to 2008. Most are SP3 but one is RTM. Upgrade...

SQL Server 2008 : SQL Server 2008 High Availability

Replication or log shipping for reporting database - I'm trying to decide between log shipping and replication for using a secondary database for reporting purposes. They want to...

cluster node recieving bad sql on db engine. - Hi Guys, I have an issue with one of my nodes on a sql 2008 r2 cluster (10.50.4000). On one of my...

Log Shipping or Transactional Replication - Hi, We have an ecommerce site for which primary infrastructure (DB and web servers) is based in Chicago. We have a...

SQL Server 2008 : SQL Server 2008 Administration

Upgrade from Sql 2003 to Sql 2008 - Hi, We are planning to upgrade from Sql 2003 to Sql 2008 and I would like to know what needs to...

Maintainance Plan for my DB - hi all please help me to create good performance plan for my database.In SQL default maintenance plan are there but...

Register SPN? - Hi, I found error msg in Error log as below.. SQL Service account not running under domain account. please guide me...

copy system database files - Dear All, I would like to have a backup of the SQL system databases (the files themselves) not the SQL backup....

Notifying SQL of additional CPU additions - Dear All, Iam planning to add two more CPU’s to each node on my SQL 2008 standard edition (Vmware virtualized 2...

Career : Employers and Employees

Contractors - I'm curious to hear from contractors who work independently and how they find their clients. Right now I'm working corp-to-corp...

Programming : General

Trying to incorporate a Database Abstract Layer... - I have a goal of creating a Database Abstract Layer (stored procedures and maybe views) as long term project, in...

Need Help on SQL query script on sum - Hey guys, New to the site, new to writing SQL queries and have no background in this type of thing. But I've...

SQLServerCentral.com : Anything that is NOT about SQL!

How do you manage your code snippets/documentation? - The .sql file that I started using to store interesting bits of code, things I wanted to play with, general...

"Throw it on the Big Screen" Like on NCIS tv show - Ok weird request here; NCIS makes this look easy. we've got conference rooms CPU's and projectors or big screens; one of the screens...

Forum Topics Order - Just kind of wanted to throw this out there and see what others think. Since SQL Server 2012 has been...

PolyServe replacement options - While it seems HP still has not made the official announcement, some of us have had conversations with HP representatives...

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

JDBC connection from SSRS - How can I add in data sources a connection trough a JDBC driver?

'phantom' header when adding a new column? - I am no expert in SSRS but I have added columns before but this time when I added a new...

Main report A4 Subreport Zebra label 105mm x 105mm - How can I stop my subreport inheriting the A4 layout of my main report. The subreport is set to layout 105mm...

While running a report, mostly the report got completed successfully but some times i am receiving the following ERROR in my log file while exporting to CSV. - [Info] DeliverToSure : Rendering Report (CSV) [Error] Microsoft.ReportingServices.ProcessingCore : ProcessingAbortedException : An error has occurred during report processing. [Error] Microsoft.ReportingServices.ProcessingCore : ReportProcessingException : Query execution failed for...

Subreport addendum - I want to provide a report that prints a manifest containing all the products on an order. The report will...

Database Design : Design Ideas and Questions

Is it Better to use Multiple DB than Single DB? - Hi In need to design an Enterprise level solution which will contain around 8 modules (such as Accounting, Human Resource, Inventory,...

Data Warehousing : Integration Services

Source data in multiple languages - Hi, confusing myself with possible options for this scenario - Reporting from our DW must be in both English and French, therefore...

Data Transfer queries - Hi there, If I could advise on my situation at present. I have been asked to create a Datawarehouse soloution...

Load in different table base on different number of columns in text file. - I have 1000 text files in one folder, text files have 2 or 3 or 4 column. Now I need...

Is it possible to Rollback the Transaction for a single load is you SSIS Package or the Job that runs the package? - Is it possible to Rollback the Transaction for a single load is you SSIS Package or the Job that runs...

SSIS: use 2 different connections managers in one datasource - Hi, I'm using SSIS to fill a datawarehouse. Until now I used to truncate the tables and refill them every night....

SSIS 2012 / mixed SQL Server 2008R2 and 2012 / stored procs which use #temp tables - Apologies in advance for the longish post… We have the following environment: 1) SSIS 2012 2) Mixed SQL Server 2008R2 and 2012 We have instances of...

Microsoft.ACE.OLEDB.12.0 provider not registered on local Machine - My source file was created in Excel 2007, so i had to install ACE drivers on server (I did it...

SSIS error when configuring data flow task with .xls file - Quick environment details: 64 bit Server 2008; SQL Server 2012; Studio 2010 I have a package that connects to a .xlsx...

Run package when email is received or based on database value? - Hi. I've seen a couple of questions/answers here describing how to use a script to check a folder and see...

Data Warehousing : Analysis Services

what is the best impersonation options for data soruces to avoid Development to production migration of SSAS cubtes. - [font="Tahoma"]Hi All, I am new to SSAS and its been difficult in visualizing the way impersonation works from Development Environment to...

Cube sync failed due to lack of disk space - I am using Analysis Services 2008 R2. I have a cube on a processing server which I regularly sync to...

Login failed for user 'NT Service\MSSQLServerOLAPService' 28000 - I am using SQL Server 2012 developer edition on Windows 7. I have the following error attempting to process a...

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