Category Archives: Fun stuff with SQL Server

SQL date operations: Last 90 days, Get Date from DateTime…

Posted on May 12, 2008 by Serguei Dosyukov

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:

Posted in Fun stuff with SQL Server | Tagged , , | Leave a comment

SQL Server Collation. An enemy or a friend?

Posted on Apr 15, 2008 by Serguei Dosyukov

Is SQL Server Collation setting your enemy or your friend? How to change server default collation? In general, it is your friend, it will help SQL Server to figure out how to store character strings in different locale. It becomes … Continue reading →

Posted in Fun stuff with SQL Server | Tagged , , , | 6 Comments

Load text file data into SQL Server table

Posted on Mar 6, 2008 by Serguei Dosyukov

Last time we have seen how to manipulate text files from SQL Server code using Scripting object. This time we would look at “Read File As Table” operation from a different angle – using BULK INSERT operation. There are pros and … Continue reading →

Posted in Fun stuff with SQL Server | Tagged , , | Leave a comment

File management from inside SQL code

Posted on Feb 15, 2008 by Serguei Dosyukov

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 →

Posted in Delphi, Fun stuff with SQL Server | Tagged , , | 2 Comments

SQL date operations: First day, Last day of the month…

Posted on Feb 5, 2008 by Serguei Dosyukov

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 →

Posted in Fun stuff with SQL Server | Tagged , , , | 4 Comments

Fun stuff with SQL Server

Posted on Feb 5, 2008 by Serguei Dosyukov

Over past several years Microsoft SQL Server became primary database platform for me when it comes to Windows Development. Why am I so specific? When it comes to Web development and it is not ASP.Net related, then MySQL is THE engine … Continue reading →

Posted in Fun stuff with SQL Server | Tagged | Leave a comment

  • About

    From a junior developer through Sr 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 being 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.

       

  • Testimonials

    I’m a huge fan of this theme. I’ve got more than 90,000 pictures in my gallery3 running on a Ubuntu 11.10 desktop. It’s only for family photos. The GD theme is by far the most polished theme, easy to use … Continue reading →

    ― Jklobo

    The greydragon theme is fantastic. It’s clean, stable and feature rich. It took me a while to decide to move to G3 but with a there like this one, I could no longer resist. Thanks!

    ― Ed

  • Categories