SQLServerCentral: Content tagged administration

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Content with tag administration

<< Previous 20 Items 41 to 60 of 1412 Next 20 >>

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day. Read more...

By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration

Rating:

|

Briefcase | 10,463 reads

Mirrors

By Honza Mensdorff 2012/12/11 | Category: administration

Rating: (not yet rated) |

Briefcase | 1,765 reads

Log Shipping - Monitor Server

By Raghavendra Mudugal 2012/12/05 | Category: log shipping

Rating: (not yet rated) |

Briefcase | 1,642 reads

Get Rid of All Those Pesky 1 MB File Growth DB Files

Use sp_MSForeEachDB to set all 1 MB file growth databases to 10%. Read more...

By Greg Milner 2013/05/31 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Briefcase | 1,218 reads

Steps to add Log Shipping monitor into an existing SQL Server

I have a requirement to add the Log Shipping Monitor for an existing installation. I have heard you can only complete this by rebuilding the Log Shipping infrastructure. Is that true? Are there any other options? In this tip I will explain how we can add the Log Shipping monitor to a SQL Server 2005, 2008, 2008 R2 or 2012 environment without rebuilding the Log Shipping installation. Read more...

By Additional Articles 2012/12/05 | Source: MSSQLTips.com | Category: log shipping

Rating: (not yet rated) Rate this |

Briefcase | 1,694 reads

Has tempdb grown since the last restart?

Check tempdb to see if it has been autogrown since the last restart. If it has, there may be an opportunity to improve server performance. Read more...

By Orlando Colamatteo 2012/11/20 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Briefcase | 7,552 reads

Viewing VMware Counters in PerfMon for SQL Server

I want to ensure that my SQL Server on a VMware Guest OS is getting the resources it should. This would go a long way towards helping isolate the performance problems we're experiencing. However, our system administrators won't give us access to VirtualCenter or any of the tools they use. Is there anything I can do? Check out this tip to learn more. Read more...

By Additional Articles 2012/11/12 | Source: MSSQLTips.com | Category: performance tuning

Rating: (not yet rated) Rate this |

Briefcase | 2,115 reads

Enable Database Mail in 2012

By Mike Hays 2012/11/07 | Category: database mail

Rating: (not yet rated) |

Briefcase | 1,862 reads

Shrinking all log files on SQL Server 2008R2

It shrinks all log files for the databases created by users. Read more...

By Igor Micev 2012/11/02 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Briefcase | 1,462 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) |

Briefcase | 112 reads

Check SQL Server Virtual Log Files Using PowerShell

In a previous tip on Monitor Your SQL Server Virtual Log Files with Policy Based Management, we have seen how we can use Policy Based Management to monitor the number of virtual log files (VLFs) in our SQL Server databases. However, even with that most of the solutions I see online involve the creation of temporary tables and/or a combination of using cursors to get the total number of VLFs in a transaction log file. Is there a much easier solution? Read more...

By Additional Articles 2012/10/11 | Source: MSSQLTips.com | Category: administration

Rating:

Rate this |

Briefcase | 2,723 reads

Statistics - 3

By bitbucket 2012/10/09 | Category: statistics

Rating: (not yet rated) |

Briefcase | 2,305 reads

SQL Server Uptime

This script is used to get uptime for the SQL Server. (Supports SQL2005 and onwards only) Read more...

By Chandu Ade 2012/09/28 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Briefcase | 1,094 reads

Extended Events II

By Jason Brimhall 2012/09/28 | Category: extended events

Rating: (not yet rated) |

Briefcase | 1,921 reads

Extended Events I

By Jason Brimhall 2012/09/24 | Category: extended events

Rating: (not yet rated) |

Briefcase | 1,901 reads

Tracking Processes

By Naseer Ahmad 2012/09/21 | Category: administration

Rating: (not yet rated) |

Briefcase | 2,197 reads

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly. Read more...

By Nakul Vachhrajani 2012/09/17 | Source: SQLServerCentral.com | Category: sql server agent

Rating:

|

Briefcase | 4,232 reads

DBA Basics

By Naseer Ahmad 2012/09/14 | Category: administration

Rating: (not yet rated) |

Briefcase | 3,044 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:

|

Briefcase | 2,686 reads

Administration

By Ravi Kumar SV 2012/09/11 | Category: administration

Rating: (not yet rated) |

Briefcase | 2,720 reads

<< Previous 20 Items 41 to 60 of 1412 Next 20 >>