Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Kenneth Igiri

SQLServerCentral.com profile

   Items 1 to 7 of 7   
 

Installing SQL Server vNext on an AWS EC2 RHEL Instance

The steps required to create an Amazon Web Services EC2 instance and install the latest SQL Server version on the EC2.  Read more...
By Kenneth Igiri 2017/03/16 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 470 reads

Five Useful SQL Server Management Practices

This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.  Read more...
By Kenneth Igiri 2017/01/18 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,904 reads

SQL Server 2016: The New @OneResultSet Parameter in SP_SpaceUsed

EXEC SP_SPACEUSED can return only one result set if you want it to. This is possible using a new parameter in SQL Server 2016. If are familiar with the inbuilt stored procedure sp_spaceused, I am sure you will find this new parameter quite useful.  Read more...
By Kenneth Igiri 2016/11/30 | Source: SQLServerCentral.com | Category: space management
Rating: |  Discuss |   Briefcase | 1,046 reads

The Real World: Implementing Data Compression in SQL Server 2008 R2

Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008  Read more...
By Kenneth Igiri 2016/01/18 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 2,805 reads

The Real World: Rebuilding Index - 1 Instance, 106 Databases

The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.  Read more...
By Kenneth Igiri 2015/02/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,145 reads

The Real World: Implementing AWE

Describes the gains experienced in my environment by implementing AWE.  Read more...
By Kenneth Igiri 2012/05/16 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,964 reads

The Real World: Fragmented Disk and High PAGEIOLATCH Waits

This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.  Read more...
By Kenneth Igiri 2012/04/20 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 6,313 reads
   Items 1 to 7 of 7