|
|
-
|
|
In SQL Azure, Service Pack 2.0, Database renaming support has been introduced. Now we can rename the database by using ALTER statement like below.
ALTER DATABASE TestDB MODIFY NAME NewTestDB...
|
|
-
|
|
Until SQL Azure Service Update 1.0, there is no support for Multiple Active Result Sets. If your stored procedure returns multiple results sets, SQL Azure will not support it.
Now SQL Azure started to support Multiple Active Result sets. If stored proc...
|
|
-
|
|
Before when we connected to SQL Azure database, if connection is idle for 5minutes, it will be automatically closed. However, this causes frequent timeouts. Now this idle time period is increased from 5 minutes to 30 minutes. This will reduce the freque...
|
|
-
|
|
Few queries will take more time and resources to execute. A long running query or poorly written query might consume a lot of resources and hence block the other resources, This will cause problems in azure model.
SQL Azure now terminates long running ...
|
|
-
|
|
In SQL Azure, there are 2 types of databases, Web and Business edition. Business edition is more costlier and has more database size is permitted. We can convert from one type of database to another database. We can also change the maxsize for the datab...
|
|
-
|
|
SQL Azure has support for few DMV's, which can be used to get information about database. As these DMV's are user database scoped, we must login into database and also user need to have VIEW DATABASE STATE permission.
1. sys.dm_db_partition_stats ...
|
|
-
|
|
In Microsoft Word 2010, WordArt has been updated with new colorful art effects.
Select the text, click “Word Art” and a list of options will appear...
|
|
-
|
|
Microsoft word files causes few security hiccups because of macros they contains. Microsoft word 2010 enhances security by allowing word files to run in sandbox environments. In Sandbox environment, it will disable the macros in the word file.
When it ...
|
|
-
|
|
HTML 5 introduced a new element "Output", which can be used to semantically indicate the calculation results in a web page. Suppose, in your webpage, if you are showing some calculations, by marking the result with "output" tag, screen readers can under...
|
|
-
|
|
HTML 5 provides a new tag called, "legend", which can be used as caption for fieldset, figure or details element. This tag can be used to show title/caption for a group of elements. Suppose, in an application form, we can group the educational details ...
|
|