June 2009 - Posts - Jacob's Blog

Just back from Tech-ED Trivandrum

I am just back from Tech-Ed Trivandrum . Both I and Pinal left for Trivandrum on Friday noon and reached Trivandrum by 5.30 PM. K-Mug had organized a small get together where we had a great time meeting other speakers and community leads. I was hoping...

by Jacob Sebastian on 06-29-2009 | 520 Views

See you at Tech-ED Trivandrum on 27th June 2009

K-MUG is organizing Tech-ED Trivandrum on 27th June 2009. Along with Tech-ED, they are also launching an official PASS Chapter in Trivandrum. You can find the agenda of the event here . I will be at Tech-ED and look forward to meet many of you there....

by Jacob Sebastian on 06-24-2009 | 518 Views

Tech-ED Ahmedabad 2009 – Event Summary

For those of you who are eager to know what happened with Tech-Ed event in Ahmedabad, here is a quick summary. Pinal has written a very detailed version in his blog site . Tech-ED Ahmedabad was a great event and was very successful from all the aspects...

by Jacob Sebastian on 06-22-2009 | 1,083 Views

Finding out who dropped a table using the transaction log

I heard this question a number of times in the SQL Server forums. I used to suggest people to create DDL triggers (from SQL Server 2005 onwards) to audit schema changes. However, this can capture only changes applied after the DDL trigger is configured...

by Jacob Sebastian on 06-16-2009 | 601 Views

PASS Summit 2009 – My abstract on “XML Schema Collections” approved for PASS 2009 Summit.

My session abstract on “XML Schema Collections” is approved by the PASS Summit Program Committee and I will be getting the ‘great’ opportunity to speak at PASS Summit 2009, Seattle, Washington, during the first week of November this year. The title of...

by Jacob Sebastian on 06-16-2009 | 405 Views

French ASP.NET MVP had a fun time solving TSQL Challenges

We getting a lot of interesting feedback on 'TSQL Challenges' and the story of French MVP Aurelien is very interesting. http://beyondrelational.com/blogs/tc/archive/2009/06/14/aurelien-and-matthieu-have-fun-with-tsql-challenges.aspx The whole...

by Jacob Sebastian on 06-14-2009 | 281 Views

Converting VARBINARY to VARCHAR using FOR XML

We have seen a number of string manipulation examples using XML. Here is yet another example that uses FOR XML to convert a VARBINARY value to VARCHAR. Some one asked me this question in one of the forums. The story is like this. The OP did a data migration...

by Jacob Sebastian on 06-13-2009 | 4,393 Views

FOR XML Tutorials

After reading the XQuery Labs many people asked me if I could build such a resource page for articles that explains the usage of FOR XML. Here is a list of short articles I have previously published. I will keep updating this page as and when new articles...

by Jacob Sebastian on 06-12-2009 | 2,995 Views

Tech-ED Ahmedabad – Count Down: 9 Days Left, Competition launched by Pinal

Count Down has started for the much awaited Tech-ED Ahmedabad (IT Pro – SQL Server). Just 9 days left for the event. For event details and registration, visit: http://techedahmedabad.eventbrite.com/ Pinal has launched a competition to spread the word...

by Jacob Sebastian on 06-11-2009 | 239 Views

Beyond Relational News – Tech-ED Ahmedabad 2009 Announced – 20 June 2009 (Saturday), Hotel Rock Regency

For those of you who missed Tech-ED India 2009 last month, there is a reason to rejoice. Tech-ED is coming to Ahmedabad on 20th June 2009. Mark your calendars and be at Hotel Rock Regency, CG Road, Ahmedabad on 20th June 2009 by 1.30 PM. We will have...

by Jacob Sebastian on 06-09-2009 | 605 Views

SQL Server 2008 – How to configure FILESTREAM while doing an unattended installation?

The Unattended installer can take two additional parameters (optional) to configure FILESTREAM as part of the installation process. /FILESTREAMLEVEL This parameter can be used to specify the FILESTREAM Access Level. This parameter can take one of the...

by Jacob Sebastian on 06-09-2009 | 677 Views

BeyondRelational.com – Logos unveiled!

I am very glad to announce the news that we have finally created a logo for BeyondRelational.com . Here is the new ‘beyondrelational’ logo. TSQL Challenges , a popular channel we run at beyondrelational.com has got a new logo as well. We...

by Jacob Sebastian on 06-06-2009 | 261 Views

SQL Server 2008 – FILESTREAM: How to find out the FILESTREAM Windows share name using TSQL?

SERVERPROPERTY() function can be used to retrieve the Windows Share name configured for FILESTREAM access. Here is an example: SELECT SERVERPROPERTY ( 'FILESTREAMShareName' ) AS FileSreamShareName /* FileSreamShareName ------------------ -- KATMAIFS...

by Jacob Sebastian on 06-05-2009 | 348 Views

How to query the auto-growth properties of a SQL Server database using TSQL?

I saw this question recently in one of the forums and wrote a small piece of code to retrieve this. SELECT name, CASE WHEN is_percent_growth = 0 THEN LTRIM(STR(growth * 8.0 / 1024,10,1)) + ' MB, ' ELSE 'By ' + CAST (growth AS VARCHAR...

by Jacob Sebastian on 06-04-2009 | 789 Views

XQuery Lab 44 – Inserting an XML fragment into an XML Document

In XQuery Lab 10 we saw how to insert an attribute to an XML document and in XQuery Lab 11 , we say how to insert an element to an XML Document. We have not seen an example that inserts an XML fragment to another XML document. So, let us see how to do...

by Jacob Sebastian on 06-02-2009 | 1,118 Views

Jacob's Blog

Recent Blog Posts

Most Viewed

Archive

June 2009 - Posts