[dba-SQLServer] Question Concerning Microsoft SQL Server 2008 R2 Prerequisites

Stuart McLachlan stuart at lexacorp.com.pg
Tue Aug 16 16:21:22 CDT 2011


I should have been more specific.

There are two PowerPivots components:  PowerPivot for Excel and  PowerPivot for 
Sharepoint.  

I was referring to the latter which Alan's asked about.


-- 
Stuart


On 16 Aug 2011 at 12:51, Gary Kjos wrote:

> Hmmmm, it is my understanding that Powerpivot is an add in for Excel
> 2010.....
> 
> http://www.powerpivot.com/
> 
> I've seen demos of it and it is really a powerful tool for analyzing
> Data Warehouse type data - almost gives end users the ability to
> create their own data marts.
> 
> But it would be outside of a SQL Server DBA kind of tool.
> 
> GK
> 
> On Tue, Aug 16, 2011 at 6:56 AM, Stuart McLachlan
> <stuart at lexacorp.com.pg> wrote:
> > Hi Alan,
> >
> > Nice to see you over on this list.
> >
> > SQL Server is a Database Management System.  It is generally used as
> > the back-end to some sort of front end application.  You can use
> > anything you like for the front end.  A number here and on the VB
> > List use Visual Studio but it is not the only thing to use ( I
> > stopped using VS years ago).
> >
> > Sharepoint is used by a small minority of SQL users.
> > Forget about Excel, PowerPivot has nothing to do with  that
> > application.
> >
> > At this stage, you would probably be best off sticking to Access as
> > the front end with ODBC linked tables and PassThrough Queries to
> > stored procedures in SQL Server.   You get your head around the
> > fundamentals of tables, triggers, SQL and stored procedures, how
> > user permissions  work, how backups work, how import and export
> > works.  They are the key components of managing SQL Server.   Then
> > you can look at other front ends if required.
> >
> > Many DBAs (Database Administrators) don't get involved in front end
> > application development at all - they just manage the back end and
> > leave it up to others to use the data in real-world applications.
> >
> > --
> > Stuart
> >
> > On 16 Aug 2011 at 4:47, Alan Lawhon wrote:
> >>
> >> My question concerns the three Microsoft products mentioned in that
> >> sentence, specifically "Microsoft Visual Studio 2010, Microsoft
> >> SharePoint 2010, and SQL Server PowerPivot for SharePoint."  Is
> >> knowledge and experience with these three products taken for
> >> granted - an assumed prerequisite - prior to pursuing a SQL Server
> >> certification?  (I have no knowledge or experience with any of
> >> these three products - I don't even know what SharePoint is - or
> >> what SharePoint does.)  As far as PowerPivot is concerned, I think
> >> that has something to do with Excel spreadsheets.  My prior
> >> experience with Excel was limited to converting (and copying over)
> >> spreadsheet data to Access tables.  Is a detailed knowledge of
> >> these three Microsoft technologies required (or assumed) as a
> >> prerequisite to pursuing a SQL Server certification?
> >>
> >> TIA.  (I suspect this is going to be the first of many questions.)
> >>
> >> Alan C. Lawhon
> >>
> >>
> >>
> >> _______________________________________________
> >> dba-SQLServer mailing list
> >> dba-SQLServer at databaseadvisors.com
> >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> >> http://www.databaseadvisors.com
> >>
> >>
> >
> >
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
> 
> 
> 
> -- 
> Gary Kjos
> garykjos at gmail.com
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 







More information about the dba-SQLServer mailing list