Tag Archives: sql server

Implementing Custom Security Extensions for SQL Server 2008 R2

Posted on Oct 14, 2011 by

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: 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

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: 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

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