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

Archives: August 2011

Interview with BI Expert Tim Mitchell

Tim 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… Read more

0 comments, 356 reads

Posted in SQL Aloha on 24 August 2011

Interview with SQL Server MVP Grant Fritchey

Grant 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… Read more

0 comments, 626 reads

Posted in SQL Aloha on 23 August 2011

Interview with SQLServerCentral.com Editor Steve Jones

Steve 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… Read more

0 comments, 581 reads

Posted in SQL Aloha on 12 August 2011

When was the Last Time You Removed an Index Because it was Never Used?

Indexes 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… Read more

2 comments, 716 reads

Posted in SQL Aloha on 11 August 2011

What SQL Server Books Do You Recommend?

Reprinted 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… Read more

0 comments, 654 reads

Posted in SQL Aloha on 8 August 2011

August Question: How Do You Manage Your Transact-SQL Scripts?

Whether 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… Read more

3 comments, 502 reads

Posted in SQL Aloha on 1 August 2011