Tag ASP.NET

Links for the Week of 2009.10.09

SQL Server

Why I prefer surrogate keys instead of natural keys in database design Mladen Prajdic put together a great article about using surrogate keys in database design. The best part is that a lot of bright people sounded off in the comments.

Donald Farmer Discusses the Benefits of Managed Self-Service BI I spoke with Donald Farmer about this topic when I was at the Richmond Code Camp last weekend. This is an incredible topic that has a lot of promise for the future of Business Intelligence.

Development

Mastering CSS Coding: Getting Started CSS is difficult to master. Very difficult to master. However, once you understand how CSS works it is a very powerful tool.

Multiple View Engines with MVC Turbine One of the coolest things about ASP.NET MVC is the flexibility it brings to ASP.NET web development. Javier Lozano demonstrates how it is possible to use multiple view engines within the same page.

Stuff & Things

9 Ways to Make Your Writing More Compelling 9 great tips for dramatically improving your writing.

Freelance Contracts: Dos and Don’ts If you’re looking to freelance, it’s important to make sure that your contracts are in order. This can cause no end of pain, trouble, and difficulty if your contracts are ambiguous. Smashing Magazine has some great information to make sure your contracts are in good working order.

Cyanide & Happiness

Columbus Give Camp is Just Two Weeks Away

The Columbus Give Camp is only two weeks away but it’s still not too late for both charities and volunteers to sign up.

GiveCamp is a weekend-long event where software developers, designers, and database administrators donate their time to create custom software for non-profit organizations. This custom software could be a new website for the nonprofit organization, a small data-collection application to keep track of members, or a application for the Red Cross that automatically emails a blood donor three months after they’ve donated blood to remind them that they are now eligible to donate again. The only limitation is that the project should be scoped to be able to be completed in a weekend.

During GiveCamp, developers are welcome to go home in the evenings or camp out all weekend long. There are usually food and drink provided at the event. There are sometimes even game systems set up for when you and your need a little break! Overall, it’s a great opportunity for people to work together, developing new friendships, and doing something important for their community.

At GiveCamp, there is an expectation of “What Happens at GiveCamp, Stays at GiveCamp”. Therefore, all source code must be turned over to the charities at the end of the weekend (developers cannot ask for payment) and the charities are responsible for maintaining the code moving forward (charities cannot expect the developers to maintain the codebase).

The deadline is July 8th, so get your charity proposals and volunteer submissions in!

Links for the Week of 2009.05.15

SQL Server

Find Last Date Time Updated for Any Table Ever want to know when a table was last updated? Now you can find out. Thanks to Pinal Dave for this slick little piece of code, I was totally astounded to know that you could do that.

Why use stored procedures? A very well reasoned argument for the use of stored procedures from Paul Nielsen.

Development

More ASP.NET MVC Best Practices Working with ASP.NET MVC? I know I haven’t had a chance to do much so I’ve got plenty of room to mess things up. That’s why best practices from others in the field are important to pay attention to.

What’s in your svn:ignore? Anyone who has ever used subversion is well aware of the pains that come when you get preference files and DLLs in your source control repository. How do you prevent that? By mucking around with svn:ignore, of course! (This also applies to anyone using VSTSDD, by the way.)

Unit tests vs Integration tests Ayende Rahien sums it up pretty well in just a sentence or two. I’ve had problems making the distinction clear to people in a succint way in the past. No longer shall I be at a loss for words!

Stuff & Things

6 Small Things You Can Do When You Lack Discipline So being disciplined is the key to success, right? And you’re having problems staying disciplined, so that clearly means you’re a failure, right? Wrong. None of us are 100% disciplined 100% of the time. Check out this post from Leo Babauta over at zenhabits.net for some great tips to keep yourself going.

How to Learn a Little Every Day I cannot stress this enough: learning is the most important thing you can ever do. I say it all the time. When people ask me what motivates me, I always respond that my primary motivation in everything is learning. Here are some great hints from Dumb Little Man on incorporating getting your learn on into your daily schedule.

burning fight Awesome live concert photos from Matt Miller. You can hire him for your less noisy events. After looking at his portfolio I would say that you probably should hire him.

On Non-Disclosure Agreements Seriously, this is what you sound like. Stop it. Unless it’s for humorous purposes. In that case you can go NDA yourself.

ASP.NET MVC on Mono/OS X

In a previous life I was a full time C# and ASP.NET developer. While I specialize in SQL Server these days, it’s still nice to keep up to date on new development techniques and technologies. I’ve recently become quite interested in ASP.NET MVC as an alternative to using Web Forms (which I have always disliked).

Now, I also use a MacBook and I really like OS X for just about everything. MonoDevelop isn’t quite there yet on OS X. I also don’t like leaving a virtual machine running just so I can occasionally play around with ASP.NET MVC, and I’m far too impatient to wait for one to boot. What’s the next best thing? Install Mono and get ASP.NET MVC running on OS X!

The heresy is prolific around here

The heresy is prolific around here

Here’s what I did:

Want proof that it works? Look no further than the screenshot attached to this post. I took it about 15 minutes ago. That’s how easy this was to get set up.

Update: I spoke too hastily about MonoDevelop on OS X. A new build has been posted and you can find out more from Miguel de Icaza.

Links for the Week of 2009.04.10

SQL Server

A Web Based Search for Books Online Buck Woody provides links to macros for MSDN search that will give the search bar in your browser the ability to search online inside Books Online. This has become my go to method for searching BOL. It’s much faster than opening the desktop BOL client and the results are typically exactly what I need.

The Third Pillar – Fundamentally Sound Louis Davidson discusses the third (of seven) pillars of database design.

PASS Update SQL Batman infiltrated the lair of PASS in the last round of elections and is now providing insider reports on what’s happening in our world of databases. Or something like that.

Development

Meet and Code Recap My friend, co-worker, and co-conspirator in development mischief has provided a recap on the Meet and Code event that we put together a few weeks ago. It’s well worth checking out to get his thoughts on the thing. Especially since I wrote my thoughts on a combined total of 9 hours of sleep for the weekend.

Stuff & Things

Narrative Planetarium Ideas for exploring narratives provided by the night time view of a city’s skyline.

A Day in the Life of the Boss (NSFW) Normally I (probably) wouldn’t link to something NSFW, but in this case this was too funny. Really it’s just bad language in a flow chart, but some people could be offended. You have been warned, this link contains offensive language (and no, it’s not the words ‘CREATE CURSOR’).

Meet and Code – Weekend in Review

I spent my weekend in my company’s office. Keep in mind that 1) I’m a consultant and I’m usually at a client and 2) I didn’t get paid. Why would I spend my weekend at work? Meet and Code

What’s the point of Meet and Code? The point is for a bunch of people (developers, DBAs, UI people, PMs, BAs, etc) to get togther and work on a project to learn, build new skills, and do it right the first time. Sometimes, the real world constraints of deadlines and budgets don’t always give us the time to do TDD and to do things properly. So we rush through things and have to test manually. Not at Meet and Code. Instead, we’re doing things using agile practices, TDD, and rapid development techniques so that we can practice the craft that we preach about.

See, a few months ago someone had the crazy idea that we should get together and work on a software project over the weekend. Now, that catch was that we had to recruit other people. So, we recruited other co-workers. Eventually we’re planning on recruiting the rest of you, but bear with me.

After we recruited a team of suckers volunteers, we did a few planning meetings before everything got started and decided on a product to work on (an event RSVP web application so we could manage the next time we do this). We also figured that everything would take about a weekend (Friday 5pm – Sunday 5pm).

Friday was pretty much a wash. There was a TDD and mocking demonstration that was incredibly helpful, especially since I haven’t done TDD in a long time and mocking is just right outside of my area of expertise. Most people didn’t have development environments set up on their computers, there was some confusion about who was responsible for determining what, but things got ironed out by the end of the night. Towards the end of the night, I started working on the database and the UI people were able to get started. I left around 12:30 or so. Things were pretty disorganized, but it was a good start.

We finally got a build server set up early Saturday morning. I kept churning out database code while the business layer was being put together. There was still a bit of confusion, but by the end of the day things were going full steam. People came and went, but that’s what we expected.

The office was pretty humid and smelled distinctly of feet by the end of the night. It didn’t help that the air conditioning is turned off on the weekends.

By Sunday, I was starting to run out of steam. It’s tough to make it through a week of your day job and then run through a development sprint on the weekend, but the fun and learning made it more than worth it.

How did it turn out?

It went well. There were definitely some initial teething problems – development environtments weren’t set up, use cases weren’t fully fleshed out – but we made it through them.

Going forward there are definitely some things that we could do differently to make things run smoother:

  • Install fest – We should have held an early install night where we focus on getting everyone’s development environment prepared. This would prevent problems with service packs installing and getting different versions updated.
  • Training materials/demo – In addition to the install night, having fully built a single feature to demonstrate the ‘proper’ way to use ASP.NET MVC would have been very helpful for everyone.
  • Dedicated user representation – We initially had some BAs present on Friday night, but they had other weekend plans. It was difficult at times to resolve some ambiguity in the use cases or to determine how a feature should really function. If someone else was designated as the user representative, we would have been able to defer to the user rep on all of these issues.

However, despite these teething problems, we had a lot of fun and I definitely think we’ll be repeating this a few more times before we take it completely public with some hints and tips on our methodology for running the event smoothly.

Links for the Week of 2009-01-30

SQL Server

Set based random numbers George Mastros points out that generating a random number using RAND() in a set-based operation will always return the same value for every row in the result set. What’s a DBA to do? Luckily, George also covers a great way to get around this predicament.

Hardware for SQL Server 2008 Andrew Fryer posted a few links to SQL Server 2008 Hardware recommendations from Microsoft. Good times.

The IDENTITY Property: A Much-Maligned Construct in SQL Server Aaron Alton gives a great overview of IDENTITY and why you might want to go about using it.

Development

Sharing ASP.net Session State Between Web Applications With SQL Server – Part I Back when I was a web developer I tried to figure out how to do this on multiple occasions (back in the .NET 1.1 days). Unfortunately, I never came up with any good way to accomplish this without re-implementing session state storage and project deadlines always took hold so we developed quick, hacky, brittle solutions. Looks like Alex Cuse has put together something a lot more robust than anything I’ve ever come up with. Thanks Alex! (Part 2 available here)

Software + Services in Plain English Brian H Prince has provided a link to a video featuring some sweet paper dolls to explain Software + Services (not Software as a Service). Plus, there’s some implied dating between the paper dolls when they “meet for coffee” and end up talking about their crappy IT infrastructure (total nerd date).

Löve In Two Dimensions Why the Lucky Stiff provides information on a game/graphics programming framework called Löve that’s something like a combination of Lua and SDL.

General

Hold the Coprophagia William Gibson is, hands down, my favorite author. As he works on a new novel he publishes fragments on his blog. Enjoy.

22 Most Used Free Fonts By Professional Designers The kind folks over at instantshift.com have put together a list of freely available fonts from the pros. Very good additions to anyone’s collection.

This site is protected with Urban Giraffe's plugin 'HTML Purified' and Edward Z. Yang's Powered by HTML Purifier. 219 items have been purified.