Stuart McLachlan
stuart at lexacorp.com.pg
Tue Aug 16 06:56:36 CDT 2011
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 > >