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

SQL date operations: Last 90 days, Get Date from DateTime…

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:

By Serguei Dosyukov, 14 yearsMay 12, 2008 ago

Fun stuff with SQL Server

SQL Server Collation. An enemy or a friend?

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 even more important when data you are storing goes beyond Read more…

By Serguei Dosyukov, 14 yearsApr 15, 2008 ago

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 themes; the author continually develops it in response to feature Read more…

― 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