William Sheldon

William
Sheldon

William Sheldon is a contributing editor for SQL Server Pro and a Microsoft MVP for Visual Basic .NET. He's coauthor of Professional Visual Basic 2010 and .NET 4 (Wrox) and an instructor at University of California, San Diego.

Articles
Atlas Takes on the World
Microsoft, recognizing that highly dynamic sites are the future of Web applications, is working to catch up with the AJAX movement by offering a free toolkit called Atlas.
Source Control Basics: Shelving, Branching, and Merging
Team Foundation Server provides three features for managing source code: shelving (which is a new and much needed feature), branching (which is helpful in specific situations), and merging (which should almost never be used).
Write Code Without Having to Type It
Visual Studio 2005's new IntelliSense Code Snippet feature lets you include code without typing it.
Finding a Rosetta Stone
Microsoft is developing a Rosetta stone that lists all the keywords for several Microsoft-supported languages. This important Rosetta stone will provide developers with a better understanding of the keywords in the various OOP languages.
We All Need to Speak a Common Tongue
Visual Basic (VB), Visual C#, Visual C++, and Visual J# all follow an OO paradigm. However, some of VB’s terms differ from those used by the other .NET languages. Here's a look at how object keywords differ.
Back to Basics - 06 Mar 2006
If you’re just getting started with .NET, here’s a look at some basic .NET learning tools as well as links to resources in which you can get more information.
VSTO and SharePoint--A Winning and Possibly Profitable Combination 1
Working with VSTO, Windows SharePoint Services, and other Office system tools to develop collaboration, messaging, and other information-management solutions might help your company net part of a $148 billion market.
Build Lab in a Box
Not sure if you should migrate to Team Foundation Server (TFS)? Team Foundation Build might just give you a reason to migrate.
A Ripple Has Become a Wave
Just as Developer .NET UPDATE is going through a transition, hopefully you're looking at your own transition to .NET if you haven't already done so.
SQL Server 2005: Development Questions
Bill Sheldon answers common questions that developers have about changes coming in SQL Server 2005.
Will .NET Survive?
Take a moment to review where .NET has been and where it’s going, because like everything else, change is coming.
Even the Orange County Choppers Are Talking Up SQL Server 2005's Features
Bill Sheldon wraps up the year with an update about SQL Server 2005 documentation and a look at some more of the new and enhanced features in SQL Server 2005.
Exciting Changes Integrated Into Reporting Services 2005
Many of the exciting changes in SQL Server 2005 Reporting Services are associated with integration. Here’s a look at some of those changes.
Leverage Reporting Services 2005 Independent of Your Database
SQL Server Reporting Services is standalone set of components that leverage data stored in SQL Server 2005. It’s to your advantage to upgrade this set of components when you upgrade to SQL Server 2005.
Workflow Today and Tomorrow
A look at the relationship between Windows Workflow Foundation and BizTalk Server 2006.

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
Mar 17, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 21: Assigning Backup Preferences

An option when creating new AlwaysOn Availability Groups is to specify Backup Preferences. It’s also something you can easily configure once the Availability Group has been set up as well – by simply right-clicking on the Availability Group and selecting Properties – then navigating into the Backup Preferences tab.  ...More
Mar 14, 2015
Commentary

For Data Quality, Intelligent Rules Add Value to the Golden Record 6

The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions for data cleansing....More
Mar 12, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 20: Avoiding Backup Fragmentation

On SQL Servers where Availability Groups (or Mirroring) isn’t in play, I typically recommend keeping a combination of on-box backups along with copying said backups off-box as well. Obviously, keeping databases AND backups on the SAME server is the metaphorical equivalent of putting all of your eggs in one basket – and therefore something you should avoid like the plague....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) ×