|
|
-
|
|
I just came across a task to extract ZIP code values from the address column of a table. The address is a single string that contains information such as street, city, state, zip code, apartment number etc. The data comes from a legacy system where the address information is not stored in separate c......
|
|
-
|
|
Pinalkumar Dave is one of my favorite SQL Server bloggers. What I most appreciate is the simplicity of his posts and the relevance of the content. Most of the times he writes about simple things, but very useful for the SQL Server developers. And when he writes about complex stuff, he makes sure ......
|
|
-
|
|
This question was asked in the comments section of my FILESTREAM article at simple-talk.com. I thought it may be a better idea to write a detailed blog post explaining it along with some sample code, rather than writing a short answer in my return comments. I created a small ASP.NET example to d......
|
|
-
|
|
I had been blogging a bit about the FILESTREAM feature of SQL Server 2008 recently. I have just published a rather long article on FILESTREAM, at simple-talk.com. You can read the article here: http://www.simple-talk.com/sql/sql-training/an-introduction-to-sql-server-filestream/ The article covers ......
|
|
-
|
|
SQL Server 2008 Service Pack 1 will soon be available through Automatic Update starting from September. Read the story: http://blogs.msdn.com/petersad/archive/2009/07/30/sql-server-2008-service-pack-sp-1-on-microsoft-update-as-a-required-automatic-update.aspx......
|
|
-
|
|
I see this error reported many times in the online forums. This usually happens if you try to create a FILESTREAM enabled table in a database that is not configured for FILESTREAM usage.
To be able to store FILESTREAM data in a database, the database should be created with a FILESTREAM file group. ......
|
|
-
|
|
“Well, when accessing from TSQL, FILESTREAM enabled columns are not different from other regular columns and the code is not different from the regular code that you write”. This used to be my usual answer to people who ask me this question. I also had a standard piece of sample code that looks like......
|
|
-
|
|
One of the readers recently asked me if we could delete an attribute with a specific name from all the elements of an XML document. However, the deletion should occur only if the attribute is at a given position.
Here is the sample data for this Lab.
Employees><br /> Employee <span style="color......
|
|
-
|
|
I will be at the Delhi PASS Chapter Launch event by SQLBuzzDelhi on 11th July 2009, along with Pinal Dave, the SQL Server Wizard of India. I will be very glad to meet many of you at the venue. Feel free to come forward and meet us if you see us moving around :-). Make sure that you don’t miss Pina......
|
|
-
|
|
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 to get a copy of the all the photographs from t......
|
|