Gary Kjos
garykjos at gmail.com
Tue Aug 16 12:51:58 CDT 2011
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