New crop of DBAs making SQL Server indexing mistakes
Friday, May 25, 2012
Database administrators have a significant responsibility ensuring their companies' database performance is always on point. But many new DBAs make mistakes when its comes to the SQL Server platform, and SQL Server Pro's Brian Moran recently highlighted how these simple errors can occur.
The writer asserted that in his experience of establishing new companies, many employees make simple mistakes regarding SQL Server indexes.
"And then it occurred to me that the people making the mistakes today probably aren't the ones who were making the mistakes 10 or 15 years ago," Moran explained. "The people no longer forgetting to put indexes on tables either learned, got fired, or moved on to other careers. But surprisingly - at least to me - many of the same basic mistakes are still being made."
While some newly trained DBAs may make the occasional index mistake from time-to-time, the position is needed now more than ever. According to a USNews report, DBAs are one of the top jobs in 2012 and the Bureau of Labor Statistics has said the workforce is projected to grow nearly 31 percent between 2010 and 2020.