SQL Debugging Tidbit of the Day

For the most part I generate stored procedures from Visual Studio (I'm a huge fan of typed datasets. . . get over it) and edit them in SQL Server Enterprise Manager. This gives me the parameters and linkages easily while letting me gut the innards and make it all do what I want. While I know Toad for SQL is great, I tend to forget about it and go back to Enterprise Manager.

Well, one of the things I just discovered was that if you receive a compilation error for a procedure or view, you can double-click the text and it will highlight the row in the code that throws the error.

This is pretty intuitive and I can't believe I didn't think of it before. Just seeing that text without a table format led me to think it wasn't possible. I do like the Enterprise Manager 2005 interface though, and I'm glad to see Microsoft recognize people are using it to do some light development.

Peace,
+Tom

Comments

Red-Gate SQL Compare

Every now and then I come across a program that becomes so ingrained in my daily work that I hardly know how I'd get by without it. I'll probably break down a couple over the next few days, but for database work, I have never found anything as good as Red Gate's SQL Compare and SQL Data Compare . Essentially these tools let you compare two SQL Server databases (all objects, users, permissions, functions, diagrams, anything) and update changes to whichever database you want. This is amazingly useful for deploying database changes to a test or production environment (do it to production with ridiculous care, even though it will generate a SQL Script for you and run all updates in one transaction), and making sure everything is synchronized. For releases we can just generate the compare script, confirm that the changes match the updates we want to go out, and store it all in one place with the release details. This is true for both the structure and the d...

Advantages and Disadvantages of Using Microsoft Access

I've answered this question in some form or another far more times than I care to count. Most often it's a question of "why do I need a fancy Web application when I can just build this myself in two days in Access. I mean, the data's already in Excel." So I figured I'd post out what I threw together, I know I've missed some points. Overview Microsoft Access is an ideal solution for relatively small datasets and a limited number of users. From the Microsoft Web site: “As a desktop database, Access is well suited for small, departmental applications. These applications may start as one user’s project. For example, an employee realizes that productivity can be increased if a paper-based process is automated with an Access application. Other users in the department recognize that they can take advantage of the application if additional features are added. As more features are added, more employees run the application. As time goes by, more and more Access...

Portrait Innovations

I mentioned in a previous post that I surprised Erin with pictures from Portrait Innovations of Rachel, Colin and (a few) of myself. This generated more comments than 99% of my posts receive (read that as I received one comment). Because both Erin and I have gone separately and had great experiences with the company, I figured I would spend a post explaining how it works, what's different from Sears and a professional photographer, and why I like them. Great Shots Erin and I went to Sears a LOT when Rachel was born. We went every month to track her growth. So far Colin's on an every 3 months cycle (second kid, life sucks, get over it and quit whining to me about being "fair"). One of the things with Sears that kind of bugged me was the set positions. You know, laying on the floor with head propped on arms, sitting on stool cross legged. While I think having some set poses are a good idea, at both Sears we've used, it's too extreme....

Tom Squared

Search This Blog