Category Archives: Fun stuff with SQL Server

SQL Server 2008: moving forward

Posted on Jan 9, 2009 by Serguei Dosyukov

SQL Server 2008 has been available since Aug 6, 2008. This does not include CTP (Feb 2008) time-frame. We are close to the year milestone now. To my surprise there are still questions around if moving to a new version is … Continue reading →

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

TIP: Installing SQL Server 2008 – reboot required check fails

Posted on Nov 8, 2008 by Serguei Dosyukov

When installing SQL Server 2008 one can run into “‘Reboot required check failed” situation. After seeing it few times already, I think a solution is worth mentioning. “Why don’t you just reboot?”, you say… Well, most likely it would not … Continue reading →

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

Tip: Get list of columns for the table

Posted on May 12, 2008 by Serguei Dosyukov

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 →

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

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

  • About

    From 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.

    View Serguei Dosyukov's profile on LinkedIn

  • Testimonials

    I've been using this [theme] since the start. It is by far the most attractive, feature packed and stable of...

    Rhyull

    The greydragon theme is fantastic. It’s clean, stable and feature rich. It took me a while to decide to move...

    Ed

    First I’m new to G3. I was wanting to append my forum with a gallery and after doing a lot...

    Setishock
    http://www.animeappeal.com

    more...

  • Categories