There was a report recently where the NSA noted that they are reducing the number of system administrators by 90%. If the report is true, that would certainly worry many of the people in the technology industry. However I'm not sure that the quote given in the article means what it looks like at first.
Much of the technology reports that we see aren't completely true since many of the reporters aren't that familiar with the details of how computer technology works. In this case, however, we have a quote: “What we’re in the process of doing – not fast enough – is reducing our system administrators by about 90 percent,” It might be hard to interpret this remark in any way other than the NSA is looking to reduce the number of people, but if you read further, the piece notes that the NSA is concerned about contractors, not necessarily FTEs. I suspect that any reduction in contractors employed by other companies will be made up by increased internal headcount.
However even if the NSA can reduce the number of people needed to administer their systems, I'd suspect that means that they had too many people to begin with. The various reports of this story all talk about automation being used increasingly to handle the load of system work, but the idea that automation replaces people is a myth. Automation usually results in less growth of people, but rarely a reduction in staff.
I've heard the concerns over automation replacing technology workers for decades (literally) and I've yet to see it happen. We have more technology workers than ever before, and no sign of there being less in the future. Your department might change, you might hire less, but there will be lots of jobs in technology for the foreseeable future. In other departments that might not be the case, but I bet you we'll have system administrators, DBAs, and developers for a long, long time in most companies that have them today.
Deploy your .NET apps, services, and SQL Server databases in a single, repeatable process with Red Gate’s Deployment Manager. Get started now.
SQL in the City – Free SQL Server training in the US
Don’t miss out on learning about best practices for SQL Server database development and administration from top SQL Server MVPs. These free seminars and events are coming to San Diego, Denver, Pasadena, Atlanta and Charlotte. Find out more and register.
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.
There are several types of tables, each with their special requirements for rules and integrity constraints. Whatever the requirement, table-level constraints will ensure that the rules are enforced and data integrity is maintained. More »
Join us at SQL Saturday Denver on September 28. SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This SQL Saturday includes a number of options for pre-conference training in Denver, including a free session presented by Steve Jones. More »
If you are interested in learning firsthand what new features are available, then you should download and install the new SQL Server bits. In this article Greg Larsen will walk you through preparing, downloading and the steps to install the SQL Server 2014 CTP1 release. More »
Question of the Day
Today's Question (by bitbucket-25253 ):
I have the following settings for my SQL Server 2012 2008R2
SET NUMERIC_ROUNDABORT, QUOTED_IDENTIFIER OFF;
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,ANSI_NULLS ON;
I execute the following T-SQL:
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SomeTable]') AND TYPE IN (N'U'))
DROP TABLE [dbo].[SomeTable]
CREATE TABLE DBO.SomeTable( [Case] char(3),
[Hours] int, [Type] int)
select 'xxx', 3, 1 union all
select 'xxx', 3, 2 union all
select 'xxx', 4, 1 union all
select 'xxx', 1, 1
I then execute the following T-SQL statement:
when [Type] = 2 then -1 * [Hours]
end) as TotalHours
The Questions are:
Does the create table statement fail or succeed?
If the create table statement succeeds what value of TotalHours is returned by the Select statement?
If the create table statement fails what error msg number is returned when the Select statement is executed?
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
2 points in this category: Reserved Words.
We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the
SQL Server Execution Plans shows you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: Which indexes are being used, and where no indexes are being used at all. How the data is being retrieved, and joined, from the tables defined in your query. How aggregations in GROUP BY queries are put together. Grab your copy today from Amazon!
Yesterday's Question of the Day
(by Steve Jones):
What does the visibility attribute control for assemblies?
Answer: If set to off, the assembly is intended to only be called by other assemblies and not used in functions, procedures, etc.
Explanation: The visibility controls whether or not the assembly is visible for creating functions, stored procedures, or other objects using this assembly. When set to off, the assembly is intended to be called only by other assemblies.
Recently I was asked to find all the Primary keys that are not clustered Indexes in the database.I constructed this script which will help us to locate the primary keys in the database which are not clustered index.
Help On Query
CREATE TABLE [dbo].[tmp]([msisdn] varchar(20) )
DECLARE @intFlag bigINT
SET @intFlag = 15210000000
WHILE (@intFlag <=15219999999)
insert into tmp select @intFlag
set @intFlag= @intFlag + 1...
EST TO UTC
I have to create offset to convert my EST Datetime columns to UTC to compare with Utc datetime columns.The server...
send_dbmail recipients from table
- Hi All,
my first post here maybe a newby one.
i have a table with data as from example below.
Idea is that...
can i apply SP3 on Microsoft SQL Server 2008 (RTM)?
- SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
10.0.1600.22 RTM Standard Edition (64-bit)
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright...
Need help in building a SQL query?
- Hi Experts,
I have table called "Entries" having general information of Employees as...
[code="sql"]Select * from Entries where mskey = 1234[/code]
MSKEY, ATTRNAME, AVALUE
Merge with more then one insert statement
- Table1 :
MERGE Table1 t1
USING table2 t2
ON t1.id = t2.id
WHEN NOT MATCHED THEN
as like this i have 16 names...
I did a check in my table and I found these duplicates:
Key Month Usage
45 Sept 464
45 Sept 471
28 Sept 762
Why is my logon trigger blocking logons?
- I've created the following trigger to track logons:
Create database AuditDB
CREATE TABLE [dbo].[ServerLogonHistory](
[SystemUser] [varchar](512) NULL,
How do I remove the Nulls in my output?
- CREATE TABLE #Total_Count
(NUM_DEATHS_1870 numeric (8,0), NUM_DEATHS_1880 numeric(8,0))
INSERT INTO #Total_Count (NUM_DEATHS_1870)
(SELECT COUNT (*) COD
WHERE YR_Died = '1870')
INSERT INTO #Total_Count...
- Okay, a topic that has NOTHING to do with SQL . . .
Came across [url=http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx]this link[/url] describing the SSC point scoring descriptions,...
Today's Random Word!
When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...
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.