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


 

Content with tag Administration Rss

   Items 1 to 20 of 1409    Next 20 >>
 

PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers

We came across a scenario where database bak files being created from long time which are no more in use...  Read more...
By Prashanth Jayaram 2013/05/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 836 reads

How to Change the SQL Server Name after Renaming the Windows Host

This article shows how to change a SQL Server name after changing the Windows machine name.  Read more...
By Shashank Srivastava 2013/05/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,991 reads

Loginless In Seattle

Identify orphaned Database Users and differentiate them from "Loginless" Database Users.  Read more...
By Orlando Colamatteo 2013/05/13 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,688 reads

List of Stored Procedures modified in past 7 days

Provide list of Stored Procedures that have been changed in past 7 days.  Read more...
By Nitesh Dedhia 2013/04/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,445 reads

Script to find the total used size of all database inside SQL Server

Script to find the total used size of all database inside SQL Server  Read more...
By Shashank Srivastava 2013/04/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,172 reads

Search for an object across multiple databases on a server.

There are other options available like Sql search from Red Gate. Here's a simple script to search for objects(s) containing a particular keyword.   Read more...
By Kishore Tallapragada 2013/04/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,675 reads

Endpoints

Read more...
By Steve Jones 2013/04/12 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,513 reads

Quick tip: Using sp_server_diagnostics

In SQL Server 2012 a new procedure sp_server_diagnostics returns a payload of information about server health and performance. The sproc...  Read more...
By matt.bowler 2013/04/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,711 reads

How To Check SQL SERVER Uptime Through T-SQL

Services uptime can be checked through WMI scripts and other methods also. As a DBA most of us would like to know the uptime of SQL Server  Read more...
By Adeoye Omoboya 2013/04/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,641 reads

Throttle a Query in Mid-Execution

Resource Governor provides a great mechanism for throttling resources, but it doesn't always allow granular control. Read about this trace flag that allows you to dynamically alter the resource usage of a query.  Read more...
By Steve Jones 2013/04/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,319 reads

Database Mirroring

Read more...
By Naseer Ahmad 2013/03/27 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,639 reads

Full-Text Search – Thesaurus Languages

Read more...
By Steve Jones 2013/03/19 | Category: full text search
Rating: (not yet rated) |  Discuss |   Briefcase | 1,546 reads

List all tables and their respective information.

List all tables in a SQL Server database with the details of them.  Read more...
By Fernando Casas Osorio 2013/03/14 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 2,054 reads

Resetting DMVs

Steve Jones asks the question why so much data in SQL Server is cleared when we restart an instance.  Read more...
By Steve Jones 2013/03/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 121 reads

Brent Ozar's Six Scary SQL Surprises

In lesson 3 of the Top 5 Hard-earned Lessons of a DBA series, Brent Ozar exposes six common but scary surprises that can lurk behind the façade of SSMS. Read it now, and learn hard lessons the easy way.  Read more...
By Additional Articles 2013/03/08 | Source: Red-Gate | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 6,358 reads

Working with SQL Server Recovery Models

The recovery models of SQL Server define how different backup and restore tasks will be performed on your database. When choosing a recovery model,   Read more...
By Prett Sons 2013/03/05 | Source: SQLServerCentral.com | Category: recovery model
Rating: |  Discuss |   Briefcase | 3,208 reads

Alter User

Read more...
By Ole Kristian Velstadbråten Bangås 2013/02/18 | Category: user
Rating: (not yet rated) |  Discuss |   Briefcase | 1,892 reads

Troubleshooting and Fixing SQL Server Page Level Corruption

Corrupt SQL Server databases are the worst nightmare of any SQL Server professional. In any environment, from small business to enterprise, the compromise of integrity and availability of the data can constitute a business emergency. This is especially the case in those organizations reliant on an OLTP data model, for a high-volume website. SQL Server database corruption and disruption of the transaction processing system can cause business repercussions such as large financial losses, a drop in reputation or customer retention, or contractual SLA problems with the service provider, if not managed in-house.  Read more...
By Additional Articles 2013/02/18 | Source: MSSQLTips.com | Category: corruption
Rating: (not yet rated)  Rate this |   Briefcase | 2,176 reads

Moving Database Files in SQL Server

A short article that talks about the isues with moving SQL Server database files around on your storage subsystem.  Read more...
By Perry Whittle 2013/02/11 | Source: SQLServerCentral.com | Category: files and filegroups
Rating: |  Discuss |   Briefcase | 7,287 reads

Thesaurus Files

Read more...
By Steve Jones 2013/02/08 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,847 reads
   Items 1 to 20 of 1409    Next 20 >>
 
Tags
sql server 7 (333)    
sql server 2005 (182)    
t-sql (98)    
configuring (63)    
security (58)    
miscellaneous (55)    
backup / restore (45)    
performance tuning (45)    
monitoring (38)    
strategies (36)    
indexing (34)    
programming (32)    
maintenance and management (29)    
utility (27)    
maintenance (25)    
sql server 6.5 (25)    
database design (18)    
disaster recovery (dr) (18)    
blogs (17)    
stored procedures (17)    
reporting services (ssrs) (16)    
advanced querying (15)    
installation (13)    
powershell (12)    
replication (12)    
visual basic 6 (12)    
editorial (11)    
dts (9)    
search (9)    
storage (9)    
tables (9)    
backup / recovery (8)    
sql-dmo (8)    
automated dba (7)    
best and worst practices (7)    
development (7)    
news (7)    
sql server 2008 (7)    
sys.dm_db_partition_stats (7)    
transaction logs (7)    
availability (6)    
career (6)    
dba (6)    
shrink database (6)    
worst practices (6)    
ado (5)    
auditing (5)    
database mirroring (5)    
jobs (5)    
list indexes (5)    
pivot (5)    
policy based management (pbm) (5)    
recovery model (5)    
sql server (5)    
sqlservercentral (5)    
.net (4)    
auto-growth (4)    
basics (4)    
crosstab (4)    
data file management (4)    
data warehousing (4)    
for xml path (4)    
naming standards (4)    
permissions (4)    
routine database growth (4)    
routine growth (4)    
service packs (4)    
statistics (4)    
sys.allocation_units (4)    
system development life cycle (4)    
tempdb (4)    
triggers (4)    
troubleshooting (4)    
administrator (3)    
automation (3)    
central management server (3)    
corruption (3)    
dbcc (3)    
disk space (3)    
distributed queries (3)    
editorial - ipod (3)    
editorial - wmv (3)    
encryption (3)    
files and filegroups (3)    
foreign keys (fk) (3)    
integration services (ssis) (3)    
log shipping (3)    
networking (3)    
numa (3)    
partitioning (3)    
resource governor (3)    
restore (3)    
role (3)    
space usage (3)    
sql agent (3)    
state of the business (3)    
transparent data encryption (tde) (3)    
advanced (2)    
attach (2)    
attach database (2)    
best practices (2)    
buffer cache (2)    
capacity planning (2)    
clustering (2)    
columns (2)    
configuration (2)    
data storage (2)    
database size (2)    
database snapshots (2)    
detach (2)    
dmv (2)    
editorial - mp3 (2)    
error logging (2)    
extended events (2)    
fragmentation (2)    
full text search (2)    
full-text search (2)    
grant (2)    
high availability (ha) (2)    
instant file initialization (2)    
isolation levels (2)    
kill (2)    
lock and connection management (2)    
locking (2)    
logins (2)    
maintenance plans (2)    
management studio (ssms) (2)    
migration (2)    
miscellaneous (2)    
performance monitoring (2)    
product reviews (2)    
profiler (2)    
reviews (2)    
row compression (2)    
script (2)    
smo (2)    
sql puzzles (2)    
sql server 2008 r2 (2)    
sql server 2012 (2)    
sql server agent (2)    
sqlclr (2)    
storage management (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)    
tuning (2)    
uptime (2)    
user (2)    
user defined function (udf) (2)    
users (2)    
video (2)    
xml (2)    
xp_logininfo (2)    
aggregates (1)    
alter database (1)    
analysis services (ssas) (1)    
architecture (1)    
autogrowth (1)    
backup (1)    
backup/restore (1)    
browser service (1)    
bugs (1)    
build list (1)    
bulk insert (1)    
business intelligence (1)    
certification (1)    
checkdb (1)    
cleanup (1)    
collation (1)    
common language runtime (clr) (1)    
compact edition (1)    
compression (1)    
conferences and events (1)    
connectivity (1)    
contained databases (1)    
copy_only (1)    
create database (1)    
dac (1)    
data (1)    
data and log file usage for a db (1)    
data compression (1)    
data quality (1)    
data types (1)    
database (1)    
database mail (1)    
database owner (1)    
database properties (1)    
database roles (1)    
database weekly (1)    
databases (1)    
dbcc checkdb (1)    
ddl (1)    
ddl triggers (1)    
declarative management framework (dmf) (1)    
default (1)    
defragmentation (1)    
diagnostic (1)    
distribution (1)    
dmv's (1)    
duplicate indexes (1)    
endpoints (1)    
english query (1)    
errorlogs (1)    
excel (1)    
extended properties (1)    
extended stored procedures (1)    
file location (1)    
filegroup (1)    
filegroups (1)    
friday poll (1)    
function (1)    
ghost cleanup (1)    
growth trend (1)    
heap (1)    
indexed views (1)    
information_schema (1)    
instance properties (1)    
kill sessions (1)    
learning (1)    
linked servers (1)    
login (1)    
login information (1)    
management (1)    
maxdop (1)    
mcitp (1)    
mcts (1)    
memory (1)    
memory tuning (1)    
memtoleave (1)    
missing indexes (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)    
process (1)    
professional development (1)    
public (1)    
query optimization (1)    
rants (1)    
rebuild (1)    
rebuild log file (1)    
recent backups (1)    
reindex (1)    
report (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_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_server_diagnostics (1)    
sp_unbindefault (1)    
sp_unbindrule (1)    
space used (1)    
sql monitor (1)    
sql server essentials (1)    
sql server express (1)    
sql virtual restore (1)    
stairway series (1)    
string manipulation (1)    
striped backups (1)    
syntax check (1)    
sys.database_files (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)    
updategrams (1)    
version (1)    
view_column_usage (1)    
virtualization (1)    
visual studio (1)    
vmware (1)    
warehouse (1)    
windows 2003 (1)    
xsl (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.