SQL Clone
SQLServerCentral is supported by Redgate
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,343 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,522 reads


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 | 3,059 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,852 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,364 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,598 reads
   Items 1 to 6 of 6   
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)