A bit on connecting Azure AD to Office 365 tenants

enriquelima — Wed, 04 Feb 2015 22:27:52 +0000

1. Navigate to http://manage.windowsazure.com

2. Sign in with your credentials for Azure

3. Scroll down and click on Active Directory

4. Click +NEW

5. Click APP SERVICES > ACTIVE DIRECTORY > DIRECTORY > CUSTOM CREATE

6. In the Add Directory dialog, select Use existing directory from the dropdown

7. Check I am ready to be signed out now, and click the checkmark

8. When the Organizational account for Microsoft Azure loads, use your organizational account information to sign in (user@company.onmicrosoft.com)

9. On the verification dialog, confirm the information is correct and click sign out now.

You will be able to go to https://manage.windowsazure.com and sign in with your Azure login and manage your users in Active Directory.

The post A bit on connecting Azure AD to Office 365 tenants appeared first on Intentional Thinking.

Exam Prep for 70-461: The unofficial guide

enriquelima — Sat, 10 Jan 2015 21:25:00 +0000

It is that time again, time to prepare for new certs, or just recert.

Here are the materials I am using to prepare and help others prepare to embark on this exam.

Create database objects

Objective

Materials

Create and alter tables using T-SQL syntax (simple statements)
Create and alter views (simple statements)
Design views
Create and modify constraints (simple statements)
Create and alter DML triggers

http://msdn.microsoft.com/en-us/library/ms188264.aspx

http://msdn.microsoft.com/en-us/library/ms190273(v=sql.110).aspx

http://msdn.microsoft.com/library/ms190174.aspx

Work with data

Objective

Materials

Query data using SELECT statements
Implement sub-queries
Implement data types
Implement aggregate queries
Query and manage XML data

http://msdn.microsoft.com/library/ms189499.aspx

http://msdn.microsoft.com/library/ms188029.aspx

http://msdn.microsoft.com/library/ms177634.aspx

Modify data

Objective

Materials

Create and alter stored procedures (simple statements)
Modify data by using INSERT, UPDATE, and DELETE statements
Combine datasets
Work with functions

http://msdn.microsoft.com/library/ms187926.aspx

http://msdn.microsoft.com/library/ms189762.aspx

http://msdn.microsoft.com/library/ms174335.aspx

http://msdn.microsoft.com/en-us/library/ms189835.aspx

http://msdn.microsoft.com/en-us/library/ms177523.aspx

Troubleshoot and optimize

Objective

Materials

Optimize queries
Manage transactions
Evaluate the use of row-based operations vs. set-based operations
Implement error handling

http://msdn.microsoft.com/library/ms174377.aspx

http://msdn.microsoft.com/library/ms173763.aspx

http://msdn.microsoft.com/library/ms191179.aspx

Additional Resources

Resource	Materials
MVA: Querying Microsoft SQL Server 2012 Databases	http://www.microsoftvirtualacademy.com/training-courses/querying-microsoft-sql-server-2012-databases-jump-start?WT.mc_id=msls_mva
Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012	https://www.microsoftpressstore.com/store/training-kit-exam-70-461-querying-microsoft-sql-server-9780735666054

The post Exam Prep for 70-461: The unofficial guide appeared first on Intentional Thinking.