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

Content with tags SQL Server 7, Administration, SQL Server 2005 Rss

   Items 1 to 20 of 31    Older >>
 

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...
By Mani Singh 2011/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,263 reads

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...
By Mani Singh 2011/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,263 reads

Available bytes for row expansion (adding columns) in a table

This scalar function accepts a table name and returns the number of bytes left out of the 8060 bytes available for adding new columns.   Read more...
By ruchir-628038 2008/04/03 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 788 reads

Open Source SQL DDL Scripting Tool

Keeping track of your DDL is something that is critical and some sort of VCS system should be used. However pulling out your scripts from SQL Server sometimes entails a bit more than the standard scripting. New author Richard Sutherland brings us an open source project that can help you get this done. Complete with code.   Read more...
By Richard Sutherland 2007/03/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,481 reads

Searching Syscomments Accurately

As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005.   Read more...
By Robert Cary 2007/01/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,895 reads

Indexes and Fragmentation in SQL Server 2000 Part 2

Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database.   Read more...
By Joe Doherty 2006/12/20 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 14,313 reads

Customizable Error Log Scanning

Monitoring your servers for issues and alerts is something every DBA should be doing on a regular basis. However even with a small number of servers, a DBA can easily be overwhelmed if some level of automation is not implemented. Thomas LaRock brings us a method of scanning your error logs automatically and notifying the DBA of problems.   Read more...
By Thomas LaRock 2006/12/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,502 reads

Changing Service Credentials

One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution.   Read more...
By Additional Articles 2007/09/21 | Source: SimpleTalk | Category: administration
Rating:  Rate this |   Briefcase | 2,246 reads

Server Farm Reporting - Part 2

Building on his first article examining management of a large server farm, Mark Tierney brings us part 2 in which he examines the data gathering process.   Read more...
By Mark Tierney 2007/08/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,794 reads

Using Non-Standard Port for SQL Server

Greg Larsen examines setting up SQL Server to listen on a different port number than 1433.   Read more...
By Additional Articles 2007/08/03 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 2,806 reads

Pop Rivett and the Expanding Log

When your database transaction log is out of control, there is only one man who can tame it.   Read more...
By Additional Articles 2007/07/06 | Source: SimpleTalk | Category: administration
Rating:  Rate this |   Briefcase | 2,386 reads

Open Source SQL DDL Scripting Tool

Keeping track of your DDL is something that is critical and some sort of VCS system should be used. However pulling out your scripts from SQL Server sometimes entails a bit more than the standard scripting. New author Richard Sutherland brings us an open source project that can help you get this done. Complete with code.   Read more...
By Richard Sutherland 2007/03/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,481 reads

Using BACKUP and RESTORE in SQL Server

This article covers the basics of full backup backups and restores in SQL Server. The examples are from SQL Server 2005 however it applies to SQL Server 2000 and SQL Server 2005. This is a very basic article covering full database backups, database restores and the simple and full recovery models.   Read more...
By Additional Articles 2007/02/27 | Source: SQLTeam.com | Category: administration
Rating:  Rate this |   Briefcase | 5,087 reads

Pop Rivett and the Suspect Database

Pop Rivett tackles a torn page in a suspect database.  Read more...
By Additional Articles 2007/02/13 | Source: SimpleTalk | Category: administration
Rating:  Rate this |   Briefcase | 2,539 reads

Searching Syscomments Accurately

As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005.   Read more...
By Robert Cary 2007/01/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,895 reads

Customizable Error Log Scanning

Monitoring your servers for issues and alerts is something every DBA should be doing on a regular basis. However even with a small number of servers, a DBA can easily be overwhelmed if some level of automation is not implemented. Thomas LaRock brings us a method of scanning your error logs automatically and notifying the DBA of problems.   Read more...
By Thomas LaRock 2006/12/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,502 reads

Indexes and Fragmentation in SQL Server 2000 Part 2

Most DBAs are constantly looking for ways to tune their servers to run better. Joe Doherty brings us the second part of his series on indexes with an in depth look at how the indexes are stored in your database.   Read more...
By Joe Doherty 2006/12/20 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 14,313 reads

Moving Your Database to a New Server

As DBAs we try our best to appropriately size a SQL Servers to match the anticipated load. But things change over time and we may find that some databases are overloading the server. When it's time to move your database to a new home on another server, Paul Mu brings us a technique for doing so.   Read more...
By Paul Mu 2006/11/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,507 reads

Monitoring File Sizes in SQL Server Part 4

Monitoring in the real world. Roy Carlson concludes his series on space monitoring for your SQL Servers with a real world example of how he found a problem and fixed it.   Read more...
By Roy Carlson 2006/11/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,642 reads

Monitoring File Sizes in SQL Server Part 3

Trending the size data for your databases can be crucial when ordering new hardware or just ensuring that you can handle the load. In Part 3, Roy Carlson looks at how you get the sizes needed for your instances into Excel and generate a chart for trending of this important piece of performance data.   Read more...
By Roy Carlson 2006/11/08 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 5,890 reads
   Items 1 to 20 of 31    Older >>
 
Tags
monitoring (3)    
news (3)    
strategies (2)    
disaster recovery (dr) (1)    
indexing (1)    
logins (1)    
miscellaneous (1)    
security (1)