Tuesday, May 24, 2011

MS-PL License

I recently found this new license type for writing software. As I read it, nothing says you can't just make your source code "email me for the source."

http://www.opensource.org/licenses/ms-pl.html

While I don't know that I want 10,000 hits requesting my source code for any of my projects, it could be a good way to do things. Alternately, if you have an email auto-responder through your web host, you could just setup one of those to auto-respond to any requests with a zip file of the code.

Tuesday, May 10, 2011

Tuesday, May 3, 2011

Tuesday, April 26, 2011

Changing what browser Visual Studio 2010 uses

You know what I love about the Internets? You can find a fix for daggone near anything that ails you.

For example, from the developer's website:

World of VS Default Browser Switcher

Currently it is a bit of a pain (as in “too many clicks” and sometimes non-visible options) to change the browser used by VS when you’re developing and testing your website.

http://visualstudiogallery.msdn.microsoft.com/bb424812-f742-41ef-974a-cdac607df921/

Tuesday, April 19, 2011

Tuesday, April 12, 2011

Making an org chart from Exchange, part 4

So, I want to build a simple report to draw out my org chart from Outlook / Exchange / Active Directory. To do that, I outlined a pretty straightforward data table:

CREATE TABLE [dbo].[reportsto](
[ID] [varchar](1000) NULL,
[pname] [varchar](1000) NULL,
[pmanager] [varchar](1000) NULL,
[paddress] [varchar](1000) NULL,
[INSERTED] [datetime] NULL
) ON [PRIMARY]

I then wrote a script to draw down various entities from Active Directory to my local SQL Server. You can simulate what data I got with the following inserts:


insert into dbo.reportsto(pname,paddress,pmanager,pmid) values ('test person 1', '123 Main Street', '',null);
insert into dbo.reportsto(pname,paddress,pmanager,pmid) values ('test person 2', '123 Main Street', 'test person 1',(select pid from dbo.reportsto where pname = 'test person 1'));
insert into dbo.reportsto(pname,paddress,pmanager,pmid) values ('test person 3', '123 Main Street', 'test person 1',(select pid from dbo.reportsto where pname = 'test person 1'));
insert into dbo.reportsto(pname,paddress,pmanager,pmid) values ('test person 4', '123 Main Street', 'test person 2',(select pid from dbo.reportsto where pname = 'test person 2'));
insert into dbo.reportsto(pname,paddress,pmanager,pmid) values ('test person 5', '123 Main Street', 'test person 2',(select pid from dbo.reportsto where pname = 'test person 2'));
insert into dbo.reportsto(pname,paddress,pmanager,pmid) values ('test person 6', '123 Main Street', 'test person 2',(select pid from dbo.reportsto where pname = 'test person 2'));
insert into dbo.reportsto(pname,paddress,pmanager,pmid) values ('test person 7', '123 Main Street', 'test person 2',(select pid from dbo.reportsto where pname = 'test person 2'));
insert into dbo.reportsto(pname,paddress,pmanager,pmid) values ('test person 8', '123 Main Street', 'test person 2',(select pid from dbo.reportsto where pname = 'test person 2'));
insert into dbo.reportsto(pname,paddress,pmanager,pmid) values ('test person 9', '123 Main Street', 'test person 2',(select pid from dbo.reportsto where pname = 'test person 2'));
insert into dbo.reportsto(pname,paddress,pmanager,pmid) values ('test person 10', '123 Main Street', 'test person 3',(select pid from dbo.reportsto where pname = 'test person 3'));