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

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






More information about the dba-SQLServer mailing list