Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Administration Rss

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

Service Principal Names

By Tom Nicol 2014/08/07 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,800 reads

Spackle: Making sure you can connect to the DAC

The DAC is an important tool and several things can go wrong when trying to connect to it.  Read more...
By Kenneth Fisher 2014/07/31 | Source: SQLServerCentral.com | Category: dac
Rating: |  Discuss |   Briefcase | 3,003 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 2014/07/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 138 reads

In-Memory feature

By free mascot 2014/07/29 | Category: memory-optimized table storage
Rating: (not yet rated) |  Discuss |   Briefcase | 1,566 reads

Recovery Interval

By free mascot 2014/07/22 | Category: recovery interval
Rating: (not yet rated) |  Discuss |   Briefcase | 1,647 reads

Physical Server or a Virtual Machine?

Simple T-SQL Script to know whether your SQL Server is running on a Physical box or a VM. Note: This Script works only on 2008R2 SP1 and above.   Read more...
By SreeSql 2014/07/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,122 reads

Kill SPID (SQL Spackle)

How to find and kill a runaway or blocking session.  Read more...
By Kenneth Fisher 2014/07/01 | Source: SQLServerCentral.com | Category: kill
Rating: |  Discuss |   Briefcase | 2,885 reads

Effective Max

By Steve Jones 2014/06/23 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,562 reads

No Files For You

By Andy Warren 2014/06/18 | Category: sys.database_files
Rating: (not yet rated) |  Discuss |   Briefcase | 1,661 reads

Compressed Backups

By Steve Jones 2014/06/13 | Category: backup / recovery
Rating: (not yet rated) |  Discuss |   Briefcase | 1,443 reads

Logging in Maintenance Plans

Enabling and Configuring Reporting and Logging for Maintenance Plans in SQL Server 2012  Read more...
By C.J. Garcia 2014/06/12 | Source: SQLServerCentral.com | Category: maintenance plans
Rating: |  Discuss |   Briefcase | 2,281 reads

Resource Governor pools

By Steve Jones 2014/06/10 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,301 reads

Display All Errors Fired in a Restore Procedure

Display all errors thrown within a catch block by a restore statement in a stored procedure using extended events  Read more...
By Brian Awe 2014/06/10 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 3,089 reads

Dropping a Memory-optimized filegroup

By rhythm k 2014/06/09 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,274 reads

Restore

By free mascot 2014/06/06 | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,493 reads

Cardinality Regression

By Steve Jones 2014/06/02 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,308 reads

Resource Governor

By Steve Jones 2014/05/29 | Category: resource governor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,287 reads

Memory-Optimized Table Filegroups

By Steve Jones 2014/05/27 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,352 reads
<< Newer    Items 41 to 60 of 1568    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (100)    
security (69)    
configuring (63)    
miscellaneous (55)    
backup / restore (46)    
performance tuning (45)    
indexing (42)    
monitoring (40)    
strategies (36)    
programming (32)    
maintenance and management (29)    
utility (27)    
maintenance (26)    
sql server 6.5 (25)    
editorial (21)    
disaster recovery (dr) (19)    
blogs (18)    
database design (18)    
reporting services (ssrs) (17)    
stored procedures (17)    
powershell (16)    
advanced querying (15)    
installation (13)    
replication (13)    
sql server 2014 (13)    
visual basic 6 (12)    
backup / recovery (10)    
dts (9)    
search (9)    
storage (9)    
tables (9)    
transaction logs (9)    
restore (8)    
sql server 2008 (8)    
sql-dmo (8)    
statistics (8)    
automated dba (7)    
best and worst practices (7)    
career (7)    
database mirroring (7)    
development (7)    
jobs (7)    
news (7)    
sql server (7)    
sys.dm_db_partition_stats (7)    
auditing (6)    
availability (6)    
dba (6)    
recovery model (6)    
resource governor (6)    
shrink database (6)    
sqlservercentral (6)    
tempdb (6)    
worst practices (6)    
ado (5)    
automation (5)    
backup (5)    
central management server (cms) (5)    
files and filegroups (5)    
high availability (ha) (5)    
list indexes (5)    
memory-optimized tables (5)    
pivot (5)    
policy based management (pbm) (5)    
sql server 2012 (5)    
.net (4)    
auto-growth (4)    
basics (4)    
corruption (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
encryption (4)    
filegroups (4)    
for xml path (4)    
fragmentation (4)    
integration services (ssis) (4)    
maintenance plans (4)    
naming standards (4)    
performance (4)    
permissions (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
sql agent (4)    
sys.allocation_units (4)    
system development life cycle (4)    
triggers (4)    
troubleshooting (4)    
administrator (3)    
cardinality estimates (3)    
configuration (3)    
dbcc (3)    
dbcc checkdb (3)    
disk space (3)    
distributed queries (3)    
editorial - ipod (3)    
editorial - wmv (3)    
extended events (3)    
foreign keys (fk) (3)    
friday poll (3)    
kill (3)    
log shipping (3)    
networking (3)    
numa (3)    
partitioning (3)    
role (3)    
space usage (3)    
sql server agent (3)    
sqlclr (3)    
state of the business (3)    
transparent data encryption (tde) (3)    
tuning (3)    
advanced (2)    
analysis services (ssas) (2)    
attach (2)    
attach database (2)    
azure (2)    
best practices (2)    
browser service (2)    
buffer cache (2)    
capacity planning (2)    
clustering (2)    
columns (2)    
compression (2)    
dac (2)    
data compression (2)    
data storage (2)    
database (2)    
database size (2)    
database snapshots (2)    
database weekly (2)    
ddl (2)    
detach (2)    
dmv (2)    
editorial - mp3 (2)    
error logging (2)    
filestream (2)    
full text search (2)    
full-text search (2)    
grant (2)    
instant file initialization (2)    
isolation levels (2)    
lock and connection management (2)    
locking (2)    
logins (2)    
management studio (ssms) (2)    
memory (2)    
migration (2)    
miscellaneous (2)    
missing indexes (2)    
performance monitoring (2)    
product reviews (2)    
professional development (2)    
profiler (2)    
reviews (2)    
row compression (2)    
script (2)    
server configuration (2)    
smo (2)    
sql puzzles (2)    
sql server 2008 r2 (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)    
trace flags (2)    
uptime (2)    
user (2)    
user defined function (udf) (2)    
users (2)    
video (2)    
virtualization (2)    
xml (2)    
xp_logininfo (2)    
aggregates (1)    
alerts (1)    
alter database (1)    
alwayson (1)    
architecture (1)    
autogrowth (1)    
backup/restore (1)    
blocking (1)    
buffer pool extension (1)    
bugs (1)    
build list (1)    
bulk insert (1)    
bulk logged recovery model (1)    
business intelligence (1)    
central management server (1)    
certifications (1)    
change data capture (cdc) (1)    
change tracking (1)    
checkdb (1)    
checkpoint (1)    
cleanup (1)    
cms (1)    
collation (1)    
columnstore indexes (1)    
common language runtime (clr) (1)    
compact edition (1)    
compressed backup (1)    
conferences and events (1)    
configuration repository (1)    
connectivity (1)    
consolidation (1)    
constraints (1)    
contained databases (1)    
copy backup (1)    
copy_only (1)    
create database (1)    
data (1)    
data and log file usage (1)    
data flow (1)    
data gathering (1)    
data quality (1)    
data quality services (dqs) (1)    
data types (1)    
database growth status (1)    
database mail (1)    
database owner (1)    
database roles (1)    
databases (1)    
dbmail (1)    
ddl triggers (1)    
declarative management framework (dmf) (1)    
default (1)    
defragmentation (1)    
detach database (1)    
details (1)    
diagnostic (1)    
distributed transactions (1)    
distribution (1)    
dmv's (1)    
drive space (1)    
duplicate indexes (1)    
dynamic management views (1)    
dynamic script to copy backup (1)    
endpoints (1)    
english query (1)    
errorlogs (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)    
function (1)    
ghost cleanup (1)    
growth trend (1)    
guest user (1)    
heap (1)    
heaps (1)    
indexed views (1)    
information_schema (1)    
in-memory oltp (1)    
instance (1)    
kill sessions (1)    
latest backup (1)    
learning (1)    
linked servers (1)    
log file (1)    
log files (1)    
logging (1)    
login (1)    
login information (1)    
management (1)    
maxdop (1)    
mcitp (1)    
mcts (1)    
memory tuning (1)    
memory-optimized table storage (1)    
memtoleave (1)    
monitor (1)    
monitor server (1)    
move (1)    
multi process (1)    
nightly jobs (1)    
normalization (1)    
object permissions (1)    
olap server (1)    
openxml (1)    
operations manager (1)    
other (1)    
page compression (1)    
parallelism (1)    
pass summit (1)    
passwords (1)    
performance counters (1)    
piecemeal (1)    
process (1)    
properties (1)    
public (1)    
query optimization (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)    
resource database (1)    
roles (1)    
rules (1)    
running aggregate (1)    
running totals (1)    
sample chapters (1)    
scalability (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)    
size (1)    
skills (1)    
sliding windows technique (1)    
slipstream (1)    
soap (1)    
sp_bindefault (1)    
sp_bindrule (1)    
sp_configure (1)    
sp_server_diagnostics (1)    
sp_unbindefault (1)    
sp_unbindrule (1)    
space used (1)    
spn (1)    
sql jobs (1)    
sql monitor (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 size (1)    
table valued function (1)    
telecommuting (1)    
templates (1)    
temporary tables (1)    
trace (1)    
trace flag (1)    
transaction isolation levels (1)    
transaction log (1)    
transactions (1)    
truncate table (1)    
trustworthy (1)    
updategrams (1)    
upgrading (1)    
version (1)    
view_column_usage (1)    
visual studio (1)    
vmware (1)    
warehouse (1)    
webinar (1)    
windows 2003 (1)    
xsl (1)