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 1494    Older >>
 

Indexes

By free mascot 2014/03/21 | Category: indexes
Rating: (not yet rated) |  Discuss |   Briefcase | 1,843 reads

Automate Sliding Window Partition Maintenance: Part III

Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell  Read more...
By Hugh Scott 2014/03/21 (first published: 2010/12/28) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 5,861 reads

Updating Statistics

By Steve Jones 2014/03/14 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,602 reads

Members of windows group

By Yogeshwar Phull 2014/03/13 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,525 reads

Mini-Me

This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...
By Steve Jones 2014/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 542 reads

Startup In Single-User Mode

By Mike Hays 2014/02/27 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,564 reads

Backup/Restore

By free mascot 2014/02/21 | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,935 reads

In Database We Trust

By Andy Warren 2014/02/20 | Category: sqlclr
Rating: (not yet rated) |  Discuss |   Briefcase | 1,737 reads

The Model Database

By free mascot 2014/02/18 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,829 reads

Backup and Housekeeping with Maintenance Plans

Get an idea of how to handle the housekeeping tasks associated with backups, like removing old backup and log files.  Read more...
By Gethyn Ellis 2014/02/17 (first published: 2011/01/26) | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 11,171 reads

Compression

By Igor Micev 2014/01/30 | Category: compression
Rating: (not yet rated) |  Discuss |   Briefcase | 1,777 reads

The DBA is Dead

Is the DBA Dead? Steve Jones scoffs at the notion put forth in an article and says we'll be using DBAs for a long time. He does, however, admit the role is changing.  Read more...
By Steve Jones 2014/01/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 407 reads

Management at Scale

Could you manage 20,000 databases? That's how many servers each person at Facebook has to manage in operations.  Read more...
By Steve Jones 2014/01/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 157 reads

Leveraging Constraint Evaluation Sequence in SQL Server

Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.  Read more...
By Nakul Vachhrajani 2014/01/27 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 2,575 reads

Common Checks

This Friday Steve Jones wants to know what types of things are you checking for on your instances. What items can cause you issues if you don't proactively monitor for them.  Read more...
By Steve Jones 2014/01/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 182 reads

Replication

By Steve Jones 2014/01/22 | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 1,414 reads

Tempdb

By free mascot 2014/01/20 | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 2,045 reads

The PoSh DBA - Reading and Filtering Errors

DBAs regularly need to keep an eye on the error logs of all their SQL Servers, and the event logs of the host servers as well. When server numbers get large, the traditional Windows GUI approach breaks down, and the PoSH DBA reaches for a PowerShell script to do the leg-work.   Read more...
By Additional Articles 2014/01/20 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,160 reads

Creating a DBA's Library

A DBA Library: it's not the library in traditional terms where you have books and journals stacked on your desk; rather it's a centralized and integrated repository of knowledge, information and applications for the DBA.  Read more...
By Additional Articles 2014/01/17 | Source: MSSQLTips.com | Category: administration
Rating:  Rate this |   Briefcase | 3,671 reads
   Items 1 to 20 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 (18)    
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)    
azure (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)    
consolidation (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 2014 (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)