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

Content with tag Administration Rss

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

How to Change the File Extension for a Data File

This is a fix to primary data file that is created with a different file extension or accidentally renamed to a different file extension  Read more...
By Sadan Kumar Budde 2018/01/08 | Source: SQLServerCentral.com | Category: data file
Rating: |  Discuss |   Briefcase | 699 reads

Partial Shrinking

By Steve Jones 2018/01/05 | Category: dbcc shrinkfile
Rating: (not yet rated) |  Discuss |   Briefcase | 863 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 2017/12/21 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,524 reads

Enabling Automatic Tuning

By Steve Jones 2017/12/18 | Category: automatic tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 765 reads

Changing the Path for the Master Database

We as DBAs, changing or migrating databases to a new path is important part of admin’s world. This article helps you with the steps involved to move the Critical 'master' database.   Read more...
By Sadan Kumar Budde 2017/12/14 | Source: SQLServerCentral.com | Category: master database
Rating: |  Discuss |   Briefcase | 625 reads

NUMA

By Steve Jones 2017/12/04 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 741 reads

Is This Database Being Used?

Can we delete this database, or is someone still using it?  Read more...
By Ginger Keys 2017/12/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,885 reads

Extended Properties

By Steve Jones 2017/11/30 | Category: extended property
Rating: (not yet rated) |  Discuss |   Briefcase | 770 reads

Automatic Plan Correction

By Steve Jones 2017/11/27 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 759 reads

Read Only access to all databases to a user in a SQL Server Instance

Script to grant a SQL a user read-only access to all the databases in Server instance except the system databases and -- the Log shipped databases(if any : secondary :read-only)   Read more...
By Gaurav Deep Juneja 2017/11/22 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 312 reads

Adding custom messages

By Steve Jones 2017/11/17 | Category: sys.messages
Rating: (not yet rated) |  Discuss |   Briefcase | 795 reads

Setting Containment

By Steve Jones 2017/10/02 | Category: contained databases
Rating: (not yet rated) |  Discuss |   Briefcase | 789 reads

The Filestream Share Name

By Steve Jones 2017/08/18 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 721 reads

More LocalDB instances

By Steve Jones 2017/08/10 | Category: localdb
Rating: (not yet rated) |  Discuss |   Briefcase | 886 reads

Timeticks

By Steve Jones 2017/08/07 | Category: timeticks
Rating: (not yet rated) |  Discuss |   Briefcase | 902 reads

IO BUSY

By Steve Jones 2017/08/03 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 946 reads

Script DB Level Permissions v4.3

Script database and object level permissions for all database users  Read more...
By S. Kusen 2017/07/25 | Source: SQLServerCentral.com | Category: login
Rating: |  Discuss |   Briefcase | 1,554 reads

PARTIAL Restores

By Steve Jones 2017/07/18 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 967 reads

Turn off Database Mirroring

By Steve Jones 2017/06/26 | Category: database mirroring
Rating: (not yet rated) |  Discuss |   Briefcase | 814 reads

Protecting Encrypted Backups

By Steve Jones 2017/06/23 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 785 reads
<< Newer    Items 21 to 40 of 1738    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (105)    
security (77)    
configuring (63)    
backup and restore (61)    
miscellaneous (59)    
indexing (46)    
performance tuning (45)    
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)    
backup (13)    
installation (13)    
replication (13)    
sql server 2014 (13)    
transaction log (13)    
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)    
extended events (xe) (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)    
columnstore index (4)    
crosstab (4)    
data file management (4)    
data warehousing (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)    
compression (3)    
configuration (3)    
database (3)    
dbcc checkdb (3)    
dbcc shrinkfile (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)    
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)    
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)