August 2008 - Posts

Free .NET Hosting for User Groups

Recently I got a question about free hosting for .NET User Groups

I have compiled a list below. If you know of any more or your company would like to be added to the list  please let me know.

VERIO has hosting for INETA UG members:
http://ineta.mykb.com/Article_7B694.aspx

Discount ASP.NET with Sitefinity CMS (from Telerik)
http://www.discountasp.com/press/2008_05_20_sitefinity-usergroup-hosting.aspx

Applied Innovations with Kentico ASP.NET CMS
http://www.devfish.net/fullblogitemview.aspx?blogid=563
http://www.misfitgeek.com/Trackback.aspx?guid=eb170258-0871-49ed-8ee0-0dd4f2d3df42

 

Posted by sweisfeld | 1 comment(s)
Filed under: ,

Huston TechFest 2008

I will be giving my SQL CLR talk at the Houston TechFest on Saturday September 13 at the University of Houston. It will be a great event.

Posted by sweisfeld | with no comments
Filed under: , ,

UAC in Vista not granular enough?

I had the following chat with one of my coworkers yesterday and I thought I would share. . . What are your thoughts?

BTW: if you have already seen Microsoft’s latest product “Mojave” you have got to check it out! http://www.mojaveexperiment.com/


Mr. Smith [8:19 AM]:
Hey what do you think of this? http://www.vnunet.com/vnunet/news/2183507/vista-secirity-hole-discovered
Weisfeld, Shawn A [8:29 AM]:
I think there is a bigger issue
Weisfeld, Shawn A [8:29 AM]:
so from reading that article the user doesn't like the granularity of UAC
Weisfeld, Shawn A [8:29 AM]:
(i.e. either No access, or full access)
Weisfeld, Shawn A [8:29 AM]:
IMHO a bigger problem is that so many people just turn UAC off entirely
Weisfeld, Shawn A [8:30 AM]:
providing no protection
Mr. Smith [8:30 AM]:
I was just reading about that
Mr. Smith [8:30 AM]:
because people get irritated with clicking 'allow'
Weisfeld, Shawn A [8:30 AM]:
ok people dont want to click "allow"
Weisfeld, Shawn A [8:31 AM]:
and Russinovich wants them not only to allow an installer but pick the correct level of access to give it
Weisfeld, Shawn A [8:31 AM]:
I dont know if this is a technical problem or a people problem
Mr. Smith [8:31 AM]:
good point...
Mr. Smith [8:31 AM]:
but to not even have the ability to restrict the authority of an installer seems like a problem
Weisfeld, Shawn A [8:32 AM]:
ok, so he said he could "do this in XP"
Weisfeld, Shawn A [8:32 AM]:
that means in XP he created an account that did not have admin rights
Mr. Smith [8:32 AM]:
granted, I've never bothered to do it
Weisfeld, Shawn A [8:32 AM]:
and ran his installer as that account
Weisfeld, Shawn A [8:32 AM]:
what is preventing him from doing the very same thing in Vista
Mr. Smith [8:33 AM]:
good question
Weisfeld, Shawn A [8:33 AM]:
if a user only has "user" access, I dont care what UAC popup they click on they cannot give anything admin rights, they dont even have them. . .

 

Posted by sweisfeld | with no comments
Filed under:

The debut of MVP TV August 21st, 2008 | 9:00am – 10:00am (PDT, Redmond time) - Automation with MSBuild 3.5 and Team Build 2008 - by Steve Andrews MVP

All the Interaction of the MSDN Chats but with the richer experience of Live meeting and hosted by the recognized world technology leaders –the Visual Studio Team System Microsoft MVP’s. In this opening session of MVP TV, please join one of the most celebrated and recent Team System MVP Steve Andrews covering off Automation with MSBuild 3.5 and Team Build 2008. Did you know that .csproj and .vbproj files are really MSBuild files?  More than build processes though, MSBuild is a full-featured automation language. It includes structured control flow, variables, refactorability, error handling, logging, and powerful extensibility. You can easily integrate MSBuild into your own enterprise processes and start adding value right away.  We'll also look at how Team Foundation Build extends on MSBuild and adds robust integration with Team Foundation Server. This is one show you will not want to miss!

About Steve Andrews: Steve Andrews has been working as a developer for more than 9 years. During this time, he has designed and developed applications in such widely varying areas as trust accounting, medical information management, supply chain management, and retail systems. He is currently employed at RDA Corporation in Philadelphia, PA, as a Software Engineer and a team member in their Architectural Guidance evangelism team. Steve is also an MCP, ICSOO, Speaker Liaison for the Philly .NET User Group, and all around .NET fanatic.

Thursday, August 21st, 2008 | 9:00am – 10:00am (PDT, Redmond time)

Hosted by MVP Lead Mei Liang, PJ Forgione

Attendee link:
https://www.livemeeting.com/cc/mvp/join?id=WP2PSH&role=attend&pw=4334ml%2BVHT8 

WW event link:
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032386225&EventCategory=4&culture=en-US&CountryCode=US

Conf call details:
Toll-free: +1 (866) 500-6738
Toll: +1 (203) 480-8000
Participant code: 6133095

Posted by sweisfeld | with no comments
Filed under:

Allow Remote Connections & Linked Servers

Got the following question via the North Texas SQL Server UG (http://northtexas.sqlpass.org/) mailing list.


Hi,
I am trying to add linked server in SQL Server 2005 (let say server1)for a another remote server(server2) which is also SQL Server 2005. Do I need to create a login on the server2 in order to use from the server1.

Because after creating linked server when I try to query the server2 from server1 getting the following error.

OLE DB provider "SQLNCLI" for linked server "SQL2K" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "SQL2K" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
Msg 53, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [53].

From the surface area configuration I checked the local and remote connections on server1 and server2.
Is that something I am missing?

Also if some one can give me the T-SQL query to add linked server I would appreciate.


Since I saw that error message yesterday I thought I would blog the link to the instructions on how to enable remote connections on SQL Server.
http://msdn.microsoft.com/en-us/library/ms188279.aspx

To answer the persons question here is the syntax for adding a linked server:
http://msdn.microsoft.com/en-us/library/ms190479.aspx

Happy coding.

Posted by sweisfeld | with no comments
Filed under:

The Top Ten Reasons to Attend the PASS Summit 2008

I read an article on SQL Server Central about the "The Top Ten Reasons to Attend the PASS Summit 2008" (http://www.sqlservercentral.com/articles/SQLServerCentral.com/62979/) and I would like to propose one more. I will let you decide if it is #1, #11 or somewhere in the middle.

If you attend Pass Summit 2008 you will get a chance to see my talk on the SQL CLR!

See you at summit!

PASS Summit
Posted by sweisfeld | with no comments
Filed under: