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

Content with tags Administration, DBA Rss

   Items 1 to 6 of 6   
 

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,281 reads

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 | 8,447 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,969 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,733 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,330 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,570 reads
   Items 1 to 6 of 6   
 
Tags
sql server 2008 (2)    
advanced querying (1)    
best practices (1)    
certifications (1)    
data (1)    
data warehousing (1)    
learning (1)    
maintenance and management (1)    
mcitp (1)    
mcts (1)    
miscellaneous (1)    
nightly jobs (1)    
skills (1)    
sql server 2008 r2 (1)    
sql server agent (1)    
stored procedures (1)    
system tables (1)    
troubleshooting (1)    
t-sql (1)    
warehouse (1)