Archive | SQL RSS feed for this section
Scott Guthrie Announces the WebsiteSpark Program
Scott guthrie just did a great announcement about the WebsiteSpark Program. what is WebsiteSpark? WebsiteSpark is designed for independent web developers and web development companies that build web applications and web sites on behalf of others. It enables you to get software, support and business resources from Microsoft at no cost for three years, and enables you [...]
Continue reading...100 % CPU SQL Server 2005, Server crashes!
11. April 2009
Ah back to my blog. well these days I’m on holidays for Sinhala/ Tamil New year in Sri Lanka. so anyway let met start with wishing all Sinhala and Tamil Friends A HAPPY NEW YEAR. Lets get back to business, its been a long time since my last post, as usual busy schedules (i know, i [...]
Continue reading...Uploading Binary files or Images using LINQ to SQL
16. January 2009
Today I received an email from a friend, asking how to save a binary file in to the database using LINQ to SQL. This was the second time a person had asked me the same question, So I thought of having a blog entry about it. Assume that we need to upload a file and save [...]
Continue reading...The FILESTREAM Data Type in SQL Server 2008
24. September 2008
Seriously, i’ve no time these days for blogging, busy with work as well as personal activities. but just wanted to share this valuable information for those who might have missed. Well the current project which im working on is the ASSETTE Presentations. for more information on the project you can see the above link. but the [...]
Continue reading...SQL Server 2008 Table Valued Parameters
23. December 2007
Last two weeks I have been working on developing bulk data manipulations. And even before that I always wondered “What’s the best way to pass an array of values into a SQL Server stored procedure.” One option I found was OPENXML, which I blogged here. And I was trying out visual studio 2008 and SQL server [...]
Continue reading...ADO.Net & OPENXML to Perform Bulk Database Operations
18. December 2007
Last week at my work I had to write a tool to process few hundreds of thousand email files and insert their details to the MS SQL Server 2005 database. Doing it in traditional way might require much connectivity to the database and will consume many resources. I was wondering what if I could insert [...]
Continue reading...
- Create Excel Sheets Programmatically with C# without Installing Excel.
- Create PDF Files on the fly with C# and PDFSharp
- Visual Studio 2008, C# 3.0, LINQ, ASP.Net 3.5 Getting Started
- Uploading Binary files or Images using LINQ to SQL
- MSDN Reader!! A Must Have Application!
- IIS and Skype : IIS: The process cannot access the file because it is being used by another process. (Exception from HRESULT: 0x80070020)
- FREE - Visual Studio 2008 Professional Edition & Expression Studio For Students
- 44 Silverlight 2.0 Videos
- ADO.Net & OPENXML to Perform Bulk Database Operations
- SQL Server 2008 Table Valued Parameters
- AirTel Sri Lanka – HSDPA a Fake Promise (25)
- SQL Server 2008 Table Valued Parameters (10)
- Give Me a Break !! (9)
- Create PDF Files on the fly with C# and PDFSharp (8)
- Create Excel Sheets Programmatically with C# without Installing Excel. (8)
- ADO.Net & OPENXML to Perform Bulk Database Operations (7)
- IIS and Skype : IIS: The process cannot access the file because it is being used by another process. (Exception from HRESULT: 0×80070020) (7)
- Uploading Binary files or Images using LINQ to SQL (7)
- Visual Studio 2008, C# 3.0, LINQ, ASP.Net 3.5 Getting Started (5)
- ClickOnce Application,Expired Certificates & Public Key Token PART II (5)
- Visual Studio 2010 RC Now Available for Download
- SCRUM- Quick Guide
- FCKEDitor – FIXED Image Upload dialog hang for .net
- Scott Guthrie Announces the WebsiteSpark Program
- ClickOnce Application,Expired Certificates & Public Key Token PART III – Pushing .net Framework 3.5
- Request UAC Elevation for .net Application (Managed Code)
- ClickOnce Application,Expired Certificates & Public Key Token PART II
- ClickOnce Application,Expired Certificates & Public Key Token PART I
- PDB Files: What Every Developer Must Know
- AirTel Sri Lanka – HSDPA a Fake Promise
24. September 2009
0 Comments