July 2007 - Posts
In continuation to my post on Linq-TSQL I was drowing on web to know more about LINQ and how-to in relation to TSQL. Here comes the resources I have used and using so far in getting information about LINQ: First, MSDNForum link on "What is LINQ? DLINQ?
Read More...
Whenever a CTP release is available it is best to refer to the documentation to know about t he features that are available in this CTP are documented. In this case ensure you have downloaded the Books Online from that CTP release and open the BOL then
Read More...
In oracle IF a session start with RESUMABLET RASACTION , If any DATA FILE got full for any reason the transactions running in that Session they will be waiting until you add more datafiles. However,In current version of SQL if it ran out of space in data
Read More...
During the conference of Worldwide Partner Conference 2007 Microsoft announced the official launch date for SQL Server 2008 which is in CTP3 at the moment. This conference is aligned to deliver best practices for software-plus-services delivery models.
Read More...
Cross-post from VirtualEarth live spaces that has featured handling Virtual Earth data with upcoming SQL Server 2008.
Read More...
Here is the link to attend a free e-learning on SQL Server 2008 eLearning78337 link. Title: Clinic 7045: What's New in SQL Server 2008 Course Type: Self-paced Course (at your ease) Available Offline: Yes Estimated Time of Completion: 2 Hours Language:
Read More...
By now you might have seen on blogs and documentation that there are new datatypes introduced in SQL Server 2008, they are: DATE - ANSI-compliant date data type TIME - ANSI-compliant time data type with variable precision DATETIMEOFFSET - timezone aware/preserved
Read More...
They (MS) said DTS will be wiped out after SQL Server 2005 and will not be supported, more and more SSIS is promoted to use. But within SQL Server "Katmai" DTS is included with a provision of management, run-time, and design-time support for DTS packages
Read More...
As you have seen since SQL Server 2005 release the sample databases are not included and as I mentioned in SampleDBs blog you have to download from the SQL Server Samples Web site. Also SQL 2008 BOL will no longer include the databases & applications,
Read More...