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

Archives: April 2009

SQLTeach to be Held June 8-12 in Vancouver

SQLTeach (a part of the larger DevTeach event) will be held in Vancouver, BC this June 8-12, 2009. It will offer 136 sessions in 8 different tracks, including 37 SQL Server sessions, 17 Agile sessions, 17 software architecture sessions, and 57 .NET sessions. In addition, there are both full-day pre-con… Read more

1 comments, 570 reads

Posted in SQL Aloha on 30 April 2009

Want to Know What MVPs are Doing: Follow the MVP Blog

If you are a current, or aspiring Microsoft MVP, you can keep up with what other MVPs are doing by reading the MVP Award Program blog. For the most part, the blog focuses on individual MVPs and their contributions to their respective communities.

 

 

Share this post :…

Read more

1 comments, 579 reads

Posted in SQL Aloha on 30 April 2009

European PASS Conference 2009 Has 254 Attendees

The 2009 European PASS Conference, which was held April 22-24, 2009, had 254 attendees from 22 different countries. In spite of a difficult economy, attendance was up from 187 attendees last year.

The event was held at the Swissôtel Conference center, which over looks the Rhine river, in Neuss,… Read more

0 comments, 650 reads

Posted in SQL Aloha on 28 April 2009

The Maintenance Plan Wizard Can Lead You Astray

In theory, the SQL Server Maintenance Plan Wizard is supposed to make it easier for non-DBAs or novice DBAs to create database maintenance plans that help to optimize the performance of their SQL Server databases. The problem is that unless you really know what you are doing, you can hurt… Read more

11 comments, 4,016 reads

Posted in SQL Aloha on 16 April 2009

Don’t Make Dumb Mistakes by Duplicating Indexes

Just today, I was reviewing the indexing of a database used by a third-party application. As part of my review, I ran a script against it that is used to identify duplicate indexes. The script I used was written Paul Nielsen, the author of the SQL Server Bible; and… Read more

14 comments, 1,097 reads

Posted in SQL Aloha on 15 April 2009

Learn How to Use the SQL Server 2008 Transact-SQL Debugger

Bill Ramos, a SQL Server Product Manager, has written a three part series on how to use the SQL Server 2008 SQL Server Transact Debugger. If you are a Transact-SQL Developer, this is a must-read series. You can find the series here:

Part 1

Part 2

Part 3

If you… Read more

0 comments, 432 reads

Posted in SQL Aloha on 15 April 2009

Richmond, VA Code Camp to be Held April 25

The Richmond Code Camp 2009.1, will be held on Saturday 25, 2009 at the J. Sargeant Reynolds Community College in Richmond, VA. For more information, or to register, visit: richmondcodecamp.org/. The call for speakers has ended and speakers are currently being selected for this event.

 

Share this post…

Read more

0 comments, 284 reads

Posted in SQL Aloha on 15 April 2009

Portland, OR Code Camp Set for May 30, 2009

The Portland Code Camp will be held at Reed College on Saturday, May 30, 2009. This free event will include many sessions for developers and DBAs. Check out portlandcodecamp.org for more information. If want to speak at the event, the call for speakers is still open.

 

Share this post…

Read more

0 comments, 158 reads

Posted in SQL Aloha on 15 April 2009

Microsoft Releases Updated White Paper on Troubleshooting SQL Server 2008 Performance

Microsoft has finally updated their classis Troubleshooting SQL Server Performance white paper for SQL Server 2008, which is available at:

 

Troubleshooting Performance Problems in SQL Server 2008 (Word document 102 pages)

download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/TShootPerfProbs2008.docx

 

If you are still using SQL Server 2005, you can still download that version also.

Troubleshooting… Read more

0 comments, 609 reads

Posted in SQL Aloha on 15 April 2009

PASS Call for Speakers Deadline Extended

If you have been procrastinating about submitting a speaking abstract for the 2009 PASS Community Summit, you have been given a short reprieve. The Call for Speakers has now been extended until midnight on April 24, 2009. See this link for more details: www.sqlpass.org/Community/SpeakerResource.aspx.

 

Share this post :…

Read more

0 comments, 235 reads

Posted in SQL Aloha on 8 April 2009

More Information for Prospective PASS Speakers

If you have already submitted an abstract for the 2009 PASS Community Summit, or you are still thinking about it, be sure to check out the new information that has been added to Speaker’s Resource page.

Specifically, two new content pages have been recently added to the original page. They… Read more

5 comments, 249 reads

Posted in SQL Aloha on 2 April 2009