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

The Ratio

It seems we never have enough staff in many of our technology departments. I have worked in companies where I thought we had too many IT employees, but somehow it seemed my department was always short of people. We always had more work than we could get done with our staff.

However one thing that I've seen almost universally is a larger number of developers than DBAs in most companies. That makes sense as I think there usually is more code to write than instances to administer, and I've usually found companies have to hire a few developers before they see the need for a DBA of any sort, whether production or development focused.  I've also found the relative levels of staffing have widely varied.

This week I'm curious what ratios you've seen between these two jobs, developer and DBA. I'd like an answer to this question, based on your experience:

How many developers does a DBA support?

I'm looking for the real ratios that you've experienced. In the places where I've developed code, or worked with developers I've typically seen about 1:10 DBAs to developers, but that number has varied. I've seen 1:5 and 1:20+, but in most cases it's been near 1:10.

Let us know this week and get a little market research that might help you convince your boss that you need a helper or two.

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 ( 12.5MB) feed

MP4 iPod Video ( 15.0MB) feed

MP3 Audio ( 3.4MB) feed

Feeds are available at iTunes and Mevio

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

ADVERTISEMENT
SQL Toolbelt

SQL Toolbelt

If you want to work faster with SQL Server, 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.

sqlbackup

SQL Backup Pro

Quickly and easily delete old offsite backups with new features in SQL Backup Pro. Get your first 5GB of storage free.

Find out more.

SQL Data Compare

SQL Data Compare

Compare and synchronize database contents. “I've been really missing a neat data comparison tool - SQL Data Compare Pro seems to be the answer to my prayers.” Jan Hansen, Database Architect.

Download a free trial.

Featured Contents

 

Group Islands of Contiguous Dates (SQL Spackle)

Jeff Moden from SQLServerCentral.com

Fill in another bit of your T-SQL knowledge by learning how to quickly group ranges of contiguous dates without RBAR. More »


 

RD Licensing Configuration on Windows Server 2012

Additional Articles from Microsoft MSDN

The Microsoft Performance Team discusses the steps in installing/configuring Windows Server 2012 Remote Desktop Services Licensing in your environment using various available options. More »


 

SQL Saturday #227 - Charleston

Press Release

SQL Saturday is coming to Charleston, SC on October 12, 2013. SQL Saturday is a free training event for SQL Server professionals and those wanting to learn about SQL Server. Don't miss Charleston's first SQL Saturday. More »


 

From the SQLServerCentral Blogs - Disaster Recovery and Business Continuity

SteveHood79 from SQLServerCentral Blogs

Fires, SAN failures, tornados, and car accidents all came up today, yet it was a very good day at work. ... More »


 

From the SQLServerCentral Blogs - Networking at the PASS Summit: First timers

Steve Jones from SQLServerCentral.com

The PASS Summit is just over a week away, and one again Andy Warren and I are hosting a networking dinner on Monday night. This is a free, informal event to help people get to know each other. Whether you are new to the community or have been to many events, you’re welcome to attend. More »

Question of the Day

Today's Question (by free mascot):

What does "Hekaton" relate to in SQL Server 2014?

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: SQL Server 2014.

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

Expert Performance Indexing for SQL Server 2012

Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Dan Hess):

In SQL Server 2012, how does Microsoft recommend to add a database user to a database role?

Answer: ALTER ROLE <database role> ADD MEMBER <database user>

Explanation:

'sp_addrolemember' is deprecated in SQL Server 2012, the ALTER ROLE command should be used.

Warning of deprecation: sp_addrolemember - http://technet.microsoft.com/en-us/library/ms187750(v=sql.110).aspx

Explanation of deprecation: ALTER ROLE - http://technet.microsoft.com/en-us/library/ms189775(v=sql.110).aspx


» Discuss this question and answer on the forums

Featured Script

Date and Time dimension creation and population T-SQL

Joshua A. Walker from SQLServerCentral.com

Dim_Date and Dim_Time, Date and Time dimensions. Creation, population, indexing and use script.

Just copy the code into a query window and run the script.

There are no additional functions or procedures required.

This code will create the tables, populate the date and time tables, add holidays, add indexes and there are a few code snippets at the bottom for using them.

There are two variables in the code right after the table creation "@StartDate" and "@EndDate". Set the @StartDate to the first day you wish to use in your dim_Date table. By default this is 1/1/1900. Then set the @EndDate to the day after the last day you want to include. By default this is 1/1/2050. Every date from 1/1/1900 through 12/31/2049 will be included in your data.

The "ID" field on the dim_Date table is the primary key and the date as format YYYYMMDD. There are lines to make it an auto incrementing int that will start at 60,000 if you wish to follow the Kimball DW book that suggest not using a date format as your primary key.

The Date and Time columns in the tables are set up as character fields. This is the proper way to do this for reporting purposes. All day,month, hour, minute and second columns will always be two characters '01' vs. 1...etc...

All columns are indexed after the population.

For functions for these tables that will return the keys from the date and time tables when passed a datetime... and a function for returning the datetime when a key is passed... go here: http://www.sqlservercentral.com/scripts/Data+Warehouse/65897/

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 2014 : Administration - SQL Server 2014

Pro Active DBA - Hi Guys, I've recently been appointed to maintain my companies internal DB's. Must also stress the point that the DB's are...


SQL Server 2014 : Development - SQL Server 2014

How to write the Following Equevalant Query - Hi, can anyone provide me the equivalent MS SQL server query for the following query: LOAD DATA LOCAL INFILE '/tmp/ state_reg_photo.csv.csv' INTO TABLE REGISTRAR_REPORTS.srdh_photodata FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '' (uid,imagedata);

The special character changed to question mark in DB - Hi.. When i am trying to insert delta symbol into db, its converted to question mark(?) symbol. I am passing...

how to convert date in varchar format into datetime - Hello Everyone, I have table in which date is in varchar format i.e. '29/09/2013' now I want to insert the records in...


SQL Server 2012 : SQL 2012 - General

SQL Server version - When I run SELECT @@VERSION on SSMS of the instance I got the following info. Microsoft SQL Server 2012 (SP1) - 11.0.3000.0...

Huge Increase in Logical Reads for 17 Hour Period - We have recently implemented Dynamics CRM and have been working to performance tune all aspects of the product. Yesterday we...

Book Reviews - Wouldn't it be a great idea to have forum members give their reviews of the book that has been featured...

openquery and DBCC - Hello. This query select * from openquery([ServerName],'exec(''SET FMTONLY OFF; dbcc page(20,1,192963 ,0) with tableresults'')') works fine in SQL SERVER 2008R2 But in SQL SERVER 2012,...

Find value of cell from header name and row name (like going down and across) - what I want is the value of cell just like where x meets y, going down and across what is...

SQL 2012 Import wizard VERY slow - what to do? - I was using the SQL 2012 import wizard to double the size of my 80k record table. It has been...

Pass data from SSRS report result set to Webform - This is my first post here so good day to all. Let me give you a background on the item...

Support of JET OLEDB - All, We are planning to upgrade from SQL Server 2005 to SQL Server 2012. 1. We have many SSIS packages. What is...

importing a populating csv file - I have a CSV file which is getting information about every 30 seconds from a third party program and I...

SQL Server Merge - Pull replication error - I have a configuration problem to create a Merge/Pull replication between two databases SQLServer 2012. The machine Publisher is a Windows...

Traces question - Hi, I'm running a server trace to determine where the procedures take more time to execute. I'm tracking events 10, 12, 43...

Printed Books Vs E-Books - ;-)


SQL Server 2012 : SQL Server 2012 - T-SQL

Help needed with BCP command - Hello I'm attempting to use the BCP command for the first time, I'm effectively trying to get the output of a...


SQL Server 2008 : SQL Server 2008 - General

Page Life Expectancy dropping in value - I have an issue whereby every now and again throughout the day the PLE value plummits from something like 14hrs...

Windows/SSIS - File Transfer Protocol question - Can we download file from an ftp server without knowing the file extension. Directory would have multiple file formats. I...

Using missing index DMVs to look for (potentially) helpful indexes... - So I had come across a query (don't recall where) which uses four missing index DMVs to give an idea...

SQL Transaction Log - Hi everyone, My transaction log file is bigger and bigger every day, can I truncate the file? If it can, does...

SQL Transactional Replication - Hi, Can someone guide me how to back up transactional replication? The problem is when my live db got the problem,...

SQL 2008 SSIS package problem with data export - I have an SSIS package I developed using the Import/Export Wizard as a base. It truncates certain tables in our...

Unable to start SQL Server agent after server restart( Sql Server 2012) - Hi I am not bale to start Server agent after server restart( Sql Server 2012) . It is giving me the...

Memory uitilization - Hi I asked bu one of my clients to schedule daily moinotring reports and provide cpu and memory uitilization of...

Checkpoint vs Log Backup - Checkpoint and log backup both have feature to "truncate the log". Checkpoint primarily handles by sql server internally but backup...

Select add new row opening balance - Dear Expert, I have a query problem, there are 4 tables (with left join) filtered by year and period and also an...

which one is better for High Avaliability - Hi everyone.. log shipping, Replication,Mirroring which one is better for High avaliability? and in now a days companies which one...

Sending Email Using Database - Dear, I require that after processing some transactions, need to send email with necessary information to the respective email addresses. I am...

select decimals after calculations, weird display - Hi, I can't get why I have that strange results, I need to keep value of dividing in a column...

Sum prescription amounts for an individual by given a start date and number of days supplied - I am trying to develop a query to determine the amount of a drug that an individual has had for...

Archive Database in SQL 2008r2 - Hello All, How to archive the entire database in SQL Server 2008r2 Thanks, Santosh

Flat File not moving all data - Hi, Im using flat file (.csv) to sql 2008, which has only 40 rows but 39 rows get transfered 1 row...

SSIS Transfer SQL Server Objects Task - Permissions Issue - I am attempting to create an SSIS package that will copy data from selected tables on one server to another....

Performance When dropping multiple tables - Hi, The software we use often creates a lot of temporary tables that need to be deleted from time to time. Depending...

Linked server to DB2 won't show catalogs - I have created the ODBC connection within the IBM Configuration Assistant, then created the linked server to the DB2 database....

Need Help on Fastest Search Logic - Hi, I have two tables named "Table1" and "Table2". Table1 Details: id bigint, product_name nvarchar(1000),quantity int records count on Table1 : 25000( may increase in...

Rolling 3 month average cost help - Hi guys, I need some help calculating a 3 month avergae rolling cost. I have been trying to figure this out...

Cannot open New SSIS Project in SQL Server 2008 R2 - I installed SQL Server 2008 R2 and Visual Studio 2008. However, after several installations and un-installations. I could no longer...


SQL Server 2008 : T-SQL (SS2K8)

Advice on Agent job step - He everyone. I have a requirement to move a .xlsx file from a local location to a sharepoint site. I looked around...

Best method to append columns based on similar ID - Hi, sorry about long thread but here we go, so i have been trying to figure this piece out as...

Inline Valued Function query... - Afternoon all, Looking for a bit of advice on something I am struggling to explain. I have 3 functions, 2 of...

Blocking SPID with Text Data? - Hi SELECT wt.session_id, ot.task_state, wt.wait_type, wt.wait_duration_ms, wt.blocking_session_id, wt.resource_description, es.[host_name], es.[program_name] FROM sys.dm_os_waiting_tasks wt INNER JOIN sys.dm_os_tasks ot ON ot.task_address = wt.waiting_task_address INNER...

Most efficient way to extract data for a historical data table - I have a 3rd normal form table which maintains history over time using a date row start and date row...

Change Excel formula to Case Statement - I have this formula I use within Excel, I'm moving most of the work into SQL & can't think how I...

wish to add rows having NULL values as placeholders for "missing" dates - I have a table that contains stuff happening. There's a datetime stamp column to show on what date the stuff...

Slow Script - Hello. I ran the following script that too 3 hours 25 minutes to insert about 40,000 rows. Is there any...


SQL Server 2008 : SQL Server Newbies

why used WITH XMLNAMESPACES in tsql ? - What is the used WITH XMLNAMESPACES in tsql. Does it provide some functionality ? What would break if do not used...

exception handling: how would you do it? - Hi all, I have a 3-part UNION ALL query. Sometimes, one of the tables are not available, meaning I can't connect...

Is this right if i will do my project this way?.. - Hi Everyone..I hope everyone is having a nice day:-) Is this right if i will do my project this way? Please see...

Select top, how to get the rest? - Hi I want to use paging and I don't want to get so many records. But if I use select top (100)...

Replace - Hi Consider this table Man_name Model Motorola MotoQ Motorola RAZR2 Nokia N73 Nokia 6100 Samsung C118 I have used Distinct Statement to retrieve the value. Now I...


SQL Server 2008 : SQL Server 2008 Administration

Transactional Replication. snapshot Agent not picking up Creation Script - I'm working on some custom transactional replication as part of a partial database/application upgrade. Table definitions have changed in the...

Alter Partition Function with existing data problem - I have inherited a datamart on SQL 2008 R2 that has an existing partition function in place for our Fact...

Memory threshold for SQL server 2008 - Hello, I am building a new virtual server - Windows 2008 R2 DataCenter. Installed SQL Server 2008 R2 Standard Edition - 64 bit. The "Maximum...

Shrinking Temp DB - I am trying to shrink the first temp db mdf, but it is not shrinking... 95% free... just added some...

Create Full Backup with Multiple FileGroups - Hello Everyone I am in the process of writing a Full Backup Database script, but this database has multiple filegroups. The...


SQL Server 2008 : SQL Server 2008 Performance Tuning

Data Engine tuning Advisor - Hi, I am trying to make use of the Data Engine Tuning Advisor, but keep getting the following error message,...

Running out of workers - Is there a way to set up a trace that will show why you are running out of workers? I know...


SQL Server 2005 : Administering

Installing Standard Edition vs Enterprise Edition of SQL Server 2005 - Okay, My Google-fu is failing me. Our SA's are replacing some servers and at the same time want to install Standard...

Database Not responding from 8:00 PM to 10:00 Pm - Dear All, I have an Sql server 2005 server which is hosting multiple Databases. Recently, users are complaining that the application...

Serious memory pressure - Hi, I would like to get some opinions on possible paths to take to rectify a physical Windows 2003 Standard server...


SQL Server 2005 : Backups

Backup failuer with error 3132. - has anyone come across this error and any solution : Msg 3132, Level 16, State 1, Line 1 The media set has...


SQL Server 2005 : Business Intelligence

Reading Server details or Enviornment variables in SSRS report - Hi, Is there any way to read SSRS report server name or enivornment variables when report is run with limited access....


SQL Server 2005 : SQL Server 2005 General Discussion

EXECUTING SSRS REPORT FILE IN COLD FUSION POSSIBLE ? - HI All, Is it Possible to integrate SSRS and ColdFusion page ?IF YES PLEASE SHARE how with some details Thanks IN...


SQL Server 2005 : SQL Server Express

database 'master' is not valid 9003 error Help!!! - I ve just rebooted the server. After it reboots SQL Services not started and i got these errors on the...


SQL Server 2005 : SQL Server 2005 Integration Services

Argument "Server1" for option "connection" is not valid. The command line parameters are invalid. The step failed. - I have a SSIS package run fine in BID, but when run as a sql agent job, it failed at...

Importing data from DB2 to Sql Server 2005 - dear all, plz i need your help , i want to import data from DB2 to Sql server 2005. i was trying it...


SQL Server 2005 : T-SQL (SS2K5)

SQL Select Case - I am trying to replace a value from my select if the value from this column 'date' is equal to...

DATEDIFF in hours and minits In Decimal Format - Calculating Difference between ClockIn and ClockOut by Job. Table : JobTran Job# ClockIn ClockOut --------------------------------------------------------------------- Job1 2013-10-03 06:17:34.387 NULL Job1 2013-10-03 05:17:34.387 2013-10-03 08:10:34.387 Job2 2013-10-03 09:17:34.387

Advantage of using date and time in 2008 over 2005 datetime - Hi Everyone, Hope all is well. We can store date and time separately in 2008,but when we are using 2005 we have...

Need help with Charindex function.. - I am trying to capture an email address from the below message..whats the best possible way to do it .. DECLARE...

Front End Read and Write - I use MSAccess as my front end. We may move to VB.Net but that is down the road. When using a...


Reporting Services : Reporting Services

MDX partial sums using cross join - Hi, I'm trying to using this MDX query to get partials sums by region, cities and proyects (first image), but...

Report Builder 3.0 - Shared Dataset - Computed Field If statement error? - I'm doing a proof of concept on self-service BI with report builder for a department here at work. As a...

How to add details in Row groups in a SSRS report? - How to add details in Row groups in a SSRS report? Please help me.

ssrs report - hi friends, i have one doubt regarding ssrs in ssrs i need diffrence for column in matrix for that i need expression...

Can you have a report mail based on when a field in a table is updated? - I send out a report with a subscription. But I set it up to mail out at 8:00 am daily...

Maximum request length exceeded - I'm having the following in my relatorio he is already quite long. "There was an exception running the extensions specified in...

Question About Creating Grouped Reports Outside of the Wizard - So this has been bugging me for quite some time now. I know it's faster to create report using the...

ReportViewer v10 issue with slow paging - We have an ASP project with ReportViewer controls. We recently upgraded the controls from v8 to v10. Everything looks good...


Reporting Services : Reporting Services 2005 Development

Page breaks in columns of one table in ssrs page - I am creating a SSRS 2008 Report in my report i have 200 columns, it is difficult for visualizing purpose,...


Reporting Services : Reporting Services 2008 Administration

Publish reports on the internet server - Good afternoon, I want to know if it is possible to publish the report server on the internet for other...

How do you delete old one time subscriptions? - Am using the following query, to get the subscriptions I want to delete. SELECT C.Name ,C.Path ,U.UserName ,S.InactiveFlags ,C.CreationDate FROM ReportServer.dbo.Subscriptions S INNER JOIN ReportServer.dbo.Catalog C ON...


Reporting Services : Reporting Services 2008 Development

ssrs 2008 r2 add connect data to a gauge - In an SSRS 2008 r2 report that I will be creating, I want to add charts and gauges to the...

adding new subscriptions problem - hi all, I have added a number of subscriptions for some RS reports. Now, when I go back to the page where...


Data Warehousing : Integration Services

Unable to export the data into flat file because of Dynamic Column Mapping - Hi Folks, I am facing an issue in my package. I have a transaction table wherein i get data date wise daily,...

SSIS scripting - Visual Basic or Visual C sharp - Why ? - I want to learn one language so that I can do script tasks easily. Which one should I learn - visual...

Problem:: SSIS: Excel Destination. Mapping columns dynamically - Hi My requirement is as follows: I have multiple Excel sheets in a folder which are in same format. I need only one...


Data Warehousing : Analysis Services

Can we use the cube data without deploying the solution? - I'm new to SSAS and I've created an dummy solution of Analysis Services project. I don't have permission to deploy...

MDX to Get Customer Status in given date range - I have a fact table that stores customer statuses based on when they last chaged. e.g. Customer Status DateAttained Cust 1 Live...


SQLServerCentral.com : Anything that is NOT about SQL!

Today's Random Word! - HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...

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


SQLServerCentral.com : SQLServerCentral.com Website Issues

Avatar gone? - Is there a problem with the avatars? Profile says folder with avatars is gone (see screenshot in attachment). ps: also notice the...


SQL Server 7,2000 : Administration

Need a script to backup DB and delete old backups - I need a script for SQL Server 2000 which can backup the database as well as delete the backup files...

space given in DB name and backup failure - There seems to be an extra space in the database name given when it was created. The backup job is failing...

Log Shipping on SQL Server 2000 Standard Edition - Hi All, Thanks for looking into my question. Do you know if it is possible to setup log shipping in SQL...


SQL Server 7,2000 : T-SQL

SQL Help in grouping - Hello, SQL Server Version 2000 create table students ( course_id varchar(5), course_name varchar(10), roll_no varchar(3), student_name varchar(40), geog_marks varchar(2), math_marks varchar(2) ) insert into students values ('1','course1','1','abc','40','') insert into students values ('1','course1','2','aaa','40','') insert...

I need help Please :( - I have a table name Employee Logs table consist of EmpID, Empname,Logdatetime. I can generate the first in and last out by...

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