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

Content with tag Management Rss

   Items 1 to 19 of 19   
 

Managers: who needs them?

Managers, look away now. Patrick Index wants to get something off his chest...  Read more...
By Patrick Index 2014/10/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 165 reads

Get record count for a specific database

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...
By James Rea 2013/10/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,407 reads

Insensitivity: A Good Technique?

This article explores the place of emotion among knowledge workers doing team-based design activities.  Read more...
By Bill Nicolich 2013/04/05 | Source: SQLServerCentral.com | Category: emotion
Rating: |  Discuss |   Briefcase | 147 reads

Get record count for a specific database

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...
By James Rea 2013/10/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,407 reads

Shrink all databases

Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).  Read more...
By Rafal Skotak 2012/03/07 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,823 reads

Clear database - delete all records from a database (updated)

The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').  Read more...
By Rafal Skotak 2011/12/09 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,029 reads

Me, myself and Powershell

Why should any SQLserver administrator, DBA, or Developer be interested in Powershell? Johan Bijens presents a few reasons today.  Read more...
By Johan Bijnens 2011/12/06 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 7,471 reads

Parse the dependency chain of an object

Parses up & down the dependency chain of an object.  Read more...
By Jesse McLain 2011/09/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,156 reads

Reindex all indexes online or offline depending on day of week.

This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.   Read more...
By Kenneth Singer 2011/04/18 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 4,406 reads

SQL Server Management Features vs Oracle Database Management Features

The usefulness and utility of the SQL Server Agent cannot be overstated. Oracle Database supports the automatic starting of an instance, so whatever is associated with the Oracle instance can also be started along with the instance. The same holds true with the SQL Server instance and its agent service.  Read more...
By Additional Articles 2010/05/06 | Source: Database Journal | Category: management
Rating:  Rate this |   Briefcase | 3,190 reads

Bonuses – Management Inequalities

If you own a business, I believe that you have a right to make more money than the rest of your employees. You are taking on a risk, and greater risk should result in greater reward, at least that’s how capitalism is supposed to work. But what about management...  Read more...
By Steve Jones 2009/05/06 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,343 reads

How to Get Management Buy-In for Software purchases

There is a good chance that the process of purchasing software or hardware in your organization involves several people. DBAs will often initiate a request, but are not normally trained in the arts of influencing the management decision process to ensure that essentials get purchased. It is becoming essential to understand how to get Management support for software purchases. Dan offers nuggets of wisdom.  Read more...
By Additional Articles 2009/03/11 | Source: SimpleTalk | Category: management
Rating: (not yet rated)  Rate this |   Briefcase | 1,732 reads

Get record count for a specific database

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...
By James Rea 2013/10/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,407 reads

Reindex all indexes online or offline depending on day of week.

This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.   Read more...
By Kenneth Singer 2011/04/18 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 4,406 reads

Help! My SQL Server Log File is too big!

Over the years, I have assisted so many different clients whose transactional log file has become "too large" that I thought it would be helpful to write about it. The issue can be a system crippling problem, but can be easily avoided. Today I'll look at what causes your transaction logs to grow too large, and what you can do to curb the problem.  Read more...
By Additional Articles 2008/10/28 | Source: Builder.com | Category: transaction logs
Rating:  Rate this |   Briefcase | 6,525 reads

Clear database - delete all records from a database (updated)

The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').  Read more...
By Rafal Skotak 2011/12/09 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,029 reads

Shrink all databases

Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).  Read more...
By Rafal Skotak 2012/03/07 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,823 reads

Parse the dependency chain of an object

Parses up & down the dependency chain of an object.  Read more...
By Jesse McLain 2011/09/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,156 reads

Get record count for a specific database

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...
By James Rea 2013/10/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,407 reads
   Items 1 to 19 of 19   
 
Tags
sql server 2005 (4)    
editorial (2)    
administration (1)    
agile (1)    
backup / restore (1)    
blogs (1)    
database weekly (1)    
emotion (1)    
indexing (1)    
insensitivity (1)    
maintenance (1)    
maintenance and management (1)    
miscellaneous (1)    
oracle (1)    
powershell (1)    
salaries (1)    
software purchases (1)    
sql agent (1)    
team (1)    
transaction logs (1)    
t-sql (1)