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.
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 »
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
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.
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...
How to write the Following Equevalant Query
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 ''
- Wouldn't it be a great idea to have forum members give their reviews of the book that has been featured...
openquery and DBCC
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,...
Need Help on Fastest Search Logic
I have two tables named "Table1" and "Table2".
id bigint, product_name nvarchar(1000),quantity int
records count on Table1 : 25000( may increase in...
Blocking SPID with Text Data?
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
How do you delete old one time subscriptions?
- Am using the following query, to get the subscriptions I want to delete.
FROM ReportServer.dbo.Subscriptions S
INNER JOIN ReportServer.dbo.Catalog C
SQL Help in grouping
SQL Server Version 2000
create table students
insert into students values ('1','course1','1','abc','40','')
insert into students values ('1','course1','2','aaa','40','')
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...
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.