SQL Server 2008 Express

Since yesterday available for download:
https://www.microsoft.com/express/sql/download/default.aspx

As I heard today, it's faster than version 2005, let's try it, Cheers.

SQL Server 2008 Express

AutoRecover in VS2005

To protect your solution in Visual Studio 2005 against crashing system, losing power,
unwanted restart, or ... there is an option for autorecover which
has been set to save information for every 5 minites and keep them
for 7 days as default.

It creates some backup files under visual studio folder:
.\Visual Studio 2005\Backup Files

To set it properly or to turn it off you can go in:
Tools\Options/Environment/AutoRecover


To check it in MSDN:
http://msdn.microsoft.com/en-us/vs2005/aa718517.aspx

AutoRecover in VS2005

CHM reader for FireFox

Even though that Microsoft Compiled HTML Help files (CHM) with attention to some security risks are not so popular but there are a lot of documents which have been compiled, or converted to CHM. To read a CHM file in FireFox, it's possible to add CHM Reader as a FireFox Add-on and enjoy using the content of those compiled help format files.

To find other FireFox Add-ons use the following URL:
https://addons.mozilla.org/en-US/firefox/

CHM reader for FireFox

Get Tables & Columns using Information Schema views (Sql 2005)

The Information Schema is an ANSI standard set of read-only views which
provide access to metadata in a relational database. Metadata is data about data and it contains information about all of the tables, views, columns, constraints, procedures, routines, and more.

According to MSDN, Information Schema Views (Transact-SQL)
"Information schema views provide an internal, system table-independent view of the SQL Server metadata. Information schema views enable applications to work correctly although significant changes have been made to the underlying system tables."



Each information schema view contains metadata for all data objects stored in that particular database.

Show all Tables in a Database:

SELECT * FROM AdventureWorksLT.information_schema.tables
WHERE table_type = 'Base Table'



The following T-SQL give us back the list of tables and related columns:

Because we needed to collect info about user generated tables, 'U' for 'xtype'
has been used in the code:

* xtype has two values - ‘U’ or ‘S’
* U = User generated tables
* S = System generated tables

USE AdventureWorksLT

SELECT table_name,
    column_name,
    data_type,
    character_maximum_length
FROM Information_Schema.columns
WHERE table_name IN (Select name FROM sysobjects WHERE xtype = 'U')
ORDER BY table_name



If you need to have access to other columns about the tables, please look at the available columns in Information_Schema.columns.

SQL Server 2005 System Tables and Views
SQL Server 2005 System Tables and Views
Using the Information Schema Views

Get Tables & Columns using Information Schema views (Sql 2005)

Visual Studio 2008 SP1 released

As I could find in news, Visual Studio 2008 SP1 comes with a lot of bug fixes and new features. To install you need to have the original media which you installed your VS 2008 from it.

In addition there is .NET Framework 3.5 Service Pack 1 too, those together offer a lot new as someone thinks VS 2009 is better name for it. Mary-Jo Foley has posted about it in ZDNet
http://blogs.zdnet.com/microsoft/?p=1523

Visual Studio 2008 SP1 delivers:

• Improved WPF designers
• SQL Server 2008 support
• ADO.NET Entity Designer
• ... and more

The .NET Framework 3.5 SP1 delivers:

• Performance increases 20-45% for WPF-based applications – without having to change any code
• WCF improvements that give developers more control over the way they access data and services
• ... and more

Downloads:

• Visual Studio 2008 SP1
• .NET Framework 3.5 SP1
• Visual Studio 2008 Express Editions with SP1
• Visual Studio Team System 2008 Team Foundation Server SP1

Visual Studio 2008 SP1 released

Activate Administrator account in Vista

Well, because of some security matters Administrator account is disabled as default for Windows Vista, to enable it you can simply follow the steps:

- Logon to Vista with your username and password
- Right click on Start->All Programs->Accessories->Command Prompt
- Select "Run as administrator" from context menu
- In command line type "Net user administrator /active:yes" then enter
- Check the message : The command completed successfully
- Switch User, Log Off, Restart, or Shut Down and boot your system again!
- Logon as Administrator

P.S. To hide Vista Administrator account use the following command:
Net user administrator /active:no

Activate Administrator account in Vista

AdventureWorks sample database for SQL server 2005 Express

When I wanted to install AdventureWorks sample database in SQL server 2005 Express on my Windows Vista home premium machine, I encountered with an error about lack of permission, I could install it after configuring permission.

First download the AdventureWorks:
- Use the following URL to download AdventureWorksLT.msi file:
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004
- Click on AdventureWorksLT.msi to save the file on your favorite location in your machine.
- Click on Run once the download is complete

Permission configuration:
- Run Windows Explorer (Windows Key + E)
- Use "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" as path
- Right click on AdventureWorksLT_Data.mdf and select Properties
- Then Security->Edit->Add
- In "Enter the object names ... " textbox enter your login name
- Click on Check Names, the entered name changes to MACHINENAME/Login then click OK
- Select your login name from Groups or username list and choose Full control then click OK and OK
- Repeat the same sequence for AdventureWorksLT_Log.ldf

Sql Server Management Studio:
- If you don't have Microsoft SQL Server Management Studio Express,
download it from (Microsoft Download Center) the following URL:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
- Lunch Sql Server Management Studio Express and connect to your local server.
- Right click on Databases in Object explorer and click on Attach
- click on Add and select AdventureWorksLT_Data.mdf and again click on OK
- finally click on OK and now you can find it in Object Explorer
Databases > AdventureWorksLT

Hope it helps if you encountered the same problem

AdventureWorks sample database for SQL server 2005 Express

Microsoft SQL Server 2008 released

I received this news by Microsoft TechNet newsletter, SQL Server 2008 is available as of today to MSDN and TechNet subscribers.

SQL Server 2008
Resources about SQL Server 2008 features, pricing and editions.
SQL Server 2008 TechCenter
Resources for IT Professionals who deploy, manage, and administer SQL Server.
SQL Server 2008 Developer Center
Resources for developers who develop applications that work with SQL Server.
Download the SQL Server 2008 Trial Software
Evaluate Microsoft SQL Server 2008 download, the 180-day trial software.

Microsoft SQL Server 2008 released

.NET News - dotNetCat.com

Another good source for .NET and other stuff, I started with dotnetcat because I found it just right now, hope it helps for
the readers too.

.NET News - dotNetCat.com

Shiretoko - Firefox 3.1 Alpha

Right after Firefox 3.1 now you can wait for a new one with some interesting features, it'll come end of 2008!

Some new features: Visual Tab Switcher which offers previews of pages, changes the sorting order based on which tab was most recently open. The advantage of dynamic ordering is quick jumps between recently visited tabs.

For futhur info look at Firefox 3.1 Alpha preview

Shiretoko - Firefox 3.1 Alpha

iBorn2Code

"i Born 2 Code" is a virtual place to present some technical, technological, informative news, daily photos, and interesting information in computer, programming, technology, art! and or may be wired fields! Tons of information all around makes the job difficult to present the best ones, anyway It will try to be cool and informative. Then let's go.

"i Born 2 Code" first content generated in saracafe in North Vancouver.

iBorn2Code