SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

What is your definition of a DBA?

Today we have a guest editorial as Steve is traveling to the UK.

OK, I know the easy answer is a Database Administrator, but what role is that?  If you had to describe it to a non-technical person what would you say?  There are many different roles and functions a DBA can have.  Some of the roles or functions I have seen / done are: installing SQL Server, managing server performance including disk space utilization, managing backups, controlling access and user’s rights/roles, managing replication and always-on / multiple failover clusters and performance tuning/indexes, sql jobs, alerts, database mail, releasing db scripts.  I think these could be described as core DBA responsibilities.

I have also seen, depending on the size of the company you work for, some DBA’s have some additional responsibilities.  Things that might be described as more database developer such as creating tables, views, functions and stored procs.  Or things that are more in the data architect realm, such as database design, schema, normalization of tables, keys and indexes.  Sometimes, a DBA might manage the SSIS packages that bring data in and/or out of the database.  Other times they might need to do some reporting perhaps using SSRS or other reporting tools.  As you move more into the BI landscape, there may be data warehousing and ETL packages to manage.  I am sure there are other aspects of being a DBA that I have missed.

In my previous job I was hired as a .net developer that also did database development.  It was a very small shop and I was the one with the most database experience.  Before I knew it I was installing sql server, setting up backups and managing sql server performance and more.  I spent nine years at that job, where about two thirds of my job was doing DBA, database architect or database developer work either for the company I worked for or for their clients.  No one really asked me to do it, I just jumped in as I saw the need.

Now there are some people out there that aim to do the minimum at work.  They are just skating by trying to stay under the radar.  These people, when they are DBAs, are probably doing an adequate job.  The database servers are running etc., but this is not how I would want to define a DBA.  I think one thing that defines a good DBA, is someone who is willing and ready to jump in and go above and beyond their job description.  They are managing their core responsibilities, but are also willing to lend a hand at some of the other aspects mentioned above that could be considered DBA work.  They are not afraid of learning / trying something new.  They are team players that want to see a project succeed and they are willing roll up their sleeves and get their hands dirty in the process.

How would you define a DBA?  What roles and responsibilities do you currently have at your job?

Ben Kubicek from SQLServerCentral.com

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


How might classification and better documentation improve data safety?

SQL Atlas is the latest prototype to come from the Redgate Foundry - find out more about what the tool does and try out the interactive demo for yourself. Try the free prototype

Redgate Hub

Stop your database being a bottleneck

The new Redgate Hub is the shortcut to the latest insights into database development. Constantly updated with invaluable content, it’s the one resource you need to solve problems, share ideas, discover new tool features, and expand your database skills. Discover the Redgate Hub

Featured Contents


Azure DWH part 15: PolyBase and Azure Data Lake

Daniel Calbimonte from SQLServerCentral.com

In this article, we will learn how to query a csv file stored in the Data Lake using PolyBase. More »


Register for the Redgate Hub Launch Livestream on September 6

To celebrate the launch of the new Redgate Hub, Data Platform MVP Steve Jones is hosting an educational livestream event alongside the team at Redgate HQ. They’ll introduce you to everything the Redgate Hub has to offer by highlighting some recent technical articles and how-to guides with in-depth live presentations. Register now. More »


Introduction to Azure Cosmos DB

Additional Articles from Database Journal

Azure Cosmos DB is the latest data service offering from Microsoft. Azure Cosmos DB is a super set of DocumentDB and provides a new set of capabilities. These capabilities make Azure Cosmos DB stand out from other members in the NoSQL database family. More »


From the SQLServerCentral Blogs - SQL Server vs Oracle: Substring

Daniel Janik from SQLServerCentral Blogs

Continuing the comparison between these two database giants, we dive into the substring function. If you’ve been working with databases... More »


From the SQLServerCentral Blogs - Power BI Custom Visuals Class (Module 65 – Visio Visual)

Devin Knight from SQLServerCentral Blogs

In this module you will learn how to use the Visio Visual Custom Visual.  The Visio Visual allows you to... More »

Question of the Day

Today's Question (by Carlo Romagnano):

From BOL "Temporary tables are automatically dropped when they go out of scope, unless explicitly dropped by using DROP TABLE". In fact, the first batch returns error: Msg 208, Level 16, State 0, Line 4 Invalid object name '#t'.

What does the second batch return? (select 2)

-- first batch
drop table if exists #t
execute ('create table #t (i int, z int)')
select * from #t
-- second batch
drop table if exists #t
create table #t (i int)
execute ('alter table #t add z int')
select * from #t

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: T-SQL.

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


Expert T-SQL Window Functions in SQL Server

Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

Today is Labor Day in this US. This holiday was first designated as an official federal holiday in 1894. What is the unofficial name?

Answer: The unofficial end of summer


This was always an end of summer holiday for me as a kid. School usually started the day after Labor Day for me.

Happy Labor Day.

» Discuss this question and answer on the forums

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

SQL Server and SSAS together in the box - I have a server where SSAS and SQL instances are running in the same box. SSAS activity usage seems to...

Filegroup status - Hi, Does anyone know a way to check a filegroups status to see if it has been restored and is online. We...

Sql 2016: ssrs home page blank - hi i have setup sql 2016 ent, its fully patched with Cumulative updates etc. SSRS has been configured and setup, but...

moving from tx replication to ao/ag possibly without fci.... - hello, we are due to upgrade our production cluster within the next 6 months and have been advised by our hosting...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

How to move / Archive filestream Files from one directory to another directory using SQL SCRIPT? - Hi Every one. I need a help! I am new to this File table's files stream concept and I have a requirement...

SQL Server 2014 : Administration - SQL Server 2014

failover cluster & windows cluster difference - Hi Teams, can you please explain me briefly below questions .fail over cluster & windows cluster difference   . Tempdb enhancements in SQL Server...

AG Listener creation failed - Hi Folks, I'm using the following script to create AG listener. But it failed. Error has been attached. Any thoughts on...

SQL Server 2014 : Development - SQL Server 2014

Determine Monday of next month and Monday of next week - I am trying to determine the first Mondayof the next Month when the first Monday of this month has passed....

SQL Server 2012 : SQL 2012 - General

Remote query gets killed after ten minutes - Hello We have a server with sql server 2012 SP3 CU5, when we run a query directly at the server it...

To automatically change the value of a column if a particular date time is reached - Hi, I am using SQL Server 2012 Express Edition. I need to automatically change the value of status field to "2"  if...

How to list all database Users without Logins - Hello, Can some one provide me script to list all database users which are not having logins? I want to  sync...

SQL Server 2008 : SQL Server 2008 - General

Update Statistics.. - Hi Experts, Trying to figure out if it might help in solving any performance issues by introducing an additional manual update...

SQL Server 2008 : T-SQL (SS2K8)

3-level reporting hierarchy. - Hi I have a requirement where I need to get employees managers up to 3 levels. (Example : A(Employee) -> B(Manager 1) ->...

Slow queries during busy times - We have a SQL 2008 Enterprise Edition server with 32 GB of memory and 16 CPU. During quiet times of the...

Reporting Services : SSRS 2014

SSRS Default dates if statement - Hi all, Is there a way I can make reports default to a date via some kind of iff statement? What...

Data Warehousing : Integration Services

ADO.NET Schema Rowset Enumerator Locking Excel file - Hello my internet peers, As I know many of you have, I've grown quite fond of using the ADO.NET Schema Rowset...

Data Warehousing : Analysis Services

MDX IIF statement over a period - Hi, I Intend to set a flag 'Yes' Or 'No' if a part was last month or not.... I first tried to...

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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com