Posts
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.
Sunday, August 24, 2008
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.
Saturday, August 23, 2008
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
.jpg)
To check it in MSDN:
http://msdn.microsoft.com/en-us/vs2005/aa718517.aspx
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
Wednesday, August 20, 2008
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/
Sunday, August 17, 2008
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
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
Tuesday, August 12, 2008
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
- 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
- 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
Sunday, August 10, 2008
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
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
Thursday, August 7, 2008
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.
Saturday, August 2, 2008
.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 forthe readers too.
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
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.
Subscribe to:
Posts (Atom)
