Melick's Blog

Getting started with NEW Office 365 As you may already know, Office 365 comes with different subscription models. First you need make you’re your billing address is available in supported countries. You can find the geographical availability by referring below URL. https://products.office.com/en/business/international-availability Once you are confident with your location you can check the available subscription plans. Available Plans:    https://products.office.com/en/business/compare-more-office-365-for-business-plans# There are trial versions and service descriptions are clearly available in above link. Once you are done with the payment you will be redirect to a page with an introduction wizard, where you will be highlighted with main sections in Office 365. I will provide a detailed article later in my post. But for the moment I will summarize the main Highlights.     These screens talking about everyth...

This is a bit of a DBA task. I have come across with a situation which I want to check Cross Database Reference for SharePoint Service Application databases like ReportingService_ServiceApplication_DB You can use following SQL scripts to find database cross references and references with in the Database. Database Cross References SELECT  OBJECT_NAME (referencing_id) AS referencing_object, referenced_database_name,  referenced_schema_name, referenced_entity_name FROM sys.sql_expression_dependencies WHERE  referenced_database_name IS NOT NULLAND is_ambiguous = 0;  Object References with in the Database SELECT  OBJECT_NAME (referencing_id) AS referencing_object, referenced_database_name,  referenced_schema_name, referenced_entity_name FROM sys.sql_expression_dependencies WHERE is_ambiguous = 0;