Interview with BI Expert Tim Mitchell
Conferences,DBA Career,SQL Server Connections | August 24, 2011 | 10:05 amTim Mitchell will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas, NV. Tell us about yourself. I’m a practitioner of business intelligence, primarily focusing on SQL Server. I’ve been in the IT field for over a decade, and have worked with SQL Server in various ...read more
Interview with SQL Server MVP Grant Fritchey
Conferences,DBA Career,SQL Server Connections | August 23, 2011 | 3:39 pmGrant Fritchey will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas, NV. Tell us about yourself. I have twenty plus years’ experience in IT, in the areas of technical support, development, and database administration. Currently, I work for Red Gate Software as a Product Evangelist, ...read more
Interview with SQLServerCentral.com Editor Steve Jones
Conferences,DBA Career,SQL Server Connections | August 12, 2011 | 2:13 pmSteve Jones will be speaking at the SQLServerCentral.com track at SQL Server Connections, October 31-November 3, 2011, in Las Vegas, NV. Tell us about yourself. I’m the editor of SQLServerCentral.com, which is a position I’ve held for over 8 years. I started writing articles as a DBA to help other people and to share ...read more
When was the Last Time You Removed an Index Because it was Never Used?
Database Maintenance,Indexing,Performance Tuning | August 11, 2011 | 11:16 amIndexes can be great for boosting the performance of a query, but if an index is never used, it can drag down an instance’s performance. This is because unused indexes must be maintained just like any index. For example, anytime a row is inserted, updated, or deleted, indexes must be maintained. If a lot of ...read more
What SQL Server Books Do You Recommend?
Opinion | August 8, 2011 | 11:20 amReprinted and amended from my editorial at Database Weekly. For nearly 11 years now, one of the most common questions people e-mail me about is what SQL Server books do I recommend for the novice DBA. A decade ago, there were many, many titles available, and it was easy for me to recommend books. I ...read more
August Question: How Do You Manage Your Transact-SQL Scripts?
Question of the Month | August 1, 2011 | 11:20 amWhether it is Transact-SQL for applications you are developing, or just for routine administrative tasks, managing Transact-SQL has never been easy. Some people use some version of source control software, while others use folders in the file system, and so on. So, for this month’s question, “How do you manage your Transact-SQL scripts?”, tell us ...read more
RSS
Twitter
Linked In