Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        
            
                
                    
                        
                            
                                | Author | 
                                
                                 Topic  | 
                             
                            
                                    | 
                                         cece 
                                        Starting Member 
                                         
                                        
                                        1 Post  | 
                                        
                                        
                                            
                                            
                                             Posted - 2013-01-12 : 05:40:01
                                            
  | 
                                             
                                            
                                            | i want to study database administration,please recommend me the topics reqired and the software required | 
                                             
                                         
                                     | 
                             
       
                            
                       
                          
                            
                                    | 
                                     Jeff Moden 
                                    Aged Yak Warrior 
                                     
                                    
                                    652 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2013-01-12 : 11:49:11
                                          
  | 
                                         
                                        
                                          Buy a copy of the Developer's Edition (actually, it's the Enterprise Edition with special licensing) of SQL Server on Amazon.  Costs <$50 USD.There are several decent books on SQL Server Administration from a learning aspect.  Unfortunately, most of the great books I learned from are out of print and a lot about SQL Server has changed over the years.  I mostly rely on the built in help system that comes with SQL Server (Books Online) but it's not a great self-learning tool.  Since I haven't actually bought a book on the subject in over 3 years, I'll let someone else recommend a good starting book for DBAs.  BUT, DO buy the Developer's Edition right away!--Jeff Moden RBAR is pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row".First step towards the paradigm shift of writing Set Based code:"Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column." When writing schedules, keep the following in mind:"If you want it real bad, that's the way you'll likely get it."  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                       
                          
                            
                                    | 
                                     jackv 
                                    Master Smack Fu Yak Hacker 
                                     
                                    
                                    2179 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2013-01-14 : 01:51:31
                                          
  | 
                                         
                                        
                                          | As well as the recomnendation made about purchasing and beginning to use the SQL Server software - the Inside Microsoft SQL Server  series is very good . They outline internals very wellJack Vamvas--------------------http://www.sqlserver-dba.com  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |