Category Archives: Fun stuff with SQL Server

Implementing Custom Security Extensions for SQL Server 2008 R2

Posted on Oct 14, 2011 by Dánechka

Introduction This article has been contributed by Daniel Klionsky and based on the work we have done within our team allowing single sign-on integration of SQL Server Reporting Services within existing application. I want to mention and praise great help … Continue reading →

Posted in Fun stuff with SQL Server, Technology | Tagged , , , , , , , , , , , , , | 26 Comments

SQL Server 2008 R2 : install mess

Posted on Apr 29, 2011 by Serguei Dosyukov

Back in 2008 I wrote an article about “reboot check” error with installer. Now it is time to mention another situation – total failure of installing SQL Server 2008 R2 on the machine with prior installation of SQL Server 2008. … Continue reading →

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

SQL Server: Tables, Views and missing columns

Posted on Feb 26, 2010 by Serguei Dosyukov

When it comes to non-schema-bound-views (NSB View) it is important to remember that there is no schema bound between objects used in the view and metadata for a view. Let’s look at the following scenario: Attempt to use the view would … Continue reading →

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

SQL tasks automation: apply scripts from folder

Posted on Dec 2, 2009 by Serguei Dosyukov

You will be amazed how common this question is: I have a folder with arbitrary set of SQL scripts and want to apply them all automatically. How do I do that? In other words: Having a folder – ex: C:\AutoSQLScripts – with some … Continue reading →

Posted in Fun stuff with SQL Server, Technology | 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

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

    Ed

    I’m a huge fan of this theme. I’ve got more than 90,000 pictures in my gallery3 running on a Ubuntu...

    Jklobo

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

    Rhyull

    more...

  • Categories