I know this is a silly question so I apologize in advance. Is the
implementation/ configuration/ design/ loading/ etc. of AS typically the
responsibility of a DBA or a Developer of a company? From the perspective
where there is a definate difference between the two roles of course.
--
SQL2K SP3
TIA, ChrisRChris
I am both at work and I firmly believe the dba is reposnible for the
management of the databases and servers in terms of optimising and load
balancing.
Develpers typically come up with a schema or ER diagrams and run them by the
dba with a view for any further normalisation etc.
But I get to do both in my case.
evan
"ChrisR" <bla@.noemail.com> wrote in message
news:Oi$ZIQl3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> I know this is a silly question so I apologize in advance. Is the
> implementation/ configuration/ design/ loading/ etc. of AS typically the
> responsibility of a DBA or a Developer of a company? From the perspective
> where there is a definate difference between the two roles of course.
> --
> SQL2K SP3
> TIA, ChrisR
>
Showing posts with label dba. Show all posts
Showing posts with label dba. Show all posts
Sunday, February 12, 2012
Analysis Services for dba's?
I know this is a silly question so I apologize in advance. Is the
implementation/ configuration/ design/ loading/ etc. of AS typically the
responsibility of a DBA or a Developer of a company? From the perspective
where there is a definate difference between the two roles of course.
SQL2K SP3
TIA, ChrisR
Chris
I am both at work and I firmly believe the dba is reposnible for the
management of the databases and servers in terms of optimising and load
balancing.
Develpers typically come up with a schema or ER diagrams and run them by the
dba with a view for any further normalisation etc.
But I get to do both in my case.
evan
"ChrisR" <bla@.noemail.com> wrote in message
news:Oi$ZIQl3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> I know this is a silly question so I apologize in advance. Is the
> implementation/ configuration/ design/ loading/ etc. of AS typically the
> responsibility of a DBA or a Developer of a company? From the perspective
> where there is a definate difference between the two roles of course.
> --
> SQL2K SP3
> TIA, ChrisR
>
implementation/ configuration/ design/ loading/ etc. of AS typically the
responsibility of a DBA or a Developer of a company? From the perspective
where there is a definate difference between the two roles of course.
SQL2K SP3
TIA, ChrisR
Chris
I am both at work and I firmly believe the dba is reposnible for the
management of the databases and servers in terms of optimising and load
balancing.
Develpers typically come up with a schema or ER diagrams and run them by the
dba with a view for any further normalisation etc.
But I get to do both in my case.
evan
"ChrisR" <bla@.noemail.com> wrote in message
news:Oi$ZIQl3EHA.1524@.TK2MSFTNGP09.phx.gbl...
> I know this is a silly question so I apologize in advance. Is the
> implementation/ configuration/ design/ loading/ etc. of AS typically the
> responsibility of a DBA or a Developer of a company? From the perspective
> where there is a definate difference between the two roles of course.
> --
> SQL2K SP3
> TIA, ChrisR
>
Analysis Services for DBA's.
A lot of job postings these days for SQL DBA's list the requirement of
Analysis Services. Not having any experience with it I'm wondering what
exactly is meant? Of course its going to vary from company to company, but I
really have no clue what they mean in general? Is it cube design? MDX query
writing? Simply backing up? To be clear, Im asking in regards specificically
for a DBA, not a Developer.
TIA, ChrisR
Chris - not that I'm an expert at all, but I have done 2 short contracts in
AS/SQL and might share these experiences. In both I had to design the cubes
and staging database structure and manage the population of the staging
database (DTS). The determination of fact granularity and measures takes
ages and I was expected to do that. All in all this was the main part of my
work. We created some sample reports using Excel PivotTables and ProClarity
and once they were up and running they wanted to take time to design the
rest of the queries. I showed them a little MDX because it was of interest
to me and the tools seem slightly limited out of the box ("Generate" was one
particularly useful function which ProClarity couldn't do at the time) but
in my 2 roles MDX wasn't a priority and unless you are using it every day
you're unlikely to become good at it anyway IMHO. Since then I've met a guy
at a large multinational insurance firm who does all their data warehousing
using AS and he has never touched MDX at all. My guess therefore is that
cube design and population are the main skills, and for report-writing it is
important to have familiarity with the main front-end tools - (as far as I
know Cognos and ProClarity).
Cheers,
Paul Ibison
Analysis Services. Not having any experience with it I'm wondering what
exactly is meant? Of course its going to vary from company to company, but I
really have no clue what they mean in general? Is it cube design? MDX query
writing? Simply backing up? To be clear, Im asking in regards specificically
for a DBA, not a Developer.
TIA, ChrisR
Chris - not that I'm an expert at all, but I have done 2 short contracts in
AS/SQL and might share these experiences. In both I had to design the cubes
and staging database structure and manage the population of the staging
database (DTS). The determination of fact granularity and measures takes
ages and I was expected to do that. All in all this was the main part of my
work. We created some sample reports using Excel PivotTables and ProClarity
and once they were up and running they wanted to take time to design the
rest of the queries. I showed them a little MDX because it was of interest
to me and the tools seem slightly limited out of the box ("Generate" was one
particularly useful function which ProClarity couldn't do at the time) but
in my 2 roles MDX wasn't a priority and unless you are using it every day
you're unlikely to become good at it anyway IMHO. Since then I've met a guy
at a large multinational insurance firm who does all their data warehousing
using AS and he has never touched MDX at all. My guess therefore is that
cube design and population are the main skills, and for report-writing it is
important to have familiarity with the main front-end tools - (as far as I
know Cognos and ProClarity).
Cheers,
Paul Ibison
Analysis Services for DBA's.
A lot of job postings these days for SQL DBA's list the requirement of
Analysis Services. Not having any experience with it I'm wondering what
exactly is meant? Of course its going to vary from company to company, but I
really have no clue what they mean in general? Is it cube design? MDX query
writing? Simply backing up? To be clear, Im asking in regards specificically
for a DBA, not a Developer.
TIA, ChrisRChris - not that I'm an expert at all, but I have done 2 short contracts in
AS/SQL and might share these experiences. In both I had to design the cubes
and staging database structure and manage the population of the staging
database (DTS). The determination of fact granularity and measures takes
ages and I was expected to do that. All in all this was the main part of my
work. We created some sample reports using Excel PivotTables and ProClarity
and once they were up and running they wanted to take time to design the
rest of the queries. I showed them a little MDX because it was of interest
to me and the tools seem slightly limited out of the box ("Generate" was one
particularly useful function which ProClarity couldn't do at the time) but
in my 2 roles MDX wasn't a priority and unless you are using it every day
you're unlikely to become good at it anyway IMHO. Since then I've met a guy
at a large multinational insurance firm who does all their data warehousing
using AS and he has never touched MDX at all. My guess therefore is that
cube design and population are the main skills, and for report-writing it is
important to have familiarity with the main front-end tools - (as far as I
know Cognos and ProClarity).
Cheers,
Paul Ibison
Analysis Services. Not having any experience with it I'm wondering what
exactly is meant? Of course its going to vary from company to company, but I
really have no clue what they mean in general? Is it cube design? MDX query
writing? Simply backing up? To be clear, Im asking in regards specificically
for a DBA, not a Developer.
TIA, ChrisRChris - not that I'm an expert at all, but I have done 2 short contracts in
AS/SQL and might share these experiences. In both I had to design the cubes
and staging database structure and manage the population of the staging
database (DTS). The determination of fact granularity and measures takes
ages and I was expected to do that. All in all this was the main part of my
work. We created some sample reports using Excel PivotTables and ProClarity
and once they were up and running they wanted to take time to design the
rest of the queries. I showed them a little MDX because it was of interest
to me and the tools seem slightly limited out of the box ("Generate" was one
particularly useful function which ProClarity couldn't do at the time) but
in my 2 roles MDX wasn't a priority and unless you are using it every day
you're unlikely to become good at it anyway IMHO. Since then I've met a guy
at a large multinational insurance firm who does all their data warehousing
using AS and he has never touched MDX at all. My guess therefore is that
cube design and population are the main skills, and for report-writing it is
important to have familiarity with the main front-end tools - (as far as I
know Cognos and ProClarity).
Cheers,
Paul Ibison
Analysis Services for DBA's.
A lot of job postings these days for SQL DBA's list the requirement of
Analysis Services. Not having any experience with it I'm wondering what
exactly is meant? Of course its going to vary from company to company, but I
really have no clue what they mean in general? Is it cube design? MDX query
writing? Simply backing up? To be clear, Im asking in regards specificically
for a DBA, not a Developer.
TIA, ChrisRChris - not that I'm an expert at all, but I have done 2 short contracts in
AS/SQL and might share these experiences. In both I had to design the cubes
and staging database structure and manage the population of the staging
database (DTS). The determination of fact granularity and measures takes
ages and I was expected to do that. All in all this was the main part of my
work. We created some sample reports using Excel PivotTables and ProClarity
and once they were up and running they wanted to take time to design the
rest of the queries. I showed them a little MDX because it was of interest
to me and the tools seem slightly limited out of the box ("Generate" was one
particularly useful function which ProClarity couldn't do at the time) but
in my 2 roles MDX wasn't a priority and unless you are using it every day
you're unlikely to become good at it anyway IMHO. Since then I've met a guy
at a large multinational insurance firm who does all their data warehousing
using AS and he has never touched MDX at all. My guess therefore is that
cube design and population are the main skills, and for report-writing it is
important to have familiarity with the main front-end tools - (as far as I
know Cognos and ProClarity).
Cheers,
Paul Ibison
Analysis Services. Not having any experience with it I'm wondering what
exactly is meant? Of course its going to vary from company to company, but I
really have no clue what they mean in general? Is it cube design? MDX query
writing? Simply backing up? To be clear, Im asking in regards specificically
for a DBA, not a Developer.
TIA, ChrisRChris - not that I'm an expert at all, but I have done 2 short contracts in
AS/SQL and might share these experiences. In both I had to design the cubes
and staging database structure and manage the population of the staging
database (DTS). The determination of fact granularity and measures takes
ages and I was expected to do that. All in all this was the main part of my
work. We created some sample reports using Excel PivotTables and ProClarity
and once they were up and running they wanted to take time to design the
rest of the queries. I showed them a little MDX because it was of interest
to me and the tools seem slightly limited out of the box ("Generate" was one
particularly useful function which ProClarity couldn't do at the time) but
in my 2 roles MDX wasn't a priority and unless you are using it every day
you're unlikely to become good at it anyway IMHO. Since then I've met a guy
at a large multinational insurance firm who does all their data warehousing
using AS and he has never touched MDX at all. My guess therefore is that
cube design and population are the main skills, and for report-writing it is
important to have familiarity with the main front-end tools - (as far as I
know Cognos and ProClarity).
Cheers,
Paul Ibison
Analysis Services for DBAs.
A lot of job postings these days for SQL DBA's list the requirement of Analysis Services. Not having any experience with it I'm wondering what exactly is meant? Of course its going to vary from company to company, but I really have no clue what they mean in general? Is it cube design? MDX query writing? Simply backing up? To be clear, Im asking in regards specificically for a DBA, not a Developer.
TIA, ChrisRit really annoys me how microsoft seems to change the name for this every year or 2. data warehousing, OLAP, analysis services, business intelligence etc... It really throws the recruiters off and makes me have to put what I think are redundant statements on my resume. do you know how to implement a denormalized copy of your data for reporting purposes in such a such version of the product?|||Yes. But I don't know much about AS, hence the question.|||it really annoys me how microsoft seems to change the name for this every year or 2.
how else would you know it's time to upgrade?|||ANALYSIS SERVICES IS NOT DATA WAREHOUSING!
(Just thought that would pair well with me sig...)|||does that mean AS is a star schema? ;)|||Logically, no.
For instance:
COW PIES ARE NOT DATA WAREHOUSES!
This does not imply that cow pies are star schemas. Neither does it assert that data warehouses are not cow pies, which, in fact, many of the ones based upon star schemas are...|||heh, i was just kidding. a dumb joke.|||the blindman is being funny too. his tone can just be misconstrued some times.
I am glad I am not the only one breaking the super bowl sabbath. Damn last minute requirements changes. My numbers are not balancing. Missing about $375 out of 500K in my testing environment. this friggin' thing was working before I got the new requirements Friday after lunch. Going nuts. At least I am at home on the couch working on it...|||that's nothing - one of my ex-girlfriends used to be a bank teller. she once told me the tellers there used to be up or down up to 1k after a *single* day. :)|||the blindman is being funny too. his tone can just be misconstrued some times.They have yet to invent an emoticon to represent the nuances of my posts.
TIA, ChrisRit really annoys me how microsoft seems to change the name for this every year or 2. data warehousing, OLAP, analysis services, business intelligence etc... It really throws the recruiters off and makes me have to put what I think are redundant statements on my resume. do you know how to implement a denormalized copy of your data for reporting purposes in such a such version of the product?|||Yes. But I don't know much about AS, hence the question.|||it really annoys me how microsoft seems to change the name for this every year or 2.
how else would you know it's time to upgrade?|||ANALYSIS SERVICES IS NOT DATA WAREHOUSING!
(Just thought that would pair well with me sig...)|||does that mean AS is a star schema? ;)|||Logically, no.
For instance:
COW PIES ARE NOT DATA WAREHOUSES!
This does not imply that cow pies are star schemas. Neither does it assert that data warehouses are not cow pies, which, in fact, many of the ones based upon star schemas are...|||heh, i was just kidding. a dumb joke.|||the blindman is being funny too. his tone can just be misconstrued some times.
I am glad I am not the only one breaking the super bowl sabbath. Damn last minute requirements changes. My numbers are not balancing. Missing about $375 out of 500K in my testing environment. this friggin' thing was working before I got the new requirements Friday after lunch. Going nuts. At least I am at home on the couch working on it...|||that's nothing - one of my ex-girlfriends used to be a bank teller. she once told me the tellers there used to be up or down up to 1k after a *single* day. :)|||the blindman is being funny too. his tone can just be misconstrued some times.They have yet to invent an emoticon to represent the nuances of my posts.
Subscribe to:
Posts (Atom)