tag:blogger.com,1999:blog-278583752024-03-12T16:35:09.204-07:00Microsoft TechnologiesA blog for Microsoft Technologeis, Articles, Reviews,Best Practices, Upcoming Microsoft Technologies particulary related to Windows Server System and Azure and related Discussions. The purpose of this blog is to provide a resource to the quick information that Application Developers,Designer and Architects need on Microsoft's Technologies for developing and integrating these technologies.
"T H E K N O W L E D G E W H I C H I S C O N C E A L E A D I S L O S T"Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.comBlogger133125tag:blogger.com,1999:blog-27858375.post-20529528383877821962023-07-27T23:12:00.000-07:002023-07-27T23:12:10.217-07:00<p> </p><h1 id="whats-new-in-" style="background-color: white; box-sizing: inherit; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: clamp(1.875rem, 22.1053px + 1.64474vw, 2.5rem); line-height: 1.3; margin: -10px 0px 0px; outline-color: inherit; overflow-wrap: break-word; padding: 0px; word-break: break-word;">What's new in SQL Server 2022 (16.x)</h1><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">SQL Server 2022 (16.x) builds on previous releases to grow SQL Server as a platform that gives you choices of development languages, data types, on-premises or cloud environments, and operating systems.</span></div><div><span style="background-color: white;"><span style="color: #161616; font-family: Segoe UI, SegoeUI, Helvetica Neue, Helvetica, Arial, sans-serif;"><a href="https://learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2022?view=sql-server-ver16">https://learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2022?view=sql-server-ver16</a></span></span></div><div><span style="background-color: white;"><br /></span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: clamp(1.59375rem, 18.7895px + 1.39803vw, 2.125rem);">Feature highlights</span></div><div><h3 style="background-color: white; box-sizing: inherit; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: clamp(1.59375rem, 18.7895px + 1.39803vw, 2.125rem); line-height: 1.3; margin-inline-start: -1.875rem; margin: 32px 0px 12px; outline-color: inherit; padding-inline-start: 1.875rem; padding: 0px; text-align: left;"><span style="font-size: 14px;"><b>Administrative:</b></span></h3><h2 class="heading-anchor" id="analytics" style="background-color: white; box-sizing: inherit; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: clamp(1.59375rem, 18.7895px + 1.39803vw, 2.125rem); line-height: 1.3; margin-inline-start: -1.875rem; margin: 32px 0px 12px; outline-color: inherit; padding-inline-start: 1.875rem; padding: 0px;"><span style="font-size: 14px;"><b>Azure Synapse Link for SQL:</b> </span><span style="font-size: 14px;"> <span style="font-weight: normal;">near </span></span><span style="font-size: 14px; font-weight: normal;">real-time analytics With integration between SQL Server 2022 (16.x) and Azure Synapse Analytics dedicated SQL pools, Azure Synapse Link for SQL enables you to run analytics scenarios on your operational data with minimum impact on source databases.</span></h2></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><b>Object storage integration: </b></span><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"> introduces new object storage integration with S3-compatible object storage, in addition to Azure Storage. The first is </span><a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url-s3-compatible-object-storage?view=sql-server-ver16" style="background-color: white; box-sizing: inherit; cursor: pointer; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">backup to URL</a><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"> and the second is Data Lake Virtualization.</span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><br /></span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><b>Link to Azure SQL Managed Instance: </b></span><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;">Connect your SQL Server instance to Azure SQL Managed Instance.</span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><br /></span></div><div></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><b>Contained availability group: </b></span><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;">Create an Always On availability group that:</span></div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"> - Manages its own metadata objects (users, logins, permissions, SQL Agent jobs etc.) at the availability <span> </span><span> </span><span> </span><span> </span><span> </span>group level in addition to the instance level.</span><br style="background-color: white; box-sizing: inherit; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; outline-color: inherit;" /><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"> - Includes specialized contained system databases within the availability group.</span><div><span style="color: #161616; font-family: Segoe UI, SegoeUI, Helvetica Neue, Helvetica, Arial, sans-serif;"><span style="font-size: 14px;"><br /></span></span><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><b>Distributed availability group: </b></span><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;">- Now using multiple TCP connections for better network bandwidth utilization across a remote link with long tcp latencies.</span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><br /></span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><b>Improved backup metadata:</b> </span><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;">system table returns last valid restore time.</span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><b><br /></b></span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><b>Azure Active Directory authentication:</b> </span><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;">Use </span><a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-overview?view=sql-server-ver16" style="background-color: white; box-sizing: inherit; cursor: pointer; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">Azure Active Directory (Azure AD) authentication</a><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"> to connect to SQL Server.</span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><br /></span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><b>Always encrypted with secure enclaves:</b> </span><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;">Support for JOIN, GROUP BY, and ORDER BY, and for text columns using UTF-8 collations in confidential queries using enclaves.</span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><br /></span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><b>Query Store on secondary replicas: </b></span><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;">Query Store on secondary replicas enables the same Query Store functionality on secondary replica workloads that is available for primary replicas.</span><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"> </span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><br /></span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><b>Manage Azure extension for SQL Server:</b></span><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;">Use SQL Server Configuration Manager to manage Azure extension for SQL Server service.</span><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"> </span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><br /></span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><b>Shrink database WAIT_AT_LOW_PRIORITY:</b></span><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;">In previous versions, shrinking databases and database files to reclaim space often leads to concurrency issues. SQL Server 2022 adds WAIT_AT_LOW_PRIORITY as an additional option for shrink operations (DBCC SHRINKDATABASE and DBCC SHRINKFILE). </span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;">When you specify WAIT_AT_LOW_PRIORITY, new queries requiring Sch-S or Sch-M locks aren't blocked by the waiting shrink operation, until the shrink operation stops waiting and begins executing</span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><br /></span></div><div><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><b>Developers:</b></span></div><div><table aria-label="Table 8" class="table table-sm" style="background-color: white; border-collapse: collapse; border-spacing: 0px; border: 1px solid var(--theme-table-border-dark); box-sizing: inherit; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 0.875rem; margin-top: 1rem; outline-color: inherit; table-layout: auto; width: 860px;"><tbody style="box-sizing: inherit; outline-color: inherit;"><tr style="box-sizing: inherit; outline-color: inherit;"><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">CREATE INDEX</td><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;"><a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/statements/create-index-transact-sql?view=sql-server-ver16#wait-at-low-priority" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">WAIT_AT_LOW_PRIORITY</a> with online index operations clause added.<br /></td></tr></tbody></table><table aria-label="Table 8" class="table table-sm" style="background-color: white; border-collapse: collapse; border-spacing: 0px; border: 1px solid var(--theme-table-border-dark); box-sizing: inherit; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 0.875rem; margin-top: 1rem; outline-color: inherit; table-layout: auto; width: 860px;"><tbody style="box-sizing: inherit; outline-color: inherit;"><tr style="box-sizing: inherit; outline-color: inherit;"><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">SELECT ... WINDOW clause</td><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">Determines the partitioning and ordering of a rowset before the window function, which uses the window in OVER clause is applied. See <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/queries/select-window-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">SELECT - WINDOW</a>.<br /></td></tr></tbody></table><table aria-label="Table 8" class="table table-sm" style="background-color: white; border-collapse: collapse; border-spacing: 0px; border: 1px solid var(--theme-table-border-dark); box-sizing: inherit; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 0.875rem; margin-top: 1rem; outline-color: inherit; table-layout: auto; width: 860px;"><tbody style="box-sizing: inherit; outline-color: inherit;"><tr style="box-sizing: inherit; outline-color: inherit;"><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">IS [NOT] DISTINCT FROM</td><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">Determines whether two expressions when compared with each other evaluate to NULL, and guarantees a true or false value as the result. For more information, see <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/queries/is-distinct-from-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">IS [NOT] DISTINCT FROM (Transact-SQL)</a>.</td></tr><tr style="box-sizing: inherit; outline-color: inherit;"><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">Time series functions</td><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">You can store and analyze data that changes over time, using time-windowing, aggregation, and filtering capabilities.<br style="box-sizing: inherit; outline-color: inherit;" />- <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/date-bucket-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">DATE_BUCKET ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/generate-series-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">GENERATE_SERIES ()</a><br style="box-sizing: inherit; outline-color: inherit;" /><br style="box-sizing: inherit; outline-color: inherit;" />The following adds support to IGNORE NULLS and RESPECT NULLS:<br style="box-sizing: inherit; outline-color: inherit;" />- <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/first-value-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">FIRST_VALUE ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/last-value-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">LAST_VALUE ()</a></td></tr><tr style="box-sizing: inherit; outline-color: inherit;"><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">JSON functions</td><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">- <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/isjson-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">ISJSON ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/json-path-exists-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">JSON_PATH_EXISTS ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/json-object-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">JSON_OBJECT ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/json-array-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">JSON_ARRAY ()</a></td></tr><tr style="box-sizing: inherit; outline-color: inherit;"><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">Aggregate functions</td><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">- <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/approx-percentile-cont-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">APPROX_PERCENTILE_CONT ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/approx-percentile-disc-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">APPROX_PERCENTILE_DISC ()</a></td></tr><tr style="box-sizing: inherit; outline-color: inherit;"><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">T-SQL functions</td><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">- <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/logical-functions-greatest-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">GREATEST ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/logical-functions-least-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">LEAST ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">STRING_SPLIT ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/datetrunc-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">DATETRUNC ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/ltrim-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">LTRIM ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/rtrim-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">RTRIM ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/trim-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">TRIM ()</a></td></tr><tr style="box-sizing: inherit; outline-color: inherit;"><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;"><a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/bit-manipulation-functions-overview?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">Bit manipulation functions</a></td><td style="border-block-start: 1px solid var(--theme-table-border-dark); box-sizing: inherit; line-height: 1.5; outline-color: inherit; overflow-wrap: break-word; padding: 0.5rem; vertical-align: top;">- <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/left-shift-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">LEFT_SHIFT ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/right-shift-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">RIGHT_SHIFT ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/bit-count-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">BIT_COUNT ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/get-bit-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">GET_BIT ()</a> - <a data-linktype="relative-path" href="https://learn.microsoft.com/en-us/sql/t-sql/functions/set-bit-transact-sql?view=sql-server-ver16" style="background-color: rgba(0, 0, 0, 0); box-sizing: inherit; cursor: pointer; outline-color: inherit; outline-style: initial; outline-width: 0px; overflow-wrap: break-word; text-decoration-line: none;">SET_BIT ()</a></td></tr></tbody></table></div><div></div></div>Shamas DBAhttp://www.blogger.com/profile/01894071527133572968noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-45794060707504103102018-10-03T20:08:00.002-07:002018-10-03T20:08:28.759-07:00MS Ignite 2018 wrap up<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;">Microsoft has started rolling updates to all platforms after wrapping up Ignite in Orlando last week. Updates from Microsoft Ignite 2018 and links to all the session videos and slide decks. There were announcements across all the Microsoft platforms, but some stood out more than others. Check recording for session and presentation at link below</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="background-color: white; color: #343a41; font-family: "Segoe UI WestEuropean", "Segoe UI", "Segoe UI Emoji", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px;"><br /></span></div>
<div class="MsoNormal">
<span style="background-color: white; color: #343a41; font-family: "Segoe UI WestEuropean", "Segoe UI", "Segoe UI Emoji", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;"><b>MS Ignite 2018 Session</b> Recording and Presentations</span></div>
<div class="MsoNormal">
<a class="linkified" href="https://myignite.techcommunity.microsoft.com/sessions" rel="nofollow noreferrer" style="background-color: white; border: 0px; box-sizing: inherit; color: #386cbb; font-family: "Segoe UI WestEuropean", "Segoe UI", "Segoe UI Emoji", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration-line: none; vertical-align: baseline;" target="_blank" title="https://myignite.techcommunity.microsoft.com/sessions">https://myignite.techcommunity.microsoft.com/sessions</a><span style="background-color: white; color: #343a41; font-family: "Segoe UI WestEuropean", "Segoe UI", "Segoe UI Emoji", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px;"> </span></div>
<div class="MsoNormal">
<span style="background-color: white; color: #343a41; font-family: "Segoe UI WestEuropean", "Segoe UI", "Segoe UI Emoji", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;"><b>Open Data Initiative:</b> Microsoft, Adobe and SAP entered into an open data partnership at Ignite. Watch Staya's keynote for details </span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;">https://www.youtube.com/watch?v=48Kjm4brpZo&feature=youtu.be </span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;"><b>Power Platform: </b>Big focus on PowerApps with supporting technologies Flow and PowerBI. Recording and slides available for 50+ sessions at the link below.</span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;"><b>MS Teams</b> as a fastest growing product in Microsoft history, many recorded videos and presentation available to explain these new features.</span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;"><b>SharePoint</b> also saw its share of announcements including the availability of hub sites which will allow you to easily pull together – with consistent navigation – all the SharePoint Team Sites you have in Office 365.</span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;">New updates to <b>SharePoint hub </b>sites will support flexible information architecture approach for the organisation. Content and Collaboration keynote: by Jeff Tepper</span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;"><b>Azure Digital Twins</b> Microsoft has announced the ability to create digital twins. A digital twin is a virtual representation of physical systems which can then take in new information or datasets to test and probe the system's capabilities.</span></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;">and a lot more….</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: Segoe UI, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<br /></div>
Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-87178574353919676272018-10-03T07:48:00.003-07:002018-10-03T07:59:34.678-07:00SharePoint & Power Apps - Few Ideas/Suggestions for product team<div class="MsoNormal" style="background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 0.0001pt;">
<span style="color: #002060;">I have noticed a few trends/things in the last couple of years and this came as a theme in recent Ignite conference as well so I thought I should share key pointers with you. Big focus on Teams and Comms site which is great but SharePoint is much bigger than this and I haven't heard much on broader topics especially following topics which deserve some attention. </span></div>
<div class="MsoNormal" style="background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 0.0001pt;">
<span style="color: #002060;"><b>SharePoint</b></span></div>
<ul style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; margin-bottom: 0cm;" type="disc">
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;">Many organizations/Govt are using SharePoint as Document and Record management system and it is a platform of choice for an organization who wants to move from file share or other DMS/Record management system to SharePoint but not much guidance available from Microsoft in modern templates to support these things (except conventional way). I have discussed this with few folks from MSFT IT Services and SharePoint product team but no clear direction available from them. </li>
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;">Consistent user experience in Onedrive and new features are great but the story is getting convoluted for OneDrive V/S SharePoint document library especially on Mobile Devices where users have (One Drive V/S SharePoint App). Many whitepaper and options available by partners on when to use what but a clear message from the product team in this regard will be helpful in shaping up better solutions I and improve adoption. </li>
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;">Microsoft best practice suggests using metadata and content types to structure content in document libraries but site created with MS Teams use a folder based structure which is confusing for users. </li>
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;">If an organization is using Teams and SharePoint based intranet and DMS how they should have a well-connected experience? Having a tab for the site inside Team is usually not good enough. I think having a flow connector which can add a newly created site under (teams) to a hub site could be one way to integrate that experience. </li>
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;">The idea of Hub site is great but organizations who have recently implemented intranet structure based on subsite structure, Microsoft should provide some guidance and roadmap for transition to new constructs. </li>
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;">Not much clarity or direction available from Microsoft for public-facing portals after this feature is deprecated in O365, partners like site core and other have a solution in this area but will be good to see Microsoft offering in this space.</li>
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;">Search is a big thing for the end user and no doubt this has improved a lot in the last couple of years but many people in community/groups are not much aware of configurations and options available in SharePoint search beyond configuring few basic settings and not </li>
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;">As much as I love SPFx and flexibility and power it offers for techs but I think from an end-user perspective they really don't care much if a yammer web part is loaded using a traditional approach or using the modern web part and same goes on for other constructs so a bit more </li>
</ul>
<div class="MsoNormal" style="background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="background-clip: initial; background-color: white; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 0.0001pt;">
<b><span style="color: #002060;">PowerApps:</span></b><span style="color: #002060;"></span></div>
<ul style="background-color: white; color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: small; margin-bottom: 0cm;" type="disc">
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;">Doesn't offer responsive experience, it has to be built either for mobile or tablet view which is not great. </li>
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;">The story for model-driven V/S Canvas app with multiple types of licensing and inconsistent experience is confusing for the user as canvas app run on PowerApp in device and model-driven runs on CRM app and many other differences. </li>
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;">Technically model driven is a light touch version of CRM so Microsoft should consider a new type of D365 license to make it easier for them to understand and use it. </li>
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;">Access for users outside the organization (<wbr></wbr>users who don't have an AD account) is limiting factor and limit many scenarios for contractors/field related staff. Microsoft can consider perhaps something similar to CRM portal licenses for users outside the organization or have at least anonymous access with a fixed fee paid by an organization who host that app. </li>
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;"> Recent whitepaper and updates are good about governance and analytics but still much opportunity available to handle dev ops for power platform. </li>
<li class="MsoNormal" style="background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #002060; font-family: Calibri, sans-serif; font-size: 11pt; line-height: normal; margin: 0cm 0cm 8pt;">Currently, available templates/examples are good but it will be good if these templates get updated with some more business savvy apps and perhaps an area can be created for allowing partners to publish apps and Microsoft can approve it before they are added to the gallery.</li>
</ul>
Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-24326578377080654762017-05-25T03:06:00.003-07:002017-05-25T03:08:17.428-07:00SQL Server on Linux step 3: Linux (Ubuntu ) Installing SQL SERVER vNext <div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span style="background: white; color: #222222;">In my previous post we learn how to install Linux through Oracle Vitual box that you can found from following link</span></div>
<div class="MsoNormal">
<span style="background: white; color: #222222;"><a href="http://shamas-saeed.blogspot.com/2017/05/sql-server-on-linux-step-2-linux-ubuntu.html" target="_blank">Sql-server-on-linux-step-2-linux-ubuntu.html</a></span></div>
<div class="MsoNormal">
<span style="background: white; color: #222222;"><br /></span></div>
<div class="MsoNormal">
<span style="background: white; color: #222222;">After finishing your Ubuntu installation, you are ready to install SQL Server. You can install it through Ubuntu or your host windows using command line. Installing from Windows you need to install putty easily available on internet. Install it and connect it using Network IP and run all steps mentioned below. </span></div>
<div class="MsoNormal">
<span style="background: white; color: #222222;">I am installing it through Ubuntu plate form and following are the steps for that<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="background: white; color: #222222;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #222222; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">1-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span></span><span style="background: white; color: #222222;">Execute “sudo apt-get update”<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #222222; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">2-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span></span><span style="background: white; color: #222222;">Execute “sudo apt-get upgrade” is an optional step<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-og83805qq3g/WSaLh6EeHkI/AAAAAAAAEmM/_hfb9daPVt8k18y_kh9b-QWmu0pyTk5EQCLcB/s1600/Linux-SQLSeverInstallation-1.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="552" data-original-width="872" height="252" src="https://3.bp.blogspot.com/-og83805qq3g/WSaLh6EeHkI/AAAAAAAAEmM/_hfb9daPVt8k18y_kh9b-QWmu0pyTk5EQCLcB/s400/Linux-SQLSeverInstallation-1.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="color: #222222; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">3-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span></span><span style="background: white; color: #222222;">Run curl command to import GPG key. GPG keys also provide cryptographic privacy and authentication. If curl command is not installed on this machine so we need to run the suggested command to install the curl command first.</span><o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-qjAb7o20WeA/WSaLjgugF2I/AAAAAAAAEm4/bhghPHEkgwUy-56-gfoyvfX6B7EZBC0PwCEw/s1600/Linux-SQLSeverInstallation-2.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="281" data-original-width="869" height="128" src="https://1.bp.blogspot.com/-qjAb7o20WeA/WSaLjgugF2I/AAAAAAAAEm4/bhghPHEkgwUy-56-gfoyvfX6B7EZBC0PwCEw/s400/Linux-SQLSeverInstallation-2.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
4-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>After successful installation of curl, we can import key using following command and add it using sudo command.<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast">
“curl <a href="https://packages.microsoft.com/key/microsoft.asc">https://packages.microsoft.com/key/microsoft.asc</a> | sudo apt-key add –“<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-OGInj-2ujKM/WSaLkuliJGI/AAAAAAAAEnI/rswuGJiQ_iELIEazEiOsLqjDeJZ7Xlg5wCEw/s1600/Linux-SQLSeverInstallation-3.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="437" data-original-width="869" height="200" src="https://2.bp.blogspot.com/-OGInj-2ujKM/WSaLkuliJGI/AAAAAAAAEnI/rswuGJiQ_iELIEazEiOsLqjDeJZ7Xlg5wCEw/s400/Linux-SQLSeverInstallation-3.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
5-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Due to some network and internet problem I was unable to register key directly from Microsoft site. So if key download fails download key from mentioned path. <a href="https://packages.microsoft.com/key/microsoft.asc">https://packages.microsoft.com/key/microsoft.asc</a> you can find it in downloads, Open the file, Save it as .asc file and open it in terminal<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-EJ8Qx9QEBBs/WSaLkqTSyYI/AAAAAAAAEnM/Xsf3YqLS1Pw6d3NdKfj62d6swjM0iaHWQCEw/s1600/Linux-SQLSeverInstallation-4.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="507" data-original-width="811" height="250" src="https://1.bp.blogspot.com/-EJ8Qx9QEBBs/WSaLkqTSyYI/AAAAAAAAEnM/Xsf3YqLS1Pw6d3NdKfj62d6swjM0iaHWQCEw/s400/Linux-SQLSeverInstallation-4.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
6-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>From the terminal windows register key from the following command<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast">
“ sudo apt-key add microsoft.asc”<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-ToYImgrPYb8/WSaLk__0f_I/AAAAAAAAEnQ/0hFpk-6qec4E-LEJYC1wb1SDed48Cp76ACEw/s1600/Linux-SQLSeverInstallation-5.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="81" data-original-width="812" height="39" src="https://1.bp.blogspot.com/-ToYImgrPYb8/WSaLk__0f_I/AAAAAAAAEnQ/0hFpk-6qec4E-LEJYC1wb1SDed48Cp76ACEw/s400/Linux-SQLSeverInstallation-5.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
7-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>After successfully registering GPG key download mssql server from following path.<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast">
“curl <a href="https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list">https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list</a> | sudo tee /etc/apt/sources.list.d/mssql-server.list”<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-R-a_5ERZ34I/WSaLlKkm-sI/AAAAAAAAEnk/83aZILb1t70amY9ETXaJd-2RwzWkFVargCEw/s1600/Linux-SQLSeverInstallation-6.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="89" data-original-width="812" height="43" src="https://1.bp.blogspot.com/-R-a_5ERZ34I/WSaLlKkm-sI/AAAAAAAAEnk/83aZILb1t70amY9ETXaJd-2RwzWkFVargCEw/s400/Linux-SQLSeverInstallation-6.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
8-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>You can check the folder and rights to the downloaded file by executing ls -lrt<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast">
“ls –lrt /etc/apt/sources.list.d”<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-wmMMWEECyJ4/WSaLlEiQ7vI/AAAAAAAAEnk/A5V6nanGx5Mm76r_rQxwXmO8y-_q07OVgCEw/s1600/Linux-SQLSeverInstallation-7.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="119" data-original-width="813" height="57" src="https://2.bp.blogspot.com/-wmMMWEECyJ4/WSaLlEiQ7vI/AAAAAAAAEnk/A5V6nanGx5Mm76r_rQxwXmO8y-_q07OVgCEw/s400/Linux-SQLSeverInstallation-7.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
9-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>After executing all run “sudo apt-get update” before installing SQL Server.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-zFxJsf771Do/WSaLlqO2CQI/AAAAAAAAEnk/plLLekwkVzAjF32bA0iAh9ixi0lBavtjgCEw/s1600/Linux-SQLSeverInstallation-8.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="193" data-original-width="811" height="95" src="https://1.bp.blogspot.com/-zFxJsf771Do/WSaLlqO2CQI/AAAAAAAAEnk/plLLekwkVzAjF32bA0iAh9ixi0lBavtjgCEw/s400/Linux-SQLSeverInstallation-8.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
10-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Now you are ready to install SQL Server now. Start SQL Server installation using following command.<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast">
“sudo apt-get install –y mssql-server”<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-npBkfVZ8vwM/WSaLlptr45I/AAAAAAAAEnk/3yHM6TO8_zAwnHZ8cEkaTllZyIaRXvtJQCEw/s1600/Linux-SQLSeverInstallation-9.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="253" data-original-width="809" height="125" src="https://4.bp.blogspot.com/-npBkfVZ8vwM/WSaLlptr45I/AAAAAAAAEnk/3yHM6TO8_zAwnHZ8cEkaTllZyIaRXvtJQCEw/s400/Linux-SQLSeverInstallation-9.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
11-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Installation will continue as we can see installation percentage. It will take some time depending on internet connection. Installation will complete with the config setup message.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-uTGUjmm8ZuM/WSaLiE1qwjI/AAAAAAAAEnk/7FXZBKpHwTsN_JqhTUpQVe2IWuSLKloewCEw/s1600/Linux-SQLSeverInstallation-10.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="553" data-original-width="689" height="320" src="https://4.bp.blogspot.com/-uTGUjmm8ZuM/WSaLiE1qwjI/AAAAAAAAEnk/7FXZBKpHwTsN_JqhTUpQVe2IWuSLKloewCEw/s400/Linux-SQLSeverInstallation-10.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
12-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>As mentioned in the message, To complete SQL Server setup run following command<o:p></o:p></div>
<div class="MsoNormal" style="margin-left: .25in;">
“sudo opt/mssql/bin/mssql-conf setup”<o:p></o:p></div>
<div class="MsoNormal" style="margin-left: .25in;">
It will prompt license agreement message.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-B_BGQEWfQpM/WSaLhzYGUoI/AAAAAAAAEnk/6vEqhnQIFnwgUSydd3re3VjDNcwIjJD5ACEw/s1600/Linux-SQLSeverInstallation-11.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="208" data-original-width="691" height="120" src="https://4.bp.blogspot.com/-B_BGQEWfQpM/WSaLhzYGUoI/AAAAAAAAEnk/6vEqhnQIFnwgUSydd3re3VjDNcwIjJD5ACEw/s400/Linux-SQLSeverInstallation-11.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
13-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>After completing above step Microsoft will ask for administrator password and will start SQL Server. During my installation I set password as “vSqlserver2017”. In the end you will get Setup completed successfully message.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-9uIbJkQJASw/WSaLiRjtHkI/AAAAAAAAEnk/3JMruj2VRfwMcF7A7hi_qH1IpQ_ozAF_ACEw/s1600/Linux-SQLSeverInstallation-12.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="107" data-original-width="809" height="52" src="https://1.bp.blogspot.com/-9uIbJkQJASw/WSaLiRjtHkI/AAAAAAAAEnk/3JMruj2VRfwMcF7A7hi_qH1IpQ_ozAF_ACEw/s400/Linux-SQLSeverInstallation-12.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
14-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>You have successfully completed MSSQL Server installation. On restarting you linux server, you can check SQL Server status by executing following command.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-F6hljXWck6U/WSaLiq2LjiI/AAAAAAAAEnk/8w_Y87uARls4TPnFAV3T79zjRLjfEnv6wCEw/s1600/Linux-SQLSeverInstallation-13.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="343" data-original-width="810" height="168" src="https://4.bp.blogspot.com/-F6hljXWck6U/WSaLiq2LjiI/AAAAAAAAEnk/8w_Y87uARls4TPnFAV3T79zjRLjfEnv6wCEw/s400/Linux-SQLSeverInstallation-13.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
15-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>We need to Install SQL Server tools by using following command. Using wget we need to download and copy prod.list on sources.list.d path.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<img border="0" data-original-height="69" data-original-width="806" height="33" src="https://4.bp.blogspot.com/-LNZF8RYYtHA/WSaLimiopVI/AAAAAAAAEnk/_tbdEIghhfw8nMK0O9-y9tw8raq9sSVIwCEw/s400/Linux-SQLSeverInstallation-14.GIF" width="400" /></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
16-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>On getting permission message I am unable to copy on given path. I used same path as I did to register key for SQL Server.<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
17-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>I downloaded prod.list file and copy it to sources.list.d<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/--TQlu5lcqLM/WSaLi5jGt1I/AAAAAAAAEnk/YDqfJlSLta4sAKHxuNEwVhYJPVcjc7k-wCEw/s1600/Linux-SQLSeverInstallation-15.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="326" data-original-width="661" height="196" src="https://2.bp.blogspot.com/--TQlu5lcqLM/WSaLi5jGt1I/AAAAAAAAEnk/YDqfJlSLta4sAKHxuNEwVhYJPVcjc7k-wCEw/s400/Linux-SQLSeverInstallation-15.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
18-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Opening root as file manager by entering following command<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast">
“sudo nautilus”<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-3BF54MplSTI/WSaLjBPckOI/AAAAAAAAEnk/MQrRpmQIIY8QJR6q6Mhl2w2JALvlpHs-gCEw/s1600/Linux-SQLSeverInstallation-16.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="85" data-original-width="634" height="52" src="https://2.bp.blogspot.com/-3BF54MplSTI/WSaLjBPckOI/AAAAAAAAEnk/MQrRpmQIIY8QJR6q6Mhl2w2JALvlpHs-gCEw/s400/Linux-SQLSeverInstallation-16.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
19-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Following root path will open<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-ZWbbfYajYxY/WSaLjHxodRI/AAAAAAAAEnk/4oVPQE4IovEnjO2qMj_34pucG7uY7PxTACEw/s1600/Linux-SQLSeverInstallation-17.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="200" data-original-width="740" height="107" src="https://3.bp.blogspot.com/-ZWbbfYajYxY/WSaLjHxodRI/AAAAAAAAEnk/4oVPQE4IovEnjO2qMj_34pucG7uY7PxTACEw/s400/Linux-SQLSeverInstallation-17.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
20-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Reaching at sources.list.d path copy<span style="font-family: "wingdings"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> paste prod.list as follows<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-tfPRZQ5XEoo/WSaLjksSFqI/AAAAAAAAEnk/cWQZaQOTfik2pGNg_IA49e60A9kivndgACEw/s1600/Linux-SQLSeverInstallation-18.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="298" data-original-width="460" height="258" src="https://1.bp.blogspot.com/-tfPRZQ5XEoo/WSaLjksSFqI/AAAAAAAAEnk/cWQZaQOTfik2pGNg_IA49e60A9kivndgACEw/s400/Linux-SQLSeverInstallation-18.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
21-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>It is recommended to run get-update command before and after any installation and then start installing tools by following command<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast">
“sudo apt-get install mssql-tools –y”<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/--PYWOzWiJzw/WSaLjtsKmRI/AAAAAAAAEnk/2jrhflS9akwR4e6tLLslWmaotTWDXkASgCEw/s1600/Linux-SQLSeverInstallation-19.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="535" data-original-width="839" height="255" src="https://2.bp.blogspot.com/--PYWOzWiJzw/WSaLjtsKmRI/AAAAAAAAEnk/2jrhflS9akwR4e6tLLslWmaotTWDXkASgCEw/s400/Linux-SQLSeverInstallation-19.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
22-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Installation will start once all required data will be downloaded.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<img border="0" data-original-height="515" data-original-width="868" height="236" src="https://4.bp.blogspot.com/-c0wSCtBf5Bs/WSaLkFTewwI/AAAAAAAAEnk/nDt1KFcpjYk_Hf3eSesN7sAwpwPpsna5wCEw/s400/Linux-SQLSeverInstallation-20.GIF" width="400" /></div>
<br />
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
After completing installation we are going to perform basic SQL Server queries using linux Ubuntu command prompt.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
23-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>SQL Server is active and running. You can connect SQL Server using following command “sqlcmd –S (Server name) –U (username) –P (Password)”<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-_kMlLJTbhm0/WSaLkF5B5KI/AAAAAAAAEnk/bgCY2GwTW0okzPCX7SAxYZZ--Rc4flS-gCEw/s1600/Linux-SQLSeverInstallation-21.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="127" data-original-width="872" height="57" src="https://2.bp.blogspot.com/-_kMlLJTbhm0/WSaLkF5B5KI/AAAAAAAAEnk/bgCY2GwTW0okzPCX7SAxYZZ--Rc4flS-gCEw/s400/Linux-SQLSeverInstallation-21.GIF" width="400" /></a></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
24-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Performing basic SQL Server testing through command prompt.<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 1in; text-indent: -0.25in;">
a.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Create database<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 1in; text-indent: -0.25in;">
b.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Create Table<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 1in; text-indent: -0.25in;">
c.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Insert data<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: 1in; text-indent: -0.25in;">
d.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Query data<o:p></o:p></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-iG5d4S8EErk/WSaLkV8xxFI/AAAAAAAAEnk/0Pe8AKU-pNIdtI0MUCiQCGt7aIO-ghKqwCEw/s1600/Linux-SQLSeverInstallation-22.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="487" data-original-width="871" height="222" src="https://1.bp.blogspot.com/-iG5d4S8EErk/WSaLkV8xxFI/AAAAAAAAEnk/0Pe8AKU-pNIdtI0MUCiQCGt7aIO-ghKqwCEw/s400/Linux-SQLSeverInstallation-22.GIF" width="400" /></a></div>
<div>
<br /></div>
</div>
Shamas DBAhttp://www.blogger.com/profile/01894071527133572968noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-17385582702341331412017-05-15T04:17:00.003-07:002017-05-15T04:17:41.644-07:00SQL Server on Linux step 2: Linux (Ubuntu ) installation using Virtual Box VM<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span style="font-family: "calibri" , "sans-serif"; font-size: 11pt; line-height: 16.8667px;">In my previous post we learn how we can get free Virtual machine to install another operating system on our existing windows. We downloaded Oracle virtual Box Virtual Machine and decided to install Linux plate form on it. We downloaded Linux flavor Ubuntu 17.10 64 bit Server .iso image from given link and now we will learn how to install Ubuntu on Virtual Box VM. You can find previous post under following link.</span></div>
<div class="MsoNormal">
<span style="font-family: "calibri" , "sans-serif"; font-size: 11pt; line-height: 16.8667px;"><br /></span></div>
<div class="MsoNormal">
<a href="http://shamas-saeed.blogspot.com/2017/05/sql-server-on-linux-step-1-installing.html" target="_blank">Installing Oracle Virtual Box on Microsoft Windows</a></div>
<div class="MsoNormal">
<span style="font-size: 14.6667px; line-height: 16.8667px;"><span style="font-family: "calibri" , sans-serif;"><br /></span></span></div>
<div class="MsoNormal">
<span style="font-family: "calibri" , "sans-serif"; font-size: 11pt; line-height: 16.8667px;"><br /></span></div>
<div class="MsoNormal">
<b>Linux Ubuntu 17.10 installation on Virtual Box VM<o:p></o:p></b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-Mz7_7MmR39s/WRmM1zF8UBI/AAAAAAAAEk0/ZdzaH8_MDVgkXbr9A5qF3SenZER9JovuwCEw/s1600/Ubuntu1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://4.bp.blogspot.com/-Mz7_7MmR39s/WRmM1zF8UBI/AAAAAAAAEk0/ZdzaH8_MDVgkXbr9A5qF3SenZER9JovuwCEw/s320/Ubuntu1.png" width="287" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoNormal">
<b><br /></b></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
1-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>From your VM box right click -> on your VM and press “Start” or “Normal Start”.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-LGzr7wgGpJQ/WRmM3R6Jk_I/AAAAAAAAElQ/FeunWzoryQUpFrWVmw6-16-Y5GIFm55TwCEw/s1600/Ubuntu2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="127" src="https://3.bp.blogspot.com/-LGzr7wgGpJQ/WRmM3R6Jk_I/AAAAAAAAElQ/FeunWzoryQUpFrWVmw6-16-Y5GIFm55TwCEw/s320/Ubuntu2.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
2-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>This will start Ubuntu setup. Load downloaded .iso file and press Start<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-P0lfB9CI0Pk/WRmM3trvbhI/AAAAAAAAElY/2qujIaAFS00DX8RXzyS1KQUsrBXYzi7UQCEw/s1600/Ubuntu3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="272" src="https://1.bp.blogspot.com/-P0lfB9CI0Pk/WRmM3trvbhI/AAAAAAAAElY/2qujIaAFS00DX8RXzyS1KQUsrBXYzi7UQCEw/s320/Ubuntu3.png" width="320" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
3-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Setup will load Ubuntu from .iso file. Press Install ubuntu<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-T3ie5O5J1xI/WRmM4LCbl6I/AAAAAAAAElc/DY7WGeHB3X0_ergHJ0F-GSEaKycZC3siwCEw/s1600/Ubuntu4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="224" src="https://4.bp.blogspot.com/-T3ie5O5J1xI/WRmM4LCbl6I/AAAAAAAAElc/DY7WGeHB3X0_ergHJ0F-GSEaKycZC3siwCEw/s320/Ubuntu4.png" width="320" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
4-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>For installation of new operating system, either select erase and install Ubuntu or manual setup. As I am installing on a separate partitioned drive, I select Erase disk and install Ubuntu.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-H10bu8cPrKw/WRmM4CJJdiI/AAAAAAAAElg/ML5WF8NhBSsoqXeEpL72swe1w-1JIWrpACEw/s1600/Ubuntu5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="241" src="https://3.bp.blogspot.com/-H10bu8cPrKw/WRmM4CJJdiI/AAAAAAAAElg/ML5WF8NhBSsoqXeEpL72swe1w-1JIWrpACEw/s320/Ubuntu5.png" width="320" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
5-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>You will get partition formation message. Press Continue<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-JoKslebmV_A/WRmM4PTCxmI/AAAAAAAAElk/hOHUf2bpmeQbOI4Q5rBVK59DtO8Iy_mGgCEw/s1600/Ubuntu6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="238" src="https://3.bp.blogspot.com/-JoKslebmV_A/WRmM4PTCxmI/AAAAAAAAElk/hOHUf2bpmeQbOI4Q5rBVK59DtO8Iy_mGgCEw/s320/Ubuntu6.png" width="320" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
6-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>You need to select time zone settings<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-3ZyMUjU2Lgw/WRmM4poQSbI/AAAAAAAAElo/tYI-ho93ZwscahgDlbZkzEd_n1fFLFAkwCEw/s1600/Ubuntu7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="238" src="https://4.bp.blogspot.com/-3ZyMUjU2Lgw/WRmM4poQSbI/AAAAAAAAElo/tYI-ho93ZwscahgDlbZkzEd_n1fFLFAkwCEw/s320/Ubuntu7.png" width="320" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
7-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Press language for your keyboard.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-dSfb89GCmwo/WRmM4sN_0eI/AAAAAAAAEls/WJL-CE5DRiYextnGU687xE-iTAspjv_RwCEw/s1600/Ubuntu8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://3.bp.blogspot.com/-dSfb89GCmwo/WRmM4sN_0eI/AAAAAAAAEls/WJL-CE5DRiYextnGU687xE-iTAspjv_RwCEw/s320/Ubuntu8.png" width="320" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
8-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>You need to create username and password. Remember password or write it somewhere for future use. I set password is same as username.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-tJVFBBhkuts/WRmM47KMQCI/AAAAAAAAElw/Ivb0jHlqF6QR_nt6hCG0cKTTwWPjGAvkQCEw/s1600/Ubuntu9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="197" src="https://4.bp.blogspot.com/-tJVFBBhkuts/WRmM47KMQCI/AAAAAAAAElw/Ivb0jHlqF6QR_nt6hCG0cKTTwWPjGAvkQCEw/s320/Ubuntu9.png" width="320" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
9-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>You will setup complete message and need to restart setup.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-WRkDR3LRdUw/WRmM1kw10VI/AAAAAAAAEks/ChiSNNh1OIcWgjQFbrkvCcJcE241wVU-wCEw/s1600/Ubuntu10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="90" src="https://2.bp.blogspot.com/-WRkDR3LRdUw/WRmM1kw10VI/AAAAAAAAEks/ChiSNNh1OIcWgjQFbrkvCcJcE241wVU-wCEw/s320/Ubuntu10.png" width="320" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
10-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>There are some settings needs to change in order to get better performance from installed virtual machine. Open Ubuntu VM settings. Move to System tab and base memory option under Motherboard.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-XupR6XA5lk8/WRmM1lfdPYI/AAAAAAAAEkw/uQY2ENoc_Sw5HhTuSxanwP0U-kBZ9mv_ACEw/s1600/Ubuntu11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="226" src="https://1.bp.blogspot.com/-XupR6XA5lk8/WRmM1lfdPYI/AAAAAAAAEkw/uQY2ENoc_Sw5HhTuSxanwP0U-kBZ9mv_ACEw/s320/Ubuntu11.png" width="320" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
11-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Switch to Processor tab and change your processor setting.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-QKc91jfrRM4/WRmM2LCbYmI/AAAAAAAAEk4/UKyU86dMU_sLlNFTecgNvE_dpACNfrLmACEw/s1600/Ubuntu12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="222" src="https://2.bp.blogspot.com/-QKc91jfrRM4/WRmM2LCbYmI/AAAAAAAAEk4/UKyU86dMU_sLlNFTecgNvE_dpACNfrLmACEw/s320/Ubuntu12.png" width="320" /></a></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
12-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>In left side tab go to Network under Adapter 1 tab.<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 1in; text-indent: -0.25in;">
a.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Enable Network Adapter and select Bridged Adapter to select same network that is on your Windows system.<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 1in; text-indent: -0.25in;">
b.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Under Name: Select Network of wireless setting as required.<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 1in; text-indent: -0.25in;">
c.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Promiscuous Mode: Select Allow All.<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: 1in; text-indent: -0.25in;">
d.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Tick Cable connected to work with Bridged Adapter.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-upPkCmQY9us/WRmM2X5EmsI/AAAAAAAAElA/8rsZvHGd5dU306LwVD36oHlzZKCRLbNzwCEw/s1600/Ubuntu14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="234" src="https://4.bp.blogspot.com/-upPkCmQY9us/WRmM2X5EmsI/AAAAAAAAElA/8rsZvHGd5dU306LwVD36oHlzZKCRLbNzwCEw/s320/Ubuntu14.png" width="320" /></a></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
13-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Setup your network setting as you setup in your windows machine.<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 1in; text-indent: -0.25in;">
a.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Start your Ubuntu VM and on top right corner. Open setting press Network.<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: 1in; text-indent: -0.25in;">
b.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Under Network Proxy press proxy server to connect network server.<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: 1in; text-indent: -0.25in;">
c.<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Press Apply system wide and restart Ubuntu to apply new changes.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-OutogJJA7Bo/WRmM26QwV8I/AAAAAAAAElE/wf579SQUCVU9fGVCJoKPZ2gCj3Gixm66gCEw/s1600/Ubuntu15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="187" src="https://1.bp.blogspot.com/-OutogJJA7Bo/WRmM26QwV8I/AAAAAAAAElE/wf579SQUCVU9fGVCJoKPZ2gCj3Gixm66gCEw/s320/Ubuntu15.png" width="320" /></a></div>
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
14-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Install putty on your windows system and you can use command prompt to connect Ubuntu from outside Ubuntu.<o:p></o:p></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-4B76-84jsUI/WRmM27_cdyI/AAAAAAAAElM/5IIJ87peKjExmfMPuuFx2yvXKK9DNftHQCEw/s1600/Ubuntu17.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="144" src="https://4.bp.blogspot.com/-4B76-84jsUI/WRmM27_cdyI/AAAAAAAAElM/5IIJ87peKjExmfMPuuFx2yvXKK9DNftHQCEw/s320/Ubuntu17.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="MsoListParagraphCxSpLast" style="line-height: normal; margin-bottom: 0in; text-indent: -0.25in;">
15-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>Starting Linux (Ubuntu). To open root command Press Ctrl+Alt+T to open a terminal window. For security purposes (and to avoid damage), the root user account is locked by default. To safely run commands as root, you should use sudo instead. Enabling the root user can put your system at risk and is not recommended by Ubuntu.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-n-F-ZYpuP5A/WRmM25CY2eI/AAAAAAAAElI/oqWYyNLQt8gOp7uxkG2VLdemonIWxKfIACEw/s1600/Ubuntu16.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="218" src="https://4.bp.blogspot.com/-n-F-ZYpuP5A/WRmM25CY2eI/AAAAAAAAElI/oqWYyNLQt8gOp7uxkG2VLdemonIWxKfIACEw/s320/Ubuntu16.png" width="320" /></a></div>
<br />
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
16-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span>You can use Sudo apt-get update as follows<o:p></o:p></div>
<br />
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-r2N0qpJvgMk/WRmM3eg5NOI/AAAAAAAAElU/silJkEIvEFMAhDIauNMcGZ-GcjLL_ajDgCEw/s1600/Ubuntu18.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="201" src="https://1.bp.blogspot.com/-r2N0qpJvgMk/WRmM3eg5NOI/AAAAAAAAElU/silJkEIvEFMAhDIauNMcGZ-GcjLL_ajDgCEw/s320/Ubuntu18.png" width="320" /></a></div>
</div>
Shamas DBAhttp://www.blogger.com/profile/01894071527133572968noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-67947137223015301602017-05-10T03:25:00.001-07:002017-05-10T03:29:38.704-07:00SQL Server on Linux step 1: Installing Oracle Virtual Box on Microsoft Windows<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
As Microsoft announces next
version of SQL server that is ready to install on other plate forms then
Windows. SQL Server 2017 CTP 2.0 is supported on Red Hat Enterprise Linux, SUSE
Linux Enterprise Server, and Ubuntu. It is also available as a Docker image
which can run on Docker Engine on Linux or Docker for Windows/Mac. Question is
how to install Linux and SQL Server on it. I am going to show you step by step
guide to install both Linux and SQL Server vNext. I tried to cover all aspects
as much as possible in both command line and graphically.<o:p></o:p></div>
<h2 style="background: white; text-align: left;">
<span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt;">SQL Server Latest Releases on
Linux: </span></h2>
<div style="background: white;">
<span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt;">The next version of SQL Server
on Linux will include all the standard SQL Server management features that come
with the Windows version. These include advanced features like
always-encrypted, row-level security and columnstore indexes etc. You can get a
full list of features which are supported in this Microsoft link: <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-release-notes" target="_blank"><span style="font-family: "times new roman" , serif; font-size: 12pt;">SQL
Server on Linux Release Notes</span></a></span>.<span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt;"> <o:p></o:p></span></div>
<h2 style="background: white; text-align: left;">
<span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt;">Download Ubuntu:</span></h2>
<div style="background: white;">
<span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt;">The first step is to decide
which platform is required to install SQL Server vNext. I decided to download
Ubuntu as I already have little bit of experience with it. You can download
latest version of Ubuntu form <a href="https://www.ubuntu.com/"><span style="font-family: "times new roman" , serif; font-size: 12pt;">https://www.ubuntu.com/</span></a></span> . <span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt;">You will find a list of Ubuntu
files to download. I downloaded Ubuntu-17.04 server 64bit (Zesty Zapus) as
shown in pic (InstallUbunut-01) <o:p></o:p></span><br />
<span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-qdagAPvdukM/WRLoA1lRkfI/AAAAAAAAEjE/KJVPKOPdHIMl0t28i_codhf5nYhmnOLxwCLcB/s1600/VB-01.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="166" src="https://4.bp.blogspot.com/-qdagAPvdukM/WRLoA1lRkfI/AAAAAAAAEjE/KJVPKOPdHIMl0t28i_codhf5nYhmnOLxwCLcB/s400/VB-01.png" width="400" /></a></div>
<br />
<h2 style="background: white; text-align: left;">
<span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt;">Oracle VirtualBox </span></h2>
<div style="background: white;">
<span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt;">There are different ways to
install Ubuntu on your machine. For this exercise I decided to use Oracle
Virtual Box. VirtualBox is a powerful x86 and AMD64/Intel64 <a href="https://www.virtualbox.org/wiki/Virtualization"><span style="color: windowtext; text-decoration-line: none;">virtualization</span></a> product
for enterprise as well as home use. Not only is VirtualBox an extremely feature
rich, high performance product for enterprise customers, it is also the only
professional solution that is freely available as Open Source Software under
the terms of the GNU General Public License (GPL) version 2. You can download Virtual
Box – Windows host from following link </span><a href="https://www.virtualbox.org/wiki/Downloads" style="font-family: calibri, sans-serif; font-size: 11pt;"><span style="font-family: "times new roman" , serif; font-size: 12pt;">https://www.virtualbox.org/wiki/Downloads</span></a></div>
<div style="background: white;">
<span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt;"><br /></span>
<span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt;">Before starting Virtual box
installation it is benificial to download some other required tools during
ubuntu installation. You can work directly in ubuntu plateform but there is
another way to work by connecting through PuTTY. You can work with PuTTY untill
you have openssh on your ubuntu server. You can install openssh directly from
ubuntu or by downloading it and install form given path. Following is the image
that is showing ubuntu and other downloaded files.<o:p></o:p></span></div>
<div style="background: white;">
<span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-9cr8VeVgRuY/WRLoAv6kKhI/AAAAAAAAEkU/b_tuSTbsD28JqE5MxrBP33MM5qVM8D1BgCEw/s1600/VB-02.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="62" src="https://3.bp.blogspot.com/-9cr8VeVgRuY/WRLoAv6kKhI/AAAAAAAAEkU/b_tuSTbsD28JqE5MxrBP33MM5qVM8D1BgCEw/s400/VB-02.png" width="400" /></a></div>
<br />
<span style="font-family: "calibri" , "sans-serif"; font-size: 11.0pt;"><br /></span></div>
<div class="MsoNormal">
There are different ways to
install linux. If you have Windows installed on your machine and want to
install linux seperately, you can go for dual boot installation. Dual-booting
is a technique which allows a single physical computer to run two or more
operating systems. This is useful for experimenting with new OS without touching
your existing setup. I have found a very good step by step installation guide
on following link <a href="http://www.instructables.com/id/How-to-Dual-boot-Linux-and-Windows-on-a-PC-with-W/"><span style="color: windowtext; text-decoration-line: none;">http://www.instructables.com/id/How-to-Dual-boot-Linux-and-Windows-on-a-PC-with-W/</span></a></div>
<div class="MsoNormal">
<o:p></o:p></div>
<div class="MsoNormal">
<br />
I choose virtual box to
install ubuntu from my existing Windows. Next is step by step example for
installing oracle virtual box.<o:p></o:p></div>
<div class="MsoListParagraph" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->1-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->Double click on
the VirtualBox setup to start installation.<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-aih_ONYPGNQ/WRLoA3rdTTI/AAAAAAAAEkU/65DtNZiICtchqXXBw6FA06uGZ0xUZaNmACEw/s1600/VB-03.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="248" src="https://1.bp.blogspot.com/-aih_ONYPGNQ/WRLoA3rdTTI/AAAAAAAAEkU/65DtNZiICtchqXXBw6FA06uGZ0xUZaNmACEw/s320/VB-03.png" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->2-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->This setup needs to
check free space on your hard drive.<o:p></o:p></div>
<div class="MsoNormal">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-_mSTce110ec/WRLoBA3B9jI/AAAAAAAAEkU/AW0yIBIiWzMwSig6i-6kcGOA_NmY7bcgACEw/s1600/VB-04.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="251" src="https://3.bp.blogspot.com/-_mSTce110ec/WRLoBA3B9jI/AAAAAAAAEkU/AW0yIBIiWzMwSig6i-6kcGOA_NmY7bcgACEw/s320/VB-04.png" width="320" /></a></div>
</div>
<div class="MsoListParagraph" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->3-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->You will get
reset warning that you can read and press Yes.<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-nq1N_icowuw/WRLoBGdwVYI/AAAAAAAAEkU/r6oC7kj8bDATQO7nr5b3mLcORG2mqtCigCEw/s1600/VB-05.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="250" src="https://1.bp.blogspot.com/-nq1N_icowuw/WRLoBGdwVYI/AAAAAAAAEkU/r6oC7kj8bDATQO7nr5b3mLcORG2mqtCigCEw/s320/VB-05.png" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->4-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->Setup will start
installing Virtual box and it will take few minutes only depending on your
machine performance.<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-93rgX4kaTMQ/WRLoBaqM0-I/AAAAAAAAEkU/zhUB1oHPZC8stQTbVVtDChm_BmF5wa1BQCEw/s1600/VB-06.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="249" src="https://1.bp.blogspot.com/-93rgX4kaTMQ/WRLoBaqM0-I/AAAAAAAAEkU/zhUB1oHPZC8stQTbVVtDChm_BmF5wa1BQCEw/s320/VB-06.png" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->5-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->You need to
install Oracle Corporation Universal Serial Bus, press install<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-wWdsWgmkClU/WRLoBnFLiUI/AAAAAAAAEkU/cI9tS5PnaqQDu7L_X7uDUUq3vkORt04XwCEw/s1600/VB-07.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="246" src="https://3.bp.blogspot.com/-wWdsWgmkClU/WRLoBnFLiUI/AAAAAAAAEkU/cI9tS5PnaqQDu7L_X7uDUUq3vkORt04XwCEw/s320/VB-07.png" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->6-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->Setup may ask for
some other network tools for installation<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->7-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->You will get successful
installation message, press Finish to start Oracle Virtual box<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-rgIsLRxlZiI/WRLoB6PukNI/AAAAAAAAEkU/kEXD-tFCAnAZzEzfEUdvz4qvbyJKm2YEQCEw/s1600/VB-08.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="249" src="https://2.bp.blogspot.com/-rgIsLRxlZiI/WRLoB6PukNI/AAAAAAAAEkU/kEXD-tFCAnAZzEzfEUdvz4qvbyJKm2YEQCEw/s320/VB-08.png" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]-->8-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->After finishing
setup Oracle VM Virtual Box Manager will open.<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-m7SiT0uNciI/WRLoB3HnSTI/AAAAAAAAEkU/UFRDxgSXfSIzB7oHfeqsRwZ66EVtUWVFgCEw/s1600/VB-09.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://3.bp.blogspot.com/-m7SiT0uNciI/WRLoB3HnSTI/AAAAAAAAEkU/UFRDxgSXfSIzB7oHfeqsRwZ66EVtUWVFgCEw/s320/VB-09.png" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Create New VM using Oracle
Virtual Box<o:p></o:p></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l2 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]-->1-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->To start creating
new VM setup, Press New icon from left top corner<o:p></o:p></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l2 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]-->2-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->It will open new
VM setup screen where you have to set name for your VM as we are installing
Ubuntu for SQL Server so it will be “Ubuntu1710”<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-9kQtynHVnEE/WRLoCFVt8JI/AAAAAAAAEkU/ZhOIMfHojRIZnu9q7G2hkN_q3HnRR22gwCEw/s1600/VB-10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="276" src="https://1.bp.blogspot.com/-9kQtynHVnEE/WRLoCFVt8JI/AAAAAAAAEkU/ZhOIMfHojRIZnu9q7G2hkN_q3HnRR22gwCEw/s320/VB-10.png" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l2 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]-->3-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->Next is Type of
your operating system installation, for us it will be Linux<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-tfQnCSsG2sQ/WRLoCR-ySFI/AAAAAAAAEkU/tUonWMKWv5MXO9J8GvLLybw-TU4okFpgACEw/s1600/VB-11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="279" src="https://3.bp.blogspot.com/-tfQnCSsG2sQ/WRLoCR-ySFI/AAAAAAAAEkU/tUonWMKWv5MXO9J8GvLLybw-TU4okFpgACEw/s320/VB-11.png" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l2 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]-->4-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->We need to select
64-bit because we have downloaded same version<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-ye4sfdGH1So/WRLoCTs00NI/AAAAAAAAEkU/KUBgSbx3oPwCkioj-gDcrAC70EiAqV0NACEw/s1600/VB-12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="278" src="https://3.bp.blogspot.com/-ye4sfdGH1So/WRLoCTs00NI/AAAAAAAAEkU/KUBgSbx3oPwCkioj-gDcrAC70EiAqV0NACEw/s320/VB-12.png" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l2 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]-->5-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->You need to set
required RAM for the VM that will be part from total available system RAM. In
this case I have mentioned 4GB out of 6GB. You need at least 3.5 GB in order to
install SQL Server on Linux. If you do not have enough RAM, You can change it
even after creating VM.<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/--GaYJSfIJrw/WRLoCdb7LtI/AAAAAAAAEkU/-N4JCDI9vfQOInKUmupPLFHC0uxvNZY2ACEw/s1600/VB-13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="279" src="https://3.bp.blogspot.com/--GaYJSfIJrw/WRLoCdb7LtI/AAAAAAAAEkU/-N4JCDI9vfQOInKUmupPLFHC0uxvNZY2ACEw/s320/VB-13.png" width="320" /></a></div>
<div class="MsoNormal" style="margin-left: .25in;">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l2 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]-->6-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->Continue by
pressing Next, You need to set Hard disk value. You can add it later or go for
virtual hard disk now, which I have selected.<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-oKG1v70g-RU/WRLoC6BEvGI/AAAAAAAAEkU/wwjHCx9VgtM2kzYQmHHE8kYb4owvYsMHwCEw/s1600/VB-14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="273" src="https://4.bp.blogspot.com/-oKG1v70g-RU/WRLoC6BEvGI/AAAAAAAAEkU/wwjHCx9VgtM2kzYQmHHE8kYb4owvYsMHwCEw/s320/VB-14.png" width="320" /></a></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l2 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]-->7-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->Next pop will be
used to select hard disk file type, I have selected Virtual Box disk image<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-HPCuHItjZ2Q/WRLoCyYay4I/AAAAAAAAEkU/6yMrbw-1PvEiJVSZpkx2Q3RU8RY4_0AqgCEw/s1600/VB-15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="298" src="https://3.bp.blogspot.com/-HPCuHItjZ2Q/WRLoCyYay4I/AAAAAAAAEkU/6yMrbw-1PvEiJVSZpkx2Q3RU8RY4_0AqgCEw/s400/VB-15.png" width="400" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l2 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]-->8-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->You have to
select which type of storage you will prefer, I used dynamically allocated so
that I can increase it when required.<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-64SicO0WSUw/WRLoC5mrpNI/AAAAAAAAEkU/M9VajXqWHiM_S-D4BP1j2MwBdm5RQ-pFQCEw/s1600/VB-16.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="270" src="https://3.bp.blogspot.com/-64SicO0WSUw/WRLoC5mrpNI/AAAAAAAAEkU/M9VajXqWHiM_S-D4BP1j2MwBdm5RQ-pFQCEw/s320/VB-16.png" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l2 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]-->9-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->In this setup you
have to select storage file location and initial size of your VM. I have set 32
GB and will increase on demand. <o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-EOBYsh5C5_M/WRLoDR-CORI/AAAAAAAAEkU/Gz7utrWmnqMss6xEQFU9oPRfBD1ge9MgQCEw/s1600/VB-17.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="272" src="https://2.bp.blogspot.com/-EOBYsh5C5_M/WRLoDR-CORI/AAAAAAAAEkU/Gz7utrWmnqMss6xEQFU9oPRfBD1ge9MgQCEw/s320/VB-17.png" width="320" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l2 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]-->10-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->Press “create”
and your new VM will be created. You can see detail on VM main page<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-hBclaplcfUs/WRLoDVHEoEI/AAAAAAAAEkU/FHcnHtl75A4Zu95rd8qVJU4vMwo2MKBnACEw/s1600/VB-18.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://3.bp.blogspot.com/-hBclaplcfUs/WRLoDVHEoEI/AAAAAAAAEkU/FHcnHtl75A4Zu95rd8qVJU4vMwo2MKBnACEw/s320/VB-18.png" width="288" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l2 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]-->11-<span style="font-size: 7pt; font-stretch: normal; font-variant-numeric: normal; line-height: normal;">
</span><!--[endif]-->Given file
location name will be created windows folder.<o:p></o:p></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-bcCz131p8XU/WRLoDQ6uIwI/AAAAAAAAEkU/WuEIJ8wuIUgP78mMEJWdk5ihKAuZ7V7EwCEw/s1600/VB-19.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="66" src="https://1.bp.blogspot.com/-bcCz131p8XU/WRLoDQ6uIwI/AAAAAAAAEkU/WuEIJ8wuIUgP78mMEJWdk5ihKAuZ7V7EwCEw/s400/VB-19.png" width="400" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
You have successfully
completed virtual box and now need to start installing Ubuntu setup on it.</div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo3; text-indent: -.25in;">
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
From this point on words Ubuntu installation will start. I will publish step by step detail in my next post... keep reading :)</div>
<br /></div>
</div>
Shamas DBAhttp://www.blogger.com/profile/01894071527133572968noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-56986281518462270452017-03-12T23:18:00.000-07:002017-03-12T23:18:15.268-07:00Save your Outlook.com email attachments to 'Specified Folder' in OneDrive<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">Save to OneDrive Features is a simpler way to manage and save your email attachments directly in OneDrive but by default it will store all attachments in a specified folder. (email attachments)</span></span><br />
<span style="background-color: white; border: 0px; box-sizing: inherit; color: #404040; font-family: SegoeUI, "Segoe UI", sans-serif; font-size: 18px; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-LUVgiXfm290/WMY4x_KkfyI/AAAAAAAABqE/8DOpJMxYc_4CnxLTwML2IL_v0HTkhb4eQCLcB/s1600/Capture.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="197" src="https://3.bp.blogspot.com/-LUVgiXfm290/WMY4x_KkfyI/AAAAAAAABqE/8DOpJMxYc_4CnxLTwML2IL_v0HTkhb4eQCLcB/s320/Capture.JPG" width="320" /></a></div>
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span>
<span style="background-color: white; font-family: Verdana, sans-serif;"><b>But if you want to save the file at different location so that you don't have to move the files later on, you can follow steps below. </b></span><br />
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span>
<span style="background-color: white; font-family: Verdana, sans-serif;">1) Click Actions as shown in figure below. </span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-wRPKOAX7sIo/WMY5oF0RylI/AAAAAAAABqM/EB62RmvdOGY16K2aJp6elm4kHiWbFye9QCLcB/s1600/Capture2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="219" src="https://1.bp.blogspot.com/-wRPKOAX7sIo/WMY5oF0RylI/AAAAAAAABqM/EB62RmvdOGY16K2aJp6elm4kHiWbFye9QCLcB/s320/Capture2.JPG" width="320" /></a></div>
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span>
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span>
<span style="background-color: white; font-family: Verdana, sans-serif;">2) Right click the file and click Save as</span><br />
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span>
<span style="background-color: white; font-family: Verdana, sans-serif;">3) Select the path (one drive or windows folder) where you want to store the files. </span><br />
<span style="background-color: white; font-family: Verdana, sans-serif;"><b><br /></b></span>Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-65092667668248924312016-03-13T20:14:00.001-07:002016-03-13T20:15:04.014-07:00 Fab40 for SharePoint 2013<br />
<div class="fauxcolumn-outer fauxcolumn-left-outer" style="background-color: white; bottom: 0px; color: #666666; font-family: 'Trebuchet MS', Trebuchet, Verdana, sans-serif; font-size: 12px; left: 0px; overflow: hidden; position: absolute; top: 0px; width: 0px;">
<div class="fauxborder-left" style="background-position: 0% 0%; background-repeat: repeat-y; height: 3159.69px; position: relative;">
<div class="fauxborder-right" style="background-position: 100% 0%; background-repeat: repeat-y; height: 3159.69px; position: absolute; right: 0px;">
</div>
<div class="fauxcolumn-inner" style="border-right-color: transparent; border-right-style: solid; border-right-width: 1px; height: 3159.69px;">
</div>
</div>
<div class="cap-bottom" style="background-position: 0% 100%; background-repeat: repeat-x; height: 0px; position: relative;">
<div class="cap-left" style="background-position: 0% 100%; background-repeat: no-repeat; float: left; height: 0px;">
</div>
<div class="cap-right" style="background-position: 100% 100%; background-repeat: no-repeat; float: right; height: 0px;">
</div>
</div>
</div>
<div class="fauxcolumn-outer fauxcolumn-right-outer" style="background-color: white; bottom: 0px; color: #666666; font-family: 'Trebuchet MS', Trebuchet, Verdana, sans-serif; font-size: 12px; overflow: hidden; position: absolute; right: 0px; top: 0px; width: 310px;">
<div class="cap-top" style="background-position: 0% 0%; background-repeat: repeat-x; height: 0px; position: relative;">
<div class="cap-left" style="background-position: 0% 0%; background-repeat: no-repeat; float: left; height: 0px;">
</div>
<div class="cap-right" style="background-position: 100% 0%; background-repeat: no-repeat; float: right; height: 0px;">
</div>
</div>
<div class="fauxborder-left" style="background-position: 0% 0%; background-repeat: repeat-y; height: 3159.69px; position: relative;">
<div class="fauxborder-right" style="background-position: 100% 0%; background-repeat: repeat-y; height: 3159.69px; position: absolute; right: 0px;">
</div>
<div class="fauxcolumn-inner" style="border-left-color: transparent; border-left-style: solid; border-left-width: 1px; height: 3159.69px;">
</div>
</div>
<div class="cap-bottom" style="background-position: 0% 100%; background-repeat: repeat-x; height: 0px; position: relative;">
<div class="cap-left" style="background-position: 0% 100%; background-repeat: no-repeat; float: left; height: 0px;">
</div>
<div class="cap-right" style="background-position: 100% 100%; background-repeat: no-repeat; float: right; height: 0px;">
</div>
</div>
</div>
<div class="columns-inner" style="background-color: white; color: #666666; font-family: 'Trebuchet MS', Trebuchet, Verdana, sans-serif; font-size: 12px; min-height: 0px;">
<div class="column-center-outer" style="float: left; position: relative; width: 570px;">
<div class="column-center-inner" style="padding: 0px;">
<div class="main section" id="main" name="Main" style="margin: 0px 1em;">
<div class="widget Blog" id="Blog1" style="line-height: 1.4; margin: 0px 0px 30px; min-height: 0px; position: relative;">
<div class="blog-posts hfeed">
<div class="date-outer">
<h2 class="date-header" style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 11px; font-stretch: normal; line-height: normal; margin: 0px; min-height: 0px; position: relative;">
<span style="font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif; font-size: 22px; font-weight: normal;">Fab40 for SharePoint 2013</span></h2>
<div class="date-posts">
<div class="post-outer">
<div class="post hentry uncustomized-post-template" itemprop="blogPost" itemscope="itemscope" itemtype="http://schema.org/BlogPosting" style="margin: 0px 0px 45px; min-height: 0px; position: relative;">
<div class="post-header" style="font-size: 10.8px; line-height: 1.6; margin: 0px 0px 1.5em;">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-8575465544041833128" itemprop="description articleBody" style="font-size: 13.2px; line-height: 1.4; position: relative; width: 546px;">
Fab 40 templates were free templates released by Microsoft for sharepoint 2007 and wss 3.0 to address some of the common scenarios encountered by SharePoint administrators, developers and event business/Marketing managers to demonstrate and show case some of the capabilities of MOSS to end users.<br />
<br />
Discussion about that how good these templates are and in which scenario these are more helpful versus things which needs to be improved in these templates is a separate topic but I have noticed many SharePoint people using these templates either for small clients , for demonstration purpose and even for training purposes etc. ..<br />
<br />
I have uploaded some of these Fab 40 templates for <span style="font-size: 13.2px; line-height: 18.48px;">SharePoint </span>2010 and SharePoint 2013, so now you can have Fab 40 for <span style="font-size: 13.2px; line-height: 18.48px;">SharePoint </span>2010 and SharePoint 2013, at least some of these are available for now…<br />
<br />
<br />
http://sharepointwebstore.com/product-category/sharepoint-2013/</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-70891596858578621952016-03-09T20:54:00.001-08:002016-03-09T20:57:51.622-08:00<span style="font-family: "arial" , "helvetica" , sans-serif;"><b>The Problem</b></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">Consume web services (running on HTTPS) in SharePoint and SSL certificate is not registered in SharePoint under TRUST Authority.<br />Related Errors</span><br />
<br />
<ul>
<li style="line-height: 20px;"><span style="color: red; font-family: "arial" , "helvetica" , sans-serif; line-height: 36px;">Web Services: Could not establish trust relationship for the SSL/TLS</span></li>
</ul>
<ul>
<li style="line-height: 20px;"><span style="color: red; font-family: "arial" , "helvetica" , sans-serif; font-size: small;">Server was unable to process request. ---> The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.</span></li>
</ul>
<ul>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="color: red; font-family: "helvetica" , "arial" , sans-serif; font-size: xx-small;"><span style="line-height: 20px;"><span style="font-size: small;">An operation failed because the following certificate has validation error</span>s:</span></span><span style="background-color: transparent; color: red; line-height: 20px;">Subject Name: CN=xxxx.com Issuer Name: CN=XXXTRUST AuthorityName DV SSL CA - G3, OU=Domain Validated SSL, O=GeoTrust Inc., C=US Thumbprint: 3495DB5381AC3EXXXXXX9 Errors: PartialChain: A certificate chain could not be built to a trusted root authority. RevocationStatusUnknown: The revocation function was unable to check revocation for the certificate. OfflineRevocation: The revocation function was unable to check revocation because the revocation server was offline. .<span class="Apple-tab-span" style="white-space: pre;"> </span>1b31659d-b408-b0d3-ae61-808af97de845</span></span></li>
</ul>
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /><br /><b>Note: </b>These errors are applicable to other web applications as well and are not limited to SharePoint.<br /><span style="font-size: small;"><span style="font-weight: 700;"><br /></span></span></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-size: small;"><span style="font-weight: 700;"><b>Resolution</b></span></span>To overcome this error, you need to add the certificate(of Web Service Running on SSL) to SharePoint Manage Trust Authority. </span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /><b>Downloading the Certificate:</b><br /><span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="line-height: 20px;">First Step is to down the certificate of web service.</span></span><span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="line-height: 20px;">1) Open Web service in Browser. </span></span><span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="line-height: 20px;">2) Click the Lock in address bar if you are using chrome, its on right hand side if you are using I.E</span></span><br /><span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="line-height: 20px;">3) Click View Certificate </span></span><br />
4) Add a new Certificate<b><br /></b></span><br />
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">
</span>
<br />
<div style="background-color: white; margin-bottom: 10px;">
</div>
<div style="background-color: white; line-height: 20px; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">
</span>
<br />
<div style="color: black; line-height: normal; margin-bottom: 10px;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-AnU1SC1nwPI/VuD72WPJ7TI/AAAAAAAABgQ/dkwMMmsJMq8/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="75" src="https://3.bp.blogspot.com/-AnU1SC1nwPI/VuD72WPJ7TI/AAAAAAAABgQ/dkwMMmsJMq8/s320/1.png" width="320" /></span></a></div>
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><br /></span></span></div>
<div style="color: black; line-height: normal; margin-bottom: 10px;">
<span style="color: #333333; font-family: "arial" , "helvetica" , sans-serif;"><span style="line-height: 20px;">2</span><span style="line-height: 20px;">) Click Details</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-X9WQGjf4ebY/VuD8CLi-Y1I/AAAAAAAABgU/sdVFcp1I8hI/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="320" src="https://3.bp.blogspot.com/-X9WQGjf4ebY/VuD8CLi-Y1I/AAAAAAAABgU/sdVFcp1I8hI/s320/2.png" width="320" /></span></a></div>
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><b><br /></b></span></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-hxa7xaQxSE8/VuD8H5d4VPI/AAAAAAAABgY/bCCS_l_Lrrs/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="204" src="https://3.bp.blogspot.com/-hxa7xaQxSE8/VuD8H5d4VPI/AAAAAAAABgY/bCCS_l_Lrrs/s320/3.png" width="320" /></span></a></div>
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><b><br /></b></span></span></div>
<div style="line-height: normal; margin-bottom: 10px;">
<div style="color: black;">
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><br /></span></span></div>
<div style="color: black;">
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><br /></span></span></div>
<div style="color: black;">
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;">4) Select Certification Path-> Select the top level Certification Path (STEP 1)->View Certificate (SEP 2)->Details tab->Copy to File(Step 3) -> Next -> Select the format as DER encoded binary X.509 (.CER)</span></span></div>
<div style="color: black;">
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><br /></span></span></div>
<div class="separator" style="clear: both; color: black; text-align: center;">
<a href="https://3.bp.blogspot.com/-hra5NAgmYks/VuD8UDg8e0I/AAAAAAAABgc/g8CWfmOoQtE/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="215" src="https://3.bp.blogspot.com/-hra5NAgmYks/VuD8UDg8e0I/AAAAAAAABgc/g8CWfmOoQtE/s320/5.png" width="320" /></span></a></div>
<div style="color: black;">
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><br /></span></span></div>
<div style="color: black;">
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><br /></span></span></div>
<div style="color: black;">
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><br /></span></span></div>
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="color: red; font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><b>Repeat Step 4 for Top level certificate and levels below it (LEVEL 1 &2 in this case)</b></span></span><br />
<div style="color: black;">
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><br /></span></span></div>
<div style="color: black;">
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><br /></span></span></div>
<div style="color: black;">
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><b>By Now you should have certificate files (2 files in this example) on your local machine in .cer format.</b></span></span></div>
<div style="color: black;">
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><b><br /></b></span></span></div>
<div style="color: black;">
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><br /></span></span></div>
<div style="color: black;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="color: black;">
<span style="color: #333333; font-family: "helvetica" , "arial" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 20px;"><br /></span></span></div>
</div>
<div style="color: #333333;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;">Add Certificate to SharePoint</span></b><br />
<b><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></b></div>
<div style="color: #333333;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">1) Open SharePoint Central Admin</span></div>
<div style="color: #333333;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">2) Click <b>Security</b></span></div>
<div style="color: #333333;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">3) Under <b>General Security </b>select <b>Manage Trust</b></span></div>
<div style="color: #333333;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></b></div>
<div class="separator" style="clear: both; color: #333333; text-align: center;">
<a href="https://4.bp.blogspot.com/-qNBtMJuTa30/VuD2oDkPT2I/AAAAAAAABf8/m9kRb5-kZEg/s1600/Manage%2BTrust.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="102" src="https://4.bp.blogspot.com/-qNBtMJuTa30/VuD2oDkPT2I/AAAAAAAABf8/m9kRb5-kZEg/s320/Manage%2BTrust.png" width="320" /></span></a></div>
<div style="color: #333333;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></b></div>
</div>
<div style="background-color: white; color: #333333; line-height: 20px; margin-bottom: 10px;">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></b>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-kT8ScvHqKnE/VuD3Rb1fbmI/AAAAAAAABgE/URS9L47b_N0/s1600/Certificate%2BTrust.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><img border="0" height="245" src="https://3.bp.blogspot.com/-kT8ScvHqKnE/VuD3Rb1fbmI/AAAAAAAABgE/URS9L47b_N0/s320/Certificate%2BTrust.png" width="320" /></span></a></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b><br /></b>
</span></div>
<div style="background-color: white; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">5) Select the certificate which you have saved in previous step, Repeat this for all downloaded certificates. (2 Certificates in this example)</span></div>
Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-70934212888803282892016-01-17T21:28:00.001-08:002016-01-17T21:28:54.671-08:00SharePoint Wakeup script Configuration in Task SchedulerThis script will access your SharePoint site specified in URL (in script) after every few minutes and will keep the application pool warm thus making it quicker for users to access the site.<br />
<br />
1) Log on to SharePoint Server<br />
<br />
2) Copy Script below in a file and save that file as spwakeup.ps1<br />
<br />
function get-webpage([string]$url,[System.Net.NetworkCredential]$cred=$null)<br />
{<br />
$error = $false<br />
$webRequest = [System.Net.HttpWebRequest]::Create($url)<br />
$webRequest.Timeout = 300000<br />
if($cred -eq $null)<br />
{<br />
$webRequest.Credentials = [system.Net.CredentialCache]::DefaultCredentials<br />
}<br />
try {<br />
$res = $webRequest.getresponse()<br />
}catch{<br />
$error = $true<br />
}<br />
}<br />
<br />
Function Load-SharePoint-Powershell<br />
{<br />
If ((Get-PsSnapin |?{$_.Name -eq "Microsoft.SharePoint.PowerShell"})-eq $null)<br />
{<br />
Write-Host -ForegroundColor White " - Loading SharePoint Powershell Snapin"<br />
Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction Stop<br />
}<br />
}<br />
Load-SharePoint-Powershell<br />
$webapplications = Get-SPWebApplication <span style="color: red;">[SITEURL]</span><br />
$AllSites = Get-SPSite -limit all<br />
$Array = @()<br />
$i=0<br />
foreach ($wa in $webapplications)<br />
{<br />
foreach ($windowsauth in $wa.AlternateUrls)<br />
{<br />
$authenticationprovider= Get-SPAuthenticationProvider -webapplication $wa -zone $windowsauth.Zone<br />
If ($authenticationprovider.UseWindowsIntegratedAuthentication)<br />
{<br />
$accessableURL = $windowsauth.IncomingUrl<br />
}<br />
}<br />
if (!$AccessableURL) {$accessableURL = $wa.url -replace ".$"}<br />
foreach ($site in $AllSites)<br />
{<br />
if ($Site.Url -and $Site.Url+"/" -match $wa.url)<br />
{<br />
$subsites = Get-SPSite $Site.Url | Get-SPWeb -Limit All<br />
Foreach ($subsite in $subsites)<br />
{<br />
$i++<br />
Write-Progress -activity "Looking up all sites" -status "Please Wait..." -PercentComplete (($i / 500) * 100)<br />
$PlainWaUrl = $wa.Url -replace ".$"<br />
$WakeUpSite = $Subsite.Url.replace($PlainWaUrl, $accessableURL)<br />
$Array = $Array + $WakeUpSite<br />
#$html=get-webpage -url "$WakeUpSite" -cred $cred;<br />
if ($i -eq 500){$i=0}<br />
}<br />
} <br />
}<br />
Remove-Variable accessableURL<br />
}<br />
<br />
$i=0<br />
Foreach ($Website in $Array)<br />
{<br />
$i++<br />
Write-Progress -activity "Waking up sites" -status "Waking: $Website" -PercentComplete (($i / $Array.Count) * 100)<br />
$html=get-webpage -url "$Website" -cred $cred;<br />
}<br />
<div>
<br /></div>
<br />
3) Click Start-> Administrative Tools - > Task Scheduler<br />
<br />
2) Expand the left hand tree and right click on Task Schedule Library to create a new Task.<br />
<br />
<br />
3) Give your task a friend name.<br />
<br />
4) In General section come to Security Options select the following options<br />
a) Run whether user is logged on or not<br />
b) Run with highest privileges<br />
c) Hidden<br />
<br />
5) In Triggers section , add a new trigger and specify the following.<br />
<br />
a) Begin the task -> on a schedule<br />
b) Settings:<br />
One Time<br />
Start date and time should be today's date and time<br />
c) Advanced Settings - > Select Enabled.<br />
<br />
6) Select Actions and add a new Action<br />
<br />
a) Action -> Start a Program<br />
b) Program/script - > PowerShell.exe<br />
c) add a arguments (optional) -> Execution Policy bypass "Path of script file which you have saved in step 2"<br />
<br />
<br />
7) Select the Conditions tab and in power section select<br />
a) Start the task only in the computer is on AC Power<br />
<br />
8) Select the Settings tab and select<br />
<br />
a) Allows task to be run on demand<br />
b) Stop the tasks if it runs longer than 5 days<br />
c) If the running task does not end when requested, force it to stop.<br />
d) Do not start a new instance<br />
<br />
<br />
9) Click Ok.<br />
<br />
<br />
<br />Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-41308086734813698152016-01-17T21:14:00.000-08:002016-03-09T21:00:43.364-08:00Build trust relationship with local domain of SharePoint server and Other Domain so that users of trusted domain can be used in SharePoint<b>Build trust relationship with local domain of SharePoint server and Other Domain so that users of trusted domain can be used in SharePoint</b><br />
<br />
<b><u>Scenario: </u></b><br />
<br />
<ul>
<li>SharePoint Farm installed in domain1.com </li>
<li>All company users are registered in domaininternal.com </li>
<li>Requirement: Add users from domaininternal.com to SharePoint site collection which is running in domain1.com </li>
</ul>
<br />
<br />
<u>Run this on Sharepoint PowerShell:</u><br />
<br />
stsadm.exe -o setproperty -url <http: server:port=""> -pn "peoplepicker-searchadforests" -pv "<forest:contoso .com="" domain:corp.contoso.com="">", <loginname>,<password>, <key></key></password></loginname></forest:contoso></http:><br />
<br />
<span style="color: #cc0000;"><br /></span>
<span style="color: #cc0000;"><b>Important:</b> LoginName is the login name of user who is domain administrator or added to domain admin group, the command will run otherwise but the results will be be as desired.</span><br />
<br />
<br />
Good References for this:<br />
<i>https://blog.tallan.com/2013/04/18/setting-up-an-external-domain-trust-in-a-simple-sharepoint-2010-extranet-with-separate-ad-domains-and-completing-a-profile-sync/</i><br />
<i><br /></i>
<i>http://www.boostsolutions.com/blog/how-to-add-trust-domains-in-a-sharepoint-farm/</i><br />
<i><br /></i>
<i>http://blog.sharepoint-voodoo.net/?p=17</i>Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-55169412859852501922016-01-17T21:05:00.000-08:002016-03-09T20:59:25.941-08:00Lock/Unlock FBA AccountIf you have FBA packed installed , it can be used to unlock an account but if you want to unlock many accounts SQL statement below can be used to do that.<br />
<br />
<b>Un-Lock FBA Account</b><br />
<div class="MsoNormal">
<span style="color: magenta; font-family: "consolas"; font-size: 9.5pt;">Update</span><span style="font-family: "consolas"; font-size: 9.5pt;"> <span style="color: teal;">[DBNAME]</span><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: blue; font-family: "consolas"; font-size: 9.5pt;">set</span><span style="font-family: "consolas"; font-size: 9.5pt;"> <span style="color: teal;">IsLockedOut</span><span style="color: grey;">=</span>0 <span style="color: grey;">,</span><span style="color: teal;">FailedPasswordAttemptCount</span><span style="color: grey;">=</span>0<o:p></o:p></span></div>
<br />
<div class="MsoNormal">
<span style="color: blue; font-family: "consolas"; font-size: 9.5pt;">where</span><span style="font-family: "consolas"; font-size: 9.5pt;"> <span style="color: teal;">IsLockedOut</span><span style="color: grey;">=</span>1 <span style="color: grey;">and</span> <span style="color: teal;">LastLockoutDate</span><span style="color: teal;">=</span><span style="color: magenta;">DateAdd</span><span style="color: grey;">(</span><span style="color: magenta;">Minute</span><span style="color: grey;">,</span>30<span style="color: grey;">,</span><span style="color: teal;">LastLockoutDate</span><span style="color: grey;">)</span><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: "consolas"; font-size: 9.5pt;"><span style="color: grey;"><br /></span></span></div>
<div class="MsoNormal">
<span style="font-family: "consolas"; font-size: 9.5pt;"><span style="color: grey;"><br /></span></span></div>
<div class="MsoNormal">
<span style="font-family: "consolas"; font-size: 9.5pt;"><span style="color: grey;">P.S: where clause can be modified to add different criteria. </span></span></div>
<br />Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-11388576203235525122016-01-17T18:59:00.001-08:002016-01-17T18:59:09.403-08:00SharePoint 2013 - Get User Title and Emailvar context = new SP.ClientContext.get_current();<br />
web = context.get_web()<br />
var currentUser = web.get_currentUser();<br />
currentUser.retrieve();<br />
context.load(web);<br />
context.executeQueryAsync(<br />
var userObject = web.get_currentUser();<br />
console.log(userObject.get_email());<br />
console.log(userObject.get_loginName());<br />
console.log(userObject.get_title());<br />
);Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-7454731157141862412016-01-17T18:56:00.003-08:002016-01-17T18:56:20.962-08:00SharePoint 2013 - Set and Get Value for Hyperlink Field in JSOM<b><u>Set and Get Value for Hyperlink Field in JSOM</u></b><br />
<br />
<br />
<b><u>Set Value</u></b><br />
var urlvalue = new SP.FieldUrlValue();<br />
urlvalue.set_url('www.google.com');<br />
urlvalue.set_description('Title');<br />
oListItem.set_item("URL", urlvalue);<br />
<br />
<br />
<br />
<b>Get Value</b><br />
console.log(fvalue.get_url());<br />
console.log(fvalue.get_description());Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-72007325341169772942013-04-24T06:17:00.001-07:002013-04-24T06:17:37.221-07:00Sharding, Scale-out with Windows Azure SQL Database (Step by Step)<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 0in 0in 0pt; text-align: left;">
<span style="color: #2a2a2a; font-family: "Arial","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman";">Database sharding is a technique of horizontal partitioning data across multiple physical servers to provide application scale-out. SQL Database combined with database sharding techniques provides for virtually unlimited scalability of data for an application. <o:p></o:p></span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<b style="mso-bidi-font-weight: normal;"><span style="color: #2a2a2a; font-family: "Arial","sans-serif"; mso-bidi-font-size: 9.0pt; mso-fareast-font-family: "Times New Roman";">Sharding: <o:p></o:p></span></b></div>
<div style="text-align: left;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 0in 0in 8pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="color: #2a2a2a; font-family: "Arial","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman";">Sharding is an application pattern for improving the scalability and throughput of large-scale data solutions. To “shard” an application is the process of breaking an application’s logical database into smaller chunks of data, and distributing the chunks of data across multiple physical databases to achieve application scalability. Each physical database in this architecture is what is referred to as a shard.<o:p></o:p></span></div>
<div style="text-align: left;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
<a href="http://www.blogger.com/null" name="_Toc280036773"></a><a href="http://www.blogger.com/null" name="The_benefits_of_sharding_with_SQL_Azure"></a><span style="color: #2a2a2a; font-family: "Arial","sans-serif"; font-size: 9pt; mso-fareast-font-family: "Times New Roman";">The benefits of sharding or Federation with SQL Database</span></div>
<ul style="text-align: left;">
<li><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: "Courier New"; font-size: 10pt; mso-no-proof: yes;">Scale out using tens, hundreds or thousands of database nodes using commodity hardware instead of expensive scale-up systems,</span></div>
</li>
<li><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: "Courier New"; font-size: 10pt; mso-no-proof: yes;">To achieve scalable performance as the number of nodes increases, </span></div>
</li>
<li><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: "Courier New"; font-size: 10pt; mso-no-proof: yes;">Build a solution with an excellent price-performance ratio derived from the use of commodity hardware instead of expensive application servers</span></div>
</li>
<li><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: "Courier New"; font-size: 10pt; mso-no-proof: yes;">SQL Database provides a high availability SLA of 99.9% for all databases, no need to implement RAID and other availability techniques yourself.<o:p></o:p></span></div>
</li>
</ul>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-PoNYMysDTSs/UXfRZzM7fLI/AAAAAAAADho/epdaVPI82Ao/s1600/Untitled.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="376" src="http://2.bp.blogspot.com/-PoNYMysDTSs/UXfRZzM7fLI/AAAAAAAADho/epdaVPI82Ao/s400/Untitled.png" width="400" /></a></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
</div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
</div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
</div>
<div class="MsoNormal" style="margin: 0in 0in 8pt;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; line-height: 107%; mso-bidi-font-size: 9.0pt;">How to Shard your database<o:p></o:p></span></b></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
<span style="font-family: "Arial","sans-serif"; font-size: 9pt; line-height: 107%;">To start working with Sql server sharding I have used SQLAzureMW tool to done sharding activity. You can download the tool from<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
<a href="http://sqlazuremw.codeplex.com/releases/view/32334" target="_blank">Sql azure Managment view Tool</a></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
</div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
<span style="font-family: "Arial","sans-serif"; font-size: 9pt; line-height: 107%;">Before starting sharding you need to design or update your database keeping following points in mind<o:p></o:p></span></div>
<ol style="text-align: left;">
<li><div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
<span style="font-family: "Arial","sans-serif"; font-size: 9pt; line-height: 107%;">Every table must have a primary key.<o:p></o:p></span></div>
</li>
<li><div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
<span style="font-family: "Arial","sans-serif"; font-size: 9pt; line-height: 107%;">Sharded key must be a primary key or part of primary key in related tables (Clustered index required).<o:p></o:p></span></div>
</li>
<li><div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
<span style="font-family: "Arial","sans-serif"; font-size: 9pt; line-height: 107%;">Identity and Timestamp are not included as a part of data types for sharded tables<o:p></o:p></span></div>
</li>
<li><div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
<span style="font-family: "Arial","sans-serif"; font-size: 9pt; line-height: 107%;">Identity can be set in Root DB tables and Sharding reference tables. (both terms defined during step by step creation)<o:p></o:p></span></div>
</li>
<li><div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
<span style="font-family: "Arial","sans-serif"; font-size: 9pt; line-height: 107%;">Root DB collation and size are replicated to all sharded databases.<o:p></o:p></span></div>
</li>
<li><div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
<span style="font-family: "Arial","sans-serif"; font-size: 9pt; line-height: 107%;">You need to manage schema changes in all databases manually to avoid merging problems.<o:p></o:p></span></div>
</li>
<li><div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
<span style="font-family: "Arial","sans-serif"; font-size: 9pt; line-height: 107%;">Replication not support with table scripts.<o:p></o:p></span></div>
</li>
<li><div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
<span style="font-family: "Arial","sans-serif"; font-size: 9pt; line-height: 107%;">Need to mention Federation key at table creation level even root database are not created yet (using this tool).<o:p></o:p></span></div>
</li>
</ol>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 2.25pt 0in; mso-outline-level: 3;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-A3nPsv_BtaI/UXfSLMn34TI/AAAAAAAADiE/4clVLWOfMcU/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://3.bp.blogspot.com/-A3nPsv_BtaI/UXfSLMn34TI/AAAAAAAADiE/4clVLWOfMcU/s320/1.png" width="286" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
Run the tool and select Database</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-n3SIEtekKyM/UXfSL9NUibI/AAAAAAAADiU/D3kR1urUh7Q/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://3.bp.blogspot.com/-n3SIEtekKyM/UXfSL9NUibI/AAAAAAAADiU/D3kR1urUh7Q/s320/2.png" width="290" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
Connect to your local db where Database exists that needs to shard or migrate on SQL Azure</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-OHknZaIaEMM/UXfSMMebbhI/AAAAAAAADic/0aP-JgXiiYQ/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://3.bp.blogspot.com/-OHknZaIaEMM/UXfSMMebbhI/AAAAAAAADic/0aP-JgXiiYQ/s320/3.png" width="295" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
If you want to migrate to simple Azure DB select SQLAzure for Federation, Select as selected. </div>
<div class="separator" style="clear: both; text-align: left;">
Also select objects like Tables, procedures etc. </div>
<div class="separator" style="clear: both; text-align: left;">
You can also select Table and Schema or Table or Schema only.</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-PI84EWWMqOc/UXfSM-cWMPI/AAAAAAAADjQ/BswkOd7-X8U/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://1.bp.blogspot.com/-PI84EWWMqOc/UXfSM-cWMPI/AAAAAAAADjQ/BswkOd7-X8U/s320/4.png" width="291" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: left;">
Script generated for Selected objects and if there are any errors it will show in red lines in Summary section.</div>
<div class="separator" style="clear: both; text-align: left;">
For federation as we don't connect our Azure server yet. We need to add federation key manually so that when script were executed at the end table are ready to created on the basis of federation key.</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-201D_DQ9Oog/UXfSNK05P6I/AAAAAAAADiw/70eezVwXZkg/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://4.bp.blogspot.com/-201D_DQ9Oog/UXfSNK05P6I/AAAAAAAADiw/70eezVwXZkg/s320/5.png" width="293" /></a></div>
<div align="left" class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div align="left" class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: left;">
On this screen you can view FEDERATED ON (UserId = UserId).</div>
<ul style="text-align: left;">
<li><div class="separator" style="clear: both; text-align: left;">
Federated On is keyword to add this table into federation</div>
</li>
<li><div class="separator" style="clear: both; text-align: left;">
"UserId" is key attribute on which we need to generated shards.</div>
</li>
<li><div class="separator" style="clear: both; text-align: left;">
"= UserId" is the Key column that has data and on the basis of this data definition shards data will be moved from one to other federation.</div>
</li>
</ul>
<div class="separator" style="clear: both; text-align: left;">
If you are planning to migrate your database onto Azure Plateform. You do not need to mention FEDERATED ON clause.</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-LCmzNeSUm_c/UXfSNIh4qII/AAAAAAAADio/Gb2eJ8MVkT4/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://4.bp.blogspot.com/-LCmzNeSUm_c/UXfSNIh4qII/AAAAAAAADio/Gb2eJ8MVkT4/s320/6.png" width="305" /></a></div>
<br />
Use "Connect to Server" and by providing Azure credentials as we can see in next screen shot you will be connected to Azure Database server.<br />
As there is no database created yet. We need a database or Root database to start our database migration.<br />
Click on Create Database and You can et its size and Edition along with its name.<br />
Following editions are available<br />
<ul style="text-align: left;">
<li><div style="text-align: left;">
<span style="color: red; font-size: x-small;"><span style="color: red; font-size: x-small;"></span></span><span style="font-size: x-small;">Express -- Web Editions</span></div>
</li>
<li><div style="text-align: left;">
<span style="color: red; font-size: x-small;"><span style="color: red; font-size: x-small;"></span></span><span style="font-size: x-small;">Workgroup -- Business Editions</span></div>
</li>
<li><div style="text-align: left;">
<span style="color: red; font-size: x-small;"><span style="color: red; font-size: x-small;"></span></span><span style="color: blue; font-size: x-small;"><span style="color: blue; font-size: x-small;">Standard</span></span></div>
</li>
<li><div style="text-align: left;">
<span style="color: red; font-size: x-small;"><span style="color: red; font-size: x-small;"></span></span><span style="font-size: x-small;">Enterprise</span></div>
</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-VGHi_zHXUhE/UXfSNqNS8NI/AAAAAAAADjM/trYb2XWtzNU/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://1.bp.blogspot.com/-VGHi_zHXUhE/UXfSNqNS8NI/AAAAAAAADjM/trYb2XWtzNU/s320/7.png" width="292" /></a></div>
<div style="text-align: left;">
If you want to migrate your database without federation you can click next and deploy your changes to database.</div>
<br />
for Federation: <br />
<div style="text-align: left;">
You have successfully created Root database for your Federation database. Now connect again to create federations.</div>
<div style="text-align: left;">
The difference is change your server type to <strong>SQL Azure Federation</strong> and mention your database that was recently created. In this case <strong>UserDBRoot</strong></div>
<div style="text-align: left;">
<strong></strong> </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-73-7hqUNpUo/UXfSNkYCXII/AAAAAAAADjE/eNa3eRpq_gs/s1600/8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://4.bp.blogspot.com/-73-7hqUNpUo/UXfSNkYCXII/AAAAAAAADjE/eNa3eRpq_gs/s320/8.png" width="298" /></a></div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
Now you have created Federation Root db and need to create it Federation Key on which you data will be moved to respective shards.</div>
<div style="text-align: left;">
You can set Distribution data type as BigInt, Float and UniqueIdentifier.</div>
<div style="text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-6ew_ELYCUiA/UXfSLChlWII/AAAAAAAADjY/xJaM6DFghhY/s1600/10.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="320" src="http://4.bp.blogspot.com/-6ew_ELYCUiA/UXfSLChlWII/AAAAAAAADjY/xJaM6DFghhY/s320/10.png" width="295" /></a><a href="http://4.bp.blogspot.com/-grEB1UKXQZ0/UXfSN2ZqFbI/AAAAAAAADi8/DBWXMBCQ-ew/s1600/9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://4.bp.blogspot.com/-grEB1UKXQZ0/UXfSN2ZqFbI/AAAAAAAADi8/DBWXMBCQ-ew/s320/9.png" width="295" /></a></div>
<div align="left" class="separator" style="clear: both; text-align: center;">
</div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
Now you have successfully created Federation Member and you can see its range is Min value of BigInt to Max value of BigInt</div>
<div style="text-align: left;">
In this Screen shot I am creating Split point that will be key decision factor to distribute data. For sample I have set to 5. (It depends on your requirements).</div>
<div style="text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-03Tre8tpoR8/UXfSLBRFmiI/AAAAAAAADiA/yyqGuj3KqNQ/s1600/11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://4.bp.blogspot.com/-03Tre8tpoR8/UXfSLBRFmiI/AAAAAAAADiA/yyqGuj3KqNQ/s320/11.png" width="295" /></a></div>
<div align="left" class="separator" style="clear: both; text-align: center;">
</div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
On click next scripts will generate member databases and also their respective table structures and data (if mentioned) using BCP command.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-3kGy3ZcBCb0/UXfSL3pAz8I/AAAAAAAADiI/HQi5OYlJkzw/s1600/12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="170" src="http://1.bp.blogspot.com/-3kGy3ZcBCb0/UXfSL3pAz8I/AAAAAAAADiI/HQi5OYlJkzw/s320/12.png" width="320" /></a></div>
<br />
You can connect and query your database from Online Management Studio and Local management studio as well.<br />
<div style="text-align: left;">
</div>
<h3 style="text-align: left;">
Merging Federated Members</h3>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-sllWM3JWanI/UXfSOOUY5zI/AAAAAAAADjI/f9WLBxoKwgs/s1600/99.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://3.bp.blogspot.com/-sllWM3JWanI/UXfSOOUY5zI/AAAAAAAADjI/f9WLBxoKwgs/s320/99.png" width="293" /></a></div>
<div style="text-align: left;">
If I want to merge my federation members I will use Delete button and specified options. </div>
<ul style="text-align: left;">
<li><div style="text-align: left;">
For merging you need to remember</div>
</li>
<li><div style="text-align: left;">
All data of deleting member will be lost</div>
</li>
<li><div style="text-align: left;">
Take backup of both members (merger and deleting)</div>
</li>
<li><div style="text-align: left;">
After merging member you need to insert all deleted member data manually</div>
</li>
<li><div style="text-align: left;">
If you delete Federation all members will be lost</div>
</li>
<li><div style="text-align: left;">
You need to make your federation members offline to avoid problems to your customer</div>
</li>
</ul>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
<em>There will be another post that will define following in detail</em></div>
<ul style="text-align: left;">
<li><div style="text-align: left;">
How to Query a specific Shard.</div>
</li>
<li><div style="text-align: left;">
How to Check database usage size.</div>
</li>
<li><div style="text-align: left;">
How to View your sharding database ranges and Stats by Query.</div>
</li>
<li><div style="text-align: left;">
Querying your database using Online and On-premises database management studio.</div>
</li>
</ul>
</div>
Shamas DBAhttp://www.blogger.com/profile/01894071527133572968noreply@blogger.com3tag:blogger.com,1999:blog-27858375.post-35727630822095160302013-02-26T04:11:00.000-08:002013-02-26T04:12:06.314-08:00OAuth and REST and OData in SharePoint 2013<span style="background-color: white; color: #333333; font-family: 'lucida grande', tahoma, verdana, arial, sans-serif; font-size: 13px; line-height: 17px;">Speaking at Perth's SharePoint Saturday - Registrations to attend a SharePoint event in Perth are now open! Spaces are limited register today to confirm your spot. </span><br />
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="background-color: white; font-family: verdana, arial, helvetica, sans-serif; font-size: 11px;">SharePoint 2013 has introduced exciting new features for both the developers and business users alike. This session will focus on OData and Rest services. It will cover an overview of REST, OData and OAuth and how they can be used in SharePoint 2013. With the introduction of new App model in SharePoint 2013, these APIs are becoming increasingly important. How do you choose between them, to know when the REST/OData approach is best? In this session, I’ll cover </span></div>
<div class="MsoNormal">
<span style="background-color: white; font-family: verdana, arial, helvetica, sans-serif; font-size: 11px;"><br />• Understanding REST </span></div>
<div class="MsoNormal">
<span style="background-color: white; font-family: verdana, arial, helvetica, sans-serif; font-size: 11px;">•</span><span style="background-color: white; font-family: verdana, arial, helvetica, sans-serif; font-size: 11px;"> OData Fundamentals <br />• OData Support in SharePoint 2013 </span></div>
<div class="MsoNormal">
<span style="background-color: white; font-family: verdana, arial, helvetica, sans-serif; font-size: 11px;">• OData Programming </span></div>
<div class="MsoNormal">
<span style="background-color: white; font-family: verdana, arial, helvetica, sans-serif; font-size: 11px;">• Introduction to OAuth.</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
http://www.sharepointsaturday.org/perth/meetings/66/OAuthandRESTandODatainSharePoint2013.aspx<o:p></o:p></div>
Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-69084040694728748942012-12-03T21:13:00.002-08:002012-12-03T21:14:22.466-08:00SharePoint Field set to Required but still doesn't require InputOne of common mistake when making content type/list using sharepoint schema is to make the required field field as <br />
<br />
Required="True" or Required ="ture"<br />
<br />
if you pick the value true for the the field as specified above, Visual Studio doesn't give you any error and you can deploy your content type and list with out any errors.<br />
But when you try to enter value for field, you will see that the field is not mandatory OR no redstar (required field indication) on add form of that field.<br />
<br /><b>This will not make this field required.</b><br />
<b><br /></b>
<br />
<pre class="default prettyprint prettyprinted" style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 18px; margin-bottom: 10px; max-height: 600px; overflow: auto; padding: 5px; vertical-align: baseline; width: auto;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; margin: 0px; padding: 0px; vertical-align: baseline;"><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;"><field span="span"><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"{070e50ac-f9c1-4d4c-b1f9-de0bcac300f6}"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Name</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"test"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">DisplayName</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"test"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Type</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"text"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Required</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"true"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Group</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"MytestGroup"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">ColName</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"test"</span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">/></span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
...
</span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;"><contenttype span="span"><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"0x01000a4547a7e98c46248e063d79ddd67f5c"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Name</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"TESTContent Type"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Group</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"MyGroup"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Description</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"Test Content Type Description"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Inherits</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"FALSE"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Overwrite</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"TRUE"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Version</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"0"</span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">></span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;"><fieldref span="span"><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"{<span style="background-color: transparent;">070e50ac-f9c1-4d4c-b1f9-de0bcac300f6</span></span></fieldref></span></contenttype></span></field></span></code><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">}"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Name</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"Price"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">DisplayName</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"test"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Required</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"True"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">/></span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></pre>
<b>This will not make this field required.</b><br />
<pre class="default prettyprint prettyprinted" style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 18px; margin-bottom: 10px; max-height: 600px; overflow: auto; padding: 5px; vertical-align: baseline; width: auto;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; margin: 0px; padding: 0px; vertical-align: baseline;"><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;"><field span="span"><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"{070e50ac-f9c1-4d4c-b1f9-de0bcac300f6}"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Name</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"test"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">DisplayName</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"test"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Type</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"text"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Required</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"true"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Group</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"MytestGroup"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">ColName</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"test"</span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">/></span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
...
</span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;"><contenttype span="span"><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"0x01000a4547a7e98c46248e063d79ddd67f5c"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Name</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"TESTContent Type"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Group</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"MyGroup"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Description</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"Test Content Type Description"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Inherits</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"FALSE"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Overwrite</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"TRUE"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Version</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"0"</span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">></span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;"><fieldref span="span"><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"{<span style="background-color: transparent;">070e50ac-f9c1-4d4c-b1f9-de0bcac300f6</span></span></fieldref></span></contenttype></span></field></span></code><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">}"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Name</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"Price"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">DisplayName</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"test"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Required</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"True"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">/></span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></pre>
<pre class="default prettyprint prettyprinted" style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 18px; margin-bottom: 10px; max-height: 600px; overflow: auto; padding: 5px; vertical-align: baseline; width: auto;"><b style="background-color: transparent; font-family: 'Times New Roman'; font-size: medium; line-height: normal; white-space: normal;">This will make this field required.</b></pre>
<pre class="default prettyprint prettyprinted" style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 18px; margin-bottom: 10px; max-height: 600px; overflow: auto; padding: 5px; vertical-align: baseline; width: auto;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; margin: 0px; padding: 0px; vertical-align: baseline;"><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;"><field span="span"><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"{070e50ac-f9c1-4d4c-b1f9-de0bcac300f6}"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Name</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"test"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">DisplayName</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"test"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Type</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"text"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Required</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"true"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Group</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"MytestGroup"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">ColName</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"test"</span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">/></span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
...
</span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;"><contenttype span="span"><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"0x01000a4547a7e98c46248e063d79ddd67f5c"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Name</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"TESTContent Type"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Group</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"MyGroup"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Description</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"Test Content Type Description"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Inherits</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"FALSE"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Overwrite</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"TRUE"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Version</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"0"</span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">></span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;"><fieldref span="span"><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">ID</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"{<span style="background-color: transparent;">070e50ac-f9c1-4d4c-b1f9-de0bcac300f6</span></span></fieldref></span></contenttype></span></field></span></code><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">}"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Name</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"Price"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">DisplayName</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"test"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="atn" style="background-color: transparent; border: 0px; color: red; margin: 0px; padding: 0px; vertical-align: baseline;">Required</span><span class="pun" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">=</span><span class="atv" style="background-color: transparent; border: 0px; color: blue; margin: 0px; padding: 0px; vertical-align: baseline;">"true"</span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="tag" style="background-color: transparent; border: 0px; color: maroon; margin: 0px; padding: 0px; vertical-align: baseline;">/></span><span class="pln" style="background-color: transparent; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;"> </span></pre>
Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-14204453009295143342012-11-28T23:28:00.001-08:002012-11-28T23:28:11.797-08:00Loading form Library(created programmatically) in InfoPath form<div>
<b>Scenario:</b> </div>
<div>
1) Form Library is created using Visual Studio 2010 ....follow the link below for steps of creating form library using visual studio. </div>
http://microsofttechnologies.blogspot.com.au/2012/11/creating-sp-2010-form-library-using.html<div>
<br /></div>
<div>
<br /></div>
<div>
2) Infopath form is created with few fields on it , <b>when the user tries to publish the form to form library which was created using Visual Studio....it doesn't appear in Infpath Form Library list.</b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b>Solution:</b></div>
<div>
<b><br /></b></div>
<div>
<br /></div>
<div>
Open List Definition in Visual Studio and change URL by removing List before slash </div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<b>Wrong</b>-----This form library will not appear in infopath form when we try to publish a form and want to select a form library which was created before..</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<div>
<listinstance br="br" title="ListTitle"></listinstance></div>
<div>
OnQuickLaunch="TRUE" </div>
<div>
TemplateType="115" </div>
<div>
<b> Url="Lists\ListURL" </b></div>
<div>
Description="List Description"> </div>
<div>
</div>
</div>
<br /><div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<b>Correct</b>-----This form library will appear in infopath form when we try to publish a form and want to select a form library which was created before..</div>
<div>
<div>
<listinstance br="br" title="ListTitle"></listinstance></div>
<div>
OnQuickLaunch="TRUE" </div>
<div>
TemplateType="115" </div>
<div>
<b> Url="ListURL" </b></div>
<div>
Description="List Description"> </div>
<div>
</div>
</div>
Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-48553090039748637272012-11-28T23:20:00.001-08:002012-11-28T23:20:42.973-08:00Creating SP 2010 Form Library using Visual Studio 20101) Open Visual Studio, in New Project select SharePoint 2010 and then select an empty project. (Create an empty SharePoint project)<div>
<br /></div>
<div>
2) Add a new List or List based on selected content type. </div>
<div>
<br /></div>
<div>
3) Open <b>List template definition</b> and change it to (List Template not list definition) </div>
<div>
<div>
<listtemplate br="br" nbsp="nbsp"></listtemplate></div>
<div>
Name="ListName" </div>
<div>
Type="115" </div>
<div>
BaseType="1" </div>
<div>
OnQuickLaunch="TRUE" </div>
<div>
SecurityBits="11" </div>
<div>
Sequence="120" </div>
<div>
DisplayName="List Display Name" </div>
<div>
Description="List Description" </div>
<div>
Image="/_layouts/images/itfl.png" </div>
<div>
DocumentTemplate="1000"/> </div>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
4) Build the project and deploy it, it will create a form library in SharePoint with the name you specified above. </div>
Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-65851022053937500142012-11-28T22:54:00.000-08:002012-11-28T23:38:33.692-08:00Promoting Infopath form fields to SharePoint - with out duplication<b>Scenario:</b><br />
SharePoint 2010 form library is created using object model or schema definition in Visual Studio 2010 and form is created in InfoPath 2010 using InfoPath designer, When the fields are promoted to SharePoint Form library from InfoPath form it duplicates the filed in Form Library.<br />
<b><br /></b>
<b><br /></b>
<b>Solution:</b><br />
When you promote a field from infopath form to sharepoint it creates a new field in form library with the name of promoted field, even if the field with that name exist it creates a new field and give it different internal name.<br />
<br />
Solution is when you are promoting a field from infopath form , select that field modify it select the SiteColumn group and SiteColumn from dropdowns as shown in figure belw....<br />
<br />
<br />
For Example: if you have created a column which exist in DSL Columns group select DSL Columns from drop down.<br />
<br />
now select the name of field from Site Column and click ok<br />
<br />
Do same steps for all promoted fields...if you have already created those fields in FormLibrary...<br />
<br />
Check the Image below with screenshot highlighting points above ...<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-5Uy0kF_JFQs/ULcQ8KoD3gI/AAAAAAAAAYg/coIVSBZxu28/s1600/Untitled.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="107" src="http://1.bp.blogspot.com/-5Uy0kF_JFQs/ULcQ8KoD3gI/AAAAAAAAAYg/coIVSBZxu28/s320/Untitled.png" width="320" /></a></div>
<br />Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-12911500241913125202012-11-20T17:59:00.001-08:002012-11-20T17:59:09.156-08:00Create a content type with out Title Field<b>Scenario:-</b><br />
<br />
<br />
Create a content type in SharePoint 2010 based on item content type but it should not have a title field.<br />
<br />
<br />
<b>Solution:-</b><br />
1) Create an empty solution in visual studio 2010.<br />
<br />
2) Add new item-> Content Type<br />
<br />
3) Extend your content type from <b>item</b> content type.<br />
<br />
4) now open the file and change inherits to False.<br />
<br />
<br />
<br />
<contenttype id="GUID" p="p"> Name="ContentTypeName"<br />
Group="ContentType Group"<br />
Description="ContentType Description"<br />
<b> Inherits="FALSE"</b><br />
Version="0"><br />
</contenttype>Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-67175166053912622362012-11-18T20:32:00.000-08:002012-11-18T20:32:34.665-08:00Set Default Value in People Picker FieldThis post explains that how to set default value in people picker field in infopath 2010, i have picked current user in my example but it can be another field value on form, any function etc...
<br>
People picker field has <br>
Display Name<br>
AccountID <br>
Account Type <br>
<br>
in it....
<br>
you can set default values for each of these fields....
<br>
1) Add a people picker on infopath form
<br>
2) Take properties of any of above (sub fields) [I have picked Account ID in my example]
<br>
You can take properties by selecting AccountID in left hand field pan and right click, properties.
<br>
3) Set the default value for this as show in image below....
<br>
[i set it to current user, you can pick any other field value or function etc]
<br>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-X1VhSDHGGy4/UKm2BEIkdDI/AAAAAAAAAYQ/jIeKLyxeR-s/s1600/image.png" imageanchor="1" style="margin-left:1em; margin-right:1em"><img border="0" height="202" width="320" src="http://4.bp.blogspot.com/-X1VhSDHGGy4/UKm2BEIkdDI/AAAAAAAAAYQ/jIeKLyxeR-s/s320/image.png" /></a></div>
Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com1tag:blogger.com,1999:blog-27858375.post-13089601423549489142012-10-07T17:43:00.001-07:002012-11-20T17:38:49.673-08:00SharePoint 2010 - Programmatically Copy Picture to Image Library on Item AddedSharePoint 2010 - Pro grammatically Copy Picture to Image Library on Item Added
<br>
Scenario:<br>
Two Picture Libraries <br>
PicLib and PicLib2<br>
<br>
Requirement:
<br>When an image is uploaded by user in First Picture Library upload the same image in PicLib2.
<br>
Solution
<br>
Create a new Project in VS 2010 (Event Receiver Project)
<br>Select the site where you want to deploy this
<br>Select the source List (PicLib in our scenario) and ItemAdded event
<br>Write Code below in ItemAdded
<br>
<br>
public override void ItemAdded(SPItemEventProperties properties)
<br>{
<br>base.ItemAdded(properties);
<br>
<br>try
<br>{
<br>SPList lib1 = (SPDocumentLibrary) properties.Web.Lists ["piclib"];
<br>SPList lib2 = (SPDocumentLibrary)properties.Web.Lists["piclib2"];
<br>SPListItem item1 = properties.ListItem;
<br>byte[] fileBytes = item1.File.OpenBinary();
<br>string destinationUrl = lib2.RootFolder.Url + "/" + item1.File.Name;
<br>SPFile destFile = lib2.RootFolder.Files.Add(destinationUrl , fileBytes, true);
<br>
<br>}
<br>catch (Exception e)
<br>{
<br>throw e;
<br>}
<br>}Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-11376169213678367212012-09-25T08:14:00.003-07:002012-09-25T08:14:54.851-07:00September 2012 Perth SharePoint User Group - Apps for SharePoint 2013
September 2012 Perth SharePoint User Group Meeting - Apps for SharePoint 2013
Perth SharePoint User Group
Tuesday, September 25, 2012 from 12:15 PM to 1:15 PM (WST)
Perth, Australia
For the September 2012 Perth SharePoint User Group meeting, Khalil Khan, Perth based SharePoint Server MVP and SharePoint Architect at Velrada will be presenting on the new App Model for SharePoint 2013.
SharePoint 2013 has introduced exciting new features for both the developers and business users alike. This session will focus on this new App Model and how to make best use of it for building effective SharePoint solutions.
The presentation will cover:
A brief overview of App Model for SharePoint 2013;
Comparison of app models with SharePoint Solutions;
Design Considerations and Development Tools; and
Building/Deploying Apps for SharePoint 2013.
Velrada is proud to sponsor the event, with a pizza lunch provided.
http://september2012perthsharepointusergroup.eventbrite.com/?ref=esfbenivte001
Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0tag:blogger.com,1999:blog-27858375.post-49805825514075854022012-09-11T18:47:00.001-07:002012-09-11T18:47:07.687-07:00Authentication Model in SharePoint 2013<br />
<br />
<b>New Authentication Model in SharePoint 2013<br />
</b>SP 2013 preview is available now for few weeks and I am sure many of you have tried SharePoint 2013 by installing it on your standalone box/VM or by getting an account on SharePoint Online, When you log into SharePoint for the first time it looks like that nothing has really changed in terms of authentication but when you dig down Microsoft has made changes to authentication model of SharePoint 2013. <br />
<br />
In SharePoint 2010 Claims based authentication was the default authentication mode for SharePoint 2013 web apps and now SharePoint can leverage OAuth and Server to Server (S2S Authentication)<br />
<br />
<b>Background of Authentication in SharePoint from 2007 to 2013<br />
</b>MOSS 2007 was base d on capabilities of IIS to provide authentication what we call Classic Authentication Mode, Classic Auth support Basic and Forms Auth , NTML or Kerberos modes but at one time single authentication mechanism was supported on a MOSS web application. <br />
SharePoint 2010 introduced a new authentication mode what we call Claims based authentication, Claims supports FBA and Basic but still Classic was default auth mode for SP 2010 apps.<br />
Claims based auth uses “tokens” that identify the user and specific, customizable attributes about the user (username, email, full name, etc.). Each attribute is known as a claim.<br />
In Preview SharePoint 2013 doesn’t support Classic Auth from UI but you can still do that using power shell . <br />
<br />
<b>Server to Server (S2S) Authentication and OAuth for SP 2013 Apps<br />
</b><br />
Server to Server Authentication is another change in auth area in Sharepoint 2013, New server products including SharePoint 2013, Exchange and Lync 2013 are using S2S . This is similar to OAuth for Applications but is for an entire server and is actually delegating the user’s identity to the remote server. <br />
S2S relies on claims behind the scenes to delegate the user’s identity. Where it differs from straight claims is that the delegation is automatic and doesn’t have to be initiated by the user. <br />
<br />
OAuth is some thing which is there for a while now and the current version of OAuth is I believe OAuth 2, it is used widely on web these days specially on social networking Apps including open social etc. <br />
In SharePoint 2013, OAuth provides authorization for apps to access specific user resources without the user needing to provide credentials to the app. The idea is to establish a trust ….. Regardless of where the app is actually hosted (on-premise or in the cloud), between the app server and SharePoint allowing the app access to the resources it’s requested.<br />
<br />
In the case of an on-premise app, everything is negotiated between the server and SharePoint and an implicit trust exists. This comes from the app being hosted on SharePoint. For the case of cloud-based apps, SharePoint trusts the Azure Access Control Service (ACS). <br />
Khalil ur Rehmanhttp://www.blogger.com/profile/01985229048140471707noreply@blogger.com0