Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Administration Rss

   Items 1 to 20 of 1642    Older >>
 

What does Copy-only Backup do?

By Ben Kubicek 2016/06/28 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 629 reads

Minimally Logged

By Steve Jones 2016/06/21 | Category: transaction log
Rating: (not yet rated) |  Discuss |   Briefcase | 974 reads

Database autogrowth and initail size setup.

Set initial size and autogrowth of all database on a SQL instance in a go.  Read more...
By Rajesh Sharma 2016/06/21 | Source: SQLServerCentral.com | Category: database
Rating: |  Discuss |   Briefcase | 394 reads

Checkpoints

By Steve Jones 2016/06/17 | Category: checkpoint
Rating: (not yet rated) |  Discuss |   Briefcase | 1,012 reads

Stats_date()

By Steve Jones 2016/06/10 | Category: statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 1,157 reads

Throttling Services

By Steve Jones 2016/06/08 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 942 reads

Multi Instance Resources

By Steve Jones 2016/05/16 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 983 reads

Resource Governor Limits?

By Steve Jones 2016/05/12 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,035 reads

What does sp_setnetname do?

By Steve Jones 2016/04/14 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,101 reads

The Endpoint IP

By Steve Jones 2016/03/23 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,046 reads

Where's the snapshot?

By Steve Jones 2016/03/22 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,174 reads

Script DB Level Permissions v4

Script database and object level permissions for all database users  Read more...
By S. Kusen 2016/03/22 | Source: SQLServerCentral.com | Category: login
Rating: |  Discuss |   Briefcase | 862 reads

Finding the database collation

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

Growing Database Files

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

Suspect Pages

By Steve Jones 2016/02/10 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,276 reads

DBCC Error 6

By Andy Warren 2016/02/02 | Category: dbcc
Rating: (not yet rated) |  Discuss |   Briefcase | 1,428 reads

Query Progress

By Muhammad Farhan 2016/01/27 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,515 reads

The security scheme

By Steve Jones 2016/01/26 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,345 reads
   Items 1 to 20 of 1642    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (101)    
security (70)    
configuring (63)    
backup and restore (58)    
miscellaneous (57)    
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)    
stored procedures (18)    
powershell (17)    
reporting services (ssrs) (17)    
advanced querying (15)    
installation (13)    
replication (13)    
sql server 2014 (13)    
transaction log (13)    
visual basic 6 (12)    
resource governor (10)    
sql server (10)    
statistics (10)    
backup (9)    
dts (9)    
restore (9)    
search (9)    
storage (9)    
tables (9)    
agent jobs (8)    
database mirroring (8)    
sql server 2008 (8)    
sql-dmo (8)    
automated dba (7)    
best and worst practices (7)    
career (7)    
central management server (cms) (7)    
development (7)    
news (7)    
sqlservercentral (7)    
sys.dm_db_partition_stats (7)    
tempdb (7)    
auditing (6)    
availability (6)    
dba (6)    
files and filegroups (6)    
recovery model (6)    
shrink database (6)    
worst practices (6)    
ado (5)    
automation (5)    
corruption (5)    
dbcc (5)    
high availability (ha) (5)    
list indexes (5)    
logins (5)    
memory-optimized tables (5)    
performance (5)    
permissions (5)    
pivot (5)    
policy based management (pbm) (5)    
sql agent (5)    
sql server 2012 (5)    
troubleshooting (5)    
.net (4)    
auto-growth (4)    
basics (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
detach database (4)    
encryption (4)    
extended events (4)    
filegroups (4)    
for xml path (4)    
fragmentation (4)    
integration services (ssis) (4)    
maintenance plans (4)    
naming standards (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
space usage (4)    
sys.allocation_units (4)    
system development life cycle (4)    
triggers (4)    
administrator (3)    
attach database (3)    
azure (3)    
cardinality estimates (3)    
checkpoint (3)    
columns (3)    
columnstore index (3)    
compression (3)    
configuration (3)    
database (3)    
dbcc checkdb (3)    
disk space (3)    
distributed queries (3)    
editorial - ipod (3)    
editorial - wmv (3)    
error log (3)    
foreign keys (fk) (3)    
friday poll (3)    
kill (3)    
locking (3)    
log shipping (3)    
memory (3)    
migration (3)    
networking (3)    
numa (3)    
partitioning (3)    
role (3)    
row compression (3)    
script (3)    
sql server agent (3)    
sqlclr (3)    
state of the business (3)    
transparent data encryption (tde) (3)    
tuning (3)    
user (3)    
users (3)    
advanced (2)    
alter database (2)    
analysis services (ssas) (2)    
attach (2)    
autogrowth (2)    
best practices (2)    
browser service (2)    
buffer cache (2)    
capacity planning (2)    
clustering (2)    
collation (2)    
dac (2)    
data compression (2)    
data storage (2)    
database size (2)    
database snapshots (2)    
database weekly (2)    
ddl (2)    
dmv (2)    
dmvs (2)    
editorial - mp3 (2)    
endpoints (2)    
filestream (2)    
full text search (2)    
full-text search (2)    
function (2)    
grant (2)    
instant file initialization (ifi) (2)    
isolation levels (2)    
lock and connection management (2)    
log files (2)    
management studio (ssms) (2)    
miscellaneous (2)    
missing indexes (2)    
page compression (2)    
performance monitoring (2)    
product reviews (2)    
professional development (2)    
profiler (2)    
resource database (2)    
reviews (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)    
table size (2)    
trace flags (2)    
transactions (2)    
uptime (2)    
user defined function (udf) (2)    
video (2)    
virtualization (2)    
xml (2)    
xp_logininfo (2)    
admin (1)    
aggregates (1)    
alerts (1)    
alwayson (1)    
architecture (1)    
audit (1)    
backup/restore (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)    
cleanup (1)    
cms (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)    
cxpacket (1)    
data (1)    
data and log file usage (1)    
data flow (1)    
data gathering (1)    
data quality (1)    
data quality services (dqs) (1)    
database configuration (1)    
database growth status (1)    
database mail (1)    
database owner (1)    
database roles (1)    
databases (1)    
datatypes (1)    
dbcc show_statistics (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 (1)    
dynamic script to copy backup (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)    
ghost cleanup (1)    
growth trend (1)    
guest user (1)    
heap (1)    
heaps (1)    
index (1)    
indexed views (1)    
information_schema (1)    
initial size (1)    
in-memory oltp (1)    
instance (1)    
kill sessions (1)    
latest backup (1)    
learning (1)    
linked servers (1)    
log file (1)    
logging (1)    
login (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)    
norecovery (1)    
normalization (1)    
object permissions (1)    
olap server (1)    
openxml (1)    
operations manager (1)    
optimization (1)    
other (1)    
parallelism (1)    
pass summit (1)    
passwords (1)    
performance counters (1)    
permission (1)    
piecemeal (1)    
pivot table (1)    
processes (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)    
roles (1)    
rules (1)    
running aggregate (1)    
running totals (1)    
sample chapters (1)    
scalability (1)    
schema (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)    
single user (1)    
size (1)    
skills (1)    
sliding windows technique (1)    
slipstream (1)    
soap (1)    
sp_bindefault (1)    
sp_bindrule (1)    
sp_configure (1)    
sp_detach_db (1)    
sp_server_diagnostics (1)    
sp_setnetname (1)    
sp_spaceused (1)    
sp_unbindefault (1)    
sp_unbindrule (1)    
space used (1)    
spn (1)    
sql jobs (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 valued function (1)    
telecommuting (1)    
templates (1)    
temporary tables (1)    
trace (1)    
trace flag (1)    
truncate table (1)    
trustworthy (1)    
uninstall (1)    
updategrams (1)    
upgrading (1)    
version (1)    
view_column_usage (1)    
views (1)    
visual studio (1)    
vmware (1)    
warehouse (1)    
webinar (1)    
windows 2003 (1)    
xsl (1)