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

Guest Columnist: Kenneth Igiri

SQLServerCentral.com profile

   Items 1 to 10 of 10   
 

WorkPlace Encounters: Grappling With ASYNC_NETWORK_IO Waits

An account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed.  Read more...
By Kenneth Igiri 2017/10/10 | Source: SQLServerCentral.com | Category: wait events
Rating: |  Discuss |   Briefcase | 830 reads

Workplace Encounters: Using Volume Mount Points in SQL FCIs

How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points  Read more...
By Kenneth Igiri 2017/06/26 | Source: SQLServerCentral.com | Category: disks
Rating: |  Discuss |   Briefcase | 490 reads

Configuring Backups Using Veritas Netbackup with AGs

A short description of our experience with Veritas Netbackup on MS SQL Server AG Groups. This article does not give a full description of the procedure for configuring netbackup but highlights a few pitfalls which we think some people will find very useful.   Read more...
By Kenneth Igiri 2017/07/18 | Source: SQLServerCentral.com | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 304 reads

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 | 521 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,992 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,063 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,816 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,186 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,967 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,314 reads
   Items 1 to 10 of 10