Fun stuff with SQL Server Archives - Dragonsoft Technology View

Fun stuff with SQL Server Technology

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 provided by Carlos Sereno who was able to clarify many questions for us.

Please enjoy the reading and let us know if it did indeed work for you as well.

SSRS

SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your reporting functionality.

Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. Reporting Services includes a complete set of tools for you to create, manage, and deliver reports, and APIs that enable developers to integrate or extend data and report processing in custom applications.

Reporting Services tools work within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools and components.

(more…)

By , 11 yearsOct 14, 2011 ago

Fun stuff with SQL Server

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. Please note that if you work with Visual Studio 2010 you Read more…

By Serguei Dosyukov, 11 yearsApr 29, 2011 ago

Fun stuff with SQL Server

SQL Server: Tables, Views and missing columns

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: An attempt to use the view would give the following result: So far we are OK. Read more…

By Serguei Dosyukov, 13 yearsFeb 26, 2010 ago

Fun stuff with SQL Server Technology

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 unknown set of SQL scripts And a SQL Instance where Read more…

By Serguei Dosyukov, 13 yearsDec 2, 2009 ago

Fun stuff with SQL Server Technology

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 necessary. This is especially difficult question to discuss/suggest when SQL Read more…

By Serguei Dosyukov, 14 yearsJan 9, 2009 ago

Fun stuff with SQL Server

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 help you, but try it first. If this would not Read more…

By Serguei Dosyukov, 14 yearsNov 8, 2008 ago

Fun stuff with SQL Server

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 for specified table. or if you prefer more generic approach Read more…

By Serguei Dosyukov, 14 yearsMay 12, 2008 ago