Browsed by
Category: Code

Windows 8 Developer Preview

Windows 8 Developer Preview

Following the //build/ conference in Anaheim, I downloaded a copy of Windows 8 developer preview (32 bit) to put on my Dell Mini 12, 1 GHz Atom processor, 1GB RAM, 40GB SSD drive. A little history…I ended up having to put Windows 7 starter edition on it because it was running so horribly.  It came with Windows XP SP3, I installed Windows 7 Ultimate and it killed the performance.  I later changed it to Windows 7 Starter, and performance improved…

Read More Read More

Access Denied due to invalid credentials in IIS7

Access Denied due to invalid credentials in IIS7

I’ve been having issues with a few ASP.Net websites that we’re moving to IIS7 at work.  It didn’t happen to app of them, but to some it would prompt for network credentials, then throw an HTTP 401.1 “Access Denied Due To Invalid Credentials” error.  We’d hunt around for solutions and never find anything that worked.  Finally I tripped over the answer this morning: Open the website in IIS, and under the IIS header double-click on Authentication to open.  Click and…

Read More Read More

Get first occurance of a character in SQL

Get first occurance of a character in SQL

When I need to know the first (or any) occurrence of a character, I’m used to saying something like InStr() for VB or ASP, or String.IndexOf() in .Net, but when I tried to do something like this today (Sept 2009) in SQL for a substring portion of a query I was creating, those obviously aren’t available. Well, in Oracle InStr is available I understand, but we`re talking about SQL. To get the first occurrence of a character in a TEXT field…

Read More Read More

Clear out old selections from “Choose a Dataset” in ReportBuilder 3

Clear out old selections from “Choose a Dataset” in ReportBuilder 3

While working with ReportBuilder 3 there are times when we will move datasets around in SSRS, and old choices made when users connect to those datasets while using ReportBuilder 3 are invalid or just not there.  But the choices remain in ReportBuilder 3!  When you want to connect to these datasets, which may have the same name but just be in a different place, it’s frustrating for both the user and you.  Here’s how to remove those old dataset pointers/shortcuts…

Read More Read More

Visual Studio language support for C# not installed

Visual Studio language support for C# not installed

What?  I just get a new dev laptop (yeah, pretty proud myself, HP Pavilion dv7, triple-core i5, 6GB RAM, 640GB HD, 17.3″ display…) and I install VS 2008 and 2010, SQL, etc.  Start working on an existing website using VS 2008 and it says “Visual Studio language support for C# is not installed.  Code-editing Intellisense will not be available.  Markup Intellisense for server controls may not work”.  You gotta be kidding me… So I hit the googleverse and attempt to…

Read More Read More