There are two main Timeout property in ADO.NET.
1. Connection Timeout for Connection
2. Timeout for Data Access( Command Object or DataAdapter)
Setting Connection Timeout property for SQLConnnection object ?
You can't set timeout property in connection object because its a READ ONLY property.
SQL SERVER 2000:
select object_name(id),name from syscolumns where columnproperty(id,name,'IsIdentity')=1 SQLSERVER 2005:
select object_name(object_id),name from sys.identity_columns Note: SQL Server 2005 stores the last value of the identity property that was generated. To query the last value execute the following query.
select name,last_value from sys.identity_columns
Find ALL columns in a table that are computed columns
SQL SERVER 2000:
select name from syscolumns where id =object_id('TableName') and iscomputed=1SQL SERVER 2005:
select name from sys.computed_columns where object_id =object_id('TableName')Note: The computed column in SQL Server 2005 may be persisted. To narrow down the result set, you could execute the following query:
select * from sys.computed_columns where is_persisted=0Find ALL database names in a SQL Server instance
SQL SERVER 2000:
select name from master..sysdatabases SQL SERVER 2005:
select name from sys.databases Note: Many enhancements were made to the database. Query all of the columns in sys.databases to understand the new enhancements like snapshot, etc.
Find ALL Procedures in a Database
SQL SERVER 2000:
select name from sysobjects where type='P' SQL SERVER 2005:
select name from sys.procedures Note: You can find whether the stored procedure execution is used in replication or if the stored procedure is a startup procedure. Execute the following queries:
select name from sys.procedures where is_execution_replicated=1
select name from sys.procedures where is_auto_executed=0 Find ALL tables in a Database
SQL SERVER 2000:
select name from sysobjects where type='U' SQL SERVER 2005:
select name from sys.tables Note: In SQL Server 2005, you can find whether a table is replicated. Execute the following query.
select * from sys.tables where is_replicated =1 Find ALL views in a Database
SQL SERVER 2000:
select name from sysobjects where type='V' SQL SERVER 2005:
select name from sys.views Note: In SQL Server 2005, you can find whether a view is replicated. Execute the following query.
select * from sys.views where is_replicated =1 Find ALL Triggers in a Database
SQL SERVER 2000:
select name from sysobjects where type='TR' SQL SERVER 2005:
select name from sys.triggers where parent_class=1 Note: In SQL Server 2005, the triggers can be Assembly trigger (CLR) or a SQL trigger. In addition, we can find whether the trigger is an AFTER trigger or INSTEAD of trigger. Execute the following query:
select name from sys.triggers where type='TA'
select name from sys.triggers where type='TR'
select name from sys.triggers where is_instead_of_trigger=1 Find ALL SQL logins in a server
SQL SERVER 2000:
select * from master..syslogins where isntgroup=0 and isntname=0 SQL SERVER 2005:
select * from sys.sql_logins Find ALL dependencies of the SQL Object in a Database
SQL SERVER 2000:
select * from sysdepends SQL SERVER 2005:
select * from sys.sql_dependencies Find ALL data types in SQL server
SQL SERVER 2000:
select * from systypes SQL SERVER 2005:
select * from sys.systypes Find ALL error messages in SQL server
SQL SERVER 2000:
select * from master..sysmessages SQL SERVER 2005:
select * from sys.messages Find ALL the database files of the current database
SQL SERVER 2000:
select name,filename from sysfiles SQL SERVER 2005:
select name, physical_name from sys.database_files Find the type of index
SQL SERVER 2000: We have to use indid column to determine the type of index from 0,1 or 255.
SQL SERVER 2005:
select object_name(object_id),name, type_desc from sys.indexes where type_desc ='CLUSTERED'
select object_name(object_id),name, type_desc from sys.indexes where type_desc ='HEAP'
select object_name(object_id),name, type_desc from sys.indexes where type_desc ='NONCLUSTERED'
select object_name(object_id),name, type_desc from sys.indexes where type_desc ='XML'
Google Product Manager Tom Stocky
More details from Google:
Today we’re announcing a preview release of Google App Engine, an application-hosting tool that developers can use to build scalable web apps on top of Google’s infrastructure. The goal is to make it easier for web developers to build and scale applications, instead of focusing on system administration and maintenance.
Leveraging Google App Engine, developers can:
- Write code once and deploy. Provisioning and configuring multiple machines for web serving and data storage can be expensive and time consuming. Google App Engine makes it easier to deploy web applications by dynamically providing computing resources as they are needed. Developers write the code, and Google App Engine takes care of the rest.
- Absorb spikes in traffic. When a web app surges in popularity, the sudden increase in traffic can be overwhelming for applications of all sizes, from startups to large companies that find themselves rearchitecting their databases and entire systems several times a year. With automatic replication and load balancing, Google App Engine makes it easier to scale from one user to one million by taking advantage of Bigtable and other components of Google’s scalable infrastructure.
- Easily integrate with other Google services. It’s unnecessary and inefficient for developers to write components like authentication and e-mail from scratch for each new application. Developers using Google App Engine can make use of built-in components and Google’s broader library of APIs that provide plug-and-play functionality for simple but important features.
Google App Engine: The LimitationsThe service is launching in beta and has a number of limitations.
First, only the first 10,000 developers to sign up for the beta will be allowed to deploy applications.
The service is completely free during the beta period, but there are ceilings on usage. Applications cannot use more than 500 MB of total storage, 200 million megacycles/day CPU time, and 10 GB bandwidth (both ways) per day. We’re told this equates to about 5M pageviews/mo for the typical web app. After the beta period, those ceilings will be removed, but developers will need to pay for any overage. Google has not yet set pricing for the service.
One current limitation is a requirement that applications be written in Python, a popular scripting language for building modern web apps (Ruby and PHP are among others widely used). Google says that Python is just the first supported language, and that the entire infrastructure is designed to be language neutral. Google’s initial focus on Python makes sense because they use Python internally as their scripting language (and they hired Python creator Guido van Rossum
Source
San Francisco (InfoWorld) - Adobe's ColdFusion software for building Internet applications and Web sites is being improved with Microsoft .Net support, enabling .Net objects to be invoked from within the ColdFusion language.
A public beta of ColdFusion 8, accessible here, is to be offered on Wednesday. The general release is set for mid-year. Version 8 is the first Adobe-branded release of the former Macromedia technology.
ColdFusion is a server-side Java application; it is partnered with a markup language for writing ColdFusion applications. .Net support in the upcoming version 8 bridges the Java and Microsoft worlds.
OPOS is an existing implementation of UPOS for Microsoft Windows, based on Component Object Model (COM) technology. POS for .NET constitutes an improved, next-generation implementation of UPOS for Microsoft Windows, based on .NET. In comparison to OPOS, POS for .NET increases productivity of developers of both POS applications and service objects, by providing all the benefits of .NET managed code while at the same time exposing a set of easy to use interfaces and base classes.
POS for .NET is backward-compatible with OPOS version 1.8 service objects. In other words, applications using POS for .NET can simultaneously interact with .NET service objects written for POS for .NET and OPOS service objects.
POS for .NET Device Basic Classes
Each hardware device in POS for .NET is represented by both an abstract interface, such as CashDrawer class, and a “basic” class, such as CashDrawerBasic. Basic classes derive from the underlying interface and contain basic functional support for the device. POS for .NET provides generic support for opening, claiming, and enabling the device; device statistics; and management of delivery of events to the application. In addition, each basic class contains a set of inherited and protected methods that can be implemented by the service object. This topic provides summary information about basic classes that can be used by service objects that wish to derive from the device’s basic class, rather than taking advantage of the more fully implemented device base class
http://msdn2.microsoft.com/en-us/library/ms827970.aspxThe first portable hard drives for phones are coming onto the market, promising a "multimedia revolution".
Seagate launched its Digital Audio Video Experience (Dave) range of mobile hard drives on 30th Jan 2007, which consist of a 1cm thick credit card sized unit storing 10GB to 20GB of storage and communicating with phones via Bluetooth.
The devices have a range of around 30ft and battery life of 14 days standby or 10 hours use. No pricing details have yet been released.
"Mobile telephony is undergoing a multimedia revolution, and the Dave mobile content platform will provide even more fuel for the growth of new music and video services over mobile networks," said Patrick King, senior vice president and general manager of Seagate's consumer electronics business unit.
"Products using Dave will enable digital content for business or entertainment to be stored, moved and connected in ways never before possible."
But Seagate has been beaten to the punch on the technology by Agere Systems with a similar device, the BlueOnyx, that can communicate via Bluetooth or Wi-Fi and can store up to 40GB.
Models are also available with USB and SD card ports, and costs range from £50 to £130.
"We wanted to create a highly mobile device that solves a lot of the connectivity issues consumers have while giving them all the storage they want at an affordable price," said Ruediger Stroh, general manager of Agere's storage division.
"The capability will finally make the PC just another consumer device instead of the centre of the digital universe."
Source: vnunet
