Microsoft SQL Server 2008 Administration for Oracle DBAs by Mark Anderson
By Mark Anderson
Leverage your Oracle DBA abilities on Microsoft SQL Server 2008 Microsoft SQL Server 2008 management for Oracle DBAs indicates you ways to exploit your adventure as an Oracle DBA to wake up to hurry quick at the Microsoft SQL Server platform. Authors with real-world services in either Oracle and SQL Server introduce you to basic options, akin to SQL Server structure and center management, prior to guiding you thru complex ideas, together with functionality optimization, excessive availability and catastrophe restoration. Platform comparisons, on-the-job examples, and solutions to questions raised by means of Oracle DBAs studying the SQL Server setting support construct your abilities. This functional advisor indicates you the way to: determine the parts of the SQL Server platform comprehend SQL Server structure set up and configure SQL Server software program and shopper parts outline and deal with database gadgets enforce and administer database defense video display, determine, and unravel functionality matters layout and enforce excessive availability, approach backup, and catastrophe restoration options Automate SQL Server utilizing integrated scheduling and alerting services Import and export information to and from SQL Server and different RDBMS structures improve current SQL Server installations and migrate Oracle databases to SQL Server
Read or Download Microsoft SQL Server 2008 Administration for Oracle DBAs PDF
Similar oracle books
За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle varieties, так и администраторам - используйте PL/SQL на полную мощь.
Grasp Oracle Streams 11g Replication permit real-time info entry and knowledge sharing throughout your disbursed framework utilizing the specialist details during this Oracle Press advisor. Oracle Streams 11g information Replication explains how you can arrange and administer a unified firm info sharing infrastructure.
Oracle program show four Recipes presents an example-based method of studying program exhibit - the ground-breaking, fast program improvement platform integrated with each Oracle Database license. The recipes structure is perfect for the quick-study who simply wishes an excellent instance or to kick begin their considering and get pointed within the correct course.
- Oracle SQL Tuning Pocket Reference
- Oracle Database 10g OCP Certification All-In-One Exam Guide (Oracle Press)
- Expert Oracle Database 10g Administration (Expert's Voice)
- Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting
- Expert PL/SQL Practices: for Oracle Developers and DBAs
Extra resources for Microsoft SQL Server 2008 Administration for Oracle DBAs
There are also system pages, which are used to keep track of extents that have changed since the last backup or minimally logged operation. Table 2-1 lists some of the different page types that are used in data files. Figure 2-8 represents the start of a data file and notes the first few system pages. Page 0 in every file is always the File Header, which stores various file attributes. The page following the File Header is page 1, which is the Page Free Space (PFS) page. The PFS page is used to track page allocation and free space information.
In addition, when running antivirus software on machines running SQL Server, you should add the SQL Server data files to the exception list so that they are not being constantly scanned. ldf files to the exception list. I have still to come up with a good reason not to follow this. Figure 2-9 shows an example of a database called HR; the HR database has a single primary data file and a single log file. It also contains a secondary filegroup, which is made up of three data files. Table 2-2 summarizes the limitations of a SQL Server database with regard to the number of files and filegroups, and the sizes of the files.
A GDR is released when an issue or set of issues is found that has a broad customer impact or security implications. GDRs have no release cycle, as they are only released when Microsoft determines that the impact is great enough to produce a fix outside of the normal release cycle. GDRs are made available through the Microsoft Download Center website and also through the Windows Update capability available in the Microsoft Windows platform. Hotfixes and CUs are only available through contacting Microsoft Support, but there is no charge for the supply of the fixes.