Joe's Blog: Posts http://joeblog.homnick.com/Lists/Posts/AllPosts.aspx RSS feed for the Posts list. Thu, 09 Sep 2010 18:31:08 GMT Windows SharePoint Services V3 RSS Generator 60 Joe's Blog: Posts http://joeblog.homnick.com/_layouts/images/homepage.gif http://joeblog.homnick.com/Lists/Posts/AllPosts.aspx ASP.Net Web Matrix: Change SQL Espress Authentication and Enable SA from the Command Prompt http://joeblog.homnick.com/Lists/Posts/ViewPost.aspx?ID=65 Body:
When SQL Server Express is installed with default options it is setup with Integrated Windows Security and the SA (Administrator) account disabled, for example when installed as part of Visual Studio.  Additionally, in many cases the SQL Server Management Studio Express is not installed, so that a graphical interface to change to a Mixed Security and enabled SA account does not exist.  Many of the ASP.Net templates integrate into ASP.Net Web Matrix like Umbraco and SrewTurn Wiki require this Mixed Security scenario, so here are the steps to change from Integrated to Mixed Security and enable the SA account with a password from the command prompt.   This is assuming SQL Server Express 2008 R2, the step 4 key is slightly different with 2008/2005 installs.
1. Launch cmd.exe to enter Command Prompt
2. Run net stop MSSQL$SQLEXPRESS
3.  Run regedit
4. In the Registry Editor change the key HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQLServer\LoginMode value to 2. 
5. Close Registry Editor and return to Command Prompt
6. Run net start MSSQL$SQLEXPRESS
7. Run SQLCMD –S .\SQLEXPRESS
8. Enter alter login 'sa' enable
9. Enter alter login 'sa' with password ='MyPassword'
10. Close the Command Prompt, you are done
Published: 9/2/2010 10:53 AM
]]> System Account Thu, 02 Sep 2010 17:55:33 GMT http://joeblog.homnick.com/Lists/Posts/ViewPost.aspx?ID=65 Visual Studio LightSwitch Rapid Application Development (RAD) Tool Announced http://joeblog.homnick.com/Lists/Posts/ViewPost.aspx?ID=64 Body:
Visual Studio LightSwitch was announced this morning and I am pretty excited about the potential for this true Rapid Application Development environment that incorporates Silverlight.  You can deploy this on the Cloud or the Desktop and start a polished application almost right out of the File->New box.  LightSwitch delivers that RAD environment that VB 6.0 developers are used to, while incorporating the latest/greatest technologies and unlimited extensibility. 
 
You can get more information at http://microsoft.com/LightSwitch and Jason Zander has a step by step at http://bit.ly/dldm1g.   A public beta is scheduled for August 23.  This product will be delivered as a Visual Studio SKU, so it is baked right into the developer toolset from the beginning.   If you are in South Florida area, the Gold Coast Users Group http://GCUsersGroup.org is doing a session on LightSwitch and Web Matrix on September 9 and I’ll be speaking on it at the Southwest Florida CodeCamp http://CodeCamp/SWFLDev.net in Fort Myers on September 25.
 
Here’s the official blurb on key points for LightSwitch
 
• Simplified Development: Visual Studio LightSwitch makes it simple for developers to quickly build polished, user-friendly custom business applications that work and look like an off-the-shelf solution, for the desktop and the cloud.
• Speed to Solution: Visual Studio LightSwitch can dramatically decrease the time it takes to build a custom application by automatically handling routine code and letting developers focus on the custom logic that makes their applications unique.
• Flexibility for Today and Tomorrow: Visual Studio LightSwitch gives developers the flexibility to build practical, scalable applications that connect with their existing applications, legacy systems and web services, letting them choose from a wide variety of hosting, deployment and3rd-party plug-in options.
 
Published: 8/3/2010 10:35 AM
]]> System Account Tue, 03 Aug 2010 15:35:02 GMT http://joeblog.homnick.com/Lists/Posts/ViewPost.aspx?ID=64 Controlled Chaos in Software Development http://joeblog.homnick.com/Lists/Posts/ViewPost.aspx?ID=63 Body:
Software development is different from many other types of disciplines in that there are many different ways to complete a task and in many cases you don’t really know the outcome of many of the operations without trying them out first.  Additionally, each iteration can give additional options of how to implement the overall solution. Due to the complexity of the many moving parts of software, an unstructured or chaotic approach of iteratively attempting multiple ways of solving a problem while building on the knowledge built from each iteration is the best approach.  This creative iterative approach mesmerizes you as a software developer and you can see developers become completely absorbed and focused on the process.  Some might call it obsessed, however, to me it’s becoming completely focused on a creative process to the point you become one with the task.  This chaotic, iterative, creative process to developing software is what draws me so passionately to the discipline.
 
So, how do you control this chaos in software development? We have been doing a lot of work with the Scrum approach to software development implemented with Visual Studio Team System the last few years and I feel this is the best approach to controlling this creative chaotic process in software development.  Scrum is not an acronym and has its roots of meaning in the process during a Rugby match where the ball is “kept in play” through the use of a Scrum.  It is an Agile approach that fits into the standard MSF (Microsoft Solutions Framework) Agile Development Template V5.0 found in Visual Studio Team System/Team Foundation Server 2010.  There is also a Scrum for Team System 3.0 template available for free from Conchango (an EMC company) and one from Microsoft entitled Scrum 1.0, through Visual Studio Extension Manager.
 
Scrum allows for the developers to work in this chaotic creative environment in complete freedom, however, within specific goals defined by something known as a Sprint.  This is what is formally known as an “Iteration” in the Agile approach template, however, Scrum adds specific methodology on how these Sprints are played out.  The end result is that developer gets to work in this chaotic creative environment without interference by instituting goals that do not change; which they personally commit to achieve within the time frame of a short Sprint, normally 14-21 days.  The only other structured requirement is a short (typically 15 minutes) daily Scrum meeting limited to the Team members to discuss current status and any impediments discovered.
 
The Scrum methodology is experiencing an exploding popularity within software development teams currently and is definitely something you should look at if you are in this field.  For more information, check out http://ScrumForTeamSystem.com and for training see us at http://homnick.com.
Published: 7/26/2010 6:14 AM
]]> System Account Mon, 26 Jul 2010 13:18:01 GMT http://joeblog.homnick.com/Lists/Posts/ViewPost.aspx?ID=63