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 41 to 60 of 1595    Older >>
 

Automatic restore database to different server from backup file

if you get bunch of back up files ( full backup and transaction log backup, you need restore those database to different server, you can use my stored procedure to genereate the restore command   Read more...
By David Zhou 2015/01/15 | Source: SQLServerCentral.com | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,748 reads

Migrate existing DB Mail Exchange Configuration with New

Sometime due to the heavy load in Exchange servers we received configuration alerts notifications and report delay and that time it is require to move to some other exchange servers to full fill the requirement during the critical periods.  Read more...
By Nitin Gupta 2015/01/13 | Source: SQLServerCentral.com | Category: dbmail
Rating: (not yet rated) |  Discuss |   Briefcase | 581 reads

Verify Login SID and Machine SID

This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.  Read more...
Rating: |  Discuss |   Briefcase | 1,437 reads

Filestream files

By Steve Jones 2015/01/09 | Category: filestream
Rating: (not yet rated) |  Discuss |   Briefcase | 1,619 reads

Multiple Backup Files

This Friday Steve Jones looks at your backup system and wonders how many people use striped backups.  Read more...
By Steve Jones 2015/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 259 reads

In-Memory OLTP Storage

By Steve Jones 2014/12/22 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,459 reads

Execution Plan reuse

By Steve Jones 2014/12/17 | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 1,840 reads

Trace Flag

By S M 2014/12/04 | Category: trace flags
Rating: (not yet rated) |  Discuss |   Briefcase | 1,416 reads

Automatic Page Repair

By Steve Jones 2014/12/02 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,525 reads

How Often Does Production Drift?

Database drift is the difference between two database schemas. Today Steve Jones discusses the concept and wonders how often it happens.  Read more...
By Steve Jones 2014/11/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 127 reads

Memory

By Vyas DCS 2014/11/14 | Category: setup
Rating: (not yet rated) |  Discuss |   Briefcase | 1,754 reads

Track database growth 2012/2014

Enhancement to Track database growth By Irwan Tjanterik, 2014/09/23  Read more...
By Paulo Nascimento 2014/10/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,863 reads

Trace Flag

By Vyas DCS 2014/10/30 | Category: sql server 2008
Rating: (not yet rated) |  Discuss |   Briefcase | 1,583 reads

Primary key vs Unique key

By Rabih Karam 2014/10/28 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,361 reads

Retrieve instance-wide index level fill factor information

This script retrieves all fill factor information for all indexes (clustered and non) when it is not set to 0 or 100  Read more...
Rating: |  Discuss |   Briefcase | 581 reads

SETSPN

By Steve Jones 2014/10/17 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,679 reads

Columnstore changes

By Steve Jones 2014/10/07 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,460 reads

TempDB usage per active session

Lists the TempDB usage per each active session.   Read more...
Rating: |  Discuss |   Briefcase | 8,679 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: 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 2014/09/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,227 reads
<< Newer    Items 41 to 60 of 1595    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (100)    
security (69)    
configuring (63)    
miscellaneous (57)    
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)    
stored procedures (18)    
reporting services (ssrs) (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)    
database mirroring (8)    
restore (8)    
sql server (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)    
development (7)    
jobs (7)    
news (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)    
logins (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)    
columnstore index (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)    
dmvs (2)    
editorial - mp3 (2)    
filestream (2)    
full text search (2)    
full-text search (2)    
function (2)    
grant (2)    
instant file initialization (2)    
isolation levels (2)    
lock and connection management (2)    
locking (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)    
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)    
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 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)    
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)    
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)    
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)    
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_unbindefault (1)    
sp_unbindrule (1)    
space used (1)    
spn (1)    
sql agent jobs (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)    
views (1)    
visual studio (1)    
vmware (1)    
warehouse (1)    
webinar (1)    
windows 2003 (1)    
xsl (1)