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

Content with tags Editorial, Administration Rss

   Items 1 to 20 of 29    Older >>
 

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

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

Lowering the Noise

We are busy as administrators, and it can be very useful to ensure our systems avoid adding to our workload.  Read more...
By Steve Jones 2018/01/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 52 reads

Disable or Drop

When you need to debug or troubleshoot, Steve Jones wants you to disable, not drop, objects.  Read more...
By Steve Jones 2018/01/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads

Change Your SQL Server Oil

Regular maintenance for your instance is important.  Read more...
By Steve Jones 2017/03/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 185 reads

The Future of Auditing

Auditing is a weak point in SQL Server according to Steve Jones. He looks at a few of its flaws.  Read more...
By Steve Jones 2016/12/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 267 reads

What is the Future of Monitoring?

Monitoring your systems is critical to ensuring security and stability. Steve Jones shares a few thoughts on where monitoring might go with more computer assistance in the future.  Read more...
By Steve Jones 2016/09/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 69 reads

Multiple Backup Files

This Friday Steve Jones looks at your backup system and wonders how many people use striped backups.  Read more...
By Steve Jones 2015/01/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 286 reads

How Often Does Production Drift?

Database drift is the difference between two database schemas. Today Steve Jones discusses the concept and wonders how often it happens.  Read more...
By Steve Jones 2014/11/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 129 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

Consolidation Matters

Consolidating SQL Server instances is something Steve Jones has done in the past and he thinks we'll all do more of in the future.  Read more...
By Steve Jones 2014/04/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 113 reads

Mini-Me

This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...
By Steve Jones 2014/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 576 reads

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 | 451 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 | 181 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 | 205 reads

The Future of Auditing

Auditing is a weak point in SQL Server according to Steve Jones. He looks at a few of its flaws.  Read more...
By Steve Jones 2016/12/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 267 reads

The Ratio

How many developers does it take to overwhelm a DBA? It's an interesting question, and this week Steve Jones asks how many you actually support.  Read more...
By Steve Jones 2013/10/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 158 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 | 133 reads

What Counts for a DBA: Being Replaceable

Louis Davidson describes why all DBAs should strive to be replaceable, and what that really means.  Read more...
By Louis Davidson (@drsql) 2012/12/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 226 reads

Manage By Delegation

There always seem to be more and more instances to manage, but not more and more staff. Steve Jones talks about the key to good management being delegation of the work.  Read more...
By Steve Jones 2012/10/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 134 reads
   Items 1 to 20 of 29    Older >>
 
Tags
friday poll (3)    
database weekly (2)    
monitoring (2)    
auditing (1)    
backup (1)    
consolidation (1)    
dbcc checkdb (1)    
disaster recovery (dr) (1)    
policy based management (pbm) (1)    
powershell (1)    
restore (1)    
security (1)    
sql server (1)    
sqlservercentral (1)    
stored procedures (1)    
striped backups (1)