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

Clear the Query Store

Read more...
By Steve Jones 2017/05/04 | Category: query store (qs)
Rating: (not yet rated) |  Discuss |   Briefcase | 881 reads

Minimal Config Restrictions

Read more...
By Steve Jones 2017/04/13 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 948 reads

The CPU Basis

Read more...
By Steve Jones 2017/04/07 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,061 reads

Cycling the error log

Read more...
By Steve Jones 2017/04/03 | Category: error log
Rating: (not yet rated) |  Discuss |   Briefcase | 1,068 reads

Start Running R Scripts

Read more...
By Steve Jones 2017/03/22 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 917 reads

DB MAXDOP Settings

Read more...
By Henrico Bekker 2017/03/21 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,015 reads

Multiple TCP Ports

Read more...
By Marek Grzymala 2017/03/20 | Category: browser
Rating: (not yet rated) |  Discuss |   Briefcase | 1,047 reads

Enable Trace Flags in SQL Server

Learn how to enable trace flags to change the behavior of your SQL Server instance.  Read more...
By Steve Jones 2017/03/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,446 reads

Minimal Configuration

Read more...
By Steve Jones 2017/03/13 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 901 reads

Change Your SQL Server Oil

Regular maintenance for your instance is important.  Read more...
By Steve Jones 2017/03/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 185 reads

Trace Flag Status

Read more...
By Steve Jones 2017/03/10 | Category: trace flags
Rating: (not yet rated) |  Discuss |   Briefcase | 946 reads

SET PROCESS AFFINITY

Read more...
By Steve Jones 2017/03/03 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 888 reads

Corrupt Page Notification

This trigger will send mail notification once a row is written in the suspect pages table  Read more...
By Henrico Bekker 2017/03/03 | Source: SQLServerCentral.com | Category: corruption
Rating: (not yet rated) |  Discuss |   Briefcase | 419 reads

SQL Server 2016 Just Runs Faster - DBCC

Read more...
By Steve Jones 2017/02/10 | Category: dbcc
Rating: (not yet rated) |  Discuss |   Briefcase | 1,079 reads

Preferred Node Policy-Setting on Traditional SQL Cluster

Preferred node setting facilitates instances on traditional cluster to be on the correct nodes which will lead to load-balancing of the resources.  Read more...
By SQL ADMIN 79 2017/02/02 | Source: SQLServerCentral.com | Category: clustering
Rating: (not yet rated) |  Discuss |   Briefcase | 555 reads

Broken tempdb

Read more...
By Steve Jones 2017/01/26 | Category: disaster recovery (dr)
Rating: (not yet rated) |  Discuss |   Briefcase | 1,198 reads

Powershell Script for regular DBA activities

This script will perfrom following tasks : 1. BackUp DB 2. Restore DB from BackUp File 3. Restore DB from DB 4. Create a new DB from Existing Db It takes care of all the possible failures during these operations, while done manually.   Read more...
By Mayank Shukla 2017/01/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,307 reads

Killing Statistics Jobs

Read more...
By Steve Jones 2017/01/10 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,101 reads

The Future of Auditing

Auditing is a weak point in SQL Server according to Steve Jones. He looks at a few of its flaws.  Read more...
By Steve Jones 2016/12/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 267 reads

The autogenerated view

Read more...
By Grant Fritchey 2016/12/20 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 989 reads
<< Newer    Items 41 to 60 of 1731    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (104)    
security (77)    
configuring (63)    
backup and restore (61)    
miscellaneous (59)    
performance tuning (45)    
indexing (44)    
monitoring (42)    
strategies (36)    
programming (32)    
maintenance and management (29)    
utility (27)    
maintenance (26)    
editorial (25)    
sql server 6.5 (25)    
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)    
tables (10)    
database mirroring (9)    
dts (9)    
search (9)    
storage (9)    
agent jobs (8)    
sql server 2008 (8)    
sql-dmo (8)    
tempdb (8)    
auditing (7)    
automated dba (7)    
best and worst practices (7)    
career (7)    
central management server (cms) (7)    
development (7)    
encryption (7)    
news (7)    
sqlservercentral (7)    
sys.dm_db_partition_stats (7)    
availability (6)    
corruption (6)    
dba (6)    
dbcc (6)    
files and filegroups (6)    
high availability (ha) (6)    
logins (6)    
recovery model (6)    
shrink database (6)    
worst practices (6)    
ado (5)    
automation (5)    
detach database (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)    
attach database (4)    
auto-growth (4)    
basics (4)    
change data capture (cdc) (4)    
checkpoint (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
extended events (xe) (4)    
filegroups (4)    
for xml path (4)    
fragmentation (4)    
integration services (ssis) (4)    
maintenance plans (4)    
naming standards (4)    
numa (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
space usage (4)    
sys.allocation_units (4)    
system development life cycle (4)    
transparent data encryption (tde) (4)    
administrator (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)    
partitioning (3)    
read only (3)    
role (3)    
row compression (3)    
script (3)    
sql server agent (3)    
sqlclr (3)    
state of the business (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)    
contained databases (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)    
index (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)    
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)    
automatic tuning (1)    
availability group (ag) (1)    
backup and recovery (1)    
backup database (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 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)    
copy backup (1)    
copy_only (1)    
create database (1)    
cxpacket (1)    
data (1)    
data and log file usage (1)    
data file (1)    
data flow (1)    
data gathering (1)    
data quality (1)    
data quality services (dqs) (1)    
database configuration (1)    
database engine (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)    
dbcc shrinkfile (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 property (1)    
extended stored procedures (1)    
failover clustered instance (fci) (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)    
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)    
master database (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 and tuning (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)    
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_addmessage() (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)    
suspect pages (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.messages (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-2018 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.