Windows 2012 Hosting - MVC 6 and SQL 2014 BLOG

Tutorial and Articles about Windows Hosting, SQL Hosting, MVC Hosting, and Silverlight Hosting

Visual Studio 2012 Hosting - ASPHostPortal :: New Improvements in Visual Studio 2012

clock September 28, 2012 08:10 by author Jervis

Visual Studio includes significant improvements to make it faster and more responsive than previous versions. These improvements including:

- Making better use of multi-core processors when compiling applications.

- Using less virtual memory, which greatly reduces the footprint and resources required.
- Loading projects asynchronously and loading key parts of the project first, so that developers can start working faster. When deploy it on shared hosting environment, it will be very helpful for developers

Designer Enhancements

Visual Studio includes a new design surface for creating great looking applications and user interfaces. Project formats are now consistent between Blend for Visual Studio 2012 and Visual Studio 2012, and both IDEs use the same designer surface. This ensures that the application renders identically in both environments. Blend provides powerful design tools that help developers to optimize the look and feel of their applications. Blend offers a number of improvements, which include:


-
DOM manipulation improvements. Designers can now identify elements that have been moved or reparented by JavaScript.
-
Artboard improvements. The Artboard now supports grid lines and snap to grid lines, the ability to turn adorners on or off, the ability to select all elements, and margin and padding value indicators.
-
Improvements to CSS support. IntelliSense® now indicates syntactically invalid CSS selectors, and users are notified when properties are unrecognized.

 



SQL 2012 Hosting - ASPHostPortal :: Tabular Modeling in SQL Server 2012

clock September 24, 2012 07:44 by author Jervis

Tabular model is a new database structure in SQL Server 2012 Analysis Services. When you create tabular model project, SQL Server Developer Tools creates a Model.bim file to the project and creates workspace database in Analysis Services instance. Workspace database acts as a temporary storage for data when you develop a model in SSDT.

Workspace Database

Workspace Database stores the data in memory , SSDT retrieves the data from Workspace database when you view data in the diagram view.


The below are the Model.bim properties which can use for setting values

-
Workspace Server – use this property to set the value for server where you want to host the database.
-
Workspace Database – You can not assign value, Analysis Services assigns a name to it.

You must be an administrator for the analysis services instance hosting the workspace database.

Table Import Wizard

You can import the data into model using Table Import Wizard from one or more data sources. If you are using a relational data source then you can select from list of tables and views. You can filter the data before you importing into the model.



Table Model Designer


After importing the data into the model, designer shows the data as shown below.




When you import the data from relational datasource, process identifies the relationships and adds them to the model. To view the models switch to the diagram view




You can add new relationship by clicking a column in one table and dragging the cursor to the corresponding column in the second table.


Calculated Columns

Using Data Analysis Expression (DAX) formula, you can concatenate values from two columns into a single column.




Adding a Measure to model

To add a new measure , click the cell in calculation area then type the DAX formula in bar.




More about the using Tabular Model in project can be read
here.

Reasons why you must trust ASPHostPortal.com

Every provider will tell you how they treat their support, uptime, expertise, guarantees, etc., are. Take a close look. What they’re really offering you is nothing close to what ASPHostPortal does. You will be treated with respect and provided the courtesy and service you would expect from a world-class web hosting business.

You’ll have highly trained, skilled professional technical support people ready, willing, and wanting to help you 24 hours a day. Your web hosting account servers are monitored from three monitoring points, with two alert points, every minute, 24 hours a day, 7 days a week, 365 days a year. The followings are the list of other added- benefits you can find when hosting with us:


-
DELL Hardware
Dell hardware is engineered to keep critical enterprise applications running around the clock with clustered solutions fully tested and certified by Dell and other leading operating system and application providers.
- Recovery Systems
Recovery becomes easy and seamless with our fully managed backup services. We monitor your server to ensure your data is properly backed up and recoverable so when the time comes, you can easily repair or recover your data.

- Control Panel
We provide one of the most comprehensive customer control panels available. Providing maximum control and ease of use, our Control Panel serves as the central management point for your ASPHostPortal account. You’ll use a flexible, powerful hosting control panel that will give you direct control over your web hosting account. Our control panel and systems configuration is fully automated and this means your settings are configured automatically and instantly.

- Excellent Expertise in Technology
The reason we can provide you with a great amount of power, flexibility, and simplicity at such a discounted price is due to incredible efficiencies within our business. We have not just been providing hosting for many clients for years, we have also been researching, developing, and innovating every aspect of our operations, systems, procedures, strategy, management, and teams. Our operations are based on a continual improvement program where we review thousands of systems, operational and management metrics in real-time, to fine-tune every aspect of our operation and activities. We continually train and retrain all people in our teams. We provide all people in our teams with the time, space, and inspiration to research, understand, and explore the Internet in search of greater knowledge. We do this while providing you with the best hosting services for the lowest possible price.

- Data Center

ASPHostPortal modular Tier-3 data center was specifically designed to be a world-class web hosting facility totally dedicated to uncompromised performance and security
- Monitoring Services
From the moment your server is connected to our network it is monitored for connectivity, disk, memory and CPU utilization – as well as hardware failures. Our engineers are alerted to potential issues before they become critical.

- Network
ASPHostPortal has architected its network like no other hosting company. Every facet of our network infrastructure scales to gigabit speeds with no single point of failure.

- Security
Network security and the security of your server are ASPHostPortal’s top priorities. Our security team is constantly monitoring the entire network for unusual or suspicious behavior so that when it is detected we can address the issue before our network or your server is affected.

- Support Services
Engineers staff our data center 24 hours a day, 7 days a week, 365 days a year to manage the network infrastructure and oversee top-of-the-line servers that host our clients’ critical sites and services.

 



WCF Hosting - ASPHostPortal :: Setting up a netTcpBinding enabled WCF Service in IIS 7

clock September 14, 2012 09:06 by author Jervis

netTcpBinding is a secure, reliable binding suitable for cross-machine communication. It uses TCP for message delivery along with a binary message encoding which makes is faster than HTTP based bindings such as WSHttpBinding and BasicHttpBinding.

Hosting a netTcpBinding service in IIS 7 is simple, however it requires several steps.


1. Add Non-HTTP Activation: from the Add Features Wizard select .NET Framework 3.0 Features and add Non-HTTP Activation




2. Make sure the Net.TCP services are running:
netTcpBinding uses two windows services. NetTcpActivator - Receives activation requests over the net.tcp protocol and passes them to the Windows Process Activation Service and NetTcpPortSharing - provides ability to share TCP ports over the net.tcp protocol. This service enables net.tcp ports to be shared across multiple user processes which will make it easier to manage open ports in your network.



3. In IIS navigate to your website and select Advanced Settings from the right menu. Add net.tcp to the Enabled Protocols.




4. In IIS select Bindings from the right menu. Add a new net.tcp binding with the port you wish to use. I used port 808 so my Binding information looks like 808:*






5. From now on the system is ready to run netTcpBinding so you can now add it to web.config:


<system.serviceModel>
      <services>
            <service behaviorConfiguration="MyBehavior"
            name="MyNamespace.MyService">
            <endpoint address=""
                          binding="netTcpBinding"
                          bindingConfiguration="portSharingBinding"
                          name="MyServiceEndpoint"
                          contract="MyNamespace.IMyService">
                  <identity>
                        <dns value="localhost" />
                  </identity>
            </endpoint>
 
            <endpoint address="mex"
                          binding="mexTcpBinding"
                          bindingConfiguration=""
                          name="MyServiceMexTcpBidingEndpoint"
                          contract="IMetadataExchange" />
                  <host>
                        <baseAddresses>
                              <add baseAddress="net.tcp://MyServerIPAddress:808/MyService.svc" />
                        </baseAddresses>
                  </host>
            </service>
      </services>
      <behaviors>
        <serviceBehaviors>
            <behavior name="MyBehavior">
              <serviceMetadata httpGetEnabled="false" />
              <serviceDebug includeExceptionDetailInFaults="false" />
            </behavior>
        </serviceBehaviors>
      </behaviors>
      <bindings>
            <netTcpBinding>
                  <binding name="portSharingBinding" portSharingEnabled="true"/>
            </netTcpBinding>
      </bindings>
</system.serviceModel>


A mexTcpBinding endpoint is needed in order to use IMetadataExchange over TCP. IMetadataExchange exposes methods used to return metadata about a service. Now the service should be up and running so from Visual Studio just add a Service reference. Point the reference to:
net.tcp://MyServerIPAddress:808/MyService.svc. It should generate the following configuration

<system.serviceModel>
          <bindings>
                    <netTcpBinding>
                             <binding name="MyServiceEndpoint" closeTimeout="00:01:00" openTimeout="00:01:00" receiveTimeout="00:10:00" sendTimeout="00:01:00" transactionFlow="false" transferMode="Buffered" transactionProtocol="OleTransactions" hostNameComparisonMode="StrongWildcard" listenBacklog="10" maxBufferPoolSize="524288" maxBufferSize="65536" maxConnections="10" maxReceivedMessageSize="65536">
                                      <readerQuotas maxDepth="32" maxStringContentLength="8192" maxArrayLength="16384" maxBytesPerRead="4096" maxNameTableCharCount="16384" />
                                      <reliableSession ordered="true" inactivityTimeout="00:10:00" enabled="false" />
                                      <security mode="Transport">
                                               <transport clientCredentialType="Windows" protectionLevel="EncryptAndSign" />
                                               <message clientCredentialType="Windows" />
                                      </security>
                             </binding>
                    </netTcpBinding>
          </bindings>
          <client>
                    <endpoint address="net.tcp://MyServerName/MyService.svc" binding="netTcpBinding" bindingConfiguration="MyServiceEndpoint" contract="MyNamespace.IMyService" name="MyServiceEndpoint">
                              <identity>
                                        <dns value="localhost" />
                              </identity>
                    </endpoint>
          </client>
</system.serviceModel>


Now you are ready to use the service from the client you generated:


using (MyServiceClient client = new MyServiceClient())
{
        client.Open();
        client.MyMethod();
        client.Close();
}


That’s it. You should be able to communicate with your service faster and more efficiently than any HTTP based binding

 



SQL 2012 Hosting - ASPHostPortal :: How to Manage SQL 2012 with Powershell

clock September 11, 2012 09:20 by author Jervis

     The graphical management tools provide just in this area everything you need to work with SQL Server. Still, there are many times when you might want to work from the command line, such as when you are working on a Windows Server 2008 R2 Core installation. To help with all your command-line needs, SQL Server 2012 includes the SQL Server provider for Windows PowerShell (also known as “SQL Server PowerShell”). To work with SQL Server via Windows PowerShell, you must first open a Command Prompt window or Windows PowerShell prompt and then initiation SQL Server PowerShell by typing sqlps at the command line.

Windows PowerShell introduces the concept of a cmdlet (pronounced “commandlet”). A cmdlet is the smallest unit of functionality in Windows PowerShell. Cmdlet names are not case-sensitive. SQL Server PowerShell cmdlets include the following:


-
Backup-SQLDatabase Performs backup operations on SQL Server databases.

-
Convert-UrnToPath Converts a SQL Server Management Object Uniform Resource Name (URN) to a SQL Server provider path. The URN indicates
a management object’s place within the SQL Server object hierarchy. If the URN path has characters not supported by Windows PowerShell, the characters are encoded automatically.

-
Decode-SQLName Returns an unencoded SQL Server identifier when given an identifier that has been encoded.

-
Encode-SQLName Encodes special characters in SQL Server identifiers and name paths to formats that are usable in Windows PowerShell paths. The characters encoded by this cmdlet include :/%<>*?[]|. If you don’t encode these characters, you must getting away from them by using the single quotation mark (‘) character.

-
Invoke-PolicyEvaluation Evaluates management policies applied to SQL Server instances. By default, this cmdlet intelligence compliance but does not enforce compliance. To enforce compliance, set –AdHocPolicyEvaluationMode to Configure.

-
Invoke-Sqlcmd Runs a Transact-SQL (T-SQL) or XQuery script containing orders supported by the SQLCMD utility. By default, this cmdlet doesn’t set any SQLCMD variables or return message output; only a subset of SQLCMD orders can be used.

-
Restore-SQLDatabase Performs restore operations on SQL Server databases.

To get detailed information in this area a cmdlet, type get-help cmdletname –detailed, where cmdletname is the name of the cmdlet you want to examine. To get detailed information in this area the SQL Server provider, which provides SQL Server functionality for Windows PowerShell, type
get-help sqlserver | more.

You can use the sqlps utility on any computer where you’ve installed SQL Server or the command-line management tools. The sqlps utility starts a Windows PowerShell session with the SQL Server PowerShell provider imported so that you can use its cmdlets and work with instances of SQL Server. When you are working with Windows PowerShell or scripts, you can import the SQLPS module to load the SQL Server provider, which automatically loads the vital assemblies and initializes the environment. While you previously needed to use an initialization script, this is no longer vital so long as you import the SQLPS module prior to trying to access the SQL Server instance. For best results, import the SQLPS module using the following command:


   Import-Module "sqlps" –DisableNameChecking

You can work with cmdlets by executing orders directly at the shell prompt or by running orders from scripts. You can enter any command or cmdlet that you can run at the Windows PowerShell command prompt into a script by copying the related command text to a file and reduction the file with the .ps1 extension. You can then run the script in the same way that you would any other command or cmdlet. Even if, when you are working with Windows PowerShell, the current index might not be part of the environment path. For this reason, you might need to use the ./ notation when you run a script in the current index, such as the following:

./runtasks


The current execution policy for SQL Server PowerShell controls whether and how you can run scripts. Although the default configuration depends on which operating system and journal you’ve installed, you can quickly determine the execution policy by inflowing get-executionpolicy at the Windows PowerShell prompt.


To set the execution policy to require that all scripts have a trusted signature to do, enter the following command:


set-executionpolicy allsigned

To set the execution policy so that scripts downloaded from the web do only if they are signed by a trusted source, enter:


set-executionpolicy remotesigned

To set the execution policy to run scripts regardless of whether they have a digital signature and work in an unrestricted environment, you can enter the following command:


set-executionpolicy unrestricted

For administration at the Windows PowerShell prompt, you use Invoke-Sqlcmd to run T-SQL or XQuery scripts containing orders supported by the SQLCMD utility. Invoke-Sqlcmd fully supports T-SQL and the XQuery syntax supported by the Database Engine, but it does not set any scripting variables by default. Invoke-Sqlcmd also accepts the SQLCMD orders listed in Table 1-3, later in this chapter. By default, results are formatted as a table, with the first result set showed automatically and subsequent result sets showed only if they have the same column list as the first result set.


The basic syntax you use most often with Invoke-Sqlcmd follows:


Invoke-Sqlcmd [-ServerInstance ServerStringOrObject]

[-Database DatabaseName] [-EncryptConnection ]
[-Username UserName] [-Password Password] [[-Query] QueryString] [-DedicatedAdministratorConnection]

[-InputFile FilePath] [ | Out-File –filepath FilePath]


The command’s parameters are used as follows:


–Database Specifies the name of the database that you want to work with. If you don’t use this parameter, the database that is used depends

on whether the current path specifies both the SQLSERVER:SQL folder
and a database name. If both are specified, Invoke-Sqlcmd connects to the database that is specified in the path. Otherwise, Invoke-Sqlcmd connects to the default database for the current login ID.

NOTE
Use–IgnoreProviderContext to force a connection to the database that is defined as the default for the current login ID.

–DedicatedAdministratorConnection Ensures that a dedicated administrator connection (DAC) is used to force a connection when one might not be possible otherwise.

–EncryptConnection Enables Secure Sockets Layer (SSL) encryption for the connection.


–InputFile Provides the full path to a file that must be used as the query participation. The file can contain T-SQL statements, XQuery statements, SQLCMD orders, and scripting variables. Spaces are not allowable in the file path or file name.


–Password Sets the password for the SQL Server Certification login ID that is specified in –Username.


–Query Defines one or more queries to be run. The queries can be T-SQL queries, XQuery statements, or SQLCMD orders. Separate multiple queries with semicolons.


TIP You do not need to use the SQLCMD GO command. Getting away from any dual quotation marks included in the string and consider using bracketed identifiers such as [EmpTable] instead of quoted identifiers such as “EmpTable”. To ensure that the message output is returned, add the –Verbose parameter. –Verbose is a parameter common to all cmdlets.


–ServerInstance Specifies the name of an instance of the Database Engine that you want to work with. For default instances, specify only the computer name, such as DbServer23. For named instances, use the format “ComputerNameInstanceName”, such as DbServer23EmployeeDb.


–Username Sets the login ID for making a SQL Server certification connection to an instance of the Database Engine. You also must set the password for the login ID.


NOTE By default, Invoke-Sqlcmd attempts a Windows certification connection

by using the Windows tab running the Windows PowerShell session. Windows certification connections are preferred. To use a SQL Server certification connection instead, specify the user name and password for the SQL login ID that you want to use.

With this in mind, you could replace the following T-SQL statements:


USE OrderSystem;
GO
SELECT * FROM Inventory.Product
ORDER BY Name ASC
GO


with the following Windows PowerShell command:


Invoke-Sqlcmd -Query "SELECT * FROM Inventory.Product; ORDER BY Name ASC"
-ServerInstance "DbServer23OrderSystem"


You also could read the orders from a script, as publicized in Try out 1-1. SAMPLE 1-1 Example SQL Command Script.


Contents of SqlCmd.sql Script.

 SELECT * FROM Inventory.Product
 ORDER BY Name ASC


Command to Run the Script

 Invoke-Sqlcmd -InputFile "C:ScriptsSqlCmd.sql"

22 PART I Microsoft SQL Server 2012 Essentials

When you work with Windows PowerShell, don’t overlook the importance of SQL Server help being implemented owing to a provider. The data that providers expose appears as a drive that you can browse. One way to browse is to get or set the place with respect to the SqlServer: provider drive. The top of the hierarchy exposed is represented by the SQL folder, then there is a folder for the machine name, and finally, there is a folder for the instance name. Following this, you could navigate to the top-level folder for the default instance by inflowing

Set-Place SQLSERVER:SQLDbServer23Default

You could then determine the available database structures by inflowing Get-ChildItem (or one of its aliases, such as ls or dir). To navigate logins, triggers, endpoints, databases, and any other structures, you set the place to the name of the related folder. For example, you could use Set-Place Databases and then enter Get-ChildItem to list available databases for the selected instance. Of course, if you know the full path you want to work with in the first place, you also can access it directly, as publicized in the following example:


Set-Place SQLSERVER:SQLDbServer23DefaultDatabasesOrderSystem

Here, you navigate to the structures for the OrderSystem database on DbServer23’s default instance. If you then want to determine what tables are available for this database, you could enter:


Get-ChildItem Tables

Or you could enter:


Set-place Tables
Get-ChildItem


To manage SQL Server 2012 from a computer that isn’t running SQL Server, you need to install the management tools. In the SQL Server Installation Center, select Installation, and then click the New Installation Or Add Features To An Existing Installation choice. When the wizard starts, follow the prompts. On the Feature Choice page, select the Management Tools—Basic choice to install Management Studio, SQLCMD, and the SQL Server provider for Windows PowerShell.


For diffident management via Windows PowerShell, you need to ensure that Windows Diffident Management (WinRM) and Windows PowerShell are both installed and made available by using the Add Features Wizard. You also need to make possible diffident orders on both your management computer and the server running SQL Server.

You can verify the availability of WinRM and configure Windows PowerShell for remoting by following these steps:

1. Click Initiation, All Programs, Accessories, and Windows PowerShell. Then initiation Windows PowerShell as an administrator by right-clicking the Windows PowerShell shortcut and selecting Run As Administrator.

2. The WinRM service is configured for manual startup by default. You
must change the startup type to Automatic and initiation the service on each computer you want to work with. At the PowerShell prompt, you can verify that the WinRM service is running by using the following command:

      get-service winrm


        0. f the service is stopped, enter the following command to initiation the service and configure it to initiation automatically in the future:

            set-service –name winrm –startuptype automatic –status running

        1. To configure Windows PowerShell for remoting, type the following command:

            Make possible-PSRemoting –force

You can make possible remoting only when your computer is connected to a domain or private network. If your computer is connected to a public network, you need to disconnect from the public network and connect to a domain or private network and then repeat this step. If one or more of your computer’s connections has the Public connection type but you are really connected to a domain or private network, you need to change the network connection type in the Network And Sharing Center and then repeat this step.

In many cases, you can work with diffident computers in other domains. Even if, if the diffident computer is not in a trusted domain, the diffident computer might not be able to authenticate your credentials. To make possible certification, you need to add the diffident computer to the list of trusted hosts for the local computer in WinRM. To do so, type the following:

winrm s winrm/config/client ‘@{TrustedHosts=”RemoteComputer”}’ where RemoteComputer is the name of the diffident computer, such as winrm s winrm/config/client ‘@{TrustedHosts=”DbServer23″}’


When you are working with computers in workgroups or homegroups, you must use HTTPS as the transport or add the diffident machine to the TrustedHosts configuration settings. If you cannot connect to a diffident host, you can verify that the service on the diffident host is running and is accepting requests by running the following command on the diffident host:


winrm quickconfig
Status   Name
------   ----
Running  WinRM
DisplayName
-----------
Windows Diffident Management


24 PART I Microsoft SQL Server 2012 Essentials


This command analyzes and configures the WinRM service. If the WinRM service is set up correctly, you see output similar to the following:


WinRM already is set up to receive requests on this machine.
WinRM already is set up for diffident management on this machine.

If the WinRM service is not set up correctly, you see errors and need to respond affirmatively to several prompts that allow you to configure diffident management automatically. When this process is complete, WinRM must be set up correctly. Don’t forget that you need to make possible diffident management on the database server as well as your management computer.


Reasons why you must trust ASPHostPortal.com

Every provider will tell you how they treat their support, uptime, expertise, guarantees, etc., are. Take a close look. What they’re really offering you is nothing close to what
ASPHostPortal does. You will be treated with respect and provided the courtesy and service you would expect from a world-class web hosting business.

You’ll have highly trained, skilled professional technical support people ready, willing, and wanting to help you 24 hours a day. Your web hosting account servers are monitored from three monitoring points, with two alert points, every minute, 24 hours a day, 7 days a week, 365 days a year. The followings are the list of other added- benefits you can find when hosting with us:

- DELL Hardware
Dell hardware is engineered to keep critical enterprise applications running around the clock with clustered solutions fully tested and certified by Dell and other leading operating system and application providers.
- Recovery Systems
Recovery becomes easy and seamless with our fully managed backup services. We monitor your server to ensure your data is properly backed up and recoverable so when the time comes, you can easily repair or recover your data.

- Control Panel
We provide one of the most comprehensive customer control panels available. Providing maximum control and ease of use, our Control Panel serves as the central management point for your ASPHostPortal account. You’ll use a flexible, powerful hosting control panel that will give you direct control over your web hosting account. Our control panel and systems configuration is fully automated and this means your settings are configured automatically and instantly.

- Excellent Expertise in Technology
The reason we can provide you with a great amount of power, flexibility, and simplicity at such a discounted price is due to incredible efficiencies within our business. We have not just been providing hosting for many clients for years, we have also been researching, developing, and innovating every aspect of our operations, systems, procedures, strategy, management, and teams. Our operations are based on a continual improvement program where we review thousands of systems, operational and management metrics in real-time, to fine-tune every aspect of our operation and activities. We continually train and retrain all people in our teams. We provide all people in our teams with the time, space, and inspiration to research, understand, and explore the Internet in search of greater knowledge. We do this while providing you with the best hosting services for the lowest possible price.

- Data Center

ASPHostPortal modular Tier-3 data center was specifically designed to be a world-class web hosting facility totally dedicated to uncompromised performance and security
- Monitoring Services
From the moment your server is connected to our network it is monitored for connectivity, disk, memory and CPU utilization – as well as hardware failures. Our engineers are alerted to potential issues before they become critical.

- Network
ASPHostPortal has architected its network like no other hosting company. Every facet of our network infrastructure scales to gigabit speeds with no single point of failure.

- Security
Network security and the security of your server are ASPHostPortal’s top priorities. Our security team is constantly monitoring the entire network for unusual or suspicious behavior so that when it is detected we can address the issue before our network or your server is affected.

- Support Services
Engineers staff our data center 24 hours a day, 7 days a week, 365 days a year to manage the network infrastructure and oversee top-of-the-line servers that host our clients’ critical sites and services.

 



SQL 2012 Hosting - ASPHostPortal :: Integration Services Catalog in SQL Server 2012

clock September 8, 2012 06:07 by author Jervis

Integration Services Catalog is a new feature in SQL Server 2012 which supports the centralization of storage of packages and configuration files. You can host only one catalog for one SQL Server Instance. When you deploy your project using project deployment model all project components stored in catalog. This post describes how to create a catalog and set the properties.



Catalog creation

1. In SQL Server Management Studio , right click the Integration Services Catalogs folder and Select Create Catalog.


2. In Create Catalog dialog box, Select Enable Automatic execution of Integration Services Stored Procedure.

3. Catalog database name can not be changed and it is set to default name SSISDB. Provide the password and click ok as shown below.



Integration services uses this password to encrypt sensitive data stored in catalog.


Catalog Properties

To set the properties , right click SSISDB and select properties and you will get the properties dialogue box as shown below



The default encryption algorithm is AES_256. Operations include activities such as project deployment, project validation and project execution. Integration Services stores this information in catalog. You can see the active operations in catalog by right clicking SSISDB database.

Project Versioning

Each time you re-deploy a project with the same name to same folder 10 versions are maintained in list.

-
Locate the project under SSISDB database, right click on it and select versions.
-
In the project versions dialogue box, select the version to restore and click restore button



click yes to confirm, and then click OK to close the message box.

 



Silverlight 5 Hosting - ASPHostPortal :: Telerik Rad HtmlPlaceHolder in Silverlight 5 Via WCF Service

clock September 7, 2012 09:08 by author Jervis

Today, in this article let's concentrate on another Silverlight application, whereby communicating with a WCF Service to perform some operation.

The Telerik Rad Controls for Silverlight can be found from
http://www.telerik.com/products/silverlight/overview.aspx.

What is RadHtmlPlaceHolder?


In simple terms "It is the special controls which enables to render external WebPages into Silverlight App".


Let's get this implemented practically for a better idea of this!!!


Step 1: The complete code of the IService1.cs looks like this:


using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;

namespace Wcf_RadPlaceHolder
{

     // NOTE: You can use the "Rename" command on the "Refactor" menu to change the interface name "IService1" in both code and config file together.
     [ServiceContract]
     public interface IService1
     {

          [OperationContract]
          string url(string a);
     }
}


Step 2: The complete code of the Service1.svc.cs looks like this:


using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;

namespace Wcf_RadPlaceHolder
{
     // NOTE: You can use the "Rename" command on the "Refactor" menu to change the class name "Service1" in code, svc and config file together.
     public class Service1 : IService1
     {
          public string url(string a)
          {
               return a;
          }
     }
}


Step 3: The complete code of the Web.Config looks like this
:

<?xml version="1.0"?>
<configuration>

   <system.web>
      <compilation debug="true" targetFramework="4.0" />
   </system.web>
   <system.serviceModel>
      <behaviors>
        <serviceBehaviors>
          <behavior>
             <!-- To avoid disclosing metadata information, set the value below to false and remove the metadata endpoint above before deployment -->
             <serviceMetadata httpGetEnabled="true"/>
             <!-- To receive exception details in faults for debugging purposes, set the value below to true. Set to false before deployment to avoid disclosing exception information -->
             <serviceDebug includeExceptionDetailInFaults="false"/>
          </behavior>
         </serviceBehaviors>
      </behaviors>
      <serviceHostingEnvironment multipleSiteBindingsEnabled="true" />
   </system.serviceModel>
   <system.webServer>
      <modules runAllManagedModulesForAllRequests="true"/>
    </system.webServer>

</configuration>


Step 4: The complete code of the Clientaccesspolicy.xml looks like this (to avoid a cross domain problem in Silverlight):


<?xml version="1.0" encoding="utf-8"?>
<access-policy>
   <cross-domain-access>
     <policy>
       <allow-from http-request-headers="SOAPAction">
         <domain uri="*"/>
       </allow-from>
       <grant-to>
         <resource path="/" include-subpaths="true"/>
       </grant-to>
      </policy>
   </cross-domain-access>
</access-policy>


Step 5: The complete code of the MainPage.xaml looks like this:


<UserControl x:Class="RadPlaceHolderApplication.MainPage"
              xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
              xmlns:x=http://schemas.microsoft.com/winfx/2006/xaml
              xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
              xmlns:mc=http://schemas.openxmlformats.org/markup-compatibility/2006
              xmlns:telerik=http://schemas.telerik.com/2008/xaml/presentation
              mc:Ignorable="d" d:DesignWidth="640" d:DesignHeight="480">
       <Grid x:Name="LayoutRoot">
            <telerik:RadHtmlPlaceholder x:Name="placeHolder1"
                                        ScrollViewer.HorizontalScrollBarVisibility="Visible"
                                        ScrollViewer.VerticalScrollBarVisibility="Visible"
                                        Margin="11,74,13,0" />
        <TextBlock Height="23"
                   HorizontalAlignment="Left"
                   Margin="34,16,0,0"
                   Name="textBlock1"
                   Text="Please Enter Web URL: "
                   FontFamily="Verdana"
                   FontSize="15"
                   VerticalAlignment="Top" />

        <TextBox Height="23"
                 HorizontalAlignment="Left"
                 Margin="219,16,0,0"
                 Name="textBox1"
                 VerticalAlignment="Top"
                 Width="212" />

        <Button Content="Go"
                Background="DeepSkyBlue"
                FontFamily="Verdana"
                FontSize="15"
                Height="23"
                HorizontalAlignment="Left"
                Margin="429,15,0,0"
                Name="button1"
                VerticalAlignment="Top"
                Width="75"
                Click="button1_Click"/>
    </Grid>
</UserControl>


Step 6: The complete code of the MainPage.xaml.cs looks like this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using Telerik.Windows.Controls;
using RadPlaceHolderApplication.ServiceReference1;

namespace RadPlaceHolderApplication
{
    public partial class MainPage : UserControl
    {
        public MainPage()
        {
            InitializeComponent();
        }

        private void url_Call(object sender, urlCompletedEventArgs e)
        {
            placeHolder1.SourceUrl = new Uri(e.Result.ToString(), UriKind.RelativeOrAbsolute);
        }

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            if (string.IsNullOrEmpty(textBox1.Text))
            {
                MessageBox.Show("Please Enter Some Values", "RadHtmlPlaceHolder- WCF", MessageBoxButton.OKCancel);
            }
            else
            {
                objClient.urlCompleted += new EventHandler<urlCompletedEventArgs>(url_Call);
                objClient.urlAsync(textBox1.Text);
            }

        }

        #region Instance Variables
        Service1Client objClient = new Service1Client();
        #endregion

    }
}

Step 7: The output of the application looks like this:



Step 8: The output of the Nothing Entered Application looks like this:




Step 9: The output of URL Entered Application looks like this:




Hope it helps!



About ASPHostPortal.com

We’re a company that works differently to most. Value is what we output and help our customers achieve, not how much money we put in the bank. It’s not because we are altruistic. It’s based on an even simpler principle. "Do good things, and good things will come to you".

Success for us is something that is continually experienced, not something that is reached. For us it is all about the experience – more than the journey. Life is a continual experience. We see the Internet as being an incredible amplifier to the experience of life for all of us. It can help humanity come together to explode in knowledge exploration and discussion. It is continual enlightenment of new ideas, experiences, and passions


Author Link


Corporate Address (Location)

ASPHostPortal
170 W 56th Street, Suite 121
New York, NY 10019
United States

Sign in