Aspino

07/07/2018

31/12/2016

May this new year bring many opportunities to your way,
to explore every joy of life
&
may your resolutions for the days ahead stay firm,
turning all your dreams into reality
and all your efforts into great achievements.
Happy New Year to you & your loved ones.
😊💐

09/01/2013

Q: What is difference between Primary Key and Unique key, What are the different types of key used in sql server and what is its use what is rollup and cude functions?

Ans: A UNIQUE constraint is similar to PRIMARY key, but you can have more than one UNIQUE constraint per table.

When you declare a UNIQUE constraint, SQL Server creates a UNIQUE index to speed up the process of searching for duplicates. In this case the index defaults to NONCLUSTERED index, because you can have only one CLUSTERED index per table.

* The number of UNIQUE constraints per table is limited by the number of indexes on the table i.e 249 NONCLUSTERED index and one possible CLUSTERED index.

Contrary to PRIMARY key UNIQUE constraints can accept NULL but just once. If the constraint is defined in a combination of fields, then every field can accept NULL and can have some values on them, as long as the combination values is unique.

01/01/2013

May your New year be A new year that brings luck and prosperity A New Year that brings happiness and joy Happy New Year

13/12/2012

Q- What is Computer Graphics ?

Ans- The term computer graphics includes almost everything on computers that is not text or sound. Today almost every computer can do some graphics, and people have even come to expect to control their computer through icons and pictures rather than just by typing.

Here in our lab at the Program of Computer Graphics, we think of computer graphics as drawing pictures on computers, also called rendering. The pictures can be photographs, drawings, movies, or simulations -- pictures of things which do not yet exist and maybe could never exist. Or they may be pictures from places we cannot see directly, such as medical images from inside your body.

We spend much of our time improving the way computer pictures can simulate real world scenes. We want images on computers to not just look more realistic, but also to BE more realistic in their colors, the way objects and rooms are lighted, and the way different materials appear. We call this work "realistic image synthesis", and the following series of pictures will show some of our techniques in stages from very simple pictures through very realistic ones.

12/12/2012

Basic Difference between Oracle and Sql Server..
----

The FIRST biggest difference: Transaction control. In Oracle EVERYTHING is a transaction and it is not permanent until you COMMIT. In SQL Server, there is (by default) no transaction control. An error half way through a stored procedure WILL NOT ROLLBACK the DDL in previous steps.

Obviously, if you wrap the TSQL DML in BEGIN TRANSACTION and COMMIT then it will roll back but this is rare in SQL Server code I've seen.

The SECOND biggest difference: MVCC. In SQL Server and Oracle is different. SQL Server will allow dirty reads, and writes can block reads in MS SQL (Again, it's configurable but the default in SQL Server is for performance and not read consistency, unlike Oracle where read consistency is default and unbendable.

Also consider:

When you setup an Oracle server, you tend to have one database with many "users/schemas", and tablespaces that are shared by all your users. SQL Server has separate databases that do not share disk files.

SQL Server uses "logins" to give you access to the SQL Server instance and each database has "users" that map to a login to get individual access to the tables and views etc.

Typically, all the objects in a database are owned by dbo.

TSQL is similar to PL/SQL, but (in my opinion) less powerful. You may need to simplify your SQL to get it to work as well as you'd expect in Oracle.

The SQL Server Management Studio (2008 SP1) is fantastic!

If you like Oracle, all the "getting under the hood" and "explain plan optimisation" then this training and experience will work well for you against guy's who just code straight SQL Server TSQL and expect the server to perform fast by magic.

SQL Server does not have packages. This might start off as a bonus (PL/SQL packages can be a PITA) but eventually you'll start to get a big nest of similarly named stored procedures in the database and you'll wish there was a way you could organise and group then them better.

Final tip, always play to your strengths. Admit that you don't have much SQL Server experience but highlight that you know the principles of how an RDBMS works, how to development a data driven application and how you design in performance from the start, etc.

23/10/2012

What do we do?

If your computer is broke we fix it. Here are just a few of the things we can do for you.

Virus & Spyware Removal
Increase Computer Performance & Speed
Recover Critical Data
Troubleshoot & Repair Hardware Problems
Setup & Configure Wired & Wireless Networks.......

23/10/2012

Aspino Infotech offers many services like Computer Repair, Web Design, Data Recovery, Networking and More. Best of all, we can come to you!

20/09/2012

Difference between Log off and Switch User.

When Fast User Switching functionality is turned on in Microsoft Windows XP, and you click Log Off on the Start menu, you have the option to click a Log Off button or a Switch User button. If you click the Log Off button, you will quit all running programs and disconnect all network connections for the current session, and the session will not remain active. If you click the Switch User button, all active programs and network connections will continue to run (the session remains active), and you will return to the Welcome screen, where other users can log on. The user's session will remain active until the computer is restarted or the user is logged off of the session.

To turn off Fast User Switching functionality so that the Switch User button is not available, follow these steps:
1. Click Start, and then click Control Panel.
2. Double-click User Accounts.
3. Click Change the way users log on or off.
4. Click to clear Use fast user switching to log off.
NOTE: The keyboard shortcut Windows logo key+L can also be used to switch users.

20/09/2012

Hello Friends,

In Window OS these services should not be enable if you no need of this. Because many intruders always looks these services first to gain access in your PCs.

DISABLE UNNECESSARY SERVICES

When your operating system starts a number of programs start as the part of the core operating system

we can call them services. Windows XP is also having a number of unnecessary or unwanted services

starting with the operating system with these services comes the security risks. So, it’s very important

that you disable such unwanted services. To view the services type “services.msc ” at the Run prompt

and press enter. Review the description of these services to get a basic understanding of what it does and

find the unnecessary services. Following services are typically safe to disable:

1. Telnet

2. Universal plug and play

3. IIS (not installed by default)

4. Net meeting and remote desktop sharing

5. Remote desktop help session

6. Remote registry

7. Routing and remote access

8. SSDP discovery services

9. Wireless zero configuration (if no wireless network)

10. Background intelligent transfer service.

16/09/2012

--WEB SERVICES :-

Web services (sometimes called application services) are services (usually including some combination of programming and data, but possibly including human resources as well) that are made available from a business's Web server for Web users or other Web-connected programs. Providers of Web services are generally known as application service providers. Web services range from such major services as storage management and customer relationship management (CRM) down to much more limited services such as the furnishing of a stock quote and the checking of bids for an auction item. The accelerating creation and availability of these services is a major Web trend.

Users can access some Web services through a peer-to-peer arrangement rather than by going to a central server. Some services can communicate with other services and this exchange of procedures and data is generally enabled by a class of software known as middleware. Services previously possible only with the older standardized service known as Electronic Data Interchange (EDI) increasingly are likely to become Web services. Besides the standardization and wide availability to users and businesses of the Internet itself, Web services are also increasingly enabled by the use of the Extensible Markup Language (XML) as a means of standardizing data formats and exchanging data. XML is the foundation for the Web Services Description Language (WSDL).

As Web services proliferate, concerns include the overall demands on network bandwidth and, for any particular service, the effect on performance as demands for that service rise. A number of new products have emerged that enable software developers to create or modify existing applications that can be "published" (made known and potentially accessible) as Web services.
-------------------------------------------------Aspino Infotech-------

16/09/2012

Software Engineering.....