Tuesday, August 28, 2007
Thursday, August 9, 2007
SQL Server free tools by Idera
Personally I have not tried this. Hope it would be an useful reference.
Wednesday, August 8, 2007
SQL Server 2008 Katmai,
Today I had attended first webinar on SQL Server 2008. Eventhough the net was slow and voice was breaking somehow I managed to follow that.
Some of the key concepts are:
1. Enterprise Data Platform
2. Beyond Rational
3. Dynamic Development
4. Pervasive Insight
Links:
1. To download the SQL server katmai CTP:
2. SQL server best practices:
Some of the Features that are very interesting:
1.FileStream data type : We can save word, excel, audio, video files etc. into sql server itself. In SQL Server 2005 to achive the same functionality we need to sql varbinary(MAX) data type which stores everything in binary format.
With the help of filestream format we can handle File System objects in sql server itself & sql server supports ACID properties on this.
2. Separate date & time datatypes along with the existing datetime data type, and also a new datatype called datetime2 to store maximum dates.
Wednesday, August 1, 2007
Technorati Profile
<a href="<a href="http://technorati.com/claim/nb863ikuv9" rel="me">Technorati Profile</a>"></a>
Properties of WebMethod() Attribute
The 6 properties of WebMethod Attribute are
Description
MessageName
EnableSession
CacheDuration
TransactionOption
BufferResponse
<WebMethod(Description:="This Method add two integer")>
Public Function Add(ByVal Num1 As Integer, ByVal Num2 As Integer) As Integer
Return Num1 + Num2
End Function
Public Function Add(ByVal Num1 As Integer, ByVal Num2 As Integer) As Integer
Return Num1 + Num2
End Function
Subscribe to:
Posts (Atom)