LINQ to SQL in Action: Joining and Grouping Commented on: 5 years ago (May 12, 2009) Marco, thanks for your comment. Here's Dino Esposito's reply: "The reader is right when he says that most of the time T-SQL statements written by programmers are the main cause of troubles. However...
SQL Server 2008’s T-SQL Features Commented on: 5 years ago (February 25, 2009) Thanks for the feedback; I'm glad you find the executive summaries useful!
Build the Numbers Table You Need Commented on: 5 years ago (February 19, 2009) Uh oh, I don't know what happened to the article, but I'll get the problem fixed as soon as possible. Anne Grubb, web editor
SSAS 2005: Cube Performance Tuning Lessons Learned Commented on: 6 years ago (December 10, 2008) kcrevier, you're right, the link is broken, although the URL is correct. I will fix this--thanks for pointing it out.
SQL Server 2008 Editions - 30 Oct 2008 Commented on: 6 years ago (November 6, 2008) ledman, here's Mike Otey's response to your question: "Yes. The SQL Server 2008 Developer Edition can be used by multiple developers. You don’t need a separate copy for each developer." Thanks for...
Performance Effects of Using GUIDs as Primary Keys Commented on: 6 years ago (October 23, 2008) Eugene, thanks for pointing out the missing links. I've updated them with the correct URLS in the article. The links are: The Cost of GUIDs as Primary Keys, http://www.informit.com/articles/article....
Check It Out: Video Series: SQL Server Express Edition for Beginners Commented on: 6 years ago (September 18, 2008) The SQL Server Express video series is at this link now: http://www.microsoft.com/sql/editions/express/learnvideos.mspx. It appears that Microsoft changed the link to the videos since the article was...
Migrating to SQL Server 2008 Commented on: 6 years ago (August 18, 2008) Hi pward, Thanks for your feedback. Have you checked out any of the articles or other resources in the Learning Path, Related Articles, and resources lists--see the list titled "Learning Path,"...
Using DTS to Populate a Data Warehouse Commented on: 6 years ago (July 24, 2008) Thanks, Marcos. As you mentioned, we do have online archives for SQL Server Magazine articles, going back to the first issue--March 1999. I often see reader comments on older articles and am glad to...
Rebuild Only the Indexes that Need Help Commented on: 6 years ago (July 1, 2008) DHAY1999, thanks for notifying us of the problem. The procedure in Listing 1 does indeed appear incomplete. I will contact the editor and get the problem resolved ASAP.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Dec 16, 2014
Sponsored

Eight SQL Server Signs the Illuminati Exist

Make no mistake about it, the signs that the Illuminati exist are all around us. You can find their markings on our buildings, on our currency and even in our music videos. That’s right, they’re everywhere!...More
Dec 2, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 16: Job Synchronization Checkup Logic

With Linked Servers configured to allow cross-host or cross-box communication between the servers you’re using to host your AlwaysOn Availability Groups, it’s time to start looking at some scripts that can be used to regularly check whether or not SQL Server Agent jobs are correctly synchronized across all servers in your topology....More
Abstract illustration of linked SQL Servers
Nov 18, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 15: Setting Up Linked Servers

Learn about setting up Linked Server definitions to let two (or more) servers in an AlwaysOn Availability Group talk to each other and check up on job statuses of jobs running on each other....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×