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

Articles with tag Administration Rss

Search for any content tagged administration

   Items 1 to 20 of 836    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 | 631 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 | 64 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 | 800 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,494 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,256 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 | 185 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

How to Change the File Extension for a Data File

This is a fix to primary data file that is created with a different file extension or accidentally renamed to a different file extension  Read more...
By Sadan Kumar Budde 2018/01/08 | Source: SQLServerCentral.com | Category: data file
Rating: |  Discuss |   Briefcase | 701 reads

Changing the Path for the Master Database

We as DBAs, changing or migrating databases to a new path is important part of admin’s world. This article helps you with the steps involved to move the Critical 'master' database.   Read more...
By Sadan Kumar Budde 2017/12/14 | Source: SQLServerCentral.com | Category: master database
Rating: |  Discuss |   Briefcase | 626 reads

Is This Database Being Used?

Can we delete this database, or is someone still using it?  Read more...
By Ginger Keys 2017/12/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,925 reads

Enable Trace Flags in SQL Server

Learn how to enable trace flags to change the behavior of your SQL Server instance.  Read more...
By Steve Jones 2017/03/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,528 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

Preferred Node Policy-Setting on Traditional SQL Cluster

Preferred node setting facilitates instances on traditional cluster to be on the correct nodes which will lead to load-balancing of the resources.  Read more...
By SQL ADMIN 79 2017/02/02 | Source: SQLServerCentral.com | Category: clustering
Rating: (not yet rated) |  Discuss |   Briefcase | 556 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

Managing Log Files Sizes the Easy Way

Learn an easy, rough, and ready way to manage log files in this piece.  Read more...
By Mark Roworth 2016/12/16 (first published: 2015/03/09) | Source: SQLServerCentral.com | Category: log files
Rating: |  Discuss |   Briefcase | 9,707 reads

Deploy Security Changes with Copy-SqlLogin

Moving security changes between server instances can be a cumbersome process, but it doesn't need to be with the PowerShell cmdlet, Copy-SqlLogin.  Read more...
By Steve Jones 2016/11/01 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,400 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

Changing SQL Server Database Logical Names

SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.  Read more...
By Shawn Melton 2015/07/20 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 5,172 reads

DDL Auditing using the Default trace

This article explains how default trace can be used for auditing purposes when combined with PowerShell scripts  Read more...
By Nagaraj Venkatesan 2015/05/05 | Source: SQLServerCentral.com | Category: audit
Rating: |  Discuss |   Briefcase | 2,958 reads
   Items 1 to 20 of 836    Older >>