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 > >