Tuesday, August 30, 2005
What's Driving India's Rise as an R&D Hub?
A good article by Wharton School of the University of Pennsylvania on India's nurture as a IT based R&D hub.
A valid point from the artivle...
Considering India's diversity in terms of religion, culture, geography, climate and language, Microsoft believes the country offers opportunities to develop technology that can rapidly be deployed elsewhere. "Solutions that work in India are more likely to transfer to other locations because they will have been tested across these barriers,"
A valid point from the artivle...
Considering India's diversity in terms of religion, culture, geography, climate and language, Microsoft believes the country offers opportunities to develop technology that can rapidly be deployed elsewhere. "Solutions that work in India are more likely to transfer to other locations because they will have been tested across these barriers,"
Saturday, August 27, 2005
What is next in the Net???
Internet: One of the biggest technical, economic and social change we have seen in the last ten years. Without Internet, I can not imagine many things happend in our life.
So, What is next in the Net? How will be the tomorrow's internet?
The answer is here...
http://www.internet2.org/
The Internet2 project is being led by over 150 U.S. universities, working with industry and government, to enable and facilitate the advanced network applications necessary to meet emerging needs in next generation network applications. Internet2 participants are developing the broadband applications, engineering and network management tools for research and education.
So, What is next in the Net? How will be the tomorrow's internet?
The answer is here...
http://www.internet2.org/
The Internet2 project is being led by over 150 U.S. universities, working with industry and government, to enable and facilitate the advanced network applications necessary to meet emerging needs in next generation network applications. Internet2 participants are developing the broadband applications, engineering and network management tools for research and education.
Friday, August 26, 2005
Tempdb - a special system database - I
Tempdb is the global storage location for SQL Server which can be used by all SQL users as well by SQL Server itself. It is shared by all the processes / threads in a SQL Server instance.
SQL Server users habitually use tempdb for storing temporary tables (global / local), table variables, temporary store procedures and other temporary objects. Apart from this SQL Server use tempdb internally for some of its operation. Few of them are:
-> Work tables associated with CURSORS.
-> Work tables associated with an ORDER BY clause.
-> Work tables associated with a GROUP BY clause.
-> Work files associated with HASH PLANS / spooling operations.
-> DBCC commands like DBCC CHECKDB
Facts about tempdb:
We can not drop Tempdb.
Can not backup or restore Tempdb.
Can not change the db ownership (sp_changedbowner)
Can not drop "guest" user from Tempdb.
Can not change the recovery mode from "simple"
Tempdb uses the server level collation by default. So we have to be careful about the collation settings and their impact. I have blogged some information on collation issues here.
One more important issue is when we intensively use operations which ustilises tempdb, it can lead performance bottleneck. Dont place tempdb in the slower drive. The drive speed limits the overall performance of SQL Server.
There is a known issue and fix on tempdb contention, which can be found from here.
SQL Server users habitually use tempdb for storing temporary tables (global / local), table variables, temporary store procedures and other temporary objects. Apart from this SQL Server use tempdb internally for some of its operation. Few of them are:
-> Work tables associated with CURSORS.
-> Work tables associated with an ORDER BY clause.
-> Work tables associated with a GROUP BY clause.
-> Work files associated with HASH PLANS / spooling operations.
-> DBCC commands like DBCC CHECKDB
Facts about tempdb:
We can not drop Tempdb.
Can not backup or restore Tempdb.
Can not change the db ownership (sp_changedbowner)
Can not drop "guest" user from Tempdb.
Can not change the recovery mode from "simple"
Tempdb uses the server level collation by default. So we have to be careful about the collation settings and their impact. I have blogged some information on collation issues here.
One more important issue is when we intensively use operations which ustilises tempdb, it can lead performance bottleneck. Dont place tempdb in the slower drive. The drive speed limits the overall performance of SQL Server.
There is a known issue and fix on tempdb contention, which can be found from here.
Microsoft Security Bulletin Search
Like all software SQL Server also has security vulnerabilities. The known vulnerabilities which affects SQL Server can be located at
http://www.microsoft.com/technet/security/current.aspx
The information about the vulnerabilites and their patches / fixes is located here. Always do update your SQL Server with the latest service packs and hot fixes in case of your SQL Server falls under any listed exploits.
http://www.microsoft.com/technet/security/current.aspx
The information about the vulnerabilites and their patches / fixes is located here. Always do update your SQL Server with the latest service packs and hot fixes in case of your SQL Server falls under any listed exploits.
Sunday, August 14, 2005
To find what SQL product running....
DBAs often need to find the version of SQL Server running in a box. To find the result, we usually use "SELECT @@version" T-SQL command.
An un-noticed command to find the SQL Server verion is...
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
The results are:
• The product version (for example, 8.00.534).
• The product level (for example, "RTM" or "SP2").
• The edition (for example, "Standard Edition"). For example, the result looks similar to:
8.00.534 RTM Standard Edition
To get additional information to find SQL Server version, visit:
MSKB article
http://support.microsoft.com/?kbid=321185 and
http://vyaskn.tripod.com/sqlsps.htm
An un-noticed command to find the SQL Server verion is...
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
The results are:
• The product version (for example, 8.00.534).
• The product level (for example, "RTM" or "SP2").
• The edition (for example, "Standard Edition"). For example, the result looks similar to:
8.00.534 RTM Standard Edition
To get additional information to find SQL Server version, visit:
MSKB article
http://support.microsoft.com/?kbid=321185 and
http://vyaskn.tripod.com/sqlsps.htm
Tuesday, August 09, 2005
Best of SQL Server Central's articles
As a SQL Server DBA's we know the contribution of SQL Server Central to the SQL community.
Red-Gate, the popular tools developers for Microsoft developers and DBA's sponsoring the "Best of SQL Server Central's articles" ebook in .pdf format.
Best of SQL Server Central ebooks (Vol1 and Vol2) can be downloaded from the following link.
https://www.red-gate.com/dynamic/downloadsqlsvrcentral.aspx
These are a collection of "essays and ideas from the SQL Server community" and are a great source of information for anyone working with SQL Server.
Free registration is required to download the ebook.
Red-Gate, the popular tools developers for Microsoft developers and DBA's sponsoring the "Best of SQL Server Central's articles" ebook in .pdf format.
Best of SQL Server Central ebooks (Vol1 and Vol2) can be downloaded from the following link.
https://www.red-gate.com/dynamic/downloadsqlsvrcentral.aspx
These are a collection of "essays and ideas from the SQL Server community" and are a great source of information for anyone working with SQL Server.
Free registration is required to download the ebook.
