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

Content with tag Administration Rss

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

Solving the Target Principal Name is Incorrect

One small point to note when we receive the below error while connecting SQL server: The target principal name is incorrect. Cannot generate sspi context  Read more...
By Raghavender Chavva 2018/05/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 687 reads

Checking CHECKDB

Everyone should be running DBCC CHECKDB on their systems. We not have some help in determining if we are doing this.  Read more...
By Steve Jones 2018/05/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 68 reads

Corrupted Backups

By Steve Jones 2018/05/21 | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 846 reads

Database creation settings

By Steve Jones 2018/05/08 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 918 reads

New data in a columnstore index

By Steve Jones 2018/05/03 | Category: columnstore index
Rating: (not yet rated) |  Discuss |   Briefcase | 763 reads

EMPTYFILE

By Steve Jones 2018/05/01 | Category: dbcc shrinkfile
Rating: (not yet rated) |  Discuss |   Briefcase | 769 reads

Starting Extended Events

By Steve Jones 2018/04/24 | Category: extended events (xe)
Rating: (not yet rated) |  Discuss |   Briefcase | 661 reads

Cancelling DBCC SHRINKFILE with EMPTYFILE

A fun experiment using DBCC SHRINKFILE to rebalance data.  Read more...
By Steve Jones 2018/04/23 | Source: SQLServerCentral.com | Category: dbcc shrinkfile
Rating: |  Discuss |   Briefcase | 820 reads

How to Programmatically Identify When Your SQL Server Was Last Started

Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.  Read more...
By Additional Articles 2018/04/23 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 3,697 reads

SQL Server Services

By Raghavender Chavva 2018/04/16 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 871 reads

Detaching CDC

By Steve Jones 2018/04/12 | Category: change data capture (cdc)
Rating: (not yet rated) |  Discuss |   Briefcase | 777 reads

How to Programmatically Identify When Your SQL Server Was Last Started

Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.  Read more...
By Additional Articles 2018/04/10 | Source: Database Journal | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 3,409 reads

CDC and Restores

By Steve Jones 2018/03/23 | Category: change data capture (cdc)
Rating: (not yet rated) |  Discuss |   Briefcase | 721 reads

Unused Indexes in your databases

This Script allows you to determine the list of unused indexes in your databases. For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude  Read more...
By Rabie Harriga 2018/03/06 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 5,597 reads

Monitoring for Non Existent Events

Many DBAs monitor for those events they expect to happen, either successfully or failed. However many DBAs wouldn't be aware of an event never occurring.  Read more...
By Steve Jones 2018/02/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 186 reads

Restoring with CDC

By Steve Jones 2018/02/22 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 787 reads
<< Newer    Items 21 to 40 of 1762    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (106)    
security (78)    
backup and restore (64)    
configuring (63)    
miscellaneous (59)    
indexing (50)    
performance tuning (45)    
monitoring (42)    
strategies (36)    
programming (32)    
maintenance and management (29)    
utility (27)    
editorial (26)    
maintenance (26)    
sql server 6.5 (25)    
powershell (21)    
disaster recovery (dr) (20)    
blogs (18)    
database design (18)    
stored procedures (18)    
reporting services (ssrs) (17)    
advanced querying (15)    
installation (14)    
backup (13)    
replication (13)    
sql server 2014 (13)    
transaction log (13)    
visual basic 6 (12)    
resource governor (11)    
statistics (data) (11)    
tables (11)    
restore (10)    
sql server (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)    
dbcc (7)    
development (7)    
encryption (7)    
news (7)    
sqlservercentral (7)    
sys.dm_db_partition_stats (7)    
availability (6)    
corruption (6)    
dba (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 (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)    
buffer pool extensions (bpe) (4)    
change data capture (cdc) (4)    
checkpoint (4)    
columnstore index (4)    
configuration (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
dbcc checkdb (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)    
alter database (3)    
azure (3)    
cardinality estimates (3)    
clustering (3)    
columns (3)    
compression (3)    
database (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)    
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)    
always on (2)    
analysis services (ssas) (2)    
attach (2)    
autogrowth (2)    
availability group (ag) (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 engine (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)    
stairway series (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)    
azure sql database (1)    
backup database (1)    
backup-restore (1)    
blocking (1)    
browser (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)    
computed columns (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)    
create xml index (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 files (1)    
database growth status (1)    
database mail (1)    
database owner (1)    
database roles (1)    
database scoped configuration (1)    
databases (1)    
datatypes (1)    
dbatools.io (1)    
dbcc show_statistics (1)    
dbmail (1)    
ddl trigger (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)    
errors (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 data store (qds) (1)    
query optimization (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)    
string manipulation (1)    
summary (1)    
suspect page (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)