SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
Write for us

  

Content with tag Administration Rss

<< Newer    Items 41 to 60 of 1706    Older >>
 

Using the DAC

Read more...
By Steve Jones 2016/11/14 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,096 reads

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 2016/11/10 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 2,342 reads

A Better sp_Spaceused

Read more...
By Steve Jones 2016/11/07 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,041 reads

Track database growth 2012/2014

Enhancement to Track database growth By Irwan Tjanterik, 2014/09/23  Read more...
By Paulo Nascimento 2016/11/03 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,421 reads

Deploy Security Changes with Copy-SqlLogin

Moving security changes between server instances can be a cumbersome process, but it doesn't need to be with the PowerShell cmdlet, Copy-SqlLogin.  Read more...
By Steve Jones 2016/11/01 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,374 reads

Dropping Audit Sessions

Read more...
By Steve Jones 2016/10/28 | Category: sql audit
Rating: (not yet rated) |  Discuss |   Briefcase | 862 reads

Heaps and indexes

Read more...
By Steve Jones 2016/10/25 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,178 reads

Let the shell free

Read more...
By Steve Jones 2016/10/24 | Category: xp_cmdshell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,019 reads

Remove the Login Trigger

Read more...
By Steve Jones 2016/10/20 | Category: triggers
Rating: (not yet rated) |  Discuss |   Briefcase | 1,085 reads

Complete Details About Backups Taken a Day Ago

Complete Details About Backups Taken a Day Ago.  Read more...
By S M 2016/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,431 reads

Index IDs

Read more...
By Steve Jones 2016/10/12 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,173 reads

Storing In-Memory OLTP tables

Read more...
By Steve Jones 2016/10/06 | Category: in-memory oltp tables
Rating: (not yet rated) |  Discuss |   Briefcase | 1,004 reads

What is the Future of Monitoring?

Monitoring your systems is critical to ensuring security and stability. Steve Jones shares a few thoughts on where monitoring might go with more computer assistance in the future.  Read more...
By Steve Jones 2016/09/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 67 reads

Getting Ready for R

Read more...
By Steve Jones 2016/09/23 | Category: microsoft r services
Rating: (not yet rated) |  Discuss |   Briefcase | 975 reads

Resource Concepts

Read more...
By Junior Galvão - MVP 2016/08/11 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,016 reads

SQL 2012: Dirty pages flushed in a single write

Read more...
By GP Van Eron 2016/08/10 | Category: dirty pages
Rating: (not yet rated) |  Discuss |   Briefcase | 1,047 reads

The SQL 2016 Indirect Checkpoint

Read more...
By Steve Jones 2016/08/09 | Category: sql server 2016
Rating: (not yet rated) |  Discuss |   Briefcase | 981 reads

Real World: SQL Server Quick Quality Check

Here is a script that can give the DBA a SQL Instance quick quality check.  Read more...
By Randeep Singh 2016/08/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,151 reads

Proportional Fill

Read more...
By Steve Jones 2016/08/03 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,198 reads

Startup Procedure Limits

Read more...
By Steve Jones 2016/07/22 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,231 reads
<< Newer    Items 41 to 60 of 1706    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (104)    
security (74)    
configuring (63)    
backup and restore (59)    
miscellaneous (57)    
performance tuning (45)    
indexing (44)    
monitoring (42)    
strategies (36)    
programming (32)    
maintenance and management (29)    
utility (27)    
maintenance (26)    
sql server 6.5 (25)    
editorial (23)    
disaster recovery (dr) (20)    
powershell (20)    
blogs (18)    
database design (18)    
stored procedures (18)    
reporting services (ssrs) (17)    
advanced querying (15)    
installation (13)    
replication (13)    
sql server 2014 (13)    
transaction log (13)    
backup (12)    
visual basic 6 (12)    
resource governor (11)    
restore (10)    
sql server (10)    
statistics (data) (10)    
database mirroring (9)    
dts (9)    
search (9)    
storage (9)    
tables (9)    
agent jobs (8)    
sql server 2008 (8)    
sql-dmo (8)    
tempdb (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)    
auditing (6)    
availability (6)    
corruption (6)    
dba (6)    
dbcc (6)    
encryption (6)    
files and filegroups (6)    
high availability (ha) (6)    
logins (6)    
recovery model (6)    
shrink database (6)    
worst practices (6)    
ado (5)    
automation (5)    
error log (5)    
list indexes (5)    
memory-optimized tables (5)    
performance (5)    
permissions (5)    
pivot (5)    
policy based management (pbm) (5)    
sql agent (5)    
sql server 2012 (5)    
trace flags (5)    
triggers (5)    
troubleshooting (5)    
.net (4)    
alter server configuration (4)    
auto-growth (4)    
basics (4)    
checkpoint (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
detach database (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)    
administrator (3)    
attach database (3)    
azure (3)    
cardinality estimates (3)    
clustering (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)    
filestream (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)    
always on (2)    
analysis services (ssas) (2)    
attach (2)    
autogrowth (2)    
best practices (2)    
browser service (2)    
buffer cache (2)    
capacity planning (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)    
full text search (2)    
full-text search (2)    
function (2)    
grant (2)    
in-memory oltp tables (2)    
instant file initialization (ifi) (2)    
isolation levels (2)    
lock and connection management (2)    
log files (2)    
management studio (ssms) (2)    
maxdop (2)    
miscellaneous (2)    
missing indexes (2)    
page compression (2)    
passwords (2)    
performance monitoring (2)    
product reviews (2)    
professional development (2)    
profiler (2)    
resource database (2)    
reviews (2)    
server configuration (2)    
smo (2)    
sp_spaceused (2)    
sql monitor (2)    
sql puzzles (2)    
sql server 2008 r2 (2)    
sql server 2016 (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)    
transactions (2)    
uptime (2)    
user defined function (udf) (2)    
video (2)    
views (2)    
virtualization (2)    
xml (2)    
xp_logininfo (2)    
admin (1)    
aggregates (1)    
alerts (1)    
architecture (1)    
audit (1)    
availability groups (ag) (1)    
backup/restore (1)    
backup-restore (1)    
blocking (1)    
browser (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 files (1)    
database growth status (1)    
database mail (1)    
database owner (1)    
database roles (1)    
databases (1)    
datatypes (1)    
dbatools.io (1)    
dbcc show_statistics (1)    
dbmail (1)    
ddl triggers (1)    
declarative management framework (dmf) (1)    
dedicated administrator connection (dac) (1)    
default (1)    
default trace (1)    
defragmentation (1)    
delayed durability (1)    
details (1)    
diagnostic (1)    
dirty pages (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)    
import-module (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)    
localdb (1)    
log file (1)    
logging (1)    
login (1)    
logon triggers (1)    
management (1)    
mcitp (1)    
mcts (1)    
memory tuning (1)    
memory-optimized table storage (1)    
memtoleave (1)    
microsoft r services (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)    
performance counters (1)    
permission (1)    
piecemeal (1)    
pivot table (1)    
processes (1)    
properties (1)    
public (1)    
query optimization (1)    
query store (qs) (1)    
r language (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_procoption (1)    
sp_server_diagnostics (1)    
sp_setnetname (1)    
sp_unbindefault (1)    
sp_unbindrule (1)    
space used (1)    
spn (1)    
sql audit (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 (tvf) (1)    
tcp port (1)    
telecommuting (1)    
templates (1)    
temporary tables (1)    
timeticks (1)    
trace (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)    
writefilegather (1)    
xp_cmdshell (1)    
xsl (1)    
 
Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.