grab our rss feed

stevienova.com

Homepage of Steve Novoselac

Entries for the ‘Geeky/Programming’ Category

Google Maps Street View comes to Madison!

Although, not as exciting as my street view in Portland, I live way back in the apartments in the back. No street passes by it. Although this is pretty cool. Good way to find your way around, or at least not get lost. But remember, Google Maps gets you lost!
Technorati Tags: Google Maps,Street View,Madison,WI,Wisconsin,Portland

Leave a Comment | 741 views

Windows Live Writer - API Open (not really) - I Want To Download Existing Posts

So, I am sitting here scratching my head again. I use Windows Live Writer (WLW) to post to my blog. I like it, it rocks. There is a plugin architecture, which is cool, and some other API’s for doing things.

Comments (4) | 331 views

Salon Transcripts (STX) - Using Remotely - Opening Ports, Port Forwarding

A little background: Salon Transcripts (STX) is a Salon Management program for Mac’s. It is used by salon’s all over the country, small and large shops. The site they have is basically for sales. Tech support is 18 dollars per call/email, etc. They don’t have much for documentation, much less connecting remotely. I was tasked [...]

Comments (5) | 1,284 views

WordPress on IIS 6.0, Windows 2003 - Some Tweaks (URL Rewrite and SMTP)

OK so I lied. Everything wasn’t working after I set up my WordPress blog on IIS 6.0 on Windows 2003. Two things were broke: SMTP (email from the blog) and URL Rewrites/Permalinks.
SMTP worked through IIS just fine, I could telnet and send email out, but from WordPress, it was getting a 501 error. From what [...]

Leave a Comment | 435 views

SQL 2005, SSAS 2005: Using ascmd.exe To Create SQLAgent Jobs That Give You Completion Status

In SQL2005, you can create SQL Agent jobs. They can be scheduled, have multiple steps, alert, notify, etc. Pretty great setup. There are some downfalls though.
Like in order to call a job from a job, you need to execute the second job with T-SQL. Thing is, it doesn’t run synchronously. It runs asynchronously, which [...]

Comments (4) | 2,208 views

Server Move: Hosting My Own Site(s)

Well, I have been on HostMySite for a few years now, and I just wasn’t liking it. I didn’t have control, and couldn’t do everything I wanted to. Last week I signed up with ServerBeach and I have my own dedicated server. I am running Windows 2003, IIS, SQL, MySQL, PHP, etc.
I changed for [...]

Comments (2) | 990 views

Google Apps For Your Domain - Google Talk, Federation, SRV Records, Domain Transfers, DNS

Well, I want my Google Apps (GAFYD) account to be able to use Google Talk with other users (using Federation) besides Gmail and GAFYD (ex: Twitter, Meebo, etc). To do this, you need to add SRV records to your DNS (http://www.google.com/support/a/bin/answer.py?answer=34143) - no problem right?
Well, my current hosting (hostmysite) doesn’t allow [...]

Comments (1) | 1,315 views

SQL DBA: Function To Get Database Last Restore Time (From Log Shipping Filename)

If you need to get the last time that a database is restored from log shipping based off the transaction log file name, here is a function to do so. It parses out the date from the "last_restored_file" column, then converts it from UTC to your regular time.
 
CREATE FUNCTION [dbo].[GetLogShippingFileDate] ( [...]

Leave a Comment | 303 views

Visual Studio 2005/2008 Web Application Projects: Profile Class Auto Generation Workaround

I have been doing some coding with VS2008, and have been playing with the .NET Membership, Role, and Profile providers. I don’t use "Web Sites" when I create projects, instead I use "Web Applications" - what is the difference? Web Sites don’t really act like a first class application, there are some weird things with [...]

Comments (3) | 2,215 views

SSAS 2005: Cube Perspectives Are Good, But Something Is Missing…

In SQL Server Analysis Services 2005, you can create "perspectives" on cubes. What a perspective can do, is allow you hide different dimensions, measure groups and attributes. This works great but I still think there are a few things that are missing.
The first thing is that the cube itself is a perspective, [...]

Comments (6) | 1,583 views