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

Content with tags SQL Server 2008, Administration Rss

   Items 1 to 7 of 7   
 

Guide To MCITP: SQL Server 2008 Administration

Find out what you need to learn for the SQL Server 2008 Administration certification exams.  Read more...
By Mike McQuillan 2011/08/05 | Source: SQLServerCentral.com | Category: mcts
Rating: |  Discuss |   Briefcase | 8,442 reads

Kill all connection to database

Procedure tries to kill all connections to the specified database.  Read more...
By Rafal Skotak 2011/03/01 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,836 reads

SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.

SQL Server provides several system meta data functions which allow users to obtain property values of different SQL Server objects and securables. Although you can also use the SQL Server catalog views or Dynamic Management Views to obtain much of this information, in some circumstances the system meta data functions simplify the process. In this tip I am going to demonstrate some of the available system meta data functions and their usage in different scenarios.  Read more...
By Additional Articles 2010/05/05 | Source: MSSQLTips.com | Category: sql server 2008
Rating:  Rate this |   Briefcase | 2,961 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,730 reads

SQL Server 2008 Administration in Action - Sample Chapter

A sample chapter on clustering from Manning Publishing. Read it to learn a bit on clustering and preview this new book.  Read more...
By Press Release 2009/12/18 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 1,576 reads

SQL Server Browser

By Steve Jones 2008/11/25 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 3,357 reads

Declarative Management Framework - Performing Policy Management

The Declarative Management Framework is a new policy based management framework included with the upcoming SQL Server 2008. Using this feature administrators can define policies to govern their SQL Server environments much like in the Windows environment. This article, written based on the SQL Server "Katmai" July CTP introduces you to the DMF and shows you how you can perform policy management.  Read more...
By Additional Articles 2007/11/19 | Source: SQL Server Universe | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 1,720 reads
   Items 1 to 7 of 7   
 
Tags
dba (2)    
advanced querying (1)    
certifications (1)    
declarative management framework (dmf) (1)    
maintenance and management (1)    
mcitp (1)    
mcts (1)    
sample chapters (1)    
sql server 2005 (1)    
sql server 2008 r2 (1)    
stored procedures (1)    
t-sql (1)