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

The DBA is Dead

Is the DBA Dead? Steve Jones scoffs at the notion put forth in an article and says we'll be using DBAs for a long time. He does, however, admit the role is changing.  Read more...
By Steve Jones 2014/01/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 429 reads

Management at Scale

Could you manage 20,000 databases? That's how many servers each person at Facebook has to manage in operations.  Read more...
By Steve Jones 2014/01/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 164 reads

Leveraging Constraint Evaluation Sequence in SQL Server

Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.  Read more...
By Nakul Vachhrajani 2014/01/27 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 2,598 reads

Common Checks

This Friday Steve Jones wants to know what types of things are you checking for on your instances. What items can cause you issues if you don't proactively monitor for them.  Read more...
By Steve Jones 2014/01/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 190 reads

Replication

By Steve Jones 2014/01/22 | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 1,445 reads

Tempdb

By free mascot 2014/01/20 | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 2,123 reads

The PoSh DBA - Reading and Filtering Errors

DBAs regularly need to keep an eye on the error logs of all their SQL Servers, and the event logs of the host servers as well. When server numbers get large, the traditional Windows GUI approach breaks down, and the PoSH DBA reaches for a PowerShell script to do the leg-work.   Read more...
By Additional Articles 2014/01/20 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,236 reads

Creating a DBA's Library

A DBA Library: it's not the library in traditional terms where you have books and journals stacked on your desk; rather it's a centralized and integrated repository of knowledge, information and applications for the DBA.  Read more...
By Additional Articles 2014/01/17 | Source: MSSQLTips.com | Category: administration
Rating:  Rate this |   Briefcase | 3,756 reads

SQL Server Browser

By Mike Hays 2014/01/16 | Category: browser service
Rating: (not yet rated) |  Discuss |   Briefcase | 1,638 reads

TEMPDB Configuration per vCPU

A simple script for automation of additional secondary data files of tempdb.  Read more...
By Paulo Nascimento 2014/01/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,875 reads

Dynamically create drop user statistics scripts

Generate script to drop any unwanted user created statistics.  Read more...
By David Kranes 2014/01/09 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 843 reads

Auto Create Statistics

By Mike Hays 2014/01/07 | Category: statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 1,618 reads

View Active Session SQL

This script can be used to view current SQL statements being executed for all or any one SPID.  Read more...
By David Kranes 2014/01/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,089 reads

Keeping Track of your SQL Servers with a DBA Configuration Repository

SQL Server DBAs are often responsible for managing large number of database instances. This article talks about the concept of a Configuration Repository where DBAs can manage all the information related to their SQL Servers  Read more...
By Additional Articles 2014/01/03 | Source: MSSQLTips.com | Category: configuration repository
Rating:  Rate this |   Briefcase | 3,494 reads

Dropping indexes

By Jagadish Punnapu 2014/01/02 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,088 reads

Using Extended Properties To Keep Everyone Informed

Use CMS and Extended Properties to store information about multiple servers, including the stakeholders who should know about any maintenance you are planning.  Read more...
By E Bond 2014/01/01 (first published: 2010/11/30) | Source: SQLServerCentral.com | Category: central management server (cms)
Rating: |  Discuss |   Briefcase | 8,964 reads

List all Usernames, Roles for all the databases.

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).  Read more...
By Shiva Challa 2013/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 20,188 reads

The PoSH DBA - SQLPSX: SQL Server PowerShell Extensions

Every DBA needs to know about SQLPSX, the PowerShell module library that is built by DBAs for DBAs, and designed to provide intuitive functions around the SMO objects. Laerte Junior, who is one of the developers on the open-source project, describes how to use it.  Read more...
By Additional Articles 2013/12/27 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,478 reads

Table Information View -- No Cursors!

Row counts and storage space information for all tables in the database. (SQL Server 2005).  Read more...
By RBarry Young 2013/12/26 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 15,865 reads

Central Management Server Security

By Steve Jones 2013/12/24 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,194 reads
<< Newer    Items 41 to 60 of 1522    Older >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (100)    
security (64)    
configuring (63)    
miscellaneous (55)    
backup / restore (46)    
performance tuning (45)    
monitoring (40)    
indexing (37)    
strategies (36)    
programming (32)    
maintenance and management (29)    
utility (27)    
maintenance (26)    
sql server 6.5 (25)    
blogs (18)    
database design (18)    
disaster recovery (dr) (18)    
editorial (18)    
stored procedures (17)    
reporting services (ssrs) (16)    
advanced querying (15)    
powershell (15)    
installation (13)    
replication (13)    
visual basic 6 (12)    
sql server 2014 (11)    
backup / recovery (9)    
dts (9)    
search (9)    
storage (9)    
tables (9)    
sql-dmo (8)    
statistics (8)    
transaction logs (8)    
automated dba (7)    
best and worst practices (7)    
career (7)    
database mirroring (7)    
development (7)    
news (7)    
sql server (7)    
sql server 2008 (7)    
sys.dm_db_partition_stats (7)    
auditing (6)    
availability (6)    
dba (6)    
jobs (6)    
recovery model (6)    
resource governor (6)    
restore (6)    
shrink database (6)    
sqlservercentral (6)    
tempdb (6)    
worst practices (6)    
ado (5)    
central management server (cms) (5)    
list indexes (5)    
memory-optimized tables (5)    
pivot (5)    
policy based management (pbm) (5)    
.net (4)    
auto-growth (4)    
basics (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
encryption (4)    
filegroups (4)    
files and filegroups (4)    
for xml path (4)    
high availability (ha) (4)    
maintenance plans (4)    
naming standards (4)    
permissions (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
sql agent (4)    
sql server 2012 (4)    
sys.allocation_units (4)    
system development life cycle (4)    
triggers (4)    
troubleshooting (4)    
administrator (3)    
automation (3)    
cardinality estimates (3)    
configuration (3)    
corruption (3)    
dbcc (3)    
disk space (3)    
distributed queries (3)    
editorial - ipod (3)    
editorial - wmv (3)    
extended events (3)    
foreign keys (fk) (3)    
integration services (ssis) (3)    
kill (3)    
log shipping (3)    
networking (3)    
numa (3)    
partitioning (3)    
performance (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)    
data compression (2)    
data storage (2)    
database size (2)    
database snapshots (2)    
database weekly (2)    
dbcc checkdb (2)    
ddl (2)    
detach (2)    
dmv (2)    
editorial - mp3 (2)    
error logging (2)    
fragmentation (2)    
friday poll (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)    
storage management (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)    
uptime (2)    
user (2)    
user defined function (udf) (2)    
users (2)    
video (2)    
virtualization (2)    
xml (2)    
xp_logininfo (2)    
aggregates (1)    
alter database (1)    
alwayson (1)    
architecture (1)    
autogrowth (1)    
backup (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)    
certifications (1)    
change data capture (cdc) (1)    
change tracking (1)    
checkdb (1)    
checkpoint (1)    
cleanup (1)    
collation (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_only (1)    
create database (1)    
dac (1)    
data (1)    
data and log file usage for a db (1)    
data quality (1)    
data quality services (dqs) (1)    
data types (1)    
database (1)    
database mail (1)    
database owner (1)    
database properties (1)    
database roles (1)    
databases (1)    
ddl triggers (1)    
declarative management framework (dmf) (1)    
default (1)    
defragmentation (1)    
diagnostic (1)    
distributed transactions (1)    
distribution (1)    
dmv's (1)    
duplicate indexes (1)    
dynamic management views (1)    
endpoints (1)    
english query (1)    
errorlogs (1)    
excel (1)    
extended properties (1)    
extended stored procedures (1)    
file location (1)    
filestream (1)    
full recovery model (1)    
function (1)    
ghost cleanup (1)    
growth trend (1)    
guest user (1)    
heap (1)    
heaps (1)    
index details (1)    
indexed views (1)    
indexes (1)    
information_schema (1)    
instance properties (1)    
kill sessions (1)    
learning (1)    
linked servers (1)    
log file (1)    
logging (1)    
login (1)    
login information (1)    
management (1)    
maxdop (1)    
mcitp (1)    
mcts (1)    
memory tuning (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)    
piecemeal (1)    
process (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)    
reorganize indexes (1)    
report (1)    
reporting services (1)    
resource database (1)    
roles (1)    
rules (1)    
running aggregate (1)    
running totals (1)    
sample chapters (1)    
scalability (1)    
scripting (1)    
selectivity (1)    
server migration (1)    
server roles (1)    
server settings (1)    
server_principals (1)    
serverproperty (1)    
service broker (1)    
shrinkfile (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)    
sql monitor (1)    
sql server essentials (1)    
sql server express (1)    
sql sever 2014 (1)    
sql spackle (1)    
sql virtual restore (1)    
sqlpsx (1)    
stairway series (1)    
string manipulation (1)    
striped backups (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 (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)