Don’t have access to SQL Server Enterprise Manager/Query Analyzer at home? One of the little known jewels in VS.NET is the Server Explorer. Until a couple of months ago, when a co-worker had just that problem and discovered how much was really in there, I had only looked at it a little, not realizing how useful it was for data-intensive applications.
To bring up the explorer, goto ‘View’ -> ‘Server Explorer’ (shortcut Ctrl + Alt + S). You’ll see two sections, ‘Data Connections’ and ‘Servers’. The Data Connections section allows you to create OLEDB connections to databases on your network (or locally). The Servers section gives you the opportunity to remotely view Event Logs, Performance Counters, etc. on remote machines.
While the Servers section is useful for remote development or monitoring, I spend most of my time in the Data Connections section. The interface gives you most of the capabilities you need in Enterprise Manager: design tables, retrieve/alter data, run SQL queries and stored procedures, and even the ability to step into and debug a stored procedure running! This all comes in a UI that looks strikingly similar to Enterprise Manager’s windows. In addition, any connections you add will show up in most data wizards in the Designer.
NOTE: Most of the options are accessible via a right-mouse click.
One other quick note. I get so confused when dealing with URLs, as to what methods on HttpRequest, etc. are going to give me what ‘path’…is it virtual, or a physical path, and what does it include. I ran across this article today while looking for a related answer, pretty nice summary of the different methods!