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

DBCC and disabled indexes

By Steve Jones 2015/06/18 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,345 reads

Complete Details About Backups Taken a Day Ago

Complete Details About Backups Taken a Day Ago.  Read more...
By S M 2015/06/05 | Source: SQLServerCentral.com | Category: sql server backup
Rating: |  Discuss |   Briefcase | 761 reads

Detach & Attach Procedure

For successful run, Your SQL Server service account should have permission to old location & new location  Read more...
By Vimal Lohani 2015/05/27 | Source: SQLServerCentral.com | Category: detach database
Rating: |  Discuss |   Briefcase | 832 reads

Query to find size of each disk file in a location

Query to find size of each file in a location  Read more...
By S M 2015/05/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 843 reads

Script to change auto growth settings for all databases in SQL Server

Script to change auto growth settings for all databases in SQL Server.  Read more...
By Shashank Srivastava 2015/05/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,473 reads

Named Pipe Changes

By Steve Jones 2015/05/08 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,394 reads

Central Management Servers

By Steve Jones 2015/05/06 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,300 reads

DDL Auditing using the Default trace

This article explains how default trace can be used for auditing purposes when combined with PowerShell scripts  Read more...
By Nagaraj Venkatesan 2015/05/05 | Source: SQLServerCentral.com | Category: audit
Rating: |  Discuss |   Briefcase | 2,648 reads

SQLServerCentral Runs sp_Blitz - The Future

After examining the SQLServerCentral servers using the sp_Blitz™ script, Steve Jones now looks at how we will use the script moving forward.  Read more...
By Steve Jones 2015/04/30 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 6,433 reads

Drop Databases

By free mascot 2015/04/24 | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 1,891 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 2015/04/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,751 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 2015/04/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,456 reads

Delete Windows Service

By S M 2015/04/13 | Category: uninstall
Rating: (not yet rated) |  Discuss |   Briefcase | 1,414 reads

Adding database file

By Dathuraj Pasarge 2015/03/31 | Category: files and filegroups
Rating: (not yet rated) |  Discuss |   Briefcase | 1,674 reads

SQL Jobs

By S M 2015/03/26 | Category: sql jobs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,873 reads

Performance Counters

By John Hanrahan 2015/03/12 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,535 reads

Index Fragmentation

By Steve Jones 2015/03/11 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,646 reads

Reading Logs

By Steve Jones 2015/03/10 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,713 reads

Managing Log Files Sizes the Easy Way

Learn an easy, rough, and ready way to manage log files in this piece.  Read more...
By Mark Roworth 2015/03/09 | Source: SQLServerCentral.com | Category: log files
Rating: |  Discuss |   Briefcase | 7,617 reads

Creating schemas

By Steve Jones 2015/03/03 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,675 reads
   Items 1 to 20 of 1581    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (100)    
security (69)    
configuring (63)    
miscellaneous (55)    
backup / restore (46)    
performance tuning (45)    
indexing (42)    
monitoring (41)    
strategies (36)    
programming (32)    
maintenance and management (29)    
utility (27)    
maintenance (26)    
sql server 6.5 (25)    
editorial (21)    
disaster recovery (dr) (19)    
blogs (18)    
database design (18)    
reporting services (ssrs) (17)    
stored procedures (17)    
powershell (16)    
advanced querying (15)    
installation (13)    
replication (13)    
sql server 2014 (13)    
visual basic 6 (12)    
backup / recovery (11)    
transaction logs (10)    
dts (9)    
search (9)    
storage (9)    
tables (9)    
restore (8)    
sql server 2008 (8)    
sql-dmo (8)    
statistics (8)    
automated dba (7)    
best and worst practices (7)    
career (7)    
central management server (cms) (7)    
database mirroring (7)    
development (7)    
jobs (7)    
news (7)    
sql server (7)    
sqlservercentral (7)    
sys.dm_db_partition_stats (7)    
tempdb (7)    
auditing (6)    
availability (6)    
dba (6)    
recovery model (6)    
resource governor (6)    
shrink database (6)    
worst practices (6)    
ado (5)    
automation (5)    
backup (5)    
files and filegroups (5)    
high availability (ha) (5)    
list indexes (5)    
memory-optimized tables (5)    
pivot (5)    
policy based management (pbm) (5)    
sql server 2012 (5)    
.net (4)    
auto-growth (4)    
basics (4)    
corruption (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
dbcc (4)    
detach database (4)    
encryption (4)    
filegroups (4)    
for xml path (4)    
fragmentation (4)    
integration services (ssis) (4)    
maintenance plans (4)    
naming standards (4)    
performance (4)    
permissions (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
sql agent (4)    
sys.allocation_units (4)    
system development life cycle (4)    
triggers (4)    
troubleshooting (4)    
administrator (3)    
attach database (3)    
cardinality estimates (3)    
configuration (3)    
dbcc checkdb (3)    
disk space (3)    
distributed queries (3)    
editorial - ipod (3)    
editorial - wmv (3)    
error log (3)    
extended events (3)    
foreign keys (fk) (3)    
friday poll (3)    
kill (3)    
log shipping (3)    
networking (3)    
numa (3)    
partitioning (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)    
azure (2)    
best practices (2)    
browser service (2)    
buffer cache (2)    
capacity planning (2)    
clustering (2)    
columns (2)    
compression (2)    
dac (2)    
data compression (2)    
data storage (2)    
database (2)    
database size (2)    
database snapshots (2)    
database weekly (2)    
ddl (2)    
dmv (2)    
editorial - mp3 (2)    
filestream (2)    
full text search (2)    
full-text search (2)    
grant (2)    
instant file initialization (2)    
isolation levels (2)    
lock and connection management (2)    
locking (2)    
logins (2)    
management studio (ssms) (2)    
memory (2)    
migration (2)    
miscellaneous (2)    
missing indexes (2)    
performance monitoring (2)    
product reviews (2)    
professional development (2)    
profiler (2)    
reviews (2)    
row compression (2)    
script (2)    
server configuration (2)    
smo (2)    
sql monitor (2)    
sql puzzles (2)    
sql server 2008 r2 (2)    
sql spackle (2)    
storage management (2)    
striped backups (2)    
sys.database_files (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)    
trace flags (2)    
uptime (2)    
user (2)    
user defined function (udf) (2)    
users (2)    
video (2)    
virtualization (2)    
xml (2)    
xp_logininfo (2)    
aggregates (1)    
alerts (1)    
alter database (1)    
alwayson (1)    
architecture (1)    
audit (1)    
autogrowth (1)    
backup/restore (1)    
blocking (1)    
buffer pool extension (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)    
checkpoint (1)    
cleanup (1)    
cms (1)    
collation (1)    
columnstore index (1)    
common language runtime (clr) (1)    
compact edition (1)    
compressed backup (1)    
conferences and events (1)    
configuration repository (1)    
connection (1)    
connectivity (1)    
consolidation (1)    
constraints (1)    
contained databases (1)    
copy backup (1)    
copy_only (1)    
create database (1)    
data (1)    
data and log file usage (1)    
data flow (1)    
data gathering (1)    
data quality (1)    
data quality services (dqs) (1)    
database growth status (1)    
database mail (1)    
database owner (1)    
database roles (1)    
databases (1)    
datatypes (1)    
dbmail (1)    
ddl triggers (1)    
declarative management framework (dmf) (1)    
default (1)    
default trace (1)    
defragmentation (1)    
details (1)    
diagnostic (1)    
distributed transactions (1)    
distribution (1)    
dmv's (1)    
drive space (1)    
duplicate indexes (1)    
dynamic management views (1)    
dynamic script to copy backup (1)    
endpoints (1)    
english query (1)    
excel (1)    
execution plans (1)    
extended properties (1)    
extended stored procedures (1)    
file location (1)    
file operations (1)    
filter backup (1)    
full recovery model (1)    
function (1)    
ghost cleanup (1)    
growth trend (1)    
guest user (1)    
heap (1)    
heaps (1)    
indexed views (1)    
information_schema (1)    
in-memory oltp (1)    
instance (1)    
kill sessions (1)    
latest backup (1)    
learning (1)    
linked servers (1)    
log file (1)    
log files (1)    
logging (1)    
login (1)    
login information (1)    
management (1)    
maxdop (1)    
mcitp (1)    
mcts (1)    
memory tuning (1)    
memory-optimized table storage (1)    
memtoleave (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 counters (1)    
piecemeal (1)    
process (1)    
properties (1)    
public (1)    
query optimization (1)    
rants (1)    
read only (1)    
rebuild (1)    
rebuild log file (1)    
recent backups (1)    
recovery interval (1)    
reindex (1)    
remove old backup from path (1)    
reorganize indexes (1)    
report (1)    
resource database (1)    
roles (1)    
rules (1)    
running aggregate (1)    
running totals (1)    
sample chapters (1)    
scalability (1)    
schemas (1)    
scripting (1)    
selectivity (1)    
server (1)    
server migration (1)    
server roles (1)    
server_principals (1)    
serverproperty (1)    
service accounts (1)    
service broker (1)    
settings (1)    
setup (1)    
shrinkfile (1)    
sid (1)    
sid mismatch check (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)    
spn (1)    
sql jobs (1)    
sql server backup (1)    
sql server essentials (1)    
sql server express (1)    
sql sever 2014 (1)    
sql virtual restore (1)    
sqlpsx (1)    
stairway series (1)    
string manipulation (1)    
summary (1)    
syntax check (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 levels (1)    
transactions (1)    
truncate table (1)    
trustworthy (1)    
uninstall (1)    
updategrams (1)    
upgrading (1)    
version (1)    
view_column_usage (1)    
visual studio (1)    
vmware (1)    
warehouse (1)    
webinar (1)    
windows 2003 (1)    
xsl (1)