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


 

Content with tag Administration Rss

   Items 1 to 20 of 1319    Next 20 >>
 

Query accounts, domain groups, and members who have admin membership.

This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.  Read more...
By Eric Russell 2012/02/09 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |  Briefcase | 3,511 reads

SQL Agent Roles

Read more...
By Steve Jones 2012/02/07 | Category: security
Rating: (not yet rated) |  Discuss |  Briefcase | 1,464 reads

Concurrent Administration

Read more...
By Steve Jones 2012/01/25 | Category: administration
Rating: (not yet rated) |  Discuss |  Briefcase | 1,753 reads

Better Backups

Read more...
By Steve Jones 2012/01/23 | Category: administration
Rating: (not yet rated) |  Discuss |  Briefcase | 1,995 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.  Read more...
By Ola Hallengren 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 34,805 reads

DDL trigger

Read more...
By Dan Hess 2012/01/18 | Category: ddl trigger
Rating: (not yet rated) |  Discuss |  Briefcase | 1,718 reads

Tail Log Backups

Read more...
By Steve Jones 2012/01/13 | Category: administration
Rating: (not yet rated) |  Discuss |  Briefcase | 1,671 reads

SQL Server – Identifying default data directory for multiple instances through registry

This is a follow up post from a comment on my blog. Earlier I posted about using xp_instance_regread to get default...  Read more...
By 2012/01/10 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |  Briefcase | 579 reads

Classifier Functions

Read more...
By Steve Jones 2012/01/09 | Category: administration
Rating: (not yet rated) |  Discuss |  Briefcase | 1,916 reads

Compare Different tables from 2 Databases

List tables that have different tables and column   Read more...
By JoseACJr 0001/01/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 5,968 reads

Backup Compression

Read more...
By FOR SQLSERVER 2012/01/05 | Category: administration
Rating: (not yet rated) |  Discuss |  Briefcase | 1,824 reads

Managing Transaction Logs

A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs.  Read more...
By Gail Shaw 2012/01/03 (first published: 2008/10/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 41,479 reads

Concurrent Operations

Read more...
By Steve Jones 2011/12/29 | Category: administration
Rating: (not yet rated) |  Discuss |  Briefcase | 1,790 reads

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...
By Mani Singh 0001/01/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 2,119 reads

Backing Up a SQL Server Database Directly Onto a Remote Server

Recently I encountered a situation where the backup drive was short of space on the production server. The policy on the production server was that as soon as soon as the Full Backup is complete, a copy of the production backup is transferred to the staging server using RoboCopy  Read more...
By Additional Articles 2011/12/22 | Source: SQL Server Performance | Category: backup / restore
Rating: (not yet rated)  Rate this |  Briefcase | 2,660 reads

Tail-Log Backup

Read more...
By Steve Jones 2011/12/21 | Category: administration
Rating: (not yet rated) |  Discuss |  Briefcase | 1,836 reads

Automating Daily Checks with Powershell

Using Powershell to create color coded backup reports for all servers in your environment.  Read more...
By Warren Campbell 2011/12/19 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |  Briefcase | 8,427 reads

Clustered Instances

Read more...
By Steve Jones 2011/12/16 | Category: administration
Rating: (not yet rated) |  Discuss |  Briefcase | 1,884 reads

Why SHRINKFILE is a very bad thing, and what to do about it.

This article talks about why SHRINKFILE is a very bad thing, and what to do about it if you must shrink a database file.  Read more...
By Simon Facer 2011/12/16 (first published: 2010/11/09) | Source: SQLServerCentral.com | Category: shrinkfile
Rating: |  Discuss |  Briefcase | 47,832 reads

Concurrent Operations

Read more...
By Steve Jones 2011/12/15 | Category: administration
Rating: (not yet rated) |  Discuss |  Briefcase | 1,664 reads
   Items 1 to 20 of 1319    Next 20 >>
 
Tags
sql server 7 (333)    
sql server 2005 (183)    
t-sql (98)    
configuring (63)    
miscellaneous (55)    
security (54)    
backup / restore (45)    
performance tuning (39)    
monitoring (37)    
strategies (36)    
indexing (33)    
programming (32)    
maintenance and management (29)    
utility (27)    
sql server 6.5 (25)    
maintenance (24)    
disaster recovery (dr) (18)    
t-sql aids (18)    
database design (17)    
stored procedures (17)    
reporting services (ssrs) (16)    
advanced querying (15)    
installation (13)    
visual basic 6 (12)    
replication (11)    
dts (9)    
search (9)    
editorial (8)    
sql server 2008 (8)    
sql-dmo (8)    
storage (8)    
tables (8)    
automated dba (7)    
best and worst practices (7)    
development (7)    
news (7)    
powershell (7)    
sys.dm_db_partition_stats (7)    
transaction log (7)    
availability (6)    
blogs (6)    
shrink database (6)    
worst practices (6)    
ado (5)    
backup / recovery (5)    
career (5)    
dba (5)    
list indexes (5)    
performance (5)    
pivot (5)    
sql server (5)    
.net (4)    
auto-growth (4)    
basics (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
for xml path (4)    
jobs (4)    
naming standards (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
sys.allocation_units (4)    
system development life cycle (4)    
triggers (4)    
troubleshooting (4)    
administrator (3)    
automation (3)    
dbcc (3)    
disk space (3)    
distributed queries (3)    
editorial - ipod (3)    
editorial - wmv (3)    
encryption (3)    
integration services (ssis) (3)    
networking (3)    
numa (3)    
partitioning (3)    
permissions (3)    
policy based management (3)    
restore (3)    
role (3)    
space usage (3)    
sql server 2008 r2 (3)    
state of the business (3)    
statistics (3)    
tde (3)    
tempdb (3)    
advanced (2)    
attach (2)    
audit (2)    
auditing (2)    
buffer cache (2)    
capacity planning (2)    
central management server (2)    
clustering (2)    
column (2)    
corruption (2)    
data storage (2)    
database mirroring (2)    
detach (2)    
dmv (2)    
editorial - mp3 (2)    
error logging (2)    
foreign keys (fk) (2)    
grant (2)    
high availability (2)    
kill (2)    
lock and connection management (2)    
locking (2)    
logins (2)    
maintenance plans (2)    
management studio (ssms) (2)    
migration (2)    
miscellaneous (2)    
performance monitoring (2)    
product reviews (2)    
profiler (2)    
recovery model (2)    
resource governor (2)    
reviews (2)    
row compression (2)    
script (2)    
smo (2)    
sql agent (2)    
sql puzzles (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)    
tuning (2)    
uptime (2)    
user defined function (udf) (2)    
users (2)    
video (2)    
xml (2)    
xp_logininfo (2)    
aggregates (1)    
alter database (1)    
analysis services (ssas) (1)    
architecture (1)    
attach database (1)    
backup/restore (1)    
best practices (1)    
bugs (1)    
build list (1)    
business intelligence (1)    
certification (1)    
checkdb (1)    
cleanup (1)    
clr functions (1)    
clr stored procedures (1)    
clr udt (1)    
collation (1)    
column permissions (1)    
common language runtime (clr) (1)    
compact edition (1)    
compression (1)    
conferences and events (1)    
configuration (1)    
connectivity (1)    
copy_only (1)    
data (1)    
data and log file usage for a db (1)    
data types (1)    
database (1)    
database size (1)    
database snapshot (1)    
database weekly (1)    
databases (1)    
dbcc checkdb (1)    
ddl (1)    
ddl trigger (1)    
declarative management framework (dmf) (1)    
default (1)    
defragmentation (1)    
diagnostic (1)    
distribution (1)    
dmv's (1)    
duplicate indexes (1)    
english query (1)    
errorlogs (1)    
excel (1)    
extended properties (1)    
extended stored procedures (1)    
filegroup (1)    
filegroups (1)    
files and filegroups (1)    
fragmentation (1)    
friday poll (1)    
full text search (1)    
full-text search (1)    
growth trend (1)    
heap (1)    
indexed views (1)    
information_schema (1)    
kill sessions (1)    
learning (1)    
linked servers (1)    
login information (1)    
maintenance and management sql server 2005 (1)    
management (1)    
maxdop (1)    
mcitp (1)    
mcts (1)    
memory (1)    
memory tuning (1)    
memtoleave (1)    
missing indexes (1)    
move (1)    
multi process (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)    
pbm (1)    
performance and tuning (1)    
process (1)    
public (1)    
query optimization (1)    
rants (1)    
rebuild (1)    
recent backups (1)    
reindex (1)    
report (1)    
roles (1)    
rules (1)    
running aggregate (1)    
running totals (1)    
sample chapters (1)    
scalability (1)    
scripting (1)    
selectivity (1)    
server migration (1)    
server_principals (1)    
serverproperty (1)    
shrinkfile (1)    
size (1)    
skills (1)    
sliding windows technique (1)    
slipstream (1)    
sp_bindefault (1)    
sp_bindrule (1)    
sp_unbindefault (1)    
sp_unbindrule (1)    
space used (1)    
sql monitor (1)    
sql server agent (1)    
sql server essentials (1)    
sql server express (1)    
sql virtual restore (1)    
sqlclr (1)    
sqlservercentral (1)    
ssc clinic (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 databases (1)    
system tables (1)    
table (1)    
table compression (1)    
table size (1)    
table valued function (1)    
telecommuting (1)    
templates (1)    
temporary table (1)    
trace (1)    
trace flag (1)    
transactions (1)    
truncate (1)    
updategrams (1)    
user (1)    
view_column_usage (1)    
virtualization (1)    
visual studio (1)    
warehouse (1)    
windows 2003 (1)    
xsl (1)    
 
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.