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

Content with tag administration Rss

<< Newer    Items 61 to 80 of 1494    Older >>
 

Eight Steps to Effective SQL Server Monitoring

If you need to start monitoring your SQL Server instances and database, and there are many good reasons to do so, Tony Davis gives you the eight essential steps to diagnosing problems quickly.  Read more...
By Additional Articles 2013/08/26 | Source: SimpleTalk | Category: monitoring
Rating:  Rate this |   Briefcase | 4,429 reads

Clean Data

By Dave 2013/08/20 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,997 reads

Upgrading the GIS application and database.

In this article I will mention a specific issue that I experienced during my last GIS application and database upgrade.  Read more...
By Hilda E 2013/08/20 | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 3,407 reads

SQL Server System Report

Report to keep you abreast of various details of an instance, including: general properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more...  Read more...
By Sean Smith 2013/10/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,681 reads

User Defined Server Roles

By Steve Jones 2013/08/09 | Category: server roles
Rating: (not yet rated) |  Discuss |   Briefcase | 1,523 reads

DBCC CHECKDB

By Steve Jones 2013/07/31 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,251 reads

TDE Setup

By Steve Jones 2013/07/26 | Category: encryption
Rating: (not yet rated) |  Discuss |   Briefcase | 1,601 reads

The Ultimate Index Width Stats Reporter

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.  Read more...
By Jesse Roberge 2013/07/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,181 reads

The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)

Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.  Read more...
By Jesse Roberge 2013/07/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,565 reads

Long Running Jobs Monitor

Script to be executed every 60 minutes as a job to determine long running jobs.  Read more...
By Gregory Ferdinandsen 2013/07/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,203 reads

Orphaned Distribution Transactions

Learn about orphaned distribution transactions in SQL Server and how you can clear them.  Read more...
By Shashank Srivastava 2013/07/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,562 reads

Ordering steps in a SQL Agent job

Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is...  Read more...
By Kenneth Fisher 2013/07/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 959 reads

List orphaned users from all databases

The script returns all orphaned database users across a SQL Server.  Read more...
By James Howard 2013/07/15 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 3,808 reads

Show Database and Log sizes, free space and location

This script helps to identify which database/log takes most of the disk space and how much is free.  Read more...
By Leonid Sheinkman 2013/07/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,472 reads

Change Tracking

By Naseer Ahmad 2013/07/10 | Category: change tracking
Rating: (not yet rated) |  Discuss |   Briefcase | 2,471 reads

usp_addcolumns

This is a stored procedure to add a columns to multiple tables, if column doesn't exist  Read more...
By Wilfred van Dijk 2013/07/09 | Category: t-sql
Rating: |  Discuss |   Briefcase | 918 reads

Change the Maintenance Plan Owner

This article shows how you can change the maintenance plan owner in SQL SERVER  Read more...
By Shashank Srivastava 2013/07/02 | Source: SQLServerCentral.com | Category: maintenance plans
Rating: |  Discuss |   Briefcase | 893 reads

Database Backup Restore

By Naseer Ahmad 2013/06/26 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 2,406 reads

The Importance of Reading Comments

Read when you search for help on the internet. You might miss a very important part of what you must do.  Read more...
By Manie Verster 2013/06/10 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 4,837 reads

Get Rid of All Those Pesky 1 MB File Growth DB Files

Use sp_MSForeEachDB to set all 1 MB file growth databases to 10%.   Read more...
By Greg Milner 2013/05/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,298 reads
<< Newer    Items 61 to 80 of 1494    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (100)    
security (64)    
configuring (63)    
miscellaneous (55)    
backup / restore (46)    
performance tuning (45)    
monitoring (39)    
indexing (36)    
strategies (36)    
programming (32)    
maintenance and management (29)    
utility (27)    
maintenance (25)    
sql server 6.5 (25)    
blogs (18)    
database design (18)    
disaster recovery (dr) (18)    
editorial (17)    
stored procedures (17)    
reporting services (ssrs) (16)    
advanced querying (15)    
powershell (15)    
installation (13)    
replication (13)    
visual basic 6 (12)    
dts (9)    
search (9)    
storage (9)    
tables (9)    
backup / recovery (8)    
sql-dmo (8)    
statistics (8)    
transaction logs (8)    
automated dba (7)    
best and worst practices (7)    
career (7)    
database mirroring (7)    
development (7)    
news (7)    
sql server (7)    
sql server 2008 (7)    
sys.dm_db_partition_stats (7)    
auditing (6)    
availability (6)    
dba (6)    
jobs (6)    
recovery model (6)    
shrink database (6)    
sqlservercentral (6)    
tempdb (6)    
worst practices (6)    
ado (5)    
central management server (cms) (5)    
list indexes (5)    
pivot (5)    
policy based management (pbm) (5)    
.net (4)    
auto-growth (4)    
basics (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
encryption (4)    
files and filegroups (4)    
for xml path (4)    
high availability (ha) (4)    
naming standards (4)    
permissions (4)    
restore (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
sql agent (4)    
sql server 2012 (4)    
sys.allocation_units (4)    
system development life cycle (4)    
triggers (4)    
troubleshooting (4)    
administrator (3)    
automation (3)    
configuration (3)    
corruption (3)    
dbcc (3)    
disk space (3)    
distributed queries (3)    
editorial - ipod (3)    
editorial - wmv (3)    
filegroups (3)    
foreign keys (fk) (3)    
integration services (ssis) (3)    
log shipping (3)    
maintenance plans (3)    
networking (3)    
numa (3)    
partitioning (3)    
resource governor (3)    
role (3)    
space usage (3)    
sql server agent (3)    
sqlclr (3)    
state of the business (3)    
transparent data encryption (tde) (3)    
tuning (3)    
advanced (2)    
analysis services (ssas) (2)    
attach (2)    
attach database (2)    
best practices (2)    
browser service (2)    
buffer cache (2)    
capacity planning (2)    
clustering (2)    
columns (2)    
compression (2)    
data compression (2)    
data storage (2)    
database size (2)    
database snapshots (2)    
database weekly (2)    
dbcc checkdb (2)    
ddl (2)    
detach (2)    
dmv (2)    
editorial - mp3 (2)    
error logging (2)    
extended events (2)    
fragmentation (2)    
friday poll (2)    
full text search (2)    
full-text search (2)    
grant (2)    
instant file initialization (2)    
isolation levels (2)    
kill (2)    
lock and connection management (2)    
locking (2)    
logins (2)    
management studio (ssms) (2)    
memory (2)    
migration (2)    
miscellaneous (2)    
performance monitoring (2)    
product reviews (2)    
professional development (2)    
profiler (2)    
reviews (2)    
row compression (2)    
script (2)    
smo (2)    
sql puzzles (2)    
sql server 2008 r2 (2)    
storage management (2)    
sys.dm_exec_query_plan (2)    
sys.dm_exec_requests (2)    
sys.dm_exec_sessions (2)    
sys.dm_exec_sql_text (2)    
sys.dm_os_buffer_descriptors (2)    
sys.partitions (2)    
system databases (2)    
system tables (2)    
uptime (2)    
user (2)    
user defined function (udf) (2)    
users (2)    
video (2)    
xml (2)    
xp_logininfo (2)    
aggregates (1)    
alter database (1)    
alwayson (1)    
architecture (1)    
autogrowth (1)    
backup (1)    
backup/restore (1)    
blocking (1)    
bugs (1)    
build list (1)    
bulk insert (1)    
bulk logged recovery model (1)    
business intelligence (1)    
certifications (1)    
change data capture (cdc) (1)    
change tracking (1)    
checkdb (1)    
cleanup (1)    
collation (1)    
common language runtime (clr) (1)    
compact edition (1)    
conferences and events (1)    
configuration repository (1)    
connectivity (1)    
constraints (1)    
contained databases (1)    
copy_only (1)    
create database (1)    
dac (1)    
data (1)    
data and log file usage for a db (1)    
data quality (1)    
data quality services (dqs) (1)    
data types (1)    
database (1)    
database mail (1)    
database owner (1)    
database properties (1)    
database roles (1)    
databases (1)    
ddl triggers (1)    
declarative management framework (dmf) (1)    
default (1)    
defragmentation (1)    
diagnostic (1)    
distributed transactions (1)    
distribution (1)    
dmv's (1)    
duplicate indexes (1)    
endpoints (1)    
english query (1)    
errorlogs (1)    
excel (1)    
extended properties (1)    
extended stored procedures (1)    
file location (1)    
filestream (1)    
full recovery model (1)    
function (1)    
ghost cleanup (1)    
growth trend (1)    
guest user (1)    
heap (1)    
index details (1)    
indexed views (1)    
indexes (1)    
information_schema (1)    
instance properties (1)    
kill sessions (1)    
learning (1)    
linked servers (1)    
login (1)    
login information (1)    
management (1)    
maxdop (1)    
mcitp (1)    
mcts (1)    
memory tuning (1)    
memtoleave (1)    
missing indexes (1)    
monitor (1)    
monitor server (1)    
move (1)    
multi process (1)    
nightly jobs (1)    
normalization (1)    
object permissions (1)    
olap server (1)    
openxml (1)    
operations manager (1)    
other (1)    
page compression (1)    
parallelism (1)    
pass summit (1)    
passwords (1)    
performance (1)    
process (1)    
public (1)    
query optimization (1)    
rants (1)    
read only (1)    
rebuild (1)    
rebuild log file (1)    
recent backups (1)    
reindex (1)    
reorganize indexes (1)    
report (1)    
resource database (1)    
roles (1)    
rules (1)    
running aggregate (1)    
running totals (1)    
sample chapters (1)    
scalability (1)    
scripting (1)    
selectivity (1)    
server migration (1)    
server roles (1)    
server settings (1)    
server_principals (1)    
serverproperty (1)    
service broker (1)    
shrinkfile (1)    
size (1)    
skills (1)    
sliding windows technique (1)    
slipstream (1)    
soap (1)    
sp_bindefault (1)    
sp_bindrule (1)    
sp_configure (1)    
sp_server_diagnostics (1)    
sp_unbindefault (1)    
sp_unbindrule (1)    
space used (1)    
sql monitor (1)    
sql server essentials (1)    
sql server express (1)    
sql virtual restore (1)    
sqlpsx (1)    
stairway series (1)    
string manipulation (1)    
striped backups (1)    
syntax check (1)    
sys.database_files (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
sys.dm_exec_connections (1)    
sys.dm_exec_cursors (1)    
sys.dm_os_sys_info (1)    
sys.dm_tran_session_transactions (1)    
sys.foreign_key_columns (1)    
sys.foreign_keys (1)    
sys.server_triggers (1)    
sys.sql_modules (1)    
sys.triggers (1)    
sysadmin (1)    
system database (1)    
table (1)    
table compression (1)    
table size (1)    
table valued function (1)    
telecommuting (1)    
templates (1)    
temporary tables (1)    
trace (1)    
trace flag (1)    
transaction isolation (1)    
transactions (1)    
truncate table (1)    
trustworthy (1)    
updategrams (1)    
upgrading (1)    
version (1)    
view_column_usage (1)    
virtualization (1)    
visual studio (1)    
vmware (1)    
warehouse (1)    
webinar (1)    
windows 2003 (1)    
xsl (1)