Category Archives: Fun stuff with SQL Server

Implementing Custom Security Extensions for SQL Server 2008 R2

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

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 tasks automation: apply scripts from folder

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

SQL Server 2008: moving forward

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

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 , , , , , , | 31 Comments

Tip: Get list of columns for the table

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
  • 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’ve used your Greydragon theme ever since I switched to using Gallery3. It looks very slick; it does everything that I want; it is easy to customise the appearance with its many options; image preloading makes it faster than other … Continue reading

    Brian Stewart

    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