AboutFrom being a junior developer all the way to Development Manager position, I was always interested in new technologies. Passionate speaker, IT junky, developer, architect, team lead, and development manager - many hats, one goal - making software better and closer to people’s needs. For the most part I am using my blog as a scratch pad, writing small articles on things which I came across, was asked about more then once, and which would otherwise require additional research again and again.
I’m a huge fan of this theme. I’ve got more than 90,000 pictures in my gallery3 running on a Ubuntu...
The greydragon theme is fantastic. It’s clean, stable and feature rich. It took me a while to decide to move...
First I’m new to G3. I was wanting to append my forum with a gallery and after doing a lot...
Tag Archives: sql
When you dealing with dynamic SQL or unknown table structure, SQL meta data could help recover the missing information. There are two main system tables which give you such information: dbo.sysobjects dbo.syscolumns Example below shows how to gather column list … Continue reading
I am continuing putting some common examples of operations for Microsoft SQL Server. In addition to some of the Date related code snippets published before, there are few more today:
Writing a log, dumping data, looking for file to be used in Bulk insert… There are many situations when you would want to have access to files from inside your SQL code on Microsoft SQL Server. Did you know that you … Continue reading
Did you ever faced a situation when you need quickly calculate some boundaries of the Date value like First Day of the month, Last Day of the month, etc… in T-SQL? Colegue of mine asked me this question… WOW! What do … Continue reading