Belly Pain More Condition_symptoms

Enable the SA account on SQL Server 2005

These days I formatted the laptop and I had to rebuild the development environment than usual. Between 1000 and popped up a version of SQL Server 2005 Express that comes with the Framework. NET and Visual Studio. The only problem is that the database, as configured, is only applicable to a minimum but, with some registry tweaks, you can turn it into a real db utilities and being able to create their own database.

First of all, you must install Microsoft SQL Server Management Studio Express that is nothing more than a simple graphical interface that will handle MSSQL server.

Now, let's go to the registry, try the key "HKEY_LOCAL_MACHINE \\ SOFTWARE \\ Microsoft \\ Microsoft SQL Server \\ MSSQL.1 \\ MSSQLServer" value "LoginMode" and impostiamolo from 1 (Windows Integrated Authentication) to 2 (Authentication mixed).

At this point, and execute SQL SMSE colleghiamoci to the server via Windows integrated authentication impersonating a user with elevated rights. If you have Vista, you run the application as an administrator!

From there we execute this simple query:

   alter login sa enable; 
  alter  login  sa   with   password =   'nuova_password'  ; 

Finally, restart the instance of SQL Server database and you can log on as SA. Of course, being the "sa" account for SQL Server the equivalent of linux "root", you should use this only for the user management tasks to the db engine (create or attach new db, create new users with limited access, etc.) and use for normal users limited work on the database.

NOTE: The license is not violated in any way. The same result would be obtained BEFORE installing SQL Server 2005 Express and then. NET Framework.

Dementia More Condition_symptoms Communicating

. NET Framework 3.5

On 19 November, has released version 3.5 of the framework. Net As for 3.0, this time Microsoft has chosen to create a version of incremental update for version 2.0 without introducing, therefore, revolutionary changes as was the transition from 1.1 to 2.0. To carry out this design choice was necessary to divide the news into two groups, called "Red Bits" and "green bits". The Red bits are pre-existing feature enhancements and, in fact, represent the Service Pack for 2.0 and 3.0. In contrast, Green bits are new assemblies that encapsulate the new features.

Among the major improvements in the Red bits are 64-bit performance, re-engineering of a thread-pool and adding some functionality to the garbage collector. Obviously, the changes to be "red bits" these changes must have been made in the classroom without changing the interface.

But the juiciest news about the green bits. All the news going around LINQ (Language Integrated Query) which is, as its name suggests, a query engine designed for searching collections of objects. The introduction of LINQ, moreover, was accompanied by the insertion of special constructs within the basic languages, C # and VB.Net. Make their appearance, in fact, constructs such as automatic properties, automatically typed local variables, anonymous types, extension methods, lambda expressions. Here you can find additional information.

Another habit of Microsoft, is to link the issue of a new version of the framework to the latest version of the Visual Studio. This version, the 2008 includes the designer for WPF and WWF and the new designer for HTML with support advanced CSS, XHTML and varied. Furthermore, with regard to ASP.NET has been added IntelliSense support for Java Script code and native support for AJAX.

Finally, here is a post taken from the blog of Scott Guthrie, a leader of many of the Microsoft development team.