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

What is a Database Administrator today?

Today we have a guest editorial as Steve is traveling.

What should the job duties of a Senior Database Administrator (DBA) be?  If you started a new job as a Sr. DBA what would you expect to be doing and what would you not?

Over the last two years I have worked contracts for five different companies.  At each company I held the same title, Sr. Database Administrator, but each company had me doing radically different things.  Sometimes I was asked to work with the application team and help them write stored procedures and views and optimize existing code.  Sometimes I was tasked with backup and restores and setting permissions.  At one position I was asked to migrate a client to a new environment.  I was responsible for migrating the database components, requesting and setting up the hardware, setting up data shares for incoming text files, and having the AS400 jobs, that delivered text files, updated with the new server information.  At another company, I worked for the business unit (BU) and not the IT department, so I was not granted SysAdmin rights to the servers even though my position was as a Database Administrator.  That was very frustrating and I found out later that this was an ongoing war between the BU and IT.

So, this got me to ponder, what is a database administrator?  It is someone who just keeps the SQL Servers running and installs new servers as needed?  Someone who makes sure that the backups get run and does restores as needed?  Or has it morphed into a Jack-of-all-trades position? 

It seems to me that companies are looking for people who can do everything and that are willing to do anything.  Is that reasonable and if true, should the position still be called Database Administrator or should it have a new name?

I like doing different things, it keeps me from getting bored and it keeps me learning.  Some of my colleagues hate it, they want to do the tradition duties and that’s it.  What about you?  Have you run into this and if so, how do you feel about it?  Is being a DBA more difficult now than it was 10 or 20 years ago?

Jim Youmans from SQLServerCentral.com

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

ADVERTISEMENT
SQL Monitor Hosted

New! SQL Monitor Hosted

Start monitoring your SQL Servers in under 5 minutes. Get clear insights into server performance, whilst we manage the monitoring software. Find out more.

SQL Source Control

Get your SQL Server database under version control now!

Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

SQL Monitor

What does normal looks like on your servers?

New benchmarks in SQL Monitor instantly show you if a performance spike is a problem, or within normal SQL Server behavior. Try it live.

Featured Contents

 

Moving Large Table to Different File Group

Raj Gujar from SQLServerCentral.com

How to Move Large Table to Different File Group More »


 

Cloud Services for the DBA

Additional Articles from SimpleTalk

A critical part of any DBA's role is implementing the systems that will improve in the long term their organization's guardianship, use and understanding of its data. Too often, however, this gets lost in the fog of immediate and urgent tasks. Gareth Marlow explains why he believes Cloud services will play an increasingly prominent role in helping DBAs achieve their strategic goals. More »


 

From the SQLServerCentral Blogs - A Rickety Stairway to SQL Server Data Mining, Part 14.6: Custom Mining Functions

SQLServerSteve from SQLServerCentral Blogs

by Steve Bolton …………In the last installment of this amateur series of mistutorials on SQL Server Data Mining (SSDM), I explained how to... More »


 

From the SQLServerCentral Blogs - Decrypting Stored Procedures Thanksgiving Special:Quick Tips

Bill (DBAOnTheGo) from SQLServerCentral Blogs

Update: Thanks for your response Jon Gurgul! I have updated the files to reflect your updates. It's faster and cleaner... More »

Question of the Day

Today's Question (by Steve Jones):

In SQL Server 2014, the technology code named "Hekaton" refers to what?

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 QOTD, 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 Steve Jacobs):

In SQL Server 2005, is the code segment (a local variable in a stored procedure) below allowed?

DECLARE @a CHAR = 'A'

Answer: No

Explanation:

Answer: No

Before SQL Server 2008, inline declaration and setting of local variables are not allowed.  You have to DECLARE and then SET the variable.   SQL Server 2008 and greater allows you to perform this operation.

The error returned is:

Msg 139, Level 15, State 1, Procedure [xxx], Line 0

Cannot assign a default value to a local variable.

...

SQL 2000 and SQL 2005

DECLARE @a CHAR

Set @a = 'A'

SQL 2008 and greater

DECLARE @a CHAR = 'A'

DECLARE and SET (SQL Server 2005):

http://technet.microsoft.com/en-us/library/ms188927(v=sql.90).aspx

DECLARE and SET (SQL Server 2008 (and greater)):

http://technet.microsoft.com/en-us/library/ms188927(v=sql.100).aspx

http://www.sql-server-helper.com/error-messages/msg-139.aspx


» Discuss this question and answer on the forums

Featured Script

Disk Capacities

Nicholas Williams from SQLServerCentral.com

Hey Guys,

This script will provide information on the drive capacities, in the form of total volume, used space, free space and then a percentage of used space.

Assuming that it is being executed on Windows Server 2003+ and the user calling it has permissions to run xp_cmdshell it should run without a problem

The script uses a built in tool present in Windows Server 2003 onwards, however this utility can be downloaded and deployed on other Windows Server operating systems. (Such as Windows Server 2000)

Hope you guys find it usefull!

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

Limit DB access outside application - We have applications connected to SQL using windows authentication. While having connection with Application user can also access to Database...


SQL Server 2014 : Development - SQL Server 2014

How to call procedure from function. Getting error Invalid use of side-effecting or time-dependent operator in 'INSERT EXEC' within a function. - Hi! I am trying to call procedure from function but getting following error. Invalid use of side-effecting or time-dependent operator in 'INSERT...

Query performance - Some of developers have made modifications to database structure like indexes and later observed that the performance of queries have...

Conditional where - I need two tables to query together, but not if the value is blank(it is empty, not NULL) so I...


SQL Server 2012 : SQL 2012 - General

AlwaysOn AG for DR - Hi everyone. I have a design question about SQL Server 2012 AlwaysOn availability groups when used for DR purposes. I built...

SQL Server Audit empty fields - Hello Everyone I was requested to research about a good way to audit our prod databases. I started creating an Audit...

Change SQL Server 2012 Collation - Hi How to Change Server Level Collation in SQL Server 2012 Stan Edition after installation? -- Ragu Thangavel

How to execute sqlcmd - Hi All, I am running below command in sqlcmd but it is not giving any message just line numbers. sqlcmd -i C:\MyFolder\MyScript.sql...

DNS Aliasing, Reporting Services, and Kerberos - We're setting up DNS Aliasing on one of our SQL Servers, but I'm unable to get Kerberos to work from...

SQL SERVER 2012 MIGRATION FROM 2005, Help needed!! - Hi All, We are planning to migrate to SQL Server 2012 from 2005. We are in the initial process of building...

AOAG: Node doesn't have a vote - When setting up my AOAG (primary + one secondary), I chose the "Node + File share witness". However, I get warnings that my...

Joining database to an existing Availability Group - TSQL - Hi - I have workingSQL 2012 availability group with 2 databases.. It works like a champ. So, I'm trying to add another...


SQL Server 2012 : SQL Server 2012 - T-SQL

Issue with String concatenation need help please - Dear friends, i have 8 fields - and I have requirement to concatenate using '+' operator with semicolon delimiter but issues is in...

Error while executing a function - SQL Fellows, I am getting one error below which says A SELECT statement that assigns a value to a variable must not...

Row_Number over partition Help - Hi there i am having problems getting my last revision number out when i am trying to use inner joins...

Read XML data with related attributes/properites - Hi Team , i have a table with one of the column of xml type. the column contains xml like given...

Split string into Columns based on Special Character - Hi, Can anyone help me get the required result in SQL 2012 Create table DBInfo (Path varchar (500)) Insert into DBInfo values('/Data Sources') Insert...

Slow Query Issue... - Hi All, I'm posting a query that is troubling me. The query is taking 3-4 mins and [i]not exists[/i] part...

SQL CLR Assembly - We use a SQL assembly to make web calls. We have 1 assembly with a few dozen functions, all use...


SQL Server 2008 : SQL Server 2008 - General

Auditing a SQL Server Environment - Hi I've been tasked to audit a number of SQL Server environments. I'm going to be creating baseline documentations for each environment,...

SQL code - Hi All, Can someone help me interpret what this code is doing. open_date BETWEEN DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) - 1, 0) AND DATEADD(mm,...

SQL Orphan login issue - I copied database from Prod to Dev instance. Whe the database was restored I ran -----See if there are any...

Column properties of table variables - When I need to know the properties of a column, I can query sys.columns for a given object_id and name....

Report Manager in Sql Server 2008r2 - Hi Guys, I am new to Sql Server 2008 r2 reporting service. in installed sql server 2008 r2 in windows xp...

dateformat need - Hi Friend i have small doubt in date format in sql server in my table having data like date(dd/mm/year) and...

Learning SSIS and SSRS - Hi all I've just got a new job as a developer (my T-Sql skills are quite good) but one of the...

SUBSTRING and CAST Help Required - Hello, I have a unique column in a database called ID as varchar This column contains data in such format as: [font="Courier...

Backup - Hi I am new in sql server. I am confused with the backing up process ,when we do a Diff. backup does...

View all table Change Data Capture - Hi All Experts, I have query regarding CDC and Auditing. I have enables both in the server , however I like to...

Condition in a Where clause? - Hi Not sure if I titled this correctly but what I want to do is add a condition in a where statement...

SSRS, export to Excel to fit into single page, Report Properties margins or local Excel Margings, who takes over?? - Hi, Ultimately I want to have report with email subscription to fit into single page, tried it all changing Margins in...

asp.net - multiple inserts many primary keys and scope_identity - Hello This is working but my site will be hit by many users soon. Just need your opinions. I have a .NET...

SSRS Subscription - Which User Set it Up? - Hi all, we have a generic login that we use to create all of our report subscriptions. There is a subscription...

sql restore error - Dear all, I'm trying to restore an SQL Server database from one server to another but I get the following error: The...

Restriction on Primary key - There is a restriction that we must have only one primary key per table. We can have composite primary key...

Querying SSAS with TSQL - I'm trying to query against cube data and can't figure it out. My DB and Analysis Server are on the same...

Generate Index only scripts for whole DB - Is there a way to generate only the indexes for an entire DB. If I right click the DB and...


SQL Server 2008 : T-SQL (SS2K8)

Triggers for insert,update,delete in MSSQL - I am working on triggers for insert,update and delete output of the trigger shows tablename,user and timestamp Is it possible to display...

How to Show time in my table? - Hi Friends, My Table strct: =========== create table show_bus ( id int identity, from_p varchar(100), to_p varchar(100), timin time ) My Expecting OUTPUT: ================ insert into show_bus values('a','b','6:05 AM') when i tried to...

Dropping thousands of tables programmatically? - Hi all I have been tasked with a requirement to drop around 500,000 tables from a data warehouse. The application was...

Weighted Average Sales by Customer - advice/strategy - We are a company that sells items and ships them in bulk. I am tasked with making a report in SSRS...

Using a Stored Proc to schedule a job - Can you use a stored proc to schedule a job? What I would like to do, is that when you...


SQL Server 2008 : SQL Server Newbies

Tabledesign (newbie) - Hello, I am creating a simple database to log the number of visits from clients. The table is as follows : tbl_statistics -------------------------------------------------- p_key...

Sql Select statement running slow - Hi I have a select statement that runs forever because of 'Select Distinct' and it makes tempdb grow very large due...

sp_send_dbmail; one record at a time - Hello All, I am using dbmail to send out the results of a query. The results are being sent to SMS...

Help with multiple events per user on Same day query - I have to create a report that tells us if a Patient has had a Behavioral Health visit and a...

Select top X for each multiple item in column - I have the following script: SELECT dbo.HemAnimal.AniUserNumber, dbo.HemAnimal.AniResponderNumber, dbo.PrmDeviceVisit.DviStartTime, dbo.PrmDeviceVisit.DviEndTime, dbo.PrmDeviceVisit.DviMilkVisit, dbo.PrmDeviceVisit.DviFailure, dbo.PrmMilkVisit.MviLFTeatWidth, dbo.PrmMilkVisit.MviLRTeatWidth, dbo.PrmMilkVisit.MviRFTeatWidth, dbo.PrmMilkVisit.MviR

Difference between Now() and Today() - Hi Please explain the Difference between Now() and Today() functions in SSRS reports. Are they both same or different..??

how to maintain test environment - Hi all, I was asked to create a test environment for one of our apps that is supported by 3 databases. I...

SQL Select statement - [code="sql"] SELECT C.containerCode + ':' + C.containerName as display, C.containerCode AS code FROM Containers C INNER JOIN ContainersTypes CT ON CT.containerTypeSqlId = C.containerTypeSqlId AND CT.containerTypeIncId = C.containerTypeIncId WHERE C.isDeleted = 0 ORDER BY display [/code] Hi I...


SQL Server 2008 : Security (SS2K8)

Antivirus on large SQL Server instances - All, I'm having an issue where my current antivirus vendor is having issues when scanning my larger sql server machines....

PDF virus threat - Hello An application that sits outside of our network will allow the user to store pdf files on the database. The concern...


SQL Server 2008 : SQL Server 2008 High Availability

after removing last node from cluster - uninstall from node?? - I am uninstalling and reinstalling SQL Server 2008 R2 on a cluster. Instructions on how to uninstall from a cluster...

SSRS - Reports-web content Deletion in SQL Server 2008 R2 - Hi Guys, I am new to Sql Server 2008 r2 reporting service. in installed sql server 2008 r2 in windows xp...

TRANSACTION LOG COPY JOB FAILED IN LOGSHIPPING - Hi All, I am facing copy job failed error in log shipping. when i configured logshipping backups are occurring normally,...

SqlServer 2008 cluster adding RAW disks VMWARE - We have a sql server 2008 custer on Wndows server 2003 virtualized using VMWARE We are in the process of adding...

Moving TempDB of the Cluster Resource - I've got a client that wants to install local drives on both nodes of their cluster and move TempDB from...


SQL Server 2008 : SQL Server 2008 Administration

Moving a database log file when recovery model is Simple - Last night I needed to relocate some database log files to a drive with more space. When I attempted to...

Resource Govenor - I am trying to limit the CPU on one of my databases. On a test machine I have created the...

Backup/restore full + differential - Hi all, we are upgrading an application, and I need to backup two quite big databases, and restore them to...


SQL Server 2008 : SQL Server 2008 Performance Tuning

procedures used - Hi Experts, we have a list of procedures used when accessing a particular application. Is there anyway to check how long this...

Hit on DB from a User - Hi Experts, We have a DB user names Supply . Application will hit the DB with this username. Is there anyway to...


SQL Server 2005 : Development

Android Tutorials - Hi All, I am new to android development. Can you please to some good references having step by step tutorials for...


SQL Server 2005 : SQL Server 2005 General Discussion

error while running test mail - Hi, I have sql 2005 installed and database mail has been set up. all the parameters have been correctly entered. however...

Is this good practice for using a view? - We have a large lookup table with 200k records. This table is used frequently in a high volume database. We...

SQL trigger - We are using a CRM system and I have had trouble creating a trigger that would automatically update another field...

Database Password Protected - Hello , please can u tell me how to make my sqlserver 2005 database password protected. i make a database and i...


SQL Server 2005 : SQL Server 2005 Integration Services

ordering dynamic column string - hi i am trying to create a set of dynamic date columns (year - monthname). When i create the temp table of...


SQL Server 2005 : T-SQL (SS2K5)

unpivot dynamic columns - hi i have a table which i need to unpivot. It is always in 2 year ranges (months) so looks something...

executing dynamic sql string - hi (me again) i'm trying to get a proc to execute by passing in a dynamic sql string. this works... [code="sql"]exec [MediaCreateCustomerDataSet] @accountId,...

java.sql.SQLException: Warning: Fatal error 824 occurred at Dec 5 2013 10:11AM. Note the error and time, and contact your system administrator. - java.sql.SQLException: Warning: Fatal error 824 occurred at Dec 5 2013 10:11AM. Note the error and time, and contact your system...

NTEXT data truncated when run from an Server Agent Job - I am mystified by a problem when handling NTEXT data in SQL Server 2005 SP3. I often have to query...


Reporting Services : Reporting Services

$Project varialbes? - I'm following a course in SSIS from PluralSight. In one module, an Execute Package task references a variable in the...

Delcare variable for Multiple values paramter in SP ??? - Hi i get an error when I show multiple values in the parameter Do I declare the variable differently in the...

Dynamically "change" TextBox names for detail row when Globals!RenderFormat.Name = "CSV" - Scenario: Multiple reports that have changing column labels based on who is running the report. That part works great for rendering...

Internet Explorer cannot display the webpage - Hello, my user has a SQL Server Reporting Service problem. Windows 2003 Standard x64 Edition Physical memory : 33GB SQL Server 2008 Standard Edition,...


Reporting Services : Reporting Services 2008 Administration

Reporting services - Data Sources - Folks: We have a report which runs fine if in our data souce we select 'Credentials stored securely in the report...

RDL File Replication - Is it possible to automatically replicate rdl files across multiple servers? I know the individual files can be manually downloaded...

Backing up Reporting Services on another server - Hi, I am running reporting services on Server A. I want to back up and restore the reporting services on Server...


Reporting Services : Reporting Services 2008 Development

Category groups in Charts - Hi , I am trying to get different color bars for column chart. How ever , my fields are both in Category groups...

Sorting and filtering on a line graph doesnt work ssrs - I need to create a line graph which shows top 10 Products which have made the highest sales for the...

PDF Printing issues - Hi I have a report with a number of sub reports, one of the sub reports contains a graph. The...


Programming : General

How to insert time with AM,PM in my Table? - Hi Friends, My Table strct: =========== create table show_bus ( id int identity, from_p varchar(100), to_p varchar(100), timin time ) My Expecting OUTPUT: ================ insert into show_bus values('a','b','6:05 AM') when i tried to...


Data Warehousing : Integration Services

SSISDB backup not working - Gone to back up the SSISDB and get a message 'system.data.sqlclient.SqlError: Cannot open backup device C:\.... ' Operating system error 5(Access...

Need to execute 39 (as of today) Stored procedures and output each to a pipe delimited file - All the procs work of a Start and End date. I was wondering if anyone had a ingenuous way to...

Need help in confiruring a ssis package - Hi, all I am new to ssis and I want some info on how to create a ssis package here...

import .xlsx file to SQL 2008 - I know there are many pages giving the steps and i've tried everything. I've used following steps in the connection: Microsoft.ACE.OLEDB.12.0...

dtexec utility failing for package - I've created a package to load xls file to my DB table. While running the package from BIDS, it's running...

Maintain Delete flag in target table - Hi, I am pulling records from source table and inserting into target table. this is incremental load. If new records found...

Using SQL command from variable in Data flow task - Hello, Here is my requirement. I need the ability to use one of the below two queries in my oledb command...


Data Warehousing : Strategies and Ideas

Using OLTP as datasource over creating an OLAP - Hi all Im moving to a new company to be there BI specialist. doing some research on best practices and looking...

What tool to document the data warehouse and/or cubes for our end user community? - Dear all, Like many, we built a data warehouse (datamart?) and a set of cubes and we'd like our users to...


Data Warehousing : Analysis Services

Reporting Help (Excel, SSRS, MDX) - I have built my first cube and I believe it is setup properly but I am having hard time wrapping...

Unique Identifier Format... - There are two Cube Databases in the same server with identical schema. In than we have created a ProjectID dimension on...


Database Design : Design Ideas and Questions

Avoiding Large Number of db Columns in SQL Server - Database Redesign - I'm working on a database table in SQL Server 2008, which is the backend for a Classic ASP application. I...


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


SQLServerCentral.com : SQLServerCentral.com Website Issues

Can't subscribe to 2014 forums RSS in Feedly - It could definitely be a Feedly issue, but I can't subscribe to the 2014 forums. Feedly says "Access Denied". All the...


Career : Job Postings

Need a SQL DBA in in NW Philly ASAP - I have a client seeking a SQL DBA experienced with optimization, data exchange and T-SQL queries in the NW Philly...

This email has been sent to {user_email}. 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