Tip o' The Day (RSS)

Ole' Skool Meetingz :: Tip o' The Day

A quick tip o' the day, that really has nothing to do specifically with software development - but is none the less a very good tip. Meetings can be awesome and useful, or they can be useless and wasteful at best.  There are a couple reasons; Any
posted by adron | 0 Comments
Filed Under:

Source Control Etiquette :: Tip o' The Day

Some more quick best practices for using source control. Simple Rule:  Check in often, build often, and keep updated as frequently as you have code that builds.  This prevents merge conflicts, overrides, and other goofy nonsense that no one
posted by adron | 0 Comments
Filed Under:

Visual SVN & Database Projects in VS.NET :: Tip o' The Day

In Visual Studio 2008 when using Visual SVN there is a slight issue when using database projects.  Visual SVN doesn't know to check in the database project file itself so it will lose the database project whenever a fresh checkout is done against
posted by adron | 1 Comments
Filed Under:

Taking Responsibility for Broken Builds :: Tip O' The Day

Another quickie tip o' the day.  When the build is broken in TeamCity, a good habit to gain is to "Take Responsibility" for the broken build.  Whoever broke it, or more specifically whoever is fixing it, should click on "Take Responsibility"
posted by adron | 1 Comments
Filed Under:

Under the Reigns of Security :: Tip O' The Day

Often when developing software the software developers just work on machines that are administrators in every aspect.  Very little consideration is given to this, as developers usually know what they're doing.  In a larger corporate environment
posted by adron | 0 Comments
Filed Under:

.NET Subversion Tips

I've never been the "repository guy" or "build manager" or anything of that nature, but have had a decent amount of experience working with the tools. So a few simple tips... Exclude Directories The second you create a project in .NET, if it is one of
posted by adron | 3 Comments
Filed Under:

Building a Specific .NET Framework Version :: Tip o' The Day

I was working through changing a web project from building to .NET 3.5 to just .NET 3.0.  It was taking a little effort as I removed the .NET 3.5 features.  During that time though I had a problem with System.Web and I realized a cool feature
posted by adron | 0 Comments
Filed Under:

Cardinality :: Tip o' The Day

A quick tip o' the day.  I also posted this answer on WikiAnswers for the question, "What is the cardinality of a data type eg integer?" "Cardinality is the total number of unique occurrences of an entity (e.g. person, organization, or transaction)
posted by adron | 1 Comments
Filed Under:

Kick Ass Table Variables in T-SQL

Table variables are another "tool belt" item that one must have when really digging into various SQL tasks.  Oracle and other real databases also have this capability, but I'm going to, as usual, discuss the Microsoft SQL variant of the table variable

Bytes, Bits, Giga, Mega, and Tera :: Tip o' The Day

I think I did this right.  I needed bit and byte specific counts for each. It sometimes is useful in today's age, so I figured I'd post it.  It never hurts to know about the underlying fundamentals of the hardware we developers write software
posted by adron | 0 Comments
Filed Under:

Finding A Week in T-SQL :: Tip o' The Day

Recently I needed to identify a week within a T-SQL Query.  First off I figured I would want to know what day it is, then I could easily figure out a week time frame. To verify what day you have selected, use the following code: IF DATENAME(weekday,

Windows XP SP2 Needed on Vista? :: Tip o' The Day

I found the solution Kevin Dente's blog.  Hat tip!  If you run into the problem, the solution is really easy. The key in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers called %tempdir%\setup.exe, DELETE
posted by adron | 0 Comments
Filed Under:

T-SQL Date Range Usage :: Tip o' The Day

Often times a date range is used in a where clause with a start date and an end date that are the same.  The dates however are entered with the intention of getting that single day worth of data.  By default T-SQL will look at that but not give

Cube Design Best Practice :: Tip o' The Day

Do not put too many parent-child dimensions in a cube. This tip is magnified when the dimension contains custom rollups or unary operators.  Yes, some of you might say, "but they are so powerful!"  Well with power comes responsibility!  In this case the

Numeric Keys RULE! :: Tip O' The Day

When you're developing attributes that have a bunch of members, let's say more than a million (1,000,000,000), you should definitely use numeric keys.  Don't use strings or anything like that or you will suffer delays.  With business intelligence cube
More Posts Next page »