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

Content with tags Administration, SQL Server 2008 Rss

   Items 1 to 8 of 8   

Trace Flag

By Vyas DCS 2014/10/30 | Category: sql server 2008
Rating: (not yet rated) |  Discuss |   Briefcase | 1,661 reads

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,522 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,952 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 | 3,324 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,853 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,585 reads

SQL Server Browser

By Steve Jones 2008/11/25 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 3,384 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 | 2,059 reads
   Items 1 to 8 of 8   
dba (2)    
advanced querying (1)    
backup and restore (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)    
trace flags (1)    
t-sql (1)