Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag DBA Rss

   Items 1 to 20 of 43    Older >>
 

Query to find tables with Forwarded Records

Use below query to find tables that need to be optimized based on number of forwarded records.  Read more...
By Ajay Dwivedi 2016/06/16 | Source: SQLServerCentral.com | Category: optimization
Rating: |  Discuss |   Briefcase | 428 reads

What Does a DBA Do?

Today we have a guest editorial from Andy Warren as Steve is away. Andy tries to define what a DBA really does in a way that might make sense to others.  Read more...
By Andy Warren 2016/05/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 201 reads

Get IP Addresses of all Hostnames using SQL Server

To get the IP addresses of Multiple hostnames from below stored procedure.  Read more...
By Sumit Agarwal 2015/10/12 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |   Briefcase | 4,203 reads

The New DBA

Steve Jones has a new take on what it means to be a DBA.  Read more...
By Steve Jones 2015/06/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 295 reads

The Stress of a Former DBA

Rodney Landrum impresses on his audience the importance of attention to the finer details, during data analysis and reporting.  Read more...
By rodneylandrum 2015/06/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 192 reads

DevOps and the DBA

Michael Fal is a huge advocate of automation and many ways it can improve the lives of developers and DBAs alike, but you can’t just automate all your problems away. The real challenge is breaking down barriers and having developers and DBAs functioning smoothly together. You may have heard of DevOps, and so Mike explores what the buzz might mean for database administrators.  Read more...
By Additional Articles 2015/05/20 | Source: SimpleTalk | Category: devops
Rating:  Rate this |   Briefcase | 7,665 reads

Five Rules For Successful Conversations With DBAs

As a developer working with SQL Server, you'll need to work with DBAs at one point or another. Here are some easy ways to make those conversations go smoothly.  Read more...
By Joshua Feierman 2015/04/10 (first published: 2013/09/24) | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |   Briefcase | 17,990 reads

Managing Big Data DBAs

Technical support teams usually support familiar hardware and software configurations. Specialization in particular combinations of operating systems and database management software is common, and this allows some team members to gain in-depth experience that is extremely valuable in an enterprise IT setting. How has big data changed this paradigm?  Read more...
By Additional Articles 2014/08/04 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 10,558 reads

DBAs and the Fear Factor

Louis Davidson on why DBAs ought to do one thing, every day, that is scary.  Read more...
By Louis Davidson (@drsql) 2014/07/07 | Source: SQLServerCentral.com | Category: dba
Rating: (not yet rated) |  Discuss |   Briefcase | 164 reads

Never Stop Learning

A successful career in DevOps requires continuous education.  Read more...
By Andy Leonard 2014/06/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 340 reads

Call Me, Maybe

Rodney Landrum on his week of responding nicely to unsolicited sales calls.  Read more...
By Rodney Landrum 2014/04/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 113 reads

Five Rules For Successful Conversations With Developers

In this piece, Josh follows up on his earlier article about smoothing DBA/Developer interactions, this time from the side of the developers.  Read more...
By Joshua Feierman 2014/02/07 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |   Briefcase | 8,436 reads

Find Text in all columns of all tables in a Database

Will find the Table Name, Column Name and the number of occurances some text appears in a database.  Read more...
By Joshua A. Walker 2013/12/20 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,536 reads

Five Rules For Successful Conversations With DBAs

As a developer working with SQL Server, you'll need to work with DBAs at one point or another. Here are some easy ways to make those conversations go smoothly.  Read more...
By Joshua Feierman 2015/04/10 (first published: 2013/09/24) | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |   Briefcase | 17,990 reads

What Counts for a DBA: Patience

Technical debt is frustrating but dealing with it requires patience. Louis Davidson explains why.  Read more...
By Louis Davidson (@drsql) 2013/09/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 115 reads

The Big Data DBA

Many IT enterprises are starting pilot projects to implement big data solutions. This article highlights what you need to know to check if you're ready to support these efforts, and integrate them into your current architecture, processes, and standards.  Read more...
By Additional Articles 2013/08/02 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 3,325 reads

Get IP Addresses of all Hostnames using SQL Server

To get the IP addresses of Multiple hostnames from below stored procedure.  Read more...
By Sumit Agarwal 2015/10/12 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |   Briefcase | 4,203 reads

What Counts for a DBA: Amnesia

Louis Davidson explains why DBAs often need a healthy dose of selective, enforced amnesia about the pain of previous failures.  Read more...
By Louis Davidson (@drsql) 2013/01/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 137 reads

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.  Read more...
By Nakul Vachhrajani 2012/09/17 | Source: SQLServerCentral.com | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,315 reads

The Ego, the Id and the DBA

In most organizations, the DBA team is seriously outnumbered by headstrong developers and clock driven managers, and "great" DBAs will often be outnumbered by...well...the not so great. In order to be heard in this environment, a DBA will not only need to be very skilled, but will also need a healthy dose of ego.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 186 reads
   Items 1 to 20 of 43    Older >>
 
Tags
editorial (15)    
database weekly (8)    
administration (6)    
miscellaneous (3)    
big data (2)    
career (2)    
communication (2)    
free training (2)    
sql server 2008 (2)    
advanced querying (1)    
appdev (1)    
archive file (1)    
archiving data (1)    
backup and restore (1)    
becoming a dba (1)    
best practices (1)    
bi (1)    
blogs (1)    
certifications (1)    
columns (1)    
data (1)    
data warehousing (1)    
date (1)    
dba skills (1)    
developer (1)    
developers (1)    
devops (1)    
education (1)    
forwarded records (1)    
function (1)    
interviews (1)    
it operations (1)    
learning (1)    
locking (1)    
maintenance and management (1)    
mcitp (1)    
mcts (1)    
nightly jobs (1)    
optimization (1)    
pass (1)    
performance monitoring (1)    
powershell (1)    
primary responsibility (1)    
script (1)    
skills (1)    
sql server 2008 r2 (1)    
sql server agent (1)    
stored procedures (1)    
system tables (1)    
tables (1)    
time (1)    
troubleshooting (1)    
t-sql (1)    
virtual chapters (1)    
virtualization (1)    
warehouse (1)