This is a Level 200 course containing 15 modules (each consisting of a video presentation, demos and a slide-deck) and while it’s intended to be delivered as a four-day workshop for Oracle DBA’s, the content in its entirety is a reference guide (rather than a mere guideline) and contains valuable information for any SQL Server professional.

Course Description

This course is to help Oracle database administrators (DBAs) leverage their skills and experience as an Oracle DBA to manage a SQL Server 2012 system.  It provides a quick start for the Oracle DBA to map, compare and contrast the realm of Oracle database management to SQL Server 2012 database management.

The content is a comprehensive course with descriptive reference material while the course itself focuses on introducing the concepts and providing hands-on learning. This course has been developed to extend the terminologies familiar to the Oracle DBA and relate those terminologies to the SQL Server world.

Course Presenter

Maciej Pilecki (@DrHouseOfSQL)

Maciej is a Microsoft Certified Master in SQL Server 2008, Microsoft Certified Trainer and former SQL Server Most Valuable Professional (MVP) who is an expert in cross-platform integration and interoperability between Oracle, MySQL and Microsoft SQL Server.

Course Modules

Module 1 – Database and Instance

Provides an understanding of the two major components of a database system.  Contains the following sections:

• Schema and Data Structures
• Storage Architecture
• SQL Server Data Files
• Logging model

Module 2 – Database Architecture

Goes in-depth into structure, components and contents of the files that constitute the database.  Contains the following sections:

• SQL Server Instance Environment
• Client interaction with Database and Instance
• Database capacities

Module 3 – Instance Architecture

Discusses the memory and process architectures that are key to a database’s performance.  Contains the following sections:

• Memory Architecture
• Memory Address Space – Comparison
• Monitoring memory usage
• Process and Thread-Based architecture
• Using the Resource Governor
• Oracle client-database interaction
• Comparing background processes

Module 4 – Data Objects

Examines in greater detail the schema objects introduced in Module 2.   Contains the following sections:

• Reviewing large allocation units
• Views comparison
• Creating a table
• Non-native data types

Module 5 – Data Access

Focuses on how data is accessed and manipulated by the clients.  Contains the following sections:

• Structured query language
• Control statements
• Integrated full-text searching
• Query optimization
• Transaction management

Module 6 – Data Protection

Fulfils the twin tasks of protecting data against unauthorized access (database security) and also from the destructive interaction between authorized users working concurrently (concurrency control).   Contains the following sections:

• Locking
• Isolation level behaviors
• Database security
• Instance security

Module 7 – Basic Administration

Contains discussion on planning and installation of SQL Server.   Contains the following sections:

• Installing SQL Server 2012
• Server configuration
• Database system
• Database maintenance

Module 8 – Server Management

Discusses the administration of various types of resources such as system resources (such as memory, processes, storage, and so on) as well as low-level database resources (such as lock, latches, queues, and so on).   Contains the following sections:

• Using the performance monitor
• Managing storage
• Locks and latches
• Capturing deadlock information

Module 9 – Schema Management

Provides the administrative aspect of schema objects described in Module 4.   Contains the following sections:

• Referential integrity via constraints
• Managing triggers
• Managing indexes
• Managing views

Module 10 – Database Security

Continues the discussion of data protection initiated in Module 6.  Contains the following sections:

• Managing privileges
• Managing roles
• Create logins and users

Module 11 – Data Movement

Examines the non-transactional mechanisms for moving data into and out of a database.  Contains the following sections:

• Data transport
• SQL Server Integration Services
• SSIS data flow
• Import/export wizard

Module 12 – Backup and Recovery

Lists the types of errors encountered in a database and the various mechanisms that are available to safeguard against these errors.  Contains the following sections:

• Backup methods
• Recovery model
• Recovering from database errors
• Maintenance plan backup

Module 13 – Performance Tuning

Is divided into two sections: tuning an instance and tuning an application.  Contains the following sections:

• Application tuning
• Instance tuning
• Data compression
• T-SQL hints
• Plan guides

Module 14 – Scalability and High Availability

Provides a high-level overview of the scalability and high availability features available in each RDBMS.  Contains the following sections:

• Clustering
• Database mirroring
• AlwaysOn
• Replication – objects
• Scalability

Module 15 – Monitoring

Shows the mechanisms by which the database can be monitored for availability, errors, and performance.  Contains the following sections:

• Error logs
• Error messages
• Monitoring performance
• Activity monitor

Details

SSDT Version: November 2012 Update

Project Type: SQL Server Integration Services (SSIS)

Setting the Sensitive flag of package parameters to True causes various Task Editors to close down unexpectedly without error when trying to access properties associated with Variables.

Steps to Reproduce

1. Create a new Integration Services Project

2. Open the default Package

3. Click on the Parameters tab

4. Add a new parameter and set its Sensitive property to True

FTP Task

5. Add a FTP Task to the package

6. Open the FTP Task Editor by double clicking on the FTP Task

7. Select the File Transfer page

8. Set the IsLocalPathVariable property of the FTP Task to True

9. Try and select a value in the LocalVariable property field

File System Task

10. Add a File System Task to the package

11. Open the File System Task Editor by double clicking on the File System Task

12. Select the General page

13. Set the IsDestinationPathVariable property of the File System Task to True

14. Try and select a value in the DestinationVariable property field

BTW, if you set the IsSourcePathVariable property to True and then try and select a value in the SourceVariable field, a dropdown list is displayed showing a list of variables/parameters.  This is the expected.behaviour.

Summary

This error occurs on a number of other Tasks and I’m not sure whether this existed prior to the SSDT November 2012 Update as I don’t have a machine without this update to test against.

Microsoft Connect ID: 771677

Unable to open Database Project

This version of SQL Server Data Tools is not compatible with the database runtime components installed on this computer

(BTW, Clicking on the “Learn more…” and “Get the latest version of SQL Server Data Tools…” links at the bottom of the dialog returns “Page not Found” errors.)

To fix this problem you need to install SQL Server Data Tools – November 2012 update.  That said, when you now try and open an existing project/solution, you are advised that the project needs Migrating however no migration wizard is launched and there is no visible way of migrating the project.

To migrate your project you need to Right Click on the Project name and select “Reload Project”.

This will launch the “One-way Upgrade wizard” which converts your project into the latest version of SSDT.

Would be nice if SP 1 included the SSDT update and that the migration wizard automatically launched when opening a project.

http://blogs.msdn.com/b/derrick_vanarnams_blog/archive/2012/10/04/adventureworks-odata-sample-with-named-resource-streams.aspx

The AdventureWorks OData service exposes resources based on specific SQL views. The SQL views are a limited subset of the AdventureWorks database that results in several consuming scenarios:

• CompanySales
• Documents
• ManufacturingInstructions
• ProductCatalog
• TerritorySalesDrilldown
• WorkOrderRouting

Well worth the read

Source: http://blogs.msdn.com/b/derrick_vanarnams_blog/archive/2012/09/06/announcing-the-adventureworks-odata-feed-sample.aspx

For more info and to get your voucher, visit http://aka.ms/secondshot .
Spread the word on Twitter with hashtag #SecondShot.

Exam 70-457: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1

Exam 70-458: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2

Exam 70-459: Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform

Exam 70-460: Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence

Q: When starting a "Self Test" or "Game", the popup notification or instructions with the "Ok" or "Start" box will NOT go away once clicked. It remains where it is placed directly over the test or game itself.

http://social.msdn.microsoft.com/Forums/en-AU/CertGeneral/thread/b2ef324f-9f26-4648-aa09-0a1b03000904

A: To fix this error you need to set microsoftelearning.com to be displayed in Internet Explorers Compatibility View mode:

1. Launch IE
2. Select the Tools menu option (ALT + T)
3. Select the Compatibility view settings menu option
4. Enter microsoftelearning.com in the Add this website field
5. Click on the Add button
6. Click on the close button

This workaround has been tested on IE8 and IE9.

Short answer code questions test a candidates ability to write code that will solve the problem described in the question.

More information can be found at Born to Learn – Short answer code questions coming soon!

Qualifying Technology Paths*

SQL Server 2012

To be eligible for free SQL Server 2012 exam vouchers, you must sit one of the following SQL Server 2008 exams:

• Exam 70-432: TS: Microsoft SQL Server 2008, Installation and Maintenance
• Exam 70-433: TS: Microsoft SQL Server 2008, Database Development
• Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
• Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008
• Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
• Exam 70-452: PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

Windows 8 (Client)

To be eligible for free Windows 8 (Client) exam vouchers, you must sit one of the following Windows 7 (Client) exams:

• Exam 70-680: TS: Windows 7, Configuring
• Exam 70-686: PRO: Windows 7, Enterprise Desktop Administrator
• Exam 70-685: PRO: Windows 7, Enterprise Desktop Support Technician

Windows Server 2012 (Private Cloud)

To be eligible for free Windows Server 2012 (Private Cloud) exam vouchers, you must sit one of the following Windows Server 2008 (Private Cloud) exams:

• Exam 70-640: Windows Server 2008 Active Directory, Configuring
• Exam 70-642: Windows Server 2008 Network Infrastructure, Configuring
• Exam 70-646: Windows Server 2008, Server Administrator
• Exam 70-647: PRO: Windows Server 2008, Enterprise Administrator
• Exam 70-643: TS: Windows Server 2008 Applications Infrastructure, Configuring
• Exam 70-659: TS: Windows Server 2008 R2, Server Virtualization

Visual Studio 2012

To be eligible for free Visual Studio 2012 exam vouchers, you must sit one of the following Visual Studio 2010 exams:

• Exam 70-511: TS: Windows Applications Development with Microsoft .NET Framework 4
• Exam 70-513: TS: Windows Communication Foundation Development with Microsoft .NET Framework 4
• Exam 70-515: TS: Web Applications Development with Microsoft .NET Framework 4
• Exam 70-516: TS: Accessing Data with Microsoft .NET Framework 4
• Exam 70-518: PRO: Designing and Developing Windows Applications Using Microsoft .NET Framework 4
• Exam 70-519: PRO: Designing and Developing Web Applications Using Microsoft .NET Framework 4

Additional information can be found here 2 for 1 Exam Vouchers

*Purchase a qualifying exam at full price with the voucher code provided when you click on "Request your Voucher" above and take the exam by June 30, 2012. When you do this you will receive an email containing one exam voucher valid for any qualifying next version exam in your chosen technology path. Your next version exam voucher code will be valid for 90 days after the availability of the next version Certification.