tag:blogger.com,1999:blog-87699809326548133192024-03-17T00:42:06.486-07:00MSSQL SERVER DBA's ParadiseGanapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.comBlogger77125tag:blogger.com,1999:blog-8769980932654813319.post-20627642252322185772023-08-08T08:51:00.005-07:002023-08-08T08:52:01.564-07:00AWS RDS SQL Server Announcements - 2022 & 2023<p><br /></p><p></p><ul style="text-align: left;"><li>RDS Custom for SQL Server now supports Local Time Zones</li><li>Amazon RDS for SQL Server supports minor version 2019 CU21</li><li>Amazon RDS for SQL Server now supports self-managed Active Directory</li><li>Amazon RDS for SQL Server supporAmazon RDS for SQL Server now supports SQL Server 2016 SP3, 2017 CU27, and 2019 CU15ts minor versions 2014 GDR, 2016 GDR, 2017 CU31 GDR, and 2019 CU20</li><li>RDS Custom for SQL Server lets you Bring Your Own Media</li><li>RDS Custom for SQL Server now supports Multi-AZ deployments</li><li>Amazon RDS for SQL Server now supports Cross Region Automated Backups with encryption</li><li>Database Activity Streams now supports Amazon RDS for SQL Server</li><li>Amazon RDS for SQL Server now supports email subscription for SQL Server Reporting Services (SSRS)</li><li>Amazon RDS Proxy now supports Amazon RDS for SQL Server</li><li>Amazon RDS for SQL Server Now Supports TDE enabled SQL Server Database Migration</li><li>Amazon RDS for SQL Server now supports SQL Server 2014 SP3 CU4 SU</li><li>Amazon RDS for SQL Server now supports SQL Server 2016 SP3, 2017 CU27, and 2019 CU15</li><li>Amazon RDS for SQL Server now supports SSAS Multidimensional</li><li>Amazon RDS for SQL Server now supports new minor versions for SQL Server 2019 and 2017</li><li>Amazon RDS for SQL Server now supports Always On Availability Groups for Standard Edition 2017</li><li>Amazon RDS for SQL Server now supports M6i and R6i instances</li><li>Amazon RDS for SQL Server now supports SQL Server Agent job replication</li><li>Amazon RDS Custom for SQL Server now supports Custom Engine Version to improve resiliency of customizations</li><li>Amazon RDS Custom for SQL Server now supports AWS CloudFormation Templates</li><li>Amazon RDS for SQL Server now supports Cross Region Read Replica</li><li>Amazon RDS for SQL Server now supports a linked server to Oracle</li><li>Amazon RDS for SQL Server Now Supports Access to Transaction Log Backups</li><li>Amazon RDS Proxy now supports Amazon RDS for SQL Server</li><li>Amazon RDS Custom for SQL Server now supports scaling storage</li><li>Amazon RDS for SQL Server supports M6i, R6i and R5b instances in additional regions</li><li>Amazon RDS for SQL Server now supports email subscription for SQL Server Reporting Services (SSRS)</li><li>Amazon RDS for SQL Server now supports secondary host metrics in Enhanced Monitoring</li><li>Amazon RDS for SQL Server now supports self-managed Active Directory</li></ul><p></p><div><br /></div>Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-31538796108674565212023-05-31T08:42:00.004-07:002023-05-31T08:42:36.750-07:00Microsoft Announcement: Microsoft Fabric<p>Yesterday at Microsoft Build, a significant announcement took place—the introduction of <a href="https://www.microsoft.com/en-us/microsoft-fabric" target="_blank">Microsoft Fabric</a>, which is now available for public preview. Satya Nadella, the CEO of Microsoft, went as far as describing Microsoft Fabric as "The biggest launch of a Microsoft data product since the launch of SQL Server." In this blog post, I will provide an introduction to Microsoft Fabric and component involved.</p><p>To truly grasp the concept of Microsoft Fabric, envision it as an extension of Power BI that integrates SaaS versions of various Microsoft analytical products into the Power BI workspace, now referred to as a Fabric workspace.</p><h3 style="text-align: left;"><b>Microsoft Fabric</b></h3><p><b>Microsoft Fabric</b> is an integrated analytics solution designed for enterprises. It encompasses various aspects of analytics, including data movement, data science, real-time analytics, and business intelligence. The platform offers a comprehensive set of services, such as data lake, data engineering, and data integration, all in one place. Unlike using multiple services from different vendors, Fabric provides a highly integrated and user-friendly product that simplifies analytics requirements. It is built on a Software as a Service (SaaS) foundation, which enhances simplicity and integration.</p><p><br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEg6Gq9umWV_vyWwK_oElCTFGBcvinbh_7GiDafqeBw1dgCJ85bKCW002f0kueKftiuNCarCvZQoHQ3POJLERUM6KFlj8MGcz9nMclKPQyDEGRZR9E7Xh6Z8yv0Jq1U4AU2XsrphiZ4eJSU7HybDQAJYzTNEnRTV1wvfsjTuTKyXlZ-cnp2RNmwRX6s" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="357" data-original-width="950" height="150" src="https://blogger.googleusercontent.com/img/a/AVvXsEg6Gq9umWV_vyWwK_oElCTFGBcvinbh_7GiDafqeBw1dgCJ85bKCW002f0kueKftiuNCarCvZQoHQ3POJLERUM6KFlj8MGcz9nMclKPQyDEGRZR9E7Xh6Z8yv0Jq1U4AU2XsrphiZ4eJSU7HybDQAJYzTNEnRTV1wvfsjTuTKyXlZ-cnp2RNmwRX6s=w400-h150" width="400" /></a></div><br /><br /><p></p><p>Microsoft Fabric is an integrated environment that combines components from Power BI, Azure Synapse, and Azure Data Explorer into a unified platform. It offers customized user experiences and brings together various functionalities like Data Engineering, Data Factory, Data Science, Data Warehouse, Real-Time Analytics, and Power BI.</p><p>The integration of these components on a shared <b>Software as a Service (SaaS)</b> foundation brings several benefits. It provides a wide range of deeply integrated analytics capabilities, offering a comprehensive solution for industry needs. Users can leverage shared experiences that are familiar and easy to learn, promoting efficiency and collaboration.</p><p>Developers can access and reuse assets easily, enhancing productivity and enabling faster development cycles. The platform allows for a unified data lake, enabling data to be stored in its original location while utilizing preferred analytics tools. This centralizes administration and governance across all experiences, simplifying management tasks.</p><p>The Microsoft Fabric SaaS experience seamlessly integrates data and services, eliminating the need for users to handle or understand the underlying infrastructure. Core enterprise capabilities can be centrally configured, and permissions are automatically applied across all services. Data sensitivity labels are also inherited across the suite.</p><p>Microsoft Fabric is a comprehensive analytics platform that offers a range of experiences designed to seamlessly work together. Each experience is tailored to a specific task and user persona, covering various aspects of analytics. Here are the key experiences provided by Fabric:</p><p>1. Data Engineering: This experience offers a powerful Spark platform for data engineers to perform large-scale data transformations and democratize data through the lakehouse. It integrates with Data Factory for scheduling and orchestration.</p><p>2. Data Factory: Azure Data Factory combines the simplicity of Power Query with the scalability of Azure Data Factory. It provides over 200 connectors to connect to on-premises and cloud data sources.</p><p>3. Data Science: The Data Science experience allows building, deploying, and operationalizing machine learning models within Fabric. It integrates with Azure Machine Learning for experiment tracking and model registry, enabling data scientists to enrich organizational data with predictions.</p><p>4. Data Warehouse: Fabric's Data Warehouse experience offers industry-leading SQL performance and scalability. It separates compute and storage, allowing independent scaling of both components. It also supports the open Delta Lake format.</p><p>5. Real-Time Analytics: This experience is designed for analyzing observational data collected from various sources like apps, IoT devices, and human interactions. It excels in handling semi-structured data with shifting schemas.</p><p>6. Power BI: Power BI is a leading Business Intelligence platform that allows business owners to access and analyze data from Fabric quickly and intuitively, enabling better decision-making.</p><p>By bringing together these experiences into a unified platform, Microsoft Fabric offers a comprehensive big data analytics solution. It enables organizations and individuals to leverage large and complex data repositories for actionable insights and analytics. Additionally, Fabric implements the data mesh architecture, which focuses on decentralized data ownership and domain-driven data products.</p><p><b>OneLake</b> is a unified and logical data lake provided within Microsoft Fabric. Similar to how OneDrive serves as a central storage solution for individual users, OneLake serves as a centralized repository for analytics data within an organization. It is automatically available for every Microsoft Fabric tenant and is designed to be the single location for storing and managing all analytics data. With OneLake, organizations can benefit from having one data lake that caters to the entire organization's analytics needs, promoting data consistency, accessibility, and collaboration.</p><p>In the context of a SaaS service like Microsoft Fabric, a "<b>tenant</b>" refers to a customer's organization or account. The concept of a tenant provides unique benefits, including clear boundaries for governance and compliance, which are controlled by the tenant admin. By default, any data that is stored in OneLake, the unified data lake within Fabric, is governed within the boundaries set by the tenant admin.</p><p>While the tenant admin has control over the governance and compliance aspects, it is important to avoid the admin becoming a central gatekeeper that hinders contributions from other parts of the organization. Within a tenant, multiple workspaces can be created, enabling different parts of the organization to distribute ownership and access policies. This allows for decentralized management and ensures that various teams or departments can contribute to OneLake without relying solely on the admin.</p><p><br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgYLZPCpdtWuY0YF9m5tJ4CloKgcKyyBRkta-E0ijnW9oAs6eROfGQhdrJ9CdK3REydoFDwbGOXOzL7fqm-ZUVXoabHkuz4ss8_UuObSlvIahtr4CDuWtqeTxPvHi3rAPbol3YJEwaUyFNOd3WW6Y2SMZibGk-YJaDWf5WSQI5HhGm9qWUlLvof-S8" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="352" data-original-width="570" height="248" src="https://blogger.googleusercontent.com/img/a/AVvXsEgYLZPCpdtWuY0YF9m5tJ4CloKgcKyyBRkta-E0ijnW9oAs6eROfGQhdrJ9CdK3REydoFDwbGOXOzL7fqm-ZUVXoabHkuz4ss8_UuObSlvIahtr4CDuWtqeTxPvHi3rAPbol3YJEwaUyFNOd3WW6Y2SMZibGk-YJaDWf5WSQI5HhGm9qWUlLvof-S8=w400-h248" width="400" /></a></div><br /><br /><p></p><p>Each <b>workspace</b> is associated with a specific region and has its own capacity, which is billed separately. This allows for granular control and cost management within the organization. By creating workspaces, organizations can effectively distribute ownership and access policies, promoting collaboration while maintaining proper governance and compliance within the boundaries defined by the tenant admin.</p><p>In a Microsoft Fabric workspace, data is organized and accessed through data items. These items serve as containers for different types of data within OneLake, similar to how Office files like Word, Excel, and PowerPoint are stored in OneDrive. Fabric supports various types of data items, including lakehouses, warehouses, and other related components.</p><p>The use of data items allows for tailored experiences based on the specific needs and roles of different personas within the organization. For example, a Spark developer may have a dedicated data item for their lakehouse, providing them with a customized experience for their data transformation and analysis tasks.</p><p>To get started with OneLake and create a lakehouse, you can refer to the documentation on "Creating a lakehouse with OneLake." This resource will provide guidance on setting up and utilizing OneLake within Microsoft Fabric, allowing you to leverage the benefits of a unified data lake and tailored experiences for different personas.</p><p><br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEggVHr8jqfbKjmigKh0HNmfh9o479qHKpHGxUV9-1A-CgYjMJk146rhaA04E15vmQrU7CaUIM75YR14iqShdGifFHLkQR_rcwFHX4sgY-UrxiApk42bO3Qci3rEGt6w0EiPLF1WXGvJFN7ySOblJpqyKfM9ciaPkzHnkS-y-m9GPGLYGKQl7I3tisc" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="633" data-original-width="1100" height="230" src="https://blogger.googleusercontent.com/img/a/AVvXsEggVHr8jqfbKjmigKh0HNmfh9o479qHKpHGxUV9-1A-CgYjMJk146rhaA04E15vmQrU7CaUIM75YR14iqShdGifFHLkQR_rcwFHX4sgY-UrxiApk42bO3Qci3rEGt6w0EiPLF1WXGvJFN7ySOblJpqyKfM9ciaPkzHnkS-y-m9GPGLYGKQl7I3tisc=w400-h230" width="400" /></a></div><br /><br /><p></p><p><br /></p><h3 style="text-align: left;">OneLake</h3><p>OneLake, built on Azure Data Lake Storage Gen2, provides open support for various file types, whether structured or unstructured. All data items within Microsoft Fabric, such as data warehouses and lakehouses, automatically store their data in OneLake using the delta parquet format. This means that regardless of whether a data engineer loads data into a lakehouse using Spark or a SQL developer loads data into a fully transactional data warehouse using T-SQL, all contributions contribute to building the same data lake.</p><p>Tabular data is stored in OneLake using the delta parquet format, ensuring efficient storage and retrieval. OneLake supports the same Azure Data Lake Storage Gen2 APIs and SDKs, making it compatible with existing applications that utilize ADLS Gen2, including Azure Databricks. This allows for seamless integration and compatibility with existing workflows and tools.</p><p>Data within OneLake can be addressed as if it were a single, large ADLS storage account for the entire organization. Each workspace within Fabric appears as a container within that storage account, and different data items are organized as folders within those containers. This logical organization makes it easier to navigate and manage data within OneLake while leveraging the capabilities and compatibility of Azure Data Lake Storage Gen2.</p><p>The OneLake file explorer allows users to interact with their data lakes directly from their Windows machines, providing a convenient and intuitive interface. Users can explore and manage their data items within workspaces, perform file operations, and leverage familiar features just like they would with Office files in OneDrive.</p><p>By offering a file explorer-like experience, OneLake brings the power of data lakes to the hands of business users, eliminating the need for specialized technical knowledge. This enables a broader range of users to effectively work with and derive insights from the data stored in OneLake. </p><p>The goal of OneLake is to enable users to leverage the full value of their data without the overhead of duplicating or transferring it. This approach promotes efficiency, reduces complexity, and facilitates better collaboration and analysis by breaking down data silos and enabling data to be analyzed in its original location.</p><p>In summary, OneLake eliminates the need for data duplication and movement, ensuring that organizations can derive maximum value from their data without unnecessary complexity or data silos.</p><p>Overall, Fabric empowers creators to focus on their work without worrying about integrating or managing the underlying infrastructure, fostering productivity and enabling a streamlined analytics experience.</p><div><br /></div>Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-18402671821133790372022-06-16T01:21:00.002-07:002022-06-16T01:21:51.885-07:00Migrate Amazon RDS for SQL Server to Azure SQL Managed Instance. <p><span data-contrast="none" face="SegoeUI, Lato, "Helvetica Neue", Helvetica, Arial, sans-serif" style="background-color: white; box-sizing: border-box; color: #333333; font-size: 14px;">Applications are closely dependent on the databases and application evolution is frequently connected with an upgrade of the application database. Database migration is process of moving customer’s database from a source instance to a destination instance. This process includes not only the move from one instance to another, but also a modernization process - from one version of SQL Server to a newer one (or from a legacy & unsupported to a supported one).</span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}" face="SegoeUI, Lato, "Helvetica Neue", Helvetica, Arial, sans-serif" style="background-color: white; box-sizing: border-box; color: #333333; font-size: 14px;"> </span></p><p><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}" face="SegoeUI, Lato, "Helvetica Neue", Helvetica, Arial, sans-serif" style="background-color: white; box-sizing: border-box; color: #333333; font-size: 14px;"><span data-contrast="none" style="box-sizing: border-box;">There are multiple ways to migrate databases hosted in </span><a href="https://aws.amazon.com/rds/sqlserver/" rel="noopener nofollow noreferrer" style="box-sizing: border-box; color: #146cac;" target="_blank"><span data-contrast="none" style="box-sizing: border-box;">Amazon Relational Database Service (Amazon RDS) for SQL Server</span></a><span data-contrast="none" style="box-sizing: border-box;"> to </span><a href="https://azure.microsoft.com/en-us/products/azure-sql/managed-instance/" rel="noopener noreferrer" style="box-sizing: border-box; color: #146cac;" target="_blank"><span data-contrast="none" style="box-sizing: border-box;">Azure SQL Managed Instance</span></a><span data-contrast="none" style="box-sizing: border-box;">. For use cases such as migrating from </span><a href="http://aws.amazon.com/ec2" rel="noopener nofollow noreferrer" style="box-sizing: border-box; color: #146cac;" target="_blank"><span data-contrast="none" style="box-sizing: border-box;">Amazon Elastic Compute Cloud</span></a><span data-contrast="none" style="box-sizing: border-box;"> (Amazon EC2) to SQL Server on Azure SQL Managed Instance, you can use a number of ways and tools, including </span><a href="https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15" rel="noopener noreferrer" style="box-sizing: border-box; color: #146cac;" target="_blank"><span data-contrast="none" style="box-sizing: border-box;">Database Migration Assistant (DMA)</span></a><span data-contrast="none" style="box-sizing: border-box;"> <a href="https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-feature-overview" rel="noopener noreferrer" style="background-color: transparent; box-sizing: border-box; color: #146cac;" target="_self">Link feature for SQL Managed Instance</a> or </span><a href="https://docs.microsoft.com/en-gb/azure/azure-sql/managed-instance/log-replay-service-migrate" rel="noopener noreferrer" style="box-sizing: border-box; color: #146cac;" target="_blank"><span data-contrast="none" style="box-sizing: border-box;">Log Replay Service</span></a><span data-contrast="none" style="box-sizing: border-box;">. When it comes to migrating RDS for SQL databases, </span><span data-contrast="none" style="box-sizing: border-box;">we cannot use DMA or Log Replay Service methods because RDS SQL Server takes backups without checksum enabled and both of these methods require backups to have the checksum enabled in order to verify the consistency at the restore time. </span><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}" style="box-sizing: border-box;"> </span></span></p><p><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}" face="SegoeUI, Lato, "Helvetica Neue", Helvetica, Arial, sans-serif" style="background-color: white; box-sizing: border-box; color: #333333; font-size: 14px;"><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}" style="box-sizing: border-box;"><br /></span></span></p><p><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}" face="SegoeUI, Lato, "Helvetica Neue", Helvetica, Arial, sans-serif" style="background-color: white; box-sizing: border-box; color: #333333; font-size: 14px;"><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}" style="box-sizing: border-box;">This is the Multi blog post series on the Amazon RDS for SQL Server to <strong style="box-sizing: border-box;">Azure SQL Managed Instance</strong> migration that will serve as an introduction and an overview of the series.<br style="box-sizing: border-box;" /><br /></span></span></p><p><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}" face="SegoeUI, Lato, "Helvetica Neue", Helvetica, Arial, sans-serif" style="background-color: white; box-sizing: border-box; color: #333333; font-size: 14px;"><span data-ccp-props="{"134233117":true,"134233118":true,"201341983":0,"335559739":160,"335559740":240}" style="box-sizing: border-box;">In the later posts of these series, we compare different migration methods to help you to understand the features, benefits, nature of complexity, trade-off's involved in each of them.</span></span></p><p><br /></p><p><span color="rgba(0, 0, 0, 0.9)" face="-apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif" style="background-color: white; font-size: 14px;">📌 Links to bookmark: 📌</span><br style="background-color: white; box-sizing: inherit; color: rgba(0, 0, 0, 0.9); font-family: -apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif; font-size: 14px; line-height: inherit;" /><br style="background-color: white; box-sizing: inherit; color: rgba(0, 0, 0, 0.9); font-family: -apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif; font-size: 14px; line-height: inherit;" /><span><span color="rgba(0, 0, 0, 0.9)" face="-apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif" style="background-color: white;">Part 1<span style="font-size: medium;"> - </span></span></span><span face="SegoeUI, Lato, "Helvetica Neue", Helvetica, Arial, sans-serif" style="background-color: white; color: #333333;"><a href="https://techcommunity.microsoft.com/t5/azure-sql-blog/migrate-amazon-rds-for-sql-server-to-azure-sql-managed-instance/ba-p/3297872" target="_blank">Migrate Amazon RDS for SQL Server to Azure SQL Managed Instance – Part 1 (Overview)</a></span></p><p><span><span color="rgba(0, 0, 0, 0.9)" face="-apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif" style="background-color: white;">Part 2 <span style="font-size: medium;">- </span></span></span><span face="SegoeUI, Lato, "Helvetica Neue", Helvetica, Arial, sans-serif" style="background-color: white; color: #333333;"><a href="https://techcommunity.microsoft.com/t5/azure-sql-blog/migrate-amazon-rds-for-sql-server-to-azure-sql-managed-instance/ba-p/3369804" target="_blank">Migrate Amazon RDS for SQL Server to Azure SQL Managed Instance – Part 2 (Native Backup & Restore)</a></span></p><p><span style="background-color: white;">Part 3</span><span style="background-color: white; font-size: large;"> - </span><span face="SegoeUI, Lato, "Helvetica Neue", Helvetica, Arial, sans-serif" style="background-color: white; color: #333333;"><a href="https://techcommunity.microsoft.com/t5/azure-sql-blog/migrate-amazon-rds-for-sql-server-to-azure-sql-managed-instance/ba-p/3464489" target="_blank">Migrate Amazon RDS for SQL Server to Azure SQL Managed Instance – Part 3 (Azure Data Factory)</a></span></p>Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-48028414288783694312021-11-15T04:34:00.004-08:002021-11-15T04:34:34.030-08:00Architect a Managed Disaster Recovery on Amazon RDS for SQL Server<p> <span style="background-color: white; font-size: 14px;">Customers often ask for guidance on choosing the right DR solution for RDS SQL Server. In this blog series, we cover the DR solutions available for Amazon RDS for SQL Server. If you're looking for advice on best practices,trade-offs, operational costs & complexity, time to recovery... then this is it!</span></p><p><br style="background-color: white; box-sizing: inherit; color: rgba(0, 0, 0, 0.9); font-family: -apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif; font-size: 14px; line-height: inherit;" /><br style="background-color: white; box-sizing: inherit; color: rgba(0, 0, 0, 0.9); font-family: -apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif; font-size: 14px; line-height: inherit;" /><span color="rgba(0, 0, 0, 0.9)" face="-apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif" style="background-color: white; font-size: 14px;">📌 Links to bookmark: 📌</span><br style="background-color: white; box-sizing: inherit; color: rgba(0, 0, 0, 0.9); font-family: -apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif; font-size: 14px; line-height: inherit;" /><br style="background-color: white; box-sizing: inherit; color: rgba(0, 0, 0, 0.9); font-family: -apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif; font-size: 14px; line-height: inherit;" /><span style="font-size: medium;"><span color="rgba(0, 0, 0, 0.9)" face="-apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif" style="background-color: white;">Part 1 - </span><a href="https://aws.amazon.com/blogs/database/part-1-architect-a-managed-disaster-recovery-on-amazon-rds-for-sql-server/">https://aws.amazon.com/blogs/database/part-1-architect-a-managed-disaster-recovery-on-amazon-rds-for-sql-server/</a><br style="background-color: white; box-sizing: inherit; color: rgba(0, 0, 0, 0.9); font-family: -apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif; line-height: inherit;" /><br style="background-color: white; box-sizing: inherit; color: rgba(0, 0, 0, 0.9); font-family: -apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif; line-height: inherit;" /><span color="rgba(0, 0, 0, 0.9)" face="-apple-system, system-ui, "system-ui", "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif" style="background-color: white;">Part 2 - </span><a href="https://aws.amazon.com/blogs/database/part-2-architect-a-managed-disaster-recovery-on-amazon-rds-for-sql-server/">https://aws.amazon.com/blogs/database/part-2-architect-a-managed-disaster-recovery-on-amazon-rds-for-sql-server/</a></span></p><p><br /></p>Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-87842754975179349532021-11-15T04:33:00.002-08:002021-11-15T04:33:10.437-08:00AWS RDS SQL Server Announcements - 2021<p> </p><h2 style="background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 22px; margin: 0px; position: relative; text-align: center; text-indent: -24px;"><span style="color: #0b5394; font-family: inherit;">AWS RDS SQL Server Announcements - 2021</span></h2><div><span style="color: #0b5394; font-family: inherit;"><br /></span></div><div><span style="color: #0b5394; font-family: inherit;"><br /></span></div><div><ol style="text-align: left;"><li><span style="color: #0b5394;">https://aws.amazon.com/about-aws/whats-new/2021/01/amazon-rds-for-sql-server-now-supports-tempdb-on-local-instance-store-with-r5d-and-m5d-instance-types/<br /><br /></span></li><li><span style="color: #0b5394;">https://aws.amazon.com/about-aws/whats-new/2021/02/amazon-rds-for-sql-server-now-supports-always-on-availability-groups-for-standard-edition/<br /><br /></span></li><li><span style="color: #0b5394;">https://aws.amazon.com/about-aws/whats-new/2021/04/amazon-rds-sql-server-supports-extended-events/<br /><br /></span></li><li><span style="color: #0b5394;">https://aws.amazon.com/about-aws/whats-new/2021/05/amazon-rds-for-sql-server-supports-managed-disaster-recovery-with-amazon-rds-cross-region-automated-backups/<br /><br /></span></li><li><span style="color: #0b5394;">https://aws.amazon.com/about-aws/whats-new/2021/05/announcing-amazon-rds-for-sql-server-on-aws-outposts/<br /><br /></span></li><li><span style="color: #0b5394;">https://aws.amazon.com/about-aws/whats-new/2021/07/amazon-rds-sql-server-supports-new-minor-versions/<br /><br /></span></li><li><span style="color: #0b5394;">https://aws.amazon.com/about-aws/whats-new/2021/09/amazon-rds-sql-server-msdtc-jdbc-xa-sql-server-2017-cu16-plus-sql-server-2019/<br /><br /></span></li><li><span style="color: #0b5394;">https://aws.amazon.com/about-aws/whats-new/2021/09/amazon-rds-sql-server-msdtc-jdbc-xa-sql-server-2017-cu16-plus-sql-server-2019/</span></li></ol></div><div><span style="color: #0b5394;"><br /></span></div><div><span style="color: #0b5394;"><br /></span></div><div><span style="color: #0b5394;"><br /></span></div>Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-83168515420512898512021-08-03T06:37:00.003-07:002021-11-11T04:09:03.600-08:00Architect a disaster recovery for SQL Server on AWS: Part 1<p><span class="break-words"><span><span dir="ltr"> </span></span></span></p><h1 class="lb-h2 blog-post-title"><span style="font-family: times; font-size: x-large;"><span style="color: #ffa400;">New blog post - </span></span>Architect a disaster recovery for SQL Server on AWS</h1><h1 style="text-align: left;"><span style="font-family: times; font-size: x-large;"><span style="color: #ffa400;"></span></span></h1><p><span class="break-words"><span><span dir="ltr"> </span></span></span></p><p><span class="break-words"><span><span dir="ltr">Customers often ask for guidance on choosing the right HA or DR solution for SQL Server on AWS. 🤔<br /><br />In this blog series, there is now a helpful and concise guide into various architectural
best practices available. If you're looking for advice on trade-offs,
operational costs & complexity, time to recovery... then this is it!
🔥<br /><br />Topics include; backup and restore, SQL Server log shipping,
SQL Server database mirroring, SQL Server Always on Failover Cluster
Instances (FCIs), Always On availability groups, AWS Database Migration
Service (AWS DMS) & CloudEndure Disaster Recovery.<br /><br /> 📌 Links to bookmark: 📌<br /><br />Part 1 - <a data-attribute-index="15" href="https://lnkd.in/dG5QQzi">https://aws.amazon.com/blogs/database/part-1-architect-a-disaster-recovery-for-sql-server-on-aws/</a><br />Part 2 - <a data-attribute-index="16" href="https://aws.amazon.com/blogs/database/part-2-architect-a-disaster-recovery-for-sql-server-on-aws/">https://aws.amazon.com/blogs/database/part-2-architect-a-disaster-recovery-for-sql-server-on-aws/</a><br />Part 3 - <a data-attribute-index="17" href="https://aws.amazon.com/blogs/database/part-3-architect-a-disaster-recovery-for-sql-server-on-aws/">https://aws.amazon.com/blogs/database/part-3-architect-a-disaster-recovery-for-sql-server-on-aws/</a><br />Part 4 - <a data-attribute-index="18" href="https://aws.amazon.com/blogs/database/part-4-architect-a-disaster-recovery-for-sql-server-on-aws/">https://aws.amazon.com/blogs/database/part-4-architect-a-disaster-recovery-for-sql-server-on-aws/</a><br /><br />Now go build! 💥🚀<br /><br /><br /></span></span></span></p>Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-62895678420637680482021-08-03T06:30:00.002-07:002021-08-03T06:30:16.658-07:00Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.<h1 style="text-align: left;"><span style="font-family: times; font-size: x-large;"><span style="color: #ffa400;">New blog post</span> - </span><span style="font-weight: normal;"><span style="color: #2b00fe;"><a href="https://aws.amazon.com/blogs/storage/seamlessly-migrate-large-sql-databases-using-aws-snowball-and-aws-datasync/" target="_blank">Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.</a></span></span></h1><p style="text-align: left;"><span style="font-weight: normal;">In this blog post, I covered how to simplify large SQL Server database
migrations by leveraging AWS Snowball, AWS DataSync, and Amazon FSx. I
demonstrated how you can optimize a one-time full backup transfer to AWS
when there is a local network bandwidth constraint using an AWS
Snowball device. I also showed how you can transfer incremental backups
using AWS DataSync and Amazon FSx for Windows File Server, keeping your
SQL Server in AWS up to date until your application cutover. This
solution can help you automate and accelerate data transfer, freeing up
your on-premises storage capacity. By doing so, you can reduce your
organizational costs by moving that data off expensive storage systems.</span> <br /></p>Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-22394258694485579102021-06-15T13:18:00.008-07:002021-08-03T06:38:50.747-07:00<h2 style="text-align: left;"><span style="font-family: times; font-size: x-large;"><span style="color: #ffa400;">New blog post</span> - <span style="color: #232f3e;">Monitor deadlocks in Amazon RDS for SQL Server and set notifications using Amazon CloudWatch</span></span></h2><div><p>In this post, we showed how to publish error and agent log events
directly to CloudWatch Logs and then set up a CloudWatch alarm and SNS
notification for deadlock events that match a specific filter pattern.
With this solution, you can automate RDS for SQL Server error log files
monitoring and alerting. This can help you automate deadlock reporting
and take appropriate actions to resolve deadlocks.</p>
<p>You can use this solution for monitoring other RDS for SQL
Server log events and fatal errors. We showed an example on how to
capture deadlock event metrics using Performance Insights.</p></div><h2><span style="font-family: times; font-size: large;">Checkout my blog post on <span style="color: #232f3e;"><a href="https://aws.amazon.com/blogs/database/monitor-deadlocks-in-amazon-rds-for-sql-server-and-set-notifications-using-amazon-cloudwatch/" target="_blank">Monitor deadlocks in Amazon RDS for SQL Server and set notifications using Amazon CloudWatch</a></span></span></h2><p><br /></p>Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-63916684547361232172021-05-09T15:07:00.012-07:002021-08-03T06:40:01.252-07:00New Blog post- Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration<p> </p><p style="box-sizing: border-box; color: #232f3e; font-weight: 500; line-height: 1.3; margin: 0px; text-align: left; text-rendering: optimizelegibility;"><span style="font-family: helvetica; font-size: large;">Check out my new blog post-<br /><a href="https://aws.amazon.com/blogs/mt/best-practices-for-migrating-microsoft-sql-server-databases-to-amazon-ec2-using-cloudendure/" target="_blank">Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration.</a></span></p><p style="box-sizing: border-box; color: #232f3e; font-weight: 500; line-height: 1.3; margin: 0px; text-align: left; text-rendering: optimizelegibility;"><span style="font-family: helvetica; font-size: large;"> </span></p><p style="box-sizing: border-box; color: #232f3e; font-weight: 500; line-height: 1.3; margin: 0px; text-align: left; text-rendering: optimizelegibility;"><span style="font-family: helvetica; font-size: small;">In this post, we offered some best practices and considerations for
migrating your on-premises SQL Server database to an Amazon EC2 instance
using CloudEndure Migration.</span></p><p style="box-sizing: border-box; color: #232f3e; font-weight: 500; line-height: 1.3; margin: 0px; text-align: left; text-rendering: optimizelegibility;"><br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGvglPaa46A73I4Obgwb5skno2dS3vyOVyHD9CYmMQZPq6mkc2lfPx3MggdhWw7JdYOv3xNBvh6P1smWhyphenhyphenOrdOOozWaygldi_TVANhQQCPUeqJTsJB5xWymzZQPlOrGuhwf_V-sVY6O6k/s720/Slide3.jpeg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="405" data-original-width="720" height="315" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGvglPaa46A73I4Obgwb5skno2dS3vyOVyHD9CYmMQZPq6mkc2lfPx3MggdhWw7JdYOv3xNBvh6P1smWhyphenhyphenOrdOOozWaygldi_TVANhQQCPUeqJTsJB5xWymzZQPlOrGuhwf_V-sVY6O6k/w560-h315/Slide3.jpeg" width="560" /></a></div><br />Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-33156932229940072912020-02-17T03:39:00.004-08:002020-12-04T04:27:36.973-08:00AWS RDS SQL Server Announcements - 2020<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoListParagraph" style="margin-left: 36pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18pt;">
<div class="MsoNormal" style="mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 1;">
<div style="margin-bottom: .0001pt; margin: 0cm;">
<div style="text-align: left;">
<span style="color: orange; font-family: inherit;"><b><br /></b></span>
</div>
</div>
</div>
</div>
<div class="MsoListParagraph" style="margin-left: 36pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18pt;">
<div class="MsoNormal" style="mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 1;">
<div style="margin-bottom: .0001pt; margin: 0cm;">
<div style="text-align: left;">
<div style="text-align: left;">
<h2 style="text-align: center;">
<span style="color: #0b5394; font-family: inherit;"><b>AWS RDS SQL Server Announcements - 2020</b></span></h2>
<div>
<span style="color: #0b5394; font-family: inherit;"><b><br /></b></span></div>
</div>
</div>
</div>
</div>
</div>
<div class="MsoListParagraph" style="margin-left: 36pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18pt;">
<div class="MsoNormal" style="mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 1;">
<div style="margin-bottom: .0001pt; margin: 0cm;">
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: orange; font-family: inherit;"><b>1. Amazon
RDS for SQL Server Now Supports Joining a Domain Across AWS Accounts and VPCs
using Managed Microsoft AD: </b><span class="MsoHyperlink"><a href="https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-for-sql-server-now-supports-joining-domain-across-aws-accounts-and-vpcs-using-microsoft-managed-ad/">https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-for-sql-server-now-supports-joining-domain-across-aws-accounts-and-vpcs-using-microsoft-managed-ad/</a></span><o:p></o:p></span></div>
</div>
</div>
<div style="margin-bottom: .0001pt; margin: 0cm;">
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: orange; font-family: inherit;"><b>2. </b><span style="font-weight: bold;">Amazon RDS for SQL Server now supports Z1d instances:</span><b> </b><a href="https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-for-sql-server-now-supports-z1d-instances/">https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-for-sql-server-now-supports-z1d-instances/</a><o:p></o:p></span></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: orange; font-family: inherit;"><b style="color: orange;">3</b><span style="color: orange;">. </span><b style="color: orange;">Amazon RDS for SQL Server now supports In-Region Read Replicas: </b><span style="color: blue; text-indent: -18pt;"><a href="https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-rds-for-sql-server-now-supports-in-region-read-replicas/">https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-rds-for-sql-server-now-supports-in-region-read-replicas/</a></span></span></div>
<div style="text-align: left;">
<span style="color: orange; font-family: inherit;"><b>4. Amazon RDS for SQL Server supports new Minor Versions: </b></span><a href="https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-rds-for-sql-server-supports-new-minor-versions/" style="text-indent: -18pt;">https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-rds-for-sql-server-supports-new-minor-versions/</a></div>
<div style="text-align: left;">
<span style="color: orange; font-family: inherit;"><b>5. Amazon RDS for SQL Server now supports Windows authentication in more AWS Regions: </b></span><a href="https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-windows-authentication-in-more-aws-regions/" style="text-indent: -18pt;">https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-windows-authentication-in-more-aws-regions/</a></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: orange; font-family: inherit;"><b>6. Amazon RDS for SQL Server now supports Multifile Native Backups: </b><span style="text-indent: -18pt;"><a href="https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-rds-for-sqlserver-now-supports-multi-file-native-backups/">https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-rds-for-sqlserver-now-supports-multi-file-native-backups/</a></span></span></div>
</div>
</div>
<div style="margin-bottom: .0001pt; margin: 0cm;">
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: orange; font-family: inherit;"><b>7</b>. <b>Amazon RDS for SQL Server now supports SQL Server Analysis Services (SSAS):</b><a href="https://www.blogger.com/null" name="Amazon_RDS_for_SQL_Server_now_supports_SQL_Server_Analysis_Services_(SSAS)" style="box-sizing: border-box; text-indent: 0px;"> </a><a href="https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-rds-sql-server-now-supports-sql-server-analysis-service/" style="text-indent: -18pt;">https://aws.amazon.com/about-aws/whats-new/2020/04/amazon-rds-sql-server-now-supports-sql-server-analysis-service/</a></span></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: orange; font-family: inherit;"><b>8. Amazon RDS for SQL Server now supports Distributed </b><b style="text-indent: -18pt;">Transactions:</b> <a href="https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-distributed-transactions/" style="text-indent: -18pt;">https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-distributed-transactions/</a></span></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: orange; font-family: inherit;"><b>9. Amazon RDS for SQL Server supports Bulk Insert on highly available DB Instances using Amazon S3 Integration: </b><a href="https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-sql-server-bulk-insert/" style="text-indent: -18pt;">https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-sql-server-bulk-insert/</a></span></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: orange; font-family: inherit;"><b>10. Amazon RDS for SQL Server now supports SQL Server Reporting Services (SSRS): </b><a href="https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-sql-server-reporting-services/" style="text-indent: -18pt;">https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-sql-server-reporting-services/</a></span><br />
<div style="text-indent: -24px;">
<span style="background-color: white; color: orange; font-family: inherit;"><b><span style="color: orange;">11.</span> Amazon RDS for SQL Server now supports SQL Server Integration Services (SSIS):</b> </span><a href="https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-sql-server-integration-services/" style="text-indent: -18pt;">https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-rds-for-sql-server-now-supports-sql-server-integration-services/</a></div><div style="text-indent: -24px;"><b><span style="color: orange; font-family: Times, Times New Roman, serif; text-indent: 0px;">12. </span></b><span style="font-family: Times, "Times New Roman", serif; text-indent: 0px;"><b><span style="color: orange;">Amazon RDS for SQL Server now supports Windows authentication in the AWS GovCloud (US) Regions:</span></b><span style="color: #e47911;"> </span></span><a href="https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-rds-for-sql-server-now-supports-windows-authentication-in-the-aws-govcloud-regions/" style="text-indent: -18pt;">https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-rds-for-sql-server-now-supports-windows-authentication-in-the-aws-govcloud-regions/</a><br />
<div style="text-indent: -24px;">
<span style="color: orange;"><span style="text-indent: 0px;"><b>13.</b> </span><span style="font-family: Times, Times New Roman, serif; font-weight: bold; text-indent: 0px;">Amazon RDS for SQL Server Supports Disabling Old Versions of TLS and Ciphers</span><span face="AmazonEmberLight, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, sans-serif" style="font-weight: bold; text-indent: 0px;">:</span></span><span face="AmazonEmberLight, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, sans-serif" style="color: #e47911; font-weight: bold; text-indent: 0px;"> </span><a href="https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-rds-for-sql-server-supports-disabling-old-versions-of-tls-and-ciphers/">https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-rds-for-sql-server-supports-disabling-old-versions-of-tls-and-ciphers/</a></div><div style="text-indent: -24px;"><b><span style="color: #ffa400;">14. <a href="https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-rds-for-sql-server-now-supports-service-master-key-retention/"><span style="color: #ffa400;">Amazon RDS for SQL Server now supports Service Master Key Retention</span></a></span></b> <span style="color: #2b00fe;">https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-rds-for-sql-server-now-supports-service-master-key-retention/</span></div><div style="text-indent: -24px;"><span style="color: #ffa400;"><b>15.</b> </span><a name="Amazon_RDS_for_SQL_Server_lowers_the_cost_for_High_Availability_DB_Instances"><span style="color: #ffa400;"><b>Amazon RDS for SQL Server lowers the cost for High Availability DB Instances: </b></span><span style="color: #2b00fe;">https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-rds-for-sql-server-lowers-cost-for-high-availability-db-instances/</span></a></div></div></div></div></div></div></div><div class="MsoListParagraph" style="margin-left: 36pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18pt;"><div class="MsoNormal" style="mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 1;"><div style="margin-bottom: .0001pt; margin: 0cm;"><div style="text-align: left;"><div style="text-align: left;"><div style="text-indent: -24px;"><div><a name="Amazon_RDS_for_SQL_Server_lowers_the_cost_for_High_Availability_DB_Instances"><span style="color: #ffa400;"><b>16. </b></span></a><a name="Amazon_RDS_for_SQL_Server_now_Supports_SQL_Server_Major_Version_2019"><b><span style="color: #ffa400;">Amazon RDS for SQL Server now Supports SQL Server Major Version </span></b>2019 <span style="color: #2b00fe;">https://aws.amazon.com/about-aws/whats-new/2020/08/amazon-rds-for-sql-server-now-supports-sql-server-major-version-2019/</span></a></div></div></div></div></div></div></div><div class="MsoListParagraph" style="margin-left: 36pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18pt;"><div class="MsoNormal" style="mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 1;"><div style="margin-bottom: .0001pt; margin: 0cm;"><div style="text-align: left;"><div style="text-align: left;"><div style="text-indent: -24px;"><a name="Amazon_RDS_for_SQL_Server_lowers_the_cost_for_High_Availability_DB_Instances"></a><a name="Amazon_RDS_for_SQL_Server_lowers_the_cost_for_High_Availability_DB_Instances"></a><div><a name="Amazon_RDS_for_SQL_Server_lowers_the_cost_for_High_Availability_DB_Instances"></a><a name="Amazon_RDS_for_SQL_Server_now_Supports_SQL_Server_Major_Version_2019"></a></div></div></div></div></div></div></div><div class="MsoListParagraph" style="margin-left: 36pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18pt;"><div class="MsoNormal" style="mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 1;"><div style="margin-bottom: .0001pt; margin: 0cm;"><div style="text-align: left;"><div style="text-align: left;"><div style="text-indent: -24px;"><div><div style="text-align: left;"><a name="Amazon_RDS_for_SQL_Server_now_Supports_Trace_Flag_692"><b><span style="color: #ffa400;">17. Amazon RDS for SQL Server now Supports Trace Flag 692</span></b> <span style="color: #2b00fe;">https://aws.amazon.com/about-aws/whats-new/2020/08/amazon-rds-for-sql-server-now-supports-trace-flag-692/</span></a></div><div style="text-align: left;"><a name="Amazon_RDS_for_SQL_Server_Now_Supports_More_Time_Zones"><b><span style="color: #ffa400;">18. Amazon RDS for SQL Server Now Supports More Time Zones</span></b> <span style="color: #2b00fe;">https://aws.amazon.com/about-aws/whats-new/2020/09/amazon-rds-for-sql-server-now-supports-more-time-zones/</span></a></div></div></div></div></div></div></div></div><div class="MsoListParagraph" style="margin-left: 36pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18pt;"><div class="MsoNormal" style="mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 1;"><div style="margin-bottom: .0001pt; margin: 0cm;"><div style="text-align: left;"><div style="text-align: left;"><div style="text-indent: -24px;"><div><a name="Amazon_RDS_for_SQL_Server_Now_Supports_Native_Backup/Restore_on_DB_Instances_with_Read_Replicas"><b><span style="color: #ffa400;">19. Amazon RDS for SQL Server Now Supports Native Backup/Restore on DB Instances with Read Replicas</span></b> <span style="color: #2b00fe;">https://aws.amazon.com/about-aws/whats-new/2020/09/amazon-rds-for-sql-server-now-supports-native-backup-restore-on-db-instances-with-read-replicas/</span></a></div><div><a name="Amazon_RDS_for_SQL_Server_Now_Supports_SQL_Server_Reporting_Services_(SSRS)_on_SQL_Server_2016"><b><span style="color: #ffa400;">20. Amazon RDS for SQL Server Now Supports SQL Server Reporting Services (SSRS) on SQL Server 2016</span></b> <span style="color: #2b00fe;">https://aws.amazon.com/about-aws/whats-new/2020/09/amazon-rds-for-sql-server-now-supports-ssrs-on-sql-server-2016/</span></a></div><div><a name="Amazon_RDS_for_SQL_Server_Now_Supports_High_Availability_in_AWS_US_West_(Northern_California)_Region"><b><span style="color: #ffa400;">21. Amazon RDS for SQL Server Now Supports High Availability in AWS US West (Northern California) Region</span></b> <span style="color: #2b00fe;">https://aws.amazon.com/about-aws/whats-new/2020/09/amazon-rds-for-sql-server-now-supports-high-availability-in-northern-california/</span></a></div><div><a name="Amazon_RDS_for_SQL_Server_now_supports_Database_Mail"><b><span style="color: #ffa400;">22. Amazon RDS for SQL Server now supports Database Mail</span></b> <span style="color: #2b00fe;">https://aws.amazon.com/about-aws/whats-new/2020/11/amazon-rds-sql-server-supports-database-mail/</span></a></div><div><a name="Amazon_RDS_for_SQL_Server_now_supports_the_Business_Intelligence_Suite_on_SQL_Server_2019"><b><span style="color: #ffa400;">23. Amazon RDS for SQL Server now supports the Business Intelligence Suite on SQL Server 2019</span></b> <span style="color: #2b00fe;">https://aws.amazon.com/about-aws/whats-new/2020/11/amazon-rds-for-sql-server-now-supports-the-business-intelligence/</span></a></div></div></div></div></div></div></div><div class="MsoListParagraph" style="margin-left: 36pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18pt;"><div class="MsoNormal" style="mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 1;"><div style="margin-bottom: .0001pt; margin: 0cm;"><div style="text-align: left;"><div style="text-align: left;"><div style="text-indent: -24px;"><div><a name="Introducing_Amazon_RDS_Service_Delivery_Partners"><b><span style="color: #ffa400;">24. Introducing Amazon RDS Service Delivery Partners</span></b> <span style="color: #2b00fe;">https://aws.amazon.com/about-aws/whats-new/2020/12/introducing-amazon-rds-service-delivery-partners/</span></a></div></div></div></div></div></div></div><div class="MsoListParagraph" style="margin-left: 36pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18pt;"><div class="MsoNormal" style="mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 1;"><div style="margin-bottom: .0001pt; margin: 0cm;"><div style="text-align: left;"><div style="text-align: left;"><div style="text-indent: -24px;"><div><div><div><div><div><div><div><div><h1 id="Introducing_Amazon_RDS_Service_Delivery_Partners"><a name="Amazon_RDS_for_SQL_Server_now_supports_the_Business_Intelligence_Suite_on_SQL_Server_2019"></a></h1><div><a name="Introducing_Amazon_RDS_Service_Delivery_Partners"><br /></a></div><div><a name="Introducing_Amazon_RDS_Service_Delivery_Partners"><br /></a></div></div></div></div></div><div><a name="Amazon_RDS_for_SQL_Server_Now_Supports_SQL_Server_Reporting_Services_(SSRS)_on_SQL_Server_2016"><br /></a></div><div><a name="Amazon_RDS_for_SQL_Server_Now_Supports_SQL_Server_Reporting_Services_(SSRS)_on_SQL_Server_2016"><br /></a></div></div><div><a name="Amazon_RDS_for_SQL_Server_Now_Supports_Native_Backup/Restore_on_DB_Instances_with_Read_Replicas"><br /></a></div></div></div></div>
<br /></div>
</div>
</div>
</div>
</div>
</div>
<div class="MsoListParagraph" style="margin-left: 36pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18pt;">
<div class="MsoNormal" style="mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 1;">
<div style="margin-bottom: .0001pt; margin: 0cm;">
<span style="font-family: "times" , "times new roman" , serif;"><br /></span></div>
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-IE</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
DefSemiHidden="false" DefQFormat="false" DefPriority="99"
LatentStyleCount="376">
<w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 9"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="header"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footer"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index heading"/>
<w:LsdException Locked="false" Priority="35" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of figures"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope return"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="line number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="page number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of authorities"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="macro"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="toa heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 5"/>
<w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Closing"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Signature"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="true"
UnhideWhenUsed="true" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Message Header"/>
<w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Salutation"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Date"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Note Heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Block Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="FollowedHyperlink"/>
<w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Document Map"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Plain Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="E-mail Signature"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Top of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Bottom of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal (Web)"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Acronym"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Cite"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Code"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Definition"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Keyboard"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Preformatted"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Sample"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Typewriter"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Variable"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Table"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation subject"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="No List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Contemporary"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Elegant"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Professional"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Balloon Text"/>
<w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Theme"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" QFormat="true"
Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" QFormat="true"
Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" QFormat="true"
Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" QFormat="true"
Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" QFormat="true"
Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" QFormat="true"
Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" SemiHidden="true"
UnhideWhenUsed="true" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
<w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
<w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
<w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
<w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
<w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
<w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
<w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Mention"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Smart Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hashtag"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Unresolved Mention"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Smart Link"/>
</w:LatentStyles>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:3 0 0 0 1 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-536859905 -1073732485 9 0 511 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-noshow:yes;
mso-style-priority:99;
color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-noshow:yes;
mso-style-priority:99;
color:#954F72;
mso-themecolor:followedhyperlink;
text-decoration:underline;
text-underline:single;}
p
{mso-style-noshow:yes;
mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman",serif;
mso-fareast-font-family:"Times New Roman";}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}
@page WordSection1
{size:595.0pt 842.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;
mso-header-margin:35.4pt;
mso-footer-margin:35.4pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}
</style>
<![endif]-->
<!--StartFragment-->
<!--EndFragment--><br />
<div class="MsoNormal">
<br /></div>
</div>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:-536870145 1107305727 0 0 415 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-536859905 -1073732485 9 0 511 0;}
@font-face
{font-family:"\0022helveticaneue\0022";
panose-1:2 11 6 4 2 2 2 2 2 4;
mso-font-alt:Cambria;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:auto;
mso-font-signature:0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-noshow:yes;
mso-style-priority:99;
color:#954F72;
mso-themecolor:followedhyperlink;
text-decoration:underline;
text-underline:single;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}</style></div>
</div>
Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-11441566529318803502020-01-29T08:51:00.000-08:002020-05-19T04:56:22.922-07:00AWS RDS SQL Server Announcements - 2019<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<h2 style="background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 22px; margin: 0px; position: relative; text-align: center;">
<span style="color: #0b5394; font-family: inherit;">AWS RDS SQL Server Announcements - 2019</span></h2>
<div>
<span style="color: #0b5394; font-family: inherit;"><br /></span></div>
<div style="text-align: left;">
<b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">1.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Amazon RDS SQL Server Supports differential and log and restores:</span></b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"> <a href="https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/" title="https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/"><span style="color: #954f72;">https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/</span></a> </span></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">2.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Amazon RDS SQL Server now supports logs to cloudwatch:</span></b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"> <a href="https://aws.amazon.com/about-aws/whats-new/2019/11/now-publish-log-files-amazon-rds-sql-server-amazon-cloudwatch/" title="https://aws.amazon.com/about-aws/whats-new/2019/11/now-publish-log-files-amazon-rds-sql-server-amazon-cloudwatch/"><span style="color: #954f72;">https://aws.amazon.com/about-aws/whats-new/2019/11/now-publish-log-files-amazon-rds-sql-server-amazon-cloudwatch/</span></a> </span></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">3.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Amazon RDS SQL Server now supports high availability in more
regions</span></b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"> (BJS, ARN, HKG, and BAH): <a href="https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-adds-high-availability-support-in-additional-aws-regions/" title="https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-adds-high-availability-support-in-additional-aws-regions/"><span style="color: #954f72;">https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-adds-high-availability-support-in-additional-aws-regions/</span></a> </span></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">4.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Amazon RDS SQL Server S3 file transfers allowing for Bulk insert
to work on Single AZ instances</span></b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"> (multi-az
support in Q1 020): <a href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/User.SQLServer.Options.S3-integration.html"><span style="color: #954f72;">https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/User.SQLServer.Options.S3-integration.html</span></a> </span></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">5.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Amazon RDS SQL Server supports outbound network access (cross vpc
linked servers now supported):</span></b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><a href="https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-sql-server-supports-outbound-network-access/"><span style="color: #954f72;">https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-sql-server-supports-outbound-network-access/</span></a> </span></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">6.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Amazon RDS SQL Server now supports X1e and X1 instances: </span></b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><a href="https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-x1-and-x1e-instance-types/"><span style="color: #954f72;">https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-x1-and-x1e-instance-types/</span></a> </span></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">7.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Amazon RDS SQL Server now supports R5s and T3s:</span></b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"> <a href="https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-r5-and-t3-instance-types/" title="https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-r5-and-t3-instance-types/"><span style="color: #954f72;">https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-r5-and-t3-instance-types/</span></a> </span></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">8.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Amazon RDS SQL Server now supports 8xl and 16xl for nitro
instances:</span></b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"> <a href="https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-additional-instance-sizes/" title="https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-additional-instance-sizes/"><span style="color: #954f72;">https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-additional-instance-sizes/</span></a></span></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<span style="color: #954f72; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;"><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">9.</span></span></b><span style="font: 7.0pt "Times New Roman";"> </span></span></span><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="color: black; text-decoration: none;">Amazon RDS now
supports Storage Auto Scaling</span>: </span></b><u><span style="color: #954f72; font-family: "helveticaneue"; font-size: 10.0pt;"><a href="https://aws.amazon.com/about-aws/whats-new/2019/06/rds-storage-auto-scaling/"><span style="color: #954f72; text-decoration: none;">https://aws.amazon.com/about-aws/whats-new/2019/06/rds-storage-auto-scaling/</span></a></span></u></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">10. </span></span><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Amazon RDS for SQL Server now supports additional instance sizes</span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">:</span></b><span style="font-size: 10.0pt;"> </span><span style="color: #954f72; font-family: "helveticaneue"; font-size: 10.0pt;"><a href="https://aws.amazon.com/about-aws/whats-new/2019/06/rds-storage-auto-scaling/"><span style="color: #954f72; text-decoration: none;">https://aws.amazon.com/about-aws/whats-new/2019/06/rds-storage-auto-scaling/</span></a></span></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">11.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="color: black; text-decoration: none;">Amazon RDS Performance
Insights Supports Counter Metrics on Amazon RDS for SQL Server</span>: </span></b><span style="color: #954f72; font-family: "helveticaneue"; font-size: 10.0pt;"><a href="https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-performance-insights-supports-counter-metrics-on-amazon-rds-for-sql-server/"><span style="color: #954f72; text-decoration: none;">https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-performance-insights-supports-counter-metrics-on-amazon-rds-for-sql-server/</span></a></span><a href="https://www.blogger.com/null" name="Amazon_RDS_SQL_Server_now_supports_chang"><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"></span></b></a></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<span style="mso-bookmark: Amazon_RDS_SQL_Server_now_supports_chang;"><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">12.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Amazon RDS SQL Server now supports changing the server-level
collation</span></b></span><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">: </span></b><span style="color: #954f72; font-family: "helveticaneue"; font-size: 10.0pt;"><a href="https://aws.amazon.com/about-aws/whats-new/2019/08/amazon-rds-sql-server-supports-changing-server-level-collation/"><span style="color: #954f72; text-decoration: none;">https://aws.amazon.com/about-aws/whats-new/2019/08/amazon-rds-sql-server-supports-changing-server-level-collation/</span></a></span><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"></span></b></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">13.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="color: black; text-decoration: none;">Amazon RDS for SQL
Server now Supports Multi-File Native Restores</span>:</span></b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"> </span><span style="color: #954f72; font-family: "helveticaneue"; font-size: 10.0pt;"><a href="https://aws.amazon.com/about-aws/whats-new/2019/06/amazon-rds-for-sql-server-now-supports-multi-file-native-restores/"><span style="color: #954f72; text-decoration: none;">https://aws.amazon.com/about-aws/whats-new/2019/06/amazon-rds-for-sql-server-now-supports-multi-file-native-restores/</span></a></span><a href="https://www.blogger.com/null" name="Amazon_RDS_for_SQL_Server_now_Supports_S"><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"></span></b></a></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<span style="mso-bookmark: Amazon_RDS_for_SQL_Server_now_Supports_S;"><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">14.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Amazon RDS for SQL Server now Supports SQL Server Audit</span></b></span><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">: </span></b><span style="color: #954f72; font-family: "helveticaneue"; font-size: 10.0pt;"><a href="https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-rds-for-sql-server-supports-sql-server-audit/"><span style="color: #954f72; text-decoration: none;">https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-rds-for-sql-server-supports-sql-server-audit/</span></a></span><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"></span></b></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">15.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Amazon RDS for SQL Server Now Supports Always On Availability Groups
for SQL Server 2017:</span></b><span style="font-size: 10.0pt;"> </span><span style="color: #954f72; font-family: "helveticaneue"; font-size: 10.0pt;"><a href="https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-rds-for-sql-server-now-supports-always-on-availability-groups-for-sql-server-2017/"><span style="color: #954f72; text-decoration: none;">https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-rds-for-sql-server-now-supports-always-on-availability-groups-for-sql-server-2017/</span></a></span><a href="https://www.blogger.com/null" name="Amazon_RDS_for_SQL_Server_Increases_the_"><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"></span></b></a></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<span style="mso-bookmark: Amazon_RDS_for_SQL_Server_Increases_the_;"><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">16.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Amazon RDS for SQL Server Increases the Database Limit Per
Database Instance up to 100</span></b></span><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">: </span></b><span style="color: #954f72; font-family: "helveticaneue"; font-size: 10.0pt;"><a href="https://aws.amazon.com/about-aws/whats-new/2019/05/amazon_rds_for_sql_server_increases/"><span style="color: #954f72; text-decoration: none;">https://aws.amazon.com/about-aws/whats-new/2019/05/amazon_rds_for_sql_server_increases/</span></a></span><a href="https://www.blogger.com/null" name="Performance_Insights_is_Generally_Availa"><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"></span></b></a></div>
</div>
<div class="MsoListParagraph" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; mso-outline-level: 3; tab-stops: list 36.0pt; text-indent: -18.0pt;">
<div style="text-align: left;">
<span style="mso-bookmark: Performance_Insights_is_Generally_Availa;"><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"><span style="mso-list: Ignore;">17.<span style="font: 7.0pt "Times New Roman";"> </span></span></span></b><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">Performance Insights is Generally Available on Amazon RDS for SQL
Server</span></b></span><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;">:</span></b><span style="color: #954f72; font-size: 10.0pt;"> </span><span style="color: #954f72; font-family: "helveticaneue"; font-size: 10.0pt;"><a href="https://aws.amazon.com/about-aws/whats-new/2019/03/performance-insights-is-generally-available-for-sql-server/"><span style="color: #954f72; text-decoration: none;">https://aws.amazon.com/about-aws/whats-new/2019/03/performance-insights-is-generally-available-for-sql-server/</span></a></span><b><span style="color: black; font-family: "helveticaneue"; font-size: 10.0pt;"></span></b></div>
</div>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:3 0 0 0 1 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-536859905 -1073732485 9 0 511 0;}
@font-face
{font-family:HelveticaNeue;
panose-1:2 0 5 3 0 0 0 2 0 4;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-452984065 1342208475 16 0 1 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman",serif;
mso-fareast-font-family:"Times New Roman";}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}</style></div>
Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-54084420999494216332020-01-29T07:27:00.003-08:002020-01-29T08:02:53.444-08:00AWS RDS SQL Server Version List<div dir="ltr" style="text-align: left;" trbidi="on">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 621px;">
<colgroup><col style="mso-width-alt: 8277; mso-width-source: userset; width: 194pt;" width="259"></col>
<col style="mso-width-alt: 4309; mso-width-source: userset; width: 101pt;" width="135"></col>
<col style="mso-width-alt: 7253; mso-width-source: userset; width: 170pt;" width="227"></col>
</colgroup><tbody>
<tr height="25" style="height: 19.0pt;">
<td class="xl73" colspan="2" height="25" style="height: 19.0pt; mso-ignore: colspan; width: 295pt;" width="394">AWS RDS SQL Server 2017 Builds</td>
<td style="width: 170pt;" width="227"><br /></td>
</tr>
<tr height="21" style="height: 16.0pt;">
<td height="21" style="height: 16.0pt;"><br /></td>
<td><br /></td>
<td><br /></td>
</tr>
<tr height="23" style="height: 17.0pt;">
<td class="xl66" height="23" style="height: 17.0pt;">RDS SQL Server version</td>
<td class="xl66" style="border-left: none;">SQL Server Build</td>
<td class="xl68" style="border-left: none; width: 170pt;" width="227">KB /
Description</td>
</tr>
<tr height="45" style="height: 34.0pt;">
<td class="xl67" height="45" style="border-top: none; height: 34.0pt;">SQL Server
2017 14.00.3223.3.v1</td>
<td class="xl67" style="border-left: none; border-top: none;">14.0.3223.3</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4508218" rel="nofollow" target="_blank">4508218 Cumulative update 16 (CU16) for SQL Server 2017</a></td>
</tr>
<tr height="45" style="height: 34.0pt;">
<td class="xl67" height="45" style="border-top: none; height: 34.0pt;">SQL Server
2017 14.00.3192.v1</td>
<td class="xl67" style="border-left: none; border-top: none;">14.0.3192.2</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4505225" rel="nofollow" target="_blank">4505225 Security update for SQL Server 2017 CU15 GDR: July 9,
2019 </a></td>
</tr>
<tr height="68" style="height: 51.0pt;">
<td class="xl67" height="68" style="border-top: none; height: 51.0pt;">SQL Server
2017 14.00.3049.1.v1</td>
<td class="xl67" style="border-left: none; border-top: none;">14.0.3049.1</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4483666" rel="nofollow" target="_blank">4483666 On-demand hotfix update package for SQL Server 2017
Cumulative update 13 (CU13)</a></td>
</tr>
<tr height="68" style="height: 51.0pt;">
<td class="xl67" height="68" style="border-top: none; height: 51.0pt;">SQL Server
2017 14.00.3035.2.v1</td>
<td class="xl67" style="border-left: none; border-top: none;">14.0.3035.2</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4293805" rel="nofollow" target="_blank">4293805 Security update for the Remote Code Execution
vulnerability in SQL Server 2017 CU: August 14, 2018 </a></td>
</tr>
<tr height="45" style="height: 34.0pt;">
<td class="xl67" height="45" style="border-top: none; height: 34.0pt;">SQL Server
2017 14.00.3015.40.v1</td>
<td class="xl67" style="border-left: none; border-top: none;">14.0.3015.40</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4052987" rel="nofollow" target="_blank">4052987 Cumulative update 3 (CU3) for SQL Server 2017 – Security
Advisory ADV180002 </a></td>
</tr>
<tr height="23" style="height: 17.0pt;">
<td class="xl67" height="23" style="border-top: none; height: 17.0pt;">SQL Server
2017 14.00.1000.169.v1</td>
<td class="xl67" style="border-left: none; border-top: none;">14.0.1000.169</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://www.microsoft.com/en-us/sql-server/sql-server-2017" rel="nofollow" target="_blank">Microsoft SQL Server 2017 RTM </a></td>
</tr>
<tr height="21" style="height: 16.0pt;">
<td height="21" style="height: 16.0pt;"><br /></td>
<td><br /></td>
<td class="xl65"><br /></td>
</tr>
<tr height="25" style="height: 19.0pt;">
<td class="xl73" colspan="2" height="25" style="height: 19.0pt; mso-ignore: colspan;">AWS
RDS SQL Server 2016 Builds</td>
<td class="xl65"><br /></td>
</tr>
<tr height="25" style="height: 19.0pt;">
<td class="xl73" height="25" style="height: 19.0pt;"><br /></td>
<td><br /></td>
<td class="xl65"><br /></td>
</tr>
<tr height="23" style="height: 17.0pt;">
<td class="xl66" height="23" style="height: 17.0pt;">RDS SQL Server version</td>
<td class="xl66" style="border-left: none;">SQL Server Build</td>
<td class="xl68" style="border-left: none; width: 170pt;" width="227">KB /
Description</td>
</tr>
<tr height="69" style="height: 52.0pt;">
<td class="xl67" height="69" style="border-top: none; height: 52.0pt;">SQL Server
2016 13.00.5426.0.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">13.0.5426.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4505830" rel="nofollow" target="_blank">4505830 Cumulative update 8 (CU8) for SQL Server 2016 Service
Pack 2</a></td>
</tr>
<tr height="69" style="height: 52.0pt;">
<td class="xl67" height="69" style="border-top: none; height: 52.0pt;">SQL Server
2016 13.00.5366.0.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">13.0.5366.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4505222" rel="nofollow" target="_blank">4505222 Security update for SQL Server 2016 SP2 CU7 GDR: July 9,
2019</a></td>
</tr>
<tr height="69" style="height: 52.0pt;">
<td class="xl67" height="69" style="border-top: none; height: 52.0pt;">SQL Server
2016 13.00.5292.0.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">13.0.5292.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4488536" rel="nofollow" target="_blank">4488536 Cumulative update 6 (CU6) for SQL Server 2016 Service
Pack 2</a></td>
</tr>
<tr height="69" style="height: 52.0pt;">
<td class="xl67" height="69" style="border-top: none; height: 52.0pt;">SQL Server
2016 13.00.5216.0.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">13.0.5216.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4458871" rel="nofollow" target="_blank">4458871 Cumulative update 3 (CU3) for SQL Server 2016 Service
Pack 2</a></td>
</tr>
<tr height="92" style="height: 69.0pt;">
<td class="xl67" height="92" style="border-top: none; height: 69.0pt;">SQL Server
2016 13.00.4522.0.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">13.0.4522.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4293808" rel="nofollow" target="_blank">4293808 Security update for the Remote Code Execution
vulnerability in SQL Server 2016 SP1 CU: August 14, 2018 </a></td>
</tr>
<tr height="92" style="height: 69.0pt;">
<td class="xl67" height="92" style="border-top: none; height: 69.0pt;">SQL Server
2016 13.00.4466.4.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">13.0.4466.4</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4057119" rel="nofollow" target="_blank">4057119 Cumulative update 7 (CU7) for SQL Server 2016 Service
Pack 1 – Security Advisory ADV180002 </a></td>
</tr>
<tr height="69" style="height: 52.0pt;">
<td class="xl67" height="69" style="border-top: none; height: 52.0pt;">SQL Server
2016 13.00.4451.0.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">13.0.4451.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4040714" rel="nofollow" target="_blank">4040714 Cumulative update 5 (CU5) for SQL Server 2016 Service
Pack 1</a></td>
</tr>
<tr height="69" style="height: 52.0pt;">
<td class="xl67" height="69" style="border-top: none; height: 52.0pt;">SQL Server
2016 13.00.4422.0.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">13.0.4422.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4013106" rel="nofollow" target="_blank">4013106 Cumulative update 2 (CU2) for SQL Server 2016 Service
Pack 1</a></td>
</tr>
<tr height="47" style="height: 35.0pt;">
<td class="xl67" height="47" style="border-top: none; height: 35.0pt;">SQL Server
2016 13.00.2164.0.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">13.0.2164.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/3182270/cumulative-update-2-for-sql-server-2016">3182270
Cumulative update 2 (CU2) for SQL Server 2016</a></td>
</tr>
<tr height="21" style="height: 16.0pt;">
<td height="21" style="height: 16.0pt;"><br /></td>
<td><br /></td>
<td><br /></td>
</tr>
<tr height="25" style="height: 19.0pt;">
<td class="xl73" colspan="2" height="25" style="height: 19.0pt; mso-ignore: colspan;">AWS
RDS SQL Server 2014 Builds</td>
<td><br /></td>
</tr>
<tr height="21" style="height: 16.0pt;">
<td height="21" style="height: 16.0pt;"><br /></td>
<td><br /></td>
<td><br /></td>
</tr>
<tr height="23" style="height: 17.0pt;">
<td class="xl66" height="23" style="height: 17.0pt;">RDS SQL Server version</td>
<td class="xl66" style="border-left: none;">SQL Server Build</td>
<td class="xl68" style="border-left: none; width: 170pt;" width="227">KB /
Description</td>
</tr>
<tr height="69" style="height: 52.0pt;">
<td class="xl67" height="69" style="border-top: none; height: 52.0pt;">SQL Server
2014 12.00.6293.0.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">12.0.6293.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4505422" rel="nofollow" target="_blank">4505422 Security update for SQL Server 2014 SP3 CU3 GDR: July 9,
2019 </a></td>
</tr>
<tr height="92" style="height: 69.0pt;">
<td class="xl67" height="92" style="border-top: none; height: 69.0pt;">SQL Server
2014 12.00.5571.0.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">12.0.5571.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4052725" rel="nofollow" target="_blank">4052725 Cumulative update package 10 (CU10) for SQL Server 2014
Service Pack 2 – Security Advisory ADV180002 </a></td>
</tr>
<tr height="69" style="height: 52.0pt;">
<td class="xl67" height="69" style="border-top: none; height: 52.0pt;">SQL Server
2014 12.00.5546.0.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">12.0.5546.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4013098" rel="nofollow" target="_blank">4013098 Cumulative update package 5 (CU5) for SQL Server 2014
Service Pack 2</a></td>
</tr>
<tr height="47" style="height: 35.0pt;">
<td class="xl67" height="47" style="border-top: none; height: 35.0pt;">SQL Server
2014 12.00.5000.0.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">12.0.5000.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://www.microsoft.com/en-us/download/details.aspx?id=53168" rel="nofollow" target="_blank">SQL Server 2014 Service Pack 2 (SP2)</a></td>
</tr>
<tr height="21" style="height: 16.0pt;">
<td height="21" style="height: 16.0pt;"><br /></td>
<td><br /></td>
<td><br /></td>
</tr>
<tr height="25" style="height: 19.0pt;">
<td class="xl73" colspan="2" height="25" style="height: 19.0pt; mso-ignore: colspan;">AWS
RDS SQL Server 2012 Builds</td>
<td><br /></td>
</tr>
<tr height="21" style="height: 16.0pt;">
<td height="21" style="height: 16.0pt;"><br /></td>
<td><br /></td>
<td><br /></td>
</tr>
<tr height="23" style="height: 17.0pt;">
<td class="xl66" height="23" style="height: 17.0pt;">RDS SQL Server version</td>
<td class="xl66" style="border-left: none;">SQL Server Build</td>
<td class="xl68" style="border-left: none; width: 170pt;" width="227">KB /
Description</td>
</tr>
<tr height="92" style="height: 69.0pt;">
<td class="xl67" height="92" style="border-top: none; height: 69.0pt;">SQL Server
2012 11.00.7462.6.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">11.0.7462.6</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4057116" rel="nofollow" target="_blank">4057116 Description of the security update for SQL Server 2012
SP4 GDR: January 12, 2018 – Security Advisory ADV180002 </a></td>
</tr>
<tr height="69" style="height: 52.0pt;">
<td class="xl67" height="69" style="border-top: none; height: 52.0pt;">SQL Server
2012 11.00.6594.0.v1</td>
<td class="xl71" style="border-left: none; border-top: none;">11.0.6594.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://support.microsoft.com/en-us/help/4013104" rel="nofollow" target="_blank">4013104 Cumulative update package 8 (CU8) for SQL Server 2012
Service Pack 3</a></td>
</tr>
<tr height="45" style="height: 34.0pt;">
<td class="xl67" height="45" style="border-top: none; height: 34.0pt;">SQL Server
2012 11.00.6020.0.v1</td>
<td class="xl67" style="border-left: none; border-top: none;">11.0.6020.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="https://www.microsoft.com/en-us/download/details.aspx?id=49996" rel="nofollow" target="_blank">SQL Server 2012 Service Pack 3 (SP3)</a></td>
</tr>
<tr height="69" style="height: 52.0pt;">
<td class="xl72" height="69" style="border-top: none; height: 52.0pt; width: 194pt;" width="259">SQL Server 2012 11.00.5058.0.v1 except US East (Ohio), Canada
(Central), and Europe (London)</td>
<td class="xl71" style="border-left: none; border-top: none;">11.0.5058.0</td>
<td class="xl69" style="border-left: none; border-top: none; width: 170pt;" width="227"><a href="http://www.microsoft.com/en-us/download/details.aspx?id=43340" rel="nofollow" target="_blank">SQL Server 2012 Service Pack 2 (SP2)</a></td>
</tr>
<tr height="23" style="height: 17.0pt;">
<td height="23" style="height: 17.0pt;"><br /></td>
<td class="xl70"><br /></td>
<td><br /></td>
</tr>
<tr height="23" style="height: 17.0pt;">
<td class="xl68" height="23" style="height: 17.0pt; width: 194pt;" width="259">Date</td>
<td class="xl68" style="border-left: none; width: 101pt;" width="135">Information</td>
<td><br /></td>
</tr>
<tr height="136" style="height: 102.0pt; mso-height-source: userset;">
<td class="xl72" height="178" rowspan="3" style="border-top: none; height: 134.0pt; width: 194pt;" width="259">July 12, 2019</td>
<td class="xl74" rowspan="3" style="border-top: none; width: 101pt;" width="135">The
Amazon RDS team deprecated support for Microsoft SQL Server 2008 R2 in June
2019.<span style="mso-spacerun: yes;"> </span></td>
<td><br /></td>
</tr>
<tr height="21" style="height: 16.0pt;">
<td height="21" style="height: 16.0pt;"><br /></td>
</tr>
<tr height="21" style="height: 16.0pt;">
<td height="21" style="height: 16.0pt;"><br /></td>
</tr>
<tr height="227" style="height: 170.0pt;">
<td class="xl72" height="227" style="border-top: none; height: 170.0pt; width: 194pt;" width="259">April 25, 2019</td>
<td class="xl72" style="border-left: none; border-top: none; width: 101pt;" width="135">Before
the end of April 2019, you will no longer be able to create new Amazon RDS
for SQL Server database instances using Microsoft SQL Server 2008R2.</td>
<td><br /></td>
</tr>
</tbody></table>
<style>
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
td
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:black;
font-size:12.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl65
{mso-number-format:"Short Date";}
.xl66
{font-weight:700;
border:.5pt solid windowtext;
background:#8EA9DB;
mso-pattern:black none;}
.xl67
{border:.5pt solid windowtext;}
.xl68
{font-weight:700;
border:.5pt solid windowtext;
background:#8EA9DB;
mso-pattern:black none;
white-space:normal;}
.xl69
{color:#0563C1;
text-decoration:underline;
text-underline-style:single;
border:.5pt solid windowtext;
white-space:normal;}
.xl70
{font-size:10.0pt;
font-family:"Arial Unicode MS", sans-serif;
mso-font-charset:0;}
.xl71
{font-size:10.0pt;
font-family:"Arial Unicode MS", sans-serif;
mso-font-charset:0;
border:.5pt solid windowtext;}
.xl72
{border:.5pt solid windowtext;
white-space:normal;}
.xl73
{font-size:13.5pt;
font-weight:700;}
.xl74
{text-align:center;
border:.5pt solid windowtext;
white-space:normal;}</style></div>
Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-15975923145874546292019-04-29T06:33:00.000-07:002019-06-06T09:11:25.163-07:00SQL Server Management Studio 18.0 is available now.<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: inherit; font-size: large;"><b><br /></b></span>
<span style="font-family: inherit; font-size: large;"><b>SSMS 18.0 is available for download now.</b></span><br />
<span style="font-family: inherit; font-size: large;"><b><br /></b></span>
Microsoft has released the new version of SSMS, the free client tool from Microsoft to manage to the SQL Server infrastructure from SQL Server to Azure SQL Database.<br />
<br />
SSMS 18.0 Supported Operating Systems :<br />
<br />
Windows 10 (64-bit) *<br />
Windows Server 2016 *<br />
Windows Server 2012 R2 (64-bit)<br />
Windows Server 2012 (64-bit)<br />
Windows Server 2008 R2 (64-bit)<br />
<br />
Can be downloaded from the link below:<br />
<br />
<a href="https://download.microsoft.com/download/5/4/E/54EC1AD8-042C-4CA3-85AB-BA307CF73710/SSMS-Setup-ENU.exe" target="_blank">Download Here</a><br />
<br /></div>
Sadan Kumar Buddehttp://www.blogger.com/profile/03219932060161505759noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-36744738225193998372018-12-13T04:25:00.001-08:002018-12-17T23:18:47.703-08:00Difference Between Restore with Recovery & Restore with Norecovery<p>Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the process of backup. In case of SQL Server, restoration procedure means copying the backup and move it to the recovery point. SQL Database recovery involves rolling forward uncommitted transactions and make the database online. However, SQL database restoration process can be done in two ways, “with recovery” and “with norecovery”. In this post, we will learn about the difference between restore with recovery and restore with norecovery. We also know the full procedure of these two approaches.</p>
<h2>Difference between With Recovery and With No Recovery in SQL Server</h2>
<p>“With recovery” and “NoRecovery” are actually the part of command that we apply during database restoration. </p>
<ul>
<li><b>Restore With Recovery in SQL Server</b></li></ul>
<p>This recovery process by default involves both undo and redo parts while no excess backup restoration is not allowed. If redo/ roll forward is consistent with the database, smooth data recovery is possible by making the SQL database online. Undo part will not appear if the redo has not been made enough to be consistent with database. This may even stop the process of recovery. </p>
<ul>
<li><b>Restore With Norecovery in SQL Server</b></li></ul>
<p>When restore with norecovery is used, the uncommitted transactions are kept by removing the undo part. Thus, it permits rolling forward to continue with next sequential statement and sequence restoration can let other backup restorations to take place to further roll forward the database. Restore with norecovery can sometimes roll forward data to where the database consistency is maintained.</p>
<h2>SQL Server Restore With Recovery vs NoRecovery</h2>
<p>Now that we know the difference between these two processes, Let’s go through the detail of those.</p>
<ul><li><b>SQL Server Restore With Recovery</b></li></ul>
<p>It is one of the many available options for database restoration. This makes the restored database accessible to the users. Restore with recovery is the default option if you are restoring a full backup and not multiple backups.</p>
<p><b>Use T-SQL Statements to Perform the Restoration</b></p>
<p>These T-SQL scripts can be used for applicable situations:</p>
<p><b>For Full Backup Restoration</b></p>
<p>Though this will be the automatic option for restoring a full backup, specify it with this command:</p>
<pre>RESTORE DATABASE MotionWorks FROM DISK = 'C:\MotionWorks.BAK'
WITH RECOVERY
GO</pre>
<p><b>Recovering a ‘Restoring’ State Database</b></p>
<p>The following script is used when we have to recover a database that is still in the restoring state If this script is used, every user including the end users can access the database.</p>
<pre>RESTORE DATABASE MotionWorks WITH RECOVERY
GO</pre>
<p><b>Use “With Recovery” in Case of Last Backup while Restoring Multiple Backups</b></p>
<p>The last backup restoration in the case of multiple backups will require with recovery command. Use this following T-SQL Script to do that:</p>
<pre>RESTORE DATABASE MotionWorks FROM DISK = 'C:\MotionWorks.BAK'
WITH NORECOVERY
GO
RESTORE LOG MotionWorks FROM DISK = 'C:\MotionWorks.TRN'
WITH RECOVERY
GO</pre>
<ul><li><b>SQL Server Restore With NoRecovery</b></li></ul>
<p>We see the use of No Recovery command when there is the requirement of multiple backup restoration. In that case, With Norecovery option is used in all instances except the last one. Since With Norecovery command enables ‘restoring state’ in a database, additional backups can be performed. In the meantime, users are prohibited from accessing that database.</p>
<p><b>Restore database with norecovery in sql server</b></p>
<p>Here are some examples of commands that need to be used </p>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRRrMJqCdzJf8Hm994lMO4-dcstT1nCB0b7cVccxoSb70sXmdqz5ubGLaL1YlZFDO4IWZ_EaQG_sxEEpAYqZJZBExhPWD2WX8PRjBGD4NQT1dRIQNAn4pSHmKmucUe-gH3SIIXJMEVJYc/s1600/1.png" imageanchor="1" ><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRRrMJqCdzJf8Hm994lMO4-dcstT1nCB0b7cVccxoSb70sXmdqz5ubGLaL1YlZFDO4IWZ_EaQG_sxEEpAYqZJZBExhPWD2WX8PRjBGD4NQT1dRIQNAn4pSHmKmucUe-gH3SIIXJMEVJYc/s320/1.png" width="320" height="85" data-original-width="508" data-original-height="135" /></a>
<p>Restore Full Backup With Norecovery and One Transaction Log Backup</p>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6XlltFhkxPVU73jMgY1W0s9Sefis9qcuBI9efGnN7fqPmekDQbg5LybHWasdxW55pjWviC-Zb1KBHRQVG-jfrNRq7KDqoSieIiQRbM1JKyfEguz3TkH0BNbGQNcwhN01m0EqbajkCQU8/s1600/2.png" imageanchor="1" ><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6XlltFhkxPVU73jMgY1W0s9Sefis9qcuBI9efGnN7fqPmekDQbg5LybHWasdxW55pjWviC-Zb1KBHRQVG-jfrNRq7KDqoSieIiQRbM1JKyfEguz3TkH0BNbGQNcwhN01m0EqbajkCQU8/s320/2.png" width="320" height="126" data-original-width="511" data-original-height="201" /></a>
<p>Here, Norecovery command has been used to perform additional backups later. This command will restore the database but that database will be in the restoring state. The second command is used for transaction log backup restoration using With Recovery and making the database online for end users.</p>
<p><b>Restore Full Backup With Norecovery and Two Transaction Log Backups</b></p>
<p>The first two commands will restore the database and log where we have used With NORECOVERY option. The last command “With Recovery” will restore the transaction log.</p>
<p><b>Using SQL Server Management Studio</b></p>
<p>With the help of SQL Server Management Studio, Restore With Norecovery command can be used. Click on Options-->Choose Restore With Norecovery and click OK.</p>
<h3>Final Words</h3>
<p>In this post, we have discussed the difference between restore with recovery and restore with norecovery. We have also shared the various commands in detail related to these two types of database restoration processes. Users should get a clear idea about these two concepts and be able to restore SQL database using both the approaches. </p>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-85098729144765228382018-03-04T22:15:00.002-08:002020-04-20T02:19:48.550-07:00Calculating DTU's for Azure SQL Database<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database. Pricing Azure SQL Database is different from traditional SQL Server licensing. Azure SQL Database pricing depends on the database service tier options ,such as Database Transaction units and the maximum size of the database.</div>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Azure SQL Database offers Basic, Standard, Premium, and Premium RS service tiers for both single databases and elastic pools. The cost of Azure SQL Database directly relates to which tier and performance level you are using. To determine service tier and performance level and database throughput units (DTUs) with the help of Azure database DTU calculator.</div>
<div style="background-color: white; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<span style="color: #0c343d; font-family: "verdana" , sans-serif; font-size: large;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjj8UBErsze6VvoRIPVKe9b3aWCeauIcCeBmThyphenhyphenX_TjgNnpRBgXk8ki_z6aFRzT2JWCWQpoypLZXUvCN_yieu-MYOWYdcB72EERqkHSp1diu5vDQll-Da25AZlqQ0hxVk56VXRqTouNg5c/s1600/sql-azure2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="207" data-original-width="391" height="169" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjj8UBErsze6VvoRIPVKe9b3aWCeauIcCeBmThyphenhyphenX_TjgNnpRBgXk8ki_z6aFRzT2JWCWQpoypLZXUvCN_yieu-MYOWYdcB72EERqkHSp1diu5vDQll-Da25AZlqQ0hxVk56VXRqTouNg5c/s320/sql-azure2.png" width="320" /></a></div>
<br /></div>
<h4 style="background-color: white; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><b><span style="color: #0c343d; font-family: "verdana" , sans-serif; font-size: large;"><span style="line-height: 12.8px;">Read My Complete Article posted in SQLServercentral.com "</span><a href="http://www.sqlservercentral.com/articles/Azure+SQL+database/167292/" style="cursor: pointer; line-height: 12.8px;" target="_blank">Here</a><span style="line-height: 12.8px;">" </span></span></b></span><span style="color: #666666; font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif; font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: x-small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<div style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: x-small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></div>
<div style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: x-small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></div>
<div style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: x-small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></div>
<div style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: x-small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></div>
<div style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: x-small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></div>
<div style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: x-small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></div>
<h4 style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px; margin: 0px; position: relative;">
</h4>
<h4 style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: x-small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<br /><div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<br /></div>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<br /></div>
</div>
Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-508472885406437952018-03-04T22:12:00.004-08:002020-04-20T02:20:54.756-07:00Configure Read only routing for an always on availability group<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 style="background: white; margin-bottom: 2.4pt; margin-left: 0in; margin-right: 0in; margin-top: 12.0pt;">
</h1>
<div style="background: white; margin-bottom: .1in; margin-left: 0in; margin-right: 0in; margin-top: .1in;">
<span style="color: #2a2a2a; font-family: "arial" , sans-serif; font-size: 9.5pt;">One of my friend sent an email with the requirement to load
balance the traffic coming from application to secondary SQL Server replicas in
always on availability group. Read-only routing refers to the ability of
SQL Server to route qualifying read-only connection requests to an available
Always On </span><a href="https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/active-secondaries-readable-secondary-replicas-always-on-availability-groups"><span style="color: #2a2a2a; font-family: "arial" , sans-serif; font-size: 9.5pt;">readable secondary replica</span></a><span style="color: #2a2a2a; font-family: "arial" , sans-serif; font-size: 9.5pt;">. The
advantage of Setting the readable secondary as Read-Intent Only will allow the
secondary server to serve the read-only workload only if the connection string
of the application contains Application Intent=Readonly parameter. <o:p></o:p></span></div>
<div style="background: white; margin: 0.1in 0in; text-align: left;">
<span style="color: #2a2a2a; font-family: "verdana" , sans-serif; font-size: large;"><br /></span></div>
<div style="background-color: white; margin: 0px; position: relative; text-align: left;">
<span style="font-size: xx-small;"><span style="font-family: "verdana" , sans-serif; font-size: large;"><span style="line-height: 12.8px;"><b><span style="color: #0c343d;">Read My Complete Article posted in SQLServercentral.com "</span></b></span><span style="color: #0c343d;"><a href="http://www.sqlservercentral.com/articles/always+on/167193/" style="cursor: pointer; font-weight: bold; line-height: 12.8px;" target="_blank">Here</a><span style="font-weight: bold; line-height: 12.8px;">" </span></span></span></span></div>
<div>
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></div>
<div>
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></div>
<div>
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></div>
<div>
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></div>
<div>
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></div>
<div>
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></div>
<h4 style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px; margin: 0px; position: relative;">
</h4>
<h4 style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: small;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<div style="background-color: white; color: #2a2a2a; font-family: arial, helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<b style="color: #003366; font-size: 12.8px;">Ganapathi varma Chekuri</b></div>
<div style="background-color: white; color: #2a2a2a; font-family: arial, helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Email: gana20m@gmail.com</div>
<h4 style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><a href="http://in.linkedin.com/pub/ganapathi-varma-chekuri/54/279/874/" style="color: #225588; cursor: pointer; font-family: arial, helvetica, sans-serif; font-size: 12.8px; text-decoration-line: none;">Linkedin</a><b><span style="font-family: "verdana" , sans-serif; font-size: small;"><span style="color: #2a2a2a; line-height: 12.8px;"> </span></span></b></span></h4>
</div>
Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-10403743898288654782018-01-10T22:15:00.000-08:002020-01-29T08:20:17.298-08:00How to Change the File Extension for a Data File<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<h3 style="text-align: left;">
<b>Link Below:</b></h3>
<h3 style="text-align: left;">
<a href="http://www.sqlservercentral.com/articles/Data+File/164781/" target="_blank">How to Change the File Extension for a Data File</a></h3>
<div class="MsoNormal">
<span style="font-family: "Verdana",sans-serif; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;">In general, the file extensions that we use for SQL Server data files
are MDF (Primary Data File), NDF (Secondary Data File - this is optional), and
LDF (Transaction Log File). SQL Server works fine with any file extension but
Microsoft recommends we use MDF, NDF and LDF. </span></div>
<div class="MsoNormal">
<span style="font-family: "Verdana",sans-serif; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;">But, a different file extension also work with SQL Server.</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: "Verdana",sans-serif; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-GB;">This article helps in finding a way to rename the file extensions.</span></div>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:3 0 0 0 1 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-536859905 -1073732485 9 0 511 0;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-1593833729 1073750107 16 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}</style><style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:3 0 0 0 1 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-536859905 -1073732485 9 0 511 0;}
@font-face
{font-family:"Gurmukhi Sangam MN";
panose-1:2 0 4 0 0 0 0 0 0 0;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:131075 0 0 0 1 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}
p
{mso-style-noshow:yes;
mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman",serif;
mso-fareast-font-family:"Times New Roman";}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}size:595.0pt 842.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;
mso-header-margin:35.4pt;
mso-footer-margin:35.4pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}</style></div>
Sadan Kumar Buddehttp://www.blogger.com/profile/03219932060161505759noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-62169002867757956552018-01-10T22:06:00.000-08:002020-01-29T08:20:55.810-08:00Changing the Path for the Master Database<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Link Below:<br />
<h3 style="text-align: left;">
<br /><a href="http://www.sqlservercentral.com/articles/Master+Database/164596/" target="_blank">Changing the Path for the Master Database</a></h3>
<div>
<div style="background-color: white; color: #2a2a2a; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<span style="font-size: small;"><span style="font-family: Verdana, sans-serif;">This article will show how we can move the master database to a new location.</span></span></div>
<div style="background-color: white; color: #2a2a2a; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<span style="font-size: small;"><span style="font-family: Verdana, sans-serif;">The ALTER DATABASE command would work for moving all the user databases and some system databases, including model, msdb and tempdb, but changing the path of the master database required a different strategy. </span></span></div>
</div>
</div>
Sadan Kumar Buddehttp://www.blogger.com/profile/03219932060161505759noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-73702698836958739162017-11-30T21:48:00.001-08:002020-04-20T02:21:15.748-07:00Upgrade SQL Server Evaluation edition to license Edition of SQL Server<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="font-family: "verdana" , sans-serif;"> <span style="box-sizing: border-box;">The</span> <a href="https://www.microsoft.com/en-in/evalcenter/evaluate-sql-server-2016" target="_blank"><span style="color: black;"><b>SQL Server Evaluation Edition</b></span></a> is a great way to get a fully
functional and free instance of SQL Server for learning and developing solutions.
The edition has a built in expiry of 6 months from the time that you install
it. </span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="font-family: "verdana" , sans-serif;">One of my client doesn't have licensed key for SQL Server and they
have planned to add key later. To apply licensed key to an
existing evaluation edition of SQL Server is different from windows. Follow the
below procedure.</span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="text-indent: -24px;"><span style="font-family: "verdana" , sans-serif;">In below screenshot, SQL Server is Enterprise evaluation edition.</span></span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="font-size: 13.5pt;"><br /></span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWun16S_conelm6lGrkoyYx3rrpOCY6FnDLGlYd0k8xwQ03AKa66gufGGL1hMrowZ3od0AGV1cqSfPGtO_ghqPMBnIfaMYU66sNQ_xmXmCdWSJq1lhG0zGDUUWwLGCbaaDZDUgTlpMZKY/s1600/1.jpg" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="367" data-original-width="1173" height="125" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWun16S_conelm6lGrkoyYx3rrpOCY6FnDLGlYd0k8xwQ03AKa66gufGGL1hMrowZ3od0AGV1cqSfPGtO_ghqPMBnIfaMYU66sNQ_xmXmCdWSJq1lhG0zGDUUWwLGCbaaDZDUgTlpMZKY/s400/1.jpg" width="400" /></a></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="font-size: 18px;"><b><span style="color: #0b5394;">Upgrade SQL Server Evaluation edition to license Edition of SQL Server</span></b></span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="font-size: 18px;"><span style="color: #134f5c;"><b><br /></b></span></span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="color: #0b5394; font-family: "verdana" , sans-serif;">Step 1:</span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="text-indent: -0.25in;"><span style="font-family: "verdana" , sans-serif;"><br /></span></span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="font-family: "verdana" , sans-serif;"><span style="text-indent: -0.25in;"><span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span></span><span style="text-indent: -0.25in;">Mount SQL Server licensed setup file to
the server.</span></span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="text-indent: -0.25in;"><span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;"><span style="font-family: "verdana" , sans-serif;"><br /></span></span></span></div>
<div style="margin-bottom: .0001pt; margin: 0in;">
<span style="font-family: "verdana" , sans-serif;"><span style="text-indent: -0.25in;"><span style="font-stretch: normal; font-variant-numeric: normal; line-height: normal;"> </span></span><span style="text-indent: -0.25in;">Launch SQL Server "setup.exe", select maintenance
tab and select edition upgrade.</span></span></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 13.5pt;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYkYbmfQ8YnMmgRrWNWBTPsEraDFdhbA0PmAUmBc2Luyt1k9Y7Ef2ZUbuXfyYs8s_HUWQxZuTBCi-XXCYIqMZRGdHXi2rkrymnlC2VTfFYec4ZfEKDkIGHmqhDiZ4UabXckxJqqGxpQZc/s1600/ediiton+tab.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="657" data-original-width="1279" height="205" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYkYbmfQ8YnMmgRrWNWBTPsEraDFdhbA0PmAUmBc2Luyt1k9Y7Ef2ZUbuXfyYs8s_HUWQxZuTBCi-XXCYIqMZRGdHXi2rkrymnlC2VTfFYec4ZfEKDkIGHmqhDiZ4UabXckxJqqGxpQZc/s400/ediiton+tab.png" width="400" /></a></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 13.5pt;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWun16S_conelm6lGrkoyYx3rrpOCY6FnDLGlYd0k8xwQ03AKa66gufGGL1hMrowZ3od0AGV1cqSfPGtO_ghqPMBnIfaMYU66sNQ_xmXmCdWSJq1lhG0zGDUUWwLGCbaaDZDUgTlpMZKY/s1600/1.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a></div>
<br />
<span style="color: #0b5394; font-family: "verdana" , sans-serif;">Step 2:</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Enter the licensed product Key and click next</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2WXIzmapBfqFgXBA1A318DrCDc0CBdeRPXUCk1qRwS1ZHu2gTH0bjJTIEKRGc1tXtyrpC38XK2jCQczGnzICuIp7dPSintDRRR5HgVaCcAQvR6fLt3AsWx_WXU_QS5q2nNID19IT2wlU/s1600/2.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="617" data-original-width="819" height="301" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2WXIzmapBfqFgXBA1A318DrCDc0CBdeRPXUCk1qRwS1ZHu2gTH0bjJTIEKRGc1tXtyrpC38XK2jCQczGnzICuIp7dPSintDRRR5HgVaCcAQvR6fLt3AsWx_WXU_QS5q2nNID19IT2wlU/s400/2.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3vjIFCo8oKRCpra7C1ZNjEOiuwbLV3dy0SRJE5LjexBd1U4yLU2Gnab0Y41uTJ_W144-Ksmlbe26TzBn4ZCaewBDTkGojXqgeTsNlbKxaqOezdHjiztKrVKlSbjJOi5WjIKuTi3ByQNM/s1600/6.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8ssBYZFfy8mtPAmYVkFQiiEvlgGomj1gguPyRd7PKAUhvXLAnAzmJhX3eI0BhltobDCb8Ehdvit6x_kq2_aTqP0saragA-KmqVOB600eEyl-R6kf_Zq89r32z6Pk-Q8IPzNG7bvgLCzE/s1600/Global+rules.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><br /></a>
<span style="font-size: 13.5pt;"><span style="color: #0b5394; font-family: "verdana" , sans-serif;">Step 3:</span></span><br />
<span style="font-size: 13.5pt;"><span style="font-family: "verdana" , sans-serif;"><br /></span></span>
<span style="font-size: 13.5pt;"><span style="font-family: "verdana" , sans-serif;">Continue
with running Edition Upgrade Rules</span></span><br />
<div>
<div>
<br /></div>
<div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8ssBYZFfy8mtPAmYVkFQiiEvlgGomj1gguPyRd7PKAUhvXLAnAzmJhX3eI0BhltobDCb8Ehdvit6x_kq2_aTqP0saragA-KmqVOB600eEyl-R6kf_Zq89r32z6Pk-Q8IPzNG7bvgLCzE/s1600/Global+rules.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="615" data-original-width="819" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8ssBYZFfy8mtPAmYVkFQiiEvlgGomj1gguPyRd7PKAUhvXLAnAzmJhX3eI0BhltobDCb8Ehdvit6x_kq2_aTqP0saragA-KmqVOB600eEyl-R6kf_Zq89r32z6Pk-Q8IPzNG7bvgLCzE/s400/Global+rules.png" width="400" /></a><br />
<br />
<br />
<div class="MsoNormal">
<span style="color: #0b5394;"><span style="font-family: "times new roman" , serif; font-size: 13.5pt; line-height: 107%;">Step 4</span><span style="font-family: "times new roman" , serif; font-size: 13.5pt;">:</span></span></div>
<div class="MsoNormal">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt;">Select
the instance name that you want to upgrade</span></div>
<div class="MsoNormal">
<o:p></o:p></div>
<div class="MsoNormal">
<span style="font-family: "times new roman" , serif; font-size: 13.5pt; line-height: 107%;"><br /></span></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXSiZRWgI9ktyK8qOuIcCmDIGvn-TJ61ll3oz04I2XxeH8QLvSCp27BdiTVhJ3UfO5K_TQvLTLCpMZTzKdiROKvV2a0irW7Cp4JZbQBHp0QFiI5A25bCUq1RS2QwXczjwWMHJGS2zZQ6I/s1600/select+instance.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="663" data-original-width="1279" height="206" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXSiZRWgI9ktyK8qOuIcCmDIGvn-TJ61ll3oz04I2XxeH8QLvSCp27BdiTVhJ3UfO5K_TQvLTLCpMZTzKdiROKvV2a0irW7Cp4JZbQBHp0QFiI5A25bCUq1RS2QwXczjwWMHJGS2zZQ6I/s400/select+instance.png" width="400" /></a><br />
<br />
<br />
<span style="color: #0b5394; font-family: "verdana" , sans-serif;">Step 5:</span><br />
<br />
<span style="font-family: "verdana" , sans-serif;">Select upgrade to proceed with upgrade process and close it once successfully upgraded</span><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4XlnT-PLu_e9aNM_dPnLfBgXRSKkmIbX-z6bs6ycJZ_BICw_h57oLkC9qHUatAD1DY0PgYNIqQixATuDOti2H7B3bAZLVbzl0UXdZkiJxzi9aCM6eW3iF0v_LTITOlxH8GCsUDXsKpDo/s1600/Upgrade.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="667" data-original-width="1279" height="207" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4XlnT-PLu_e9aNM_dPnLfBgXRSKkmIbX-z6bs6ycJZ_BICw_h57oLkC9qHUatAD1DY0PgYNIqQixATuDOti2H7B3bAZLVbzl0UXdZkiJxzi9aCM6eW3iF0v_LTITOlxH8GCsUDXsKpDo/s400/Upgrade.png" width="400" /></a><br />
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">In below screenshot, SQL Server Edition is successfully upgraded.</span><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVTqMLxcekCzTp4Sj6t1a69tQWPSODtZ-1dACtn8JiWhHxJZ-kQNwv82tNRe0P2QHg_a-kXozmekrRo-eO52q25wk593n8WcRKjnGOhputNO29G3f1QhdBeM_YigC_5wUIHRRBy02GiPo/s1600/complete.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="665" data-original-width="1279" height="207" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVTqMLxcekCzTp4Sj6t1a69tQWPSODtZ-1dACtn8JiWhHxJZ-kQNwv82tNRe0P2QHg_a-kXozmekrRo-eO52q25wk593n8WcRKjnGOhputNO29G3f1QhdBeM_YigC_5wUIHRRBy02GiPo/s400/complete.png" width="400" /></a><br />
<div>
<br /></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8ssBYZFfy8mtPAmYVkFQiiEvlgGomj1gguPyRd7PKAUhvXLAnAzmJhX3eI0BhltobDCb8Ehdvit6x_kq2_aTqP0saragA-KmqVOB600eEyl-R6kf_Zq89r32z6Pk-Q8IPzNG7bvgLCzE/s1600/Global+rules.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><br /></a>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg32ujN_GRiGu_T9ShyphenhyphenTWNBhIC4LeHfrFqCQ4P6RYtBfXsOnyXKzcPGmPKpxq8rR-eghFgmvuMapuqw44icwWO1NCCvbv10pOjMkYrypMWFQMfIwq_yp2GePh_XL5Dyk01cDrgnl1Ym_I8/s1600/6.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="527" data-original-width="1233" height="170" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg32ujN_GRiGu_T9ShyphenhyphenTWNBhIC4LeHfrFqCQ4P6RYtBfXsOnyXKzcPGmPKpxq8rR-eghFgmvuMapuqw44icwWO1NCCvbv10pOjMkYrypMWFQMfIwq_yp2GePh_XL5Dyk01cDrgnl1Ym_I8/s400/6.png" width="400" /></a></div>
<br />
<br />
<br />
<div style="background-color: white; color: #2a2a2a; font-family: arial, helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<b style="color: #003366; font-size: 12.8px;"><br /></b>
<b style="color: #003366; font-size: 12.8px;"><br /></b>
<b style="color: #003366; font-size: 12.8px;"><br /></b>
<b style="color: #003366; font-size: 12.8px;"><br /></b>
<b style="color: #003366; font-size: 12.8px;"><br /></b>
<b style="color: #003366; font-size: 12.8px;"><br /></b>
<b style="color: #003366; font-size: 12.8px;"><br /></b>
<b style="color: #003366; font-size: 12.8px;"><br /></b>
<b style="color: #003366; font-size: 12.8px;"><br /></b>
<b style="color: #003366; font-size: 12.8px;"><br /></b>
<b style="color: #003366; font-size: 12.8px;"><br /></b>
<b style="color: #003366; font-size: 12.8px;"><br /></b>
<b style="color: #003366; font-size: 12.8px;">Ganapathi varma Chekuri</b></div>
<div style="background-color: white; color: #2a2a2a; font-family: arial, helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Email: gana20m@gmail.com</div>
<h4 style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><a href="http://in.linkedin.com/pub/ganapathi-varma-chekuri/54/279/874/" style="color: #225588; cursor: pointer; font-family: arial, helvetica, sans-serif; font-size: 12.8px;">Linkedin</a><b><span style="font-family: "verdana" , sans-serif; font-size: medium;"><span style="color: #2a2a2a; line-height: 12.8px;"> </span></span></b></span></h4>
<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXSiZRWgI9ktyK8qOuIcCmDIGvn-TJ61ll3oz04I2XxeH8QLvSCp27BdiTVhJ3UfO5K_TQvLTLCpMZTzKdiROKvV2a0irW7Cp4JZbQBHp0QFiI5A25bCUq1RS2QwXczjwWMHJGS2zZQ6I/s1600/select+instance.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><br /></a>
<br />
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 13.5pt;"><br /></span></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 13.5pt;"><br /></span></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4XlnT-PLu_e9aNM_dPnLfBgXRSKkmIbX-z6bs6ycJZ_BICw_h57oLkC9qHUatAD1DY0PgYNIqQixATuDOti2H7B3bAZLVbzl0UXdZkiJxzi9aCM6eW3iF0v_LTITOlxH8GCsUDXsKpDo/s1600/Upgrade.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center; text-indent: 0px;"><br /></a></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVTqMLxcekCzTp4Sj6t1a69tQWPSODtZ-1dACtn8JiWhHxJZ-kQNwv82tNRe0P2QHg_a-kXozmekrRo-eO52q25wk593n8WcRKjnGOhputNO29G3f1QhdBeM_YigC_5wUIHRRBy02GiPo/s1600/complete.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center; text-indent: 0px;"><br /></a></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 13.5pt;"><br /></span></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div style="margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-indent: -.25in;">
</div>
</div>
</div>
</div>
Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-66239435977959030822017-10-27T02:40:00.003-07:002019-06-06T09:11:25.234-07:00Cumulative Update #1 for SQL Server 2017 RTM<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="-webkit-font-smoothing: antialiased; background-color: white; border: 0px; box-sizing: inherit; color: #454545; font-family: WOL_Reg, "Segoe UI", Tahoma, Arial, sans-serif; font-feature-settings: 'kern' 1; font-size: 2.6rem; font-weight: inherit; line-height: 1.25; margin: 0px 13.9875px 8px 0px; outline: 0px; padding: 0px; vertical-align: baseline; width: 600.25px; word-break: keep-all; word-wrap: break-word;">
<br /></h1>
<div>
<span style="background-color: white; color: #454545; font-family: WOL_Reg, "Segoe UI", Tahoma, Arial, sans-serif; font-size: 14px;">The 1st cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site.</span></div>
<div>
<span style="background-color: white; color: #454545; font-family: WOL_Reg, "Segoe UI", Tahoma, Arial, sans-serif; font-size: 14px;"><br /></span></div>
<div>
<ul style="background-color: white; border: 0px; box-sizing: inherit; font-family: WOL_Reg, "Segoe UI", Tahoma, Arial, sans-serif; font-size: 14px; list-style-image: initial; list-style-position: initial; margin: 0px 0px 1.5em 3em; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="color: #454545;">CU#1 KB Article: </span><a href="https://support.microsoft.com/en-us/help/4038634/cumulative-update-1-for-sql-server-2017" style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; text-decoration-line: none; vertical-align: baseline;"><span style="color: blue;">https://support.microsoft.com/en-us/help/4038634/cumulative-update-1-for-sql-server-2017</span></a><span style="border: 0px; box-sizing: inherit; color: #454545; font-family: "Segoe UI", sans-serif; font-size: 10pt; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; box-sizing: inherit; font-family: inherit; font-size: 13.3333px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></span></span></li>
<li style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="color: #454545;">Microsoft® SQL Server® 2017 RTM Latest Cumulative Update: </span><a href="https://www.microsoft.com/download/details.aspx?id=56128" style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; text-decoration-line: none; vertical-align: baseline;"><span style="color: blue;">https://www.microsoft.com/download/details.aspx?id=56128</span></a></li>
</ul>
</div>
</div>
Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-37343033797916353172017-07-22T04:56:00.000-07:002020-04-20T02:23:58.554-07:00Resolve Network Binding Order Warning in failover cluster<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
In this post, I’m going to talk about an issue that I found while running the cluster validation report. You may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.</div>
<blockquote style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px;">
<div style="padding: 0px;">
<div style="margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<code class="codeRed" style="color: red; font-family: "Courier New", monospace; font-size: 1em;">Rule “Network binding order” generated a warning.</code></div>
</div>
<div style="padding: 0px;">
<div style="margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<code class="codeRed" style="color: red; font-family: "Courier New", monospace; font-size: 1em;">The domain network is not the first bound network. This will cause domain operations to run slowly and can cause timeouts that result in failures. Use the Windows network advanced configuration to change the binding order.</code></div>
</div>
</blockquote>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<span style="font-size: 12.8px;">In the below screenshot, the warning says the network card used to connect to your domain network is not at the top of the network binding order.</span></div>
<div style="background-color: white; clear: both; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuJg4Ks2lqbxlsgr0kqdLoHG_Y4TjcTpY25w41mZo-q3TSIklQT7cpyAfd70xhQ1JTq8iiXS0ykzpGs4ZVUAZi7V1re11pbNCsYvZpMCsYgvIJZsZVSUwyXYSt8MoeR6f1zkynYjLoaFY/s1600/1.jpg" imageanchor="1" style="clear: left; color: #225588; cursor: pointer; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="565" data-original-width="819" height="275" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuJg4Ks2lqbxlsgr0kqdLoHG_Y4TjcTpY25w41mZo-q3TSIklQT7cpyAfd70xhQ1JTq8iiXS0ykzpGs4ZVUAZi7V1re11pbNCsYvZpMCsYgvIJZsZVSUwyXYSt8MoeR6f1zkynYjLoaFY/s400/1.jpg" style="border: none;" width="400" /></a></div>
<div style="background-color: white; clear: both; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<span style="clear: left;"></span></div>
<h2 style="background-color: white; color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
</h2>
<h2 style="background-color: white; color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
</h2>
<h2 style="background-color: white; color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
</h2>
<h2 style="background-color: white; color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
</h2>
<h2 style="background-color: white; color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
</h2>
<h2 style="background-color: white; color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIisy7LDHeNehHmFTjGOvWe3NLh2O70Wo2pP5_otDIvvR4rNxnpC7HUWhziokGwEgHducfX_1pKy8MHZlo9EIOcMZfYiJjOyw7paKloMLYvIuvb4pmXsBC_bVhHEtQXDZVJiYweAe-Pew/s1600/7.png" imageanchor="1" style="clear: left; display: inline !important; font-size: 12.8px; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="192" data-original-width="417" height="182" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIisy7LDHeNehHmFTjGOvWe3NLh2O70Wo2pP5_otDIvvR4rNxnpC7HUWhziokGwEgHducfX_1pKy8MHZlo9EIOcMZfYiJjOyw7paKloMLYvIuvb4pmXsBC_bVhHEtQXDZVJiYweAe-Pew/s400/7.png" width="400" /></a></h2>
<h2 style="background-color: white; color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
Resolution</h2>
<h3 style="background-color: white; color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
Step 1</h3>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Go to run and type ncpa.cpl to open network connections. Now press Alt+F and select advanced options then click on <strong>Advanced</strong> and <strong>Advanced Settings</strong>. <span style="font-size: 12.8px;">When the </span><strong style="font-size: 12.8px;">Advanced Settings</strong><span style="font-size: 12.8px;"> window opens, you will be on the </span><strong style="font-size: 12.8px;">Adapters and Bindings</strong><span style="font-size: 12.8px;"> tab, which allows you to change the binding order for the network interfaces on the server.</span></div>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
</div>
<h3 style="background-color: white; color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
Step 2:</h3>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<span style="font-size: 12.8px;">In this case the Microsoft Failover Cluster Virtual Adapter is bound before the domain network and still the cluster validation report shows you warning. </span><span style="font-size: 12.8px;">In the below screenshot, the TeamNIC_MGMT NIC adapater is my domain network and was already at the top of the binding order.</span></div>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<span style="font-size: 12.8px;"><br /></span></div>
<h4 style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: medium;"><span style="color: #2a2a2a; line-height: 12.8px;">Read My Complete Article "</span><a href="http://www.sqlservercentral.com/articles/SQL+Cluster/157658/" style="color: #225588; cursor: pointer; line-height: 12.8px; text-decoration-line: none;" target="_blank">Here</a><span style="color: #2a2a2a; line-height: 12.8px;">"</span></span></b></span></h4>
<h4 style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: medium;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<h4 style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px; margin: 0px; position: relative;">
</h4>
<h4 style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: medium;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<div style="background-color: white; color: #2a2a2a; font-family: arial, helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<strong style="color: #003366; font-size: 12.8px;">Ganapathi varma Chekuri</strong></div>
<div style="background-color: white; color: #2a2a2a; font-family: arial, helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Email: gana20m@gmail.com</div>
<h4 style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><a href="http://in.linkedin.com/pub/ganapathi-varma-chekuri/54/279/874/" style="color: #225588; cursor: pointer; font-family: arial, helvetica, sans-serif; font-size: 12.8px; text-decoration-line: none;">Linkedin</a><b><span style="font-family: "verdana" , sans-serif; font-size: medium;"><span style="color: #2a2a2a; line-height: 12.8px;"> </span></span></b></span></h4>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<span style="font-size: 12.8px;"><br /></span></div>
</div>
Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com0tag:blogger.com,1999:blog-8769980932654813319.post-70435427268842154932017-04-17T22:04:00.000-07:002017-07-26T03:28:43.293-07:00The Connection to the Primary Replica is not Active<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group. <span style="font-size: 12.8px;">This error mostly appears when we try to join the adding replica to availability group or database to availability group using GUI and T-SQL.</span></div>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
Error 1</h3>
<div>
<br /></div>
<div>
<div class="MsoNormal">
<span style="color: red;">TITLE: Microsoft SQL Server Management Studio<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;">
------------------------------<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;"> Joining database on
secondary replica resulted in an error.
(Microsoft.SqlServer.Management.HadrTasks)<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;">
------------------------------<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: red;"> ADDITIONAL
INFORMATION:<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;"> Failed to join the
database 'AGTEST' to the availability group 'AG01' on the availability replica
'SQL2'. (Microsoft.SqlServer.Smo)<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;">
------------------------------<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;"> An exception
occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;">
------------------------------<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;"> The connection to
the primary replica is not active. The
command cannot be processed. (Microsoft SQL Server, Error:</span><o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
</div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
In below screenshot, joining the database abc to SQL2 failed with this error when creating a new Availability Group.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEga3F12JHC07QQcLw5g96_Tv6bikFrMK0uaKl3Gx5hojzMIoaelJKaxojI7yvlQHHISX06fSo6XjrzDLrJhFErwnaF5r9QXC26zDOV3B4Gy80rSYNkUFY-8vaw4_NPK-SsduoCFa8idxlY/s1600/1.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="224" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEga3F12JHC07QQcLw5g96_Tv6bikFrMK0uaKl3Gx5hojzMIoaelJKaxojI7yvlQHHISX06fSo6XjrzDLrJhFErwnaF5r9QXC26zDOV3B4Gy80rSYNkUFY-8vaw4_NPK-SsduoCFa8idxlY/s400/1.jpg" width="400" /></a></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<br /></div>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
Error 2</h3>
<div>
<span style="color: red;"><br /></span></div>
<div>
<div class="MsoNormal">
<span style="color: red;">TITLE: Microsoft SQL Server Management Studio<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;"> ------------------------------<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;"> Failed to join the database 'AGTEST' to the
availability group 'AG01' on the availability replica 'TREDSHOST08'.
(Microsoft.SqlServer.Smo)<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;"> ------------------------------<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;"> ADDITIONAL INFORMATION:<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;"> An exception occurred while executing a
Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;"> ------------------------------<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;"> The connection to the primary replica is not
active. The command cannot be processed. (Microsoft SQL Server, Error:
35250)</span><o:p></o:p></div>
</div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<br />
In the below screenshot, joining database abc to SQL2 failed with this error.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkdsO4SUvsNkfQB-Fu24KQLWkybZ8Ks0jbxwOA1CsoltLRWqcQ1NPo1ME_J3tiVFzmy-8KBWtj1bXWwacH33h_M94AiPHGnsJKRigAOFDKqoZJhF4tgGhJ-Z4YW_MsaP7W_T9l-_6vy-Y/s1600/2.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="224" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkdsO4SUvsNkfQB-Fu24KQLWkybZ8Ks0jbxwOA1CsoltLRWqcQ1NPo1ME_J3tiVFzmy-8KBWtj1bXWwacH33h_M94AiPHGnsJKRigAOFDKqoZJhF4tgGhJ-Z4YW_MsaP7W_T9l-_6vy-Y/s400/2.jpg" width="400" /></a></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<br /></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<br /></div>
<h2 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
</h2>
<h2 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
</h2>
<h2 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
</h2>
<h2 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
</h2>
<h2 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
</h2>
<h2 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
Resolution</h2>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
To solve the issues, follow these steps.</div>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
Step 1</h3>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Query the sys.dm_hadr_availability_replica_states for the last_connect_error_number which may help you diagnose the join issue. Depending on which replica was having difficulty communicating, you should query both the primary and secondary for the local replica</div>
<pre class="prettyprint lang-sql" style="background-color: #f0f0ff; border: 1px dotted rgb(153, 177, 255); font-family: "Courier New"; font-size: 14.08px; max-height: 800px; overflow: auto; width: 942.75px;">--connect secondary replica
select r.replica_server_name, r.endpoint_url,
rs.connected_state_desc, rs.last_connect_error_description,
rs.last_connect_error_number, rs.last_connect_error_timestamp
from sys.dm_hadr_availability_replica_states rs
join sys.availability_replicas r
on rs.replica_id=r.replica_id
where rs.is_local=1</pre>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
In the below screenshot, the secondary instance SQL2 was not able to communicate with SQL1</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1A2powsY1XNcgRLyk-MipHU-WyPjPBdNjQUs0OVhOG-T-ScoYaUWc7beWjS2bYPi9XmfLBOC0SDvnOSn1vUPph3fmXl_NYW1_m2bonFCRCziwHFZOWU4y_Bx5zMb57jOFxpEzpAGzIYo/s1600/3.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="223" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1A2powsY1XNcgRLyk-MipHU-WyPjPBdNjQUs0OVhOG-T-ScoYaUWc7beWjS2bYPi9XmfLBOC0SDvnOSn1vUPph3fmXl_NYW1_m2bonFCRCziwHFZOWU4y_Bx5zMb57jOFxpEzpAGzIYo/s400/3.jpg" width="400" /></a></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<br /></div>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
</h3>
<h3 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 15.36px; margin: 1em 0px 0.2em; padding: 0px;">
Step 2</h3>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
The endpoints were created with the two dedicated IP's but the CREATE AVAILABILITY GROUP statement used the FQDN in the ENDPOINT_URL section. Once I changed the ENDPOINT_URL to use the IP's of the dedicated NIC (TCP://172.16.35.11:5022), the AG started working properly with the dedicated network.</div>
<pre class="prettyprint lang-sql" style="background-color: #f0f0ff; border: 1px dotted rgb(153, 177, 255); font-family: "Courier New"; font-size: 14.08px; max-height: 800px; overflow: auto; width: 942.75px;">--connect primary replica
ALTER AVAILABILITY GROUP [AG01]
MODIFY REPLICA ON 'TREDSHOST07' WITH (ENDPOINT_URL = 'TCP://172.16.35.10:5022')
GO
ALTER AVAILABILITY GROUP [AG01]
MODIFY REPLICA ON 'TREDSHOST08' WITH (ENDPOINT_URL = 'TCP://172.16.35.11:5022')
GO</pre>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<br /></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
In the below screenshot, I have modified the endpoint URL on both replicas.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij89NnA7aef_Dnkb9WHJRV1PleE8gor_XcLh9g-L6fV9skJaKNk-r5J71IA9TATHohfYJ_D_vxT-yGqFpWHGqvAKLtBUpduFlDSu1Gow3H1nvSwdE9iJUK4B5nH9iQLyDyMhvoMxAiVjc/s1600/4.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="262" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij89NnA7aef_Dnkb9WHJRV1PleE8gor_XcLh9g-L6fV9skJaKNk-r5J71IA9TATHohfYJ_D_vxT-yGqFpWHGqvAKLtBUpduFlDSu1Gow3H1nvSwdE9iJUK4B5nH9iQLyDyMhvoMxAiVjc/s400/4.jpg" width="400" /></a></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<br /></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<br /></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<br /></div>
<div>
<br /></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; margin: 0px; position: relative;">
<span style="font-size: x-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: large;"><span style="color: #2a2a2a; line-height: 12.8px;">Read My Complete Article "</span><a href="http://www.sqlservercentral.com/articles/AlwaysOn/153400/" style="color: #225588; cursor: pointer; line-height: 12.8px; text-decoration: none;" target="_blank">Here</a><span style="color: #2a2a2a; line-height: 12.8px;">"</span></span></b></span></h4>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; margin: 0px; position: relative;">
<span style="font-size: x-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: large;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; margin: 0px; position: relative;">
<span style="font-size: x-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: large;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; margin: 0px; position: relative;">
<span style="font-size: x-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: large;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; margin: 0px; position: relative;">
<span style="font-size: x-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: large;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<div style="color: #2a2a2a; font-family: arial, helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<strong style="color: #003366; font-size: 12.8px;">Ganapathi varma Chekuri</strong></div>
<div style="color: #2a2a2a; font-family: arial, helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Lead SQL DBA, MCP</div>
<div style="color: #2a2a2a; font-family: arial, helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Email: gana20m@gmail.com</div>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; margin: 0px; position: relative;">
<span style="font-size: x-small;"><a href="http://in.linkedin.com/pub/ganapathi-varma-chekuri/54/279/874/" style="color: #225588; cursor: pointer; font-family: arial, helvetica, sans-serif; font-size: 12.8px; text-decoration: none;">Linkedin</a><b><span style="font-family: "verdana" , sans-serif; font-size: large;"><span style="color: #2a2a2a; line-height: 12.8px;"> </span></span></b></span></h4>
</div>
Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com9tag:blogger.com,1999:blog-8769980932654813319.post-40001078340923761542017-04-09T23:54:00.001-07:002017-04-13T04:02:28.613-07:00Step by Step Configuring a Dedicated Network for Availability Group<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
One of my clients came up with the requirement to isolate the replication traffic from the public network. The advantage of using a separate network for replication is reduced latency and replication can still run without any latency issues during times of heavy network traffic issued by other applications or backup activities. In this article, I will show a procedure to setup a dedicated network for Availability Group communication</div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
SQL Server 2012 AlwaysOn Availability Groups require a database mirroring endpoint for each SQL Server instance that will be hosting an availability group replica and/or database mirroring session. <span style="font-size: 12.8px;">We have two nodes SQL1 and SQL2 in a Windows failover cluster. Each node has a standalone SQL Serverinstance installed and configured with an Always On AG. </span><span style="font-size: 12.8px;">Each node also has a separate virtual network adapter for public communication, a virtual network adapter for WSFC communication, and a virtual network adapter that we’ll dedicate to availability group communication.</span></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
In the below screenshot, the Node1 (SQL1) Availability Group dedicated NIC IP address is 172.16.35.10. The Node2 (SQL2) Availability Group dedicated NIC IP address is 172.16.35.11.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC7EU9OXwm3noa4ETnjSfaRAd19H5-wqZ4NhPOxE0zo7EaMwniEUxnLckCjcJtgwSy5yrnjG4tPRBFp8RBec2nwgbtm9pN9-Z8E7rdj32AJwkg7H3mJxEh3MUp4CZrLHUV6FKAHgLZzWo/s1600/Repl.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="222" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC7EU9OXwm3noa4ETnjSfaRAd19H5-wqZ4NhPOxE0zo7EaMwniEUxnLckCjcJtgwSy5yrnjG4tPRBFp8RBec2nwgbtm9pN9-Z8E7rdj32AJwkg7H3mJxEh3MUp4CZrLHUV6FKAHgLZzWo/s400/Repl.jpg" width="400" /></a></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<br /></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<br /></div>
<h2 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
<strong><br /></strong></h2>
<h2 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
<strong><br /></strong></h2>
<h2 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
<strong><br /></strong></h2>
<h2 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
<strong><br /></strong></h2>
<h2 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
<strong><br /></strong></h2>
<h2 style="color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
<strong>Reconfigure Communication to a Dedicated Network</strong></h2>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<strong style="color: #003366; font-size: 15.36px;">Step 1:</strong></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Identify the endpoint name configured for Always On replication. By default, “Hadr_endpoint” is the endpoint name. <span style="font-size: 12.8px;">In below screenshot, we see this. </span></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<span style="font-size: 12.8px;"><br /></span></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<span style="font-size: 12.8px;"><br /></span></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<b style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: x-small;"><span style="font-family: "verdana" , sans-serif; font-size: medium;"><span style="color: #2a2a2a; line-height: 12.8px;">Read My Complete Article "</span><a href="http://www.sqlservercentral.com/articles/AlwaysOn/153397/" style="color: #225588; cursor: pointer; line-height: 12.8px; text-decoration: none;" target="_blank">Here</a><span style="color: #2a2a2a; line-height: 12.8px;">"</span></span></b></div>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: medium;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: medium;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: medium;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: medium;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<strong style="color: #003366; font-size: 12.8px;">Ganapathi varma Chekuri</strong></div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Lead SQL DBA, MCP</div>
<div style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Email: gana20m@gmail.com</div>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; margin: 0px; position: relative;">
<span style="font-size: xx-small;"><a href="http://in.linkedin.com/pub/ganapathi-varma-chekuri/54/279/874/" style="color: #225588; cursor: pointer; font-family: arial, helvetica, sans-serif; font-size: 12.8px; text-decoration: none;">Linkedin</a><b><span style="font-family: "verdana" , sans-serif; font-size: medium;"><span style="color: #2a2a2a; line-height: 12.8px;"> </span></span></b></span></h4>
<div>
<span style="font-size: xx-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: medium;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></div>
</div>
Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com3tag:blogger.com,1999:blog-8769980932654813319.post-84019398534801859282017-04-04T04:16:00.001-07:002020-04-20T02:23:34.138-07:00Step by Step Configuring AlwaysOn with Log Shipping<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<span style="font-size: 12.8px;">One of my clients came up with a requirement to use log shipping along with an AlwaysOn Availability Group. They cannot extend an AlwaysOn replica to the disaster recovery site for a few reasons listed below;</span></div>
<ul style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; list-style-position: outside; margin: 0px; padding-left: 1.3em;">
<li>Infrastructure or staffing to maintain WSFC configurations between different sites</li>
<li>Delayed Recovery – In Log-shipping we can have definite delay on secondary database, SLAs on RPO, RTO force a fast recovery from manual error which only can be realized with delayed recovery restoring the transaction log backups on one instance of the HA/DR strategy</li>
</ul>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
We have two SQL Servers in AlwaysOn AG Group SQL1 and SQL2 in Primary site for HA. One SQL Server instance SQL3 in secondary site for disaster recovery. The primary site is already setup with a two node AlwaysOn Availability Group (AG) with SQL1 as the primary replica and SQL2 as the secondary replica. </div>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
In the below screenshot, SQL1 is the primary replica and SQL2 is the secondary replica<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCnTRIrAkhxE22KfxDo1u0XiXSA_yvEOWFZzXVEOnLWw3ri-GH2wZyecZy52YUK3oD0GEYKVF4EFBdwfkPr-P2GhKGFYAIroPpQ5MTftIQI0KmZJXeRlQd6UiFEXxFKMRuTXGl55UqBe8/s1600/2.jpg" imageanchor="1" style="clear: left; font-size: 12.8px; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img border="0" height="359" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCnTRIrAkhxE22KfxDo1u0XiXSA_yvEOWFZzXVEOnLWw3ri-GH2wZyecZy52YUK3oD0GEYKVF4EFBdwfkPr-P2GhKGFYAIroPpQ5MTftIQI0KmZJXeRlQd6UiFEXxFKMRuTXGl55UqBe8/s640/2.jpg" width="640" /></a></div>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
To configure AlwaysOn Availability Groups, Reference: <a href="http://mssqllover.blogspot.in/2017/02/alwayson-availability-groups-step-by.html" style="color: #225588; cursor: pointer; font-size: 12.8px; text-decoration: none;">http://mssqllover.blogspot.in/2017/02/alwayson-availability-groups-step-by.html</a></div>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
To configure Log-shipping, Reference: <a href="http://mssqllover.blogspot.in/2017/03/step-by-step-logshipping-configuration.html" style="color: #225588; cursor: pointer; text-decoration: none;">http://mssqllover.blogspot.in/2017/03/step-by-step-logshipping-configuration.html</a></div>
<h2 style="background-color: white; color: #003366; font-family: Arial, Helvetica, sans-serif; font-size: 19.2px; margin: 1em 0px 0.2em; padding: 0px;">
How to setup Log-Shipping on Database part of AlwaysOn Availability Groups</h2>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Log shipping involves copying a database backup and subsequent transaction log backups from the primary (source) server and restoring the database and transaction log backups on one or more secondary (Stand By / Destination) servers. By default, Alwayson backup preferences are set to prefer the secondary. You have to change backup preference and select as primary. In an AlwaysOn Availability Group, BACKUP LOG supports regular log backups only. COPY_ONLY transaction log backups are not supported on secondary replicas.</div>
<div style="background-color: white; color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Right click on the AG group and select backup preference. Select the primary as the backup preference.<br />
<br />
<br />
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: medium; margin: 0px; position: relative;">
<span style="font-size: x-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: large;"><span style="color: #2a2a2a; line-height: 12.8px;">Read My Complete Article "</span><a href="http://www.sqlservercentral.com/articles/AlwaysOn/153622/" style="color: #225588; cursor: pointer; line-height: 12.8px; text-decoration: none;" target="_blank">Here</a><span style="color: #2a2a2a; line-height: 12.8px;">"</span></span></b></span></h4>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: medium; margin: 0px; position: relative;">
<span style="font-size: x-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: large;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: medium; margin: 0px; position: relative;">
<span style="font-size: x-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: large;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: medium; margin: 0px; position: relative;">
<span style="font-size: x-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: large;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: medium; margin: 0px; position: relative;">
<span style="font-size: x-small;"><b><span style="font-family: "verdana" , sans-serif; font-size: large;"><span style="color: #2a2a2a; line-height: 12.8px;"><br /></span></span></b></span></h4>
<div style="font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
<strong style="color: #003366; font-size: 12.8px;">Ganapathi varma Chekuri</strong></div>
<div style="font-size: 12.8px; margin-bottom: 0.6em; margin-top: 0.6em; padding: 0px;">
Email: gana20m@gmail.com</div>
<h4 style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: medium; margin: 0px; position: relative;">
<span style="font-size: x-small;"><a href="http://in.linkedin.com/pub/ganapathi-varma-chekuri/54/279/874/" style="color: #225588; cursor: pointer; font-family: arial, helvetica, sans-serif; font-size: 12.8px; text-decoration: none;">Linkedin</a><b><span style="font-family: "verdana" , sans-serif; font-size: large;"><span style="color: #2a2a2a; line-height: 12.8px;"> </span></span></b></span></h4>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCnTRIrAkhxE22KfxDo1u0XiXSA_yvEOWFZzXVEOnLWw3ri-GH2wZyecZy52YUK3oD0GEYKVF4EFBdwfkPr-P2GhKGFYAIroPpQ5MTftIQI0KmZJXeRlQd6UiFEXxFKMRuTXGl55UqBe8/s1600/2.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a></div>
<br /></div>
</div>
Ganapathi Varma Chekurihttp://www.blogger.com/profile/07125530325790202743noreply@blogger.com5tag:blogger.com,1999:blog-8769980932654813319.post-83322002887924839212017-03-23T06:23:00.000-07:002017-03-23T06:28:55.789-07:00TempDB Database On a Local Disk for an FCI<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Link Below:<br />
<h3 style="text-align: left;">
<br /></h3>
<h3 style="text-align: left;">
<a href="http://www.sqlservercentral.com/articles/failover/137066/" target="_blank">TempDB Database On a Local Disk for an FCI</a></h3>
<div>
<br /></div>
<span style="background-color: white; color: #2a2a2a; font-family: "arial" , "helvetica" , sans-serif; font-size: 16px;">This article will be helpful in configuring TempDB on a local Disk instead of shared storage in SQL Server 2012/2014. This will reduce the I/O requests from the shared storage and overall it can improve performance.</span></div>
Sadan Kumar Buddehttp://www.blogger.com/profile/03219932060161505759noreply@blogger.com0