Mapping SQL Server Data Types to C DataTypes

Hi Can anyone point me to a document somewhere that shows a mapping of
SQL Server 2000 datatypes to C datatypes? I am writing some extended
stored procedures which need to be able to process pretty much any
data type, so I want to make sure I am taking them from SRVPROC and
storing them in the correct C data type.

Thanks,
Bruce[posted and mailed, please reply in news]

Bruce (sandell@.pacbell.net) writes:
> Hi Can anyone point me to a document somewhere that shows a mapping of
> SQL Server 2000 datatypes to C datatypes? I am writing some extended
> stored procedures which need to be able to process pretty much any
> data type, so I want to make sure I am taking them from SRVPROC and
> storing them in the correct C data type.

Books Online.

Building SQL Server Applications.
Extended Stored Procedures Programming
Extended Stored Procedure Programmer's Reference
Data Types (the last topic).

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Map based reporting

Im going to throw this out and maybe someone has some resources to
point me at.
Map based reporting within the US based on Zip supported by census data
? Has anyone done this ? Are there any Zip Maps out there to use as
templates ?
Say I have a database of customers and addresses and I want to show
state and then zip based drill down of approximate percentages of
cutomer saturation / return for a given area.
Any ideas anyone ?
ChrisWertmanTheMad wrote:
> Any ideas anyone ?
We developed an ASP.Net-Solution with mappoint
(http://www.microsoft.com/mappoint/default.mspx)
By clicking on a zip-based-area in the map the suggested report opened.
regards
Frank|||We used Spatially Aware's Map Suite Product, you can build up web pages with
interactive maps or you can retrieve custom maps via an exteral URL in SQL
Reporting Services.
www.spatiallyaware.com
"WertmanTheMad" wrote:
> Im going to throw this out and maybe someone has some resources to
> point me at.
> Map based reporting within the US based on Zip supported by census data
> ? Has anyone done this ? Are there any Zip Maps out there to use as
> templates ?
> Say I have a database of customers and addresses and I want to show
> state and then zip based drill down of approximate percentages of
> cutomer saturation / return for a given area.
> Any ideas anyone ?
> Chris
>sql

Managing SQL database rights using AD

I’m new to SQL so maybe there is an obvious reference that I have overlook
ed
that someone can point me to.
The problem I am trying to solve is managing SQL database rights using AD.
To simplify my problem imagine I have a single SQL server (SQL 2000). I also
have an app that can be accessed by two different organizations. Within each
organization I have two sets of users: Casual-users that can see a limited
number of tables and then Power-users that can see all tables for their
organization.
The structure can be conceptualized as something like this in AD:
- MyDomain
- Org1
-- Org1 admins
-- Org1 Power-Users
-- Org1 Casual-Users
- Org2
-- Org2 admins
-- Org2 Power-Users
-- Org2 Casual-Users
I can use AD to set up the structure I need. However, I would like to use
this AD structure to manage the user’s database access rights. Ideally I
could add a new user somewhere in my AD defined Domain and they would
automatically have the correct database rights.
Questions:
- Is the scenario that I am describing possible to implement?
- If so is there a source of information someone can point me at?
Thanks,
-AnthonyAnthony
http://vyaskn.tripod.com/sql_server...t_practices.htm --sec
urity
best practices
Also , you may want to look into a database role to manage users rights
"Anthony" <Anthony@.discussions.microsoft.com> wrote in message
news:BEDEB701-EF66-4827-8D3A-F79F6C7EA284@.microsoft.com...
> Im new to SQL so maybe there is an obvious reference that I have
> overlooked
> that someone can point me to.
> The problem I am trying to solve is managing SQL database rights using AD.
> To simplify my problem imagine I have a single SQL server (SQL 2000). I
> also
> have an app that can be accessed by two different organizations. Within
> each
> organization I have two sets of users: Casual-users that can see a limited
> number of tables and then Power-users that can see all tables for their
> organization.
> The structure can be conceptualized as something like this in AD:
> - MyDomain
> - Org1
> -- Org1 admins
> -- Org1 Power-Users
> -- Org1 Casual-Users
> - Org2
> -- Org2 admins
> -- Org2 Power-Users
> -- Org2 Casual-Users
>
> I can use AD to set up the structure I need. However, I would like to use
> this AD structure to manage the users database access rights. Ideally I
> could add a new user somewhere in my AD defined Domain and they would
> automatically have the correct database rights.
> Questions:
> - Is the scenario that I am describing possible to implement?
> - If so is there a source of information someone can point me at?
> Thanks,
> -Anthony
>|||Hi Uri - Thanks for the pointer. However, it still isn't clear to me what I
need to do.
What I'm really trying to do is manage the database roles through AD.
Ideally I would like to use Windows Authentication to access the SQL server
and then have that same set of Windows credentials automatically define the
user’s rights within the database.
In other words I don’t want to administrate each individual user’s right
s at
the database. Instead I want to set up my SQL server to say any member of my
casual-users group can edit table X. Then I would use AD to define what user
s
are in the casual-users group.
Thanks,
-Anthony
"Uri Dimant" wrote:

> Anthony
> http://vyaskn.tripod.com/sql_server...t_practices.htm --s
ecurity
> best practices
>
> Also , you may want to look into a database role to manage users rights
>
>
> "Anthony" <Anthony@.discussions.microsoft.com> wrote in message
> news:BEDEB701-EF66-4827-8D3A-F79F6C7EA284@.microsoft.com...
>
>|||At a high level, you would add the two Windows groups as
logins to SQL Server. You would add these two logins you
just added as users in the database. You would set the
appropriate permissions on these windows groups you just
added as database users. Moving the users in and out of the
AD groups at the AD level then flows down to the members of
the Windows group that you just added as logins (and then
database users). If you user is added to the AD group that
has the login and permissions in the database, that user
gets the login and permissions in the database based in
their membership to the windows. The windows group has the
permissions on SQL Server so moving users in and out of that
Windows group is what would control their access to SQL
Server and the database.
-Sue
On Mon, 13 Feb 2006 12:41:22 -0800, "Anthony"
<Anthony@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Uri - Thanks for the pointer. However, it still isn't clear to me what I
>need to do.
>What I'm really trying to do is manage the database roles through AD.
>Ideally I would like to use Windows Authentication to access the SQL server
>and then have that same set of Windows credentials automatically define the
>users rights within the database.
>In other words I dont want to administrate each individual users rights a
t
>the database. Instead I want to set up my SQL server to say any member of m
y
>casual-users group can edit table X. Then I would use AD to define what use
rs
>are in the casual-users group.
>Thanks,
>-Anthony
>
>"Uri Dimant" wrote:
>

Managing Hierarchies in Dimension Tables

I am currently looking at the capabilities in SSIS from the point of view of an ETL developer who has worked with other products eg. Informatica, Cognos DecisionStream and one of things I note is a lack of support for dimensional hierarchies.

It appears that MS have assumed that SSIS users will automatically use SSAS.

We use Hyperion Essbase. Other sites have Cognos or Business Objects for their OLAP/BI.

I would like to be able build multi-level dimension hierarchies directly from within SSIS.

Has MS considered this for future versions?

We don't have any support for building hierarchies in these products simply becuase we do not connect directly to their metadata. However, it is possible to load hierarchies in SSIS - although again without direct metadata support.

Could you outline some features that you think would be useful? Or perhaps some issues you are currently facing in loading hierarchies?

Thanks

Donald Farmer

|||

Hi Donald,

Many enterprises are moving towards the concept of Master Data Management. This is the function of maintaining the reporting dimensions externally to any DW/BI system. There are specialised tools to do this but it can be managed in spreadsheets and fed into a dimension repository. This may be as simple as a few tables which store the attributes and parent/child relationships. The data in this repository has been validated.

As an ETL developer, when I wish to build dimensional tables, I can use the Master Data to source the hierarchies etc and then build the appropriate dimensional tables for either a star or snowflake schema.

Cognos 8 Data Integration (formerly the DecisionStream ETL tool) allows a developer to define a hierarchy. The GUI allows them to select the parent, child, description, and Top Parent Node of the hierarchy. It then generates a table containing chiild, description, parent, and level. From this, I can build a star schema dimension. One of the best features is that it checks the hierarchy for errors. The Developer can also view the hierarchy tree.

With SSIS, and I am a relative newbie, the only way to do the above is to too build a dimension in SSAS and then call that component from SSIS.