<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tags
Administration
,
DBA
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,228 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,225 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,757 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,635 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,303 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,540 reads
Items 1 to 6 of 6
Tags
sql server 2008
(2)
advanced querying
(1)
best practices
(1)
certification
(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)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
