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

Content with tag Administration Rss

<< Newer    Items 21 to 40 of 1700    Older >>
 

SET PROCESS AFFINITY

By Steve Jones 2017/03/03 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 855 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 | 364 reads

SQL Server 2016 Just Runs Faster - DBCC

By Steve Jones 2017/02/10 | Category: dbcc
Rating: (not yet rated) |  Discuss |   Briefcase | 1,049 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 | 535 reads

Broken tempdb

By Steve Jones 2017/01/26 | Category: disaster recovery (dr)
Rating: (not yet rated) |  Discuss |   Briefcase | 1,168 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,156 reads

Killing Statistics Jobs

By Steve Jones 2017/01/10 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,079 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 | 265 reads

The autogenerated view

By Grant Fritchey 2016/12/20 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 970 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 2016/12/16 (first published: 2015/03/09) | Source: SQLServerCentral.com | Category: log files
Rating: |  Discuss |   Briefcase | 9,635 reads

Password Policy

By Steve Jones 2016/12/07 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,001 reads

Kill SPIDs through automated job(while restore)

Here's a script, for killing a SPIDs against a particular database, here am using BIN as the database.   Read more...
By Rinu George Philip 2016/12/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,671 reads

Managing SQL Server with PowerShell

By Steve Jones 2016/11/28 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 992 reads

ALTERing Availability Groups

By Steve Jones 2016/11/23 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 876 reads

Using the DAC

By Steve Jones 2016/11/14 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,091 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,332 reads

A Better sp_Spaceused

By Steve Jones 2016/11/07 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,039 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,417 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,368 reads

Dropping Audit Sessions

By Steve Jones 2016/10/28 | Category: sql audit
Rating: (not yet rated) |  Discuss |   Briefcase | 862 reads
<< Newer    Items 21 to 40 of 1700    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (104)    
security (74)    
configuring (63)    
backup and restore (58)    
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)    
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)    
filestream (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)    
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)    
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)