Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag DBA Rss

   Items 1 to 20 of 22    Next 20 >>
 

Guide To MCITP: SQL Server 2008 Administration

Find out what you need to learn for the SQL Server 2008 Administration certification exams.  Read more...
By Mike McQuillan 2011/08/05 | Source: SQLServerCentral.com | Category: mcts
Rating: |  Discuss |  Briefcase | 6,693 reads

sp_who3

A compatibility view for DBAs used to using sp_who2  Read more...
By gerhard-356547 2011/08/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 2,090 reads

Part 1: The Database Administrator's Primary Responsibility

SQL Server Essentials Part 1: A look at the key responsibility of a DBA and why it is so vital.  Read more...
By John Sansom 2011/04/22 (first published: 2009/09/14) | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |  Briefcase | 23,363 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 0001/01/01 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |  Briefcase | 6,721 reads

End of October Free Training from PASS Virtual Chapters

This wraps up the last of the free training the PASS Virtual Chapters are providing in October.  Read more...
By Aaron Nelson 2010/10/25 | Source: SQLServerCentral.com | Category: free training
Rating: (not yet rated) |  Discuss |  Briefcase | 870 reads

Another sp_who3

Get processes run and the command.  Read more...
By Kristian Ask 0001/01/01 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |  Briefcase | 3,818 reads

Late September Free Training from PASS VCs

The DBA and Virtualization Virtual Chapters hope that last weeks 24 Hours of PASS got you in the mood for more free training. Here's what they have on tap for you this week:   Read more...
By Press Release 2010/09/21 | Source: SQLServerCentral.com | Category: pass
Rating: (not yet rated) |  Discuss |  Briefcase | 703 reads

Another sp_who3

Get processes run and the command.  Read more...
By Kristian Ask 0001/01/01 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |  Briefcase | 3,818 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 2,428 reads

The Sixty-Second Guide to becoming a SQL Server DBA

So you want to be a DBA, but don't know where to start learning what you need to know? R. Barry Young brings you a sixty second guide for how to get moving.  Read more...
By RBarry Young 2009/12/04 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |  Briefcase | 16,209 reads

Interview with the Scary DBA – Grant Fritchey

With Halloween so near, we thought it would be a good time to find out more about the so-called Scary DBA, Grant Fritchey, who's been working in IT for 20 years now. He writes for SQL Server Central, Simple-Talk and SQL Server Standard, and was awarded MVP status earlier this year. We sent Richard Morris to meet him.  Read more...
By Additional Articles | Source: SimpleTalk | Category: interviews
Rating: (not yet rated)  Rate this |  Briefcase | 150 reads

The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?

Today we have a guest editorial from Rodney Landrum. Rodney and his team of DBAs manage 110 active servers, throughout a regionally dispersed organization. How many DBAs would you expect to be on Rodney's team...?  Read more...
By Rodney Landrum 2009/10/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |  Briefcase | 308 reads

PowerShell 101 for the DBA – Installing PowerShell

Many DBAs have heard about the new scripting technology from Microsoft, but have yet to really dive right in. You...  Read more...
By Joshua Jones 2009/09/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |  Briefcase | 1,801 reads

Part 1: The Database Administrator's Primary Responsibility

SQL Server Essentials Part 1: A look at the key responsibility of a DBA and why it is so vital.  Read more...
By John Sansom 2011/04/22 (first published: 2009/09/14) | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |  Briefcase | 23,363 reads

The DBA as Detective: Troubleshooting Locking and Blocking

Rodney Landrum describes in his own unique style how he, as a working DBA, goes about troubleshooting problem queries, and investigating various types of locking and blocking problems. In the process, he passes on valuable tips learned from practical, and sometimes stressful, experience.  Read more...
By Additional Articles 2009/09/02 | Source: SimpleTalk | Category: dba
Rating:  Rate this |  Briefcase | 5,504 reads

DBA: Mentor vs. Protector

To mentor or to protect data, what is the role of the DBA? A guest editorial from Matt Simmons.  Read more...
By Matt Simmons 2009/08/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |  Briefcase | 200 reads

What's Your Ideal DBA Job?

Brad engages in a little Summer daydreaming, and wonders what the Ideal DBA job would look like...  Read more...
By Brad McGehee 2009/06/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |  Briefcase | 319 reads

The Disappearing DBA

During a "difficult period", a developer often sinks from view. When things are going well, suddenly they are the gunslinger, the hotshot. The DBA often looks on wistfully. For him, the "fame trajectory" seems to work in reverse.  Read more...
By Tony Davis 2009/04/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |  Briefcase | 1,047 reads

Function to Add Leading 0's (Zeros) to an INT

Very simple function code to add leading zeros to a passed in int for a length also passed.  Read more...
By Joshua A. Walker 2009/03/05 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |  Briefcase | 1,478 reads

Do You Verify Your Database Backups?

Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.  Read more...
By Brad McGehee 2009/02/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |  Briefcase | 644 reads
   Items 1 to 20 of 22    Next 20 >>
 
Tags
administration (5)    
editorial (5)    
miscellaneous (3)    
free training (2)    
sql server 2008 (2)    
advanced querying (1)    
appdev (1)    
archive file (1)    
archiving (1)    
backup / restore (1)    
becoming a dba (1)    
bi (1)    
blogs (1)    
career (1)    
certification (1)    
columns (1)    
data (1)    
data warehousing (1)    
database weekly (1)    
date (1)    
function (1)    
interviews (1)    
learning (1)    
locking (1)    
maintenance and management sql server 2005 (1)    
mcitp (1)    
mcts (1)    
pass (1)    
performance monitoring (1)    
powershell (1)    
primary responsibility (1)    
script (1)    
skills (1)    
sql server 2008 r2 (1)    
stored procedures (1)    
tables (1)    
time (1)    
troubleshooting (1)    
t-sql (1)    
virtual chapters (1)    
virtualization (1)    
warehouse (1)