Managing SQL Server Identity Values, Simple Linear Regression to Make Predictions and High Availability Myths (MSSQLTips 7/24/2020)

Free SQL Server Resources [Five Costly Myths About High Availability in Cloud]( [Whitepaper] Separating the facts and myths of HA and DR in cloud deployments can help you save money and reduce risk of downtime and data loss. [Using Simple Linear Regression to Make Predictions]( The first part of this article focuses on using an R program to find a linear regression equation and the second part is devoted to simple linear regression analysis. [SQL Server Transparent Data Encryption Alternative]( Whether you are facing GDPR, HIPAA, PCI, etc. regulations, encrypting your SQL Server databases is a critical component to be compliant. SQL Server offers a few different options to encrypt databases including column level encryption and transparent data encryption with Enterprise Edition. Learn about alternative solutions to be compliant. [Managing and maintaining SQL Server identity values]( In this article we look at how to check the current values for an identity column and how to reset the value for the next record. [Find, Analyze and Optimize SQL Server Performance]( Learn about the Query Tuning and Table Tuning Advisors in SolarWinds Database Performance Analyzer to find, analyze and optimize SQL Server performance. [Azure Data Factory vs SSIS vs Azure Databricks]( In this article we cover some things you should consider when determining whether to use Azure Data Factory, SSIS or Azure Databricks. [Secrets to Fast, Easy High Availability for SQL Server in AWS]( [Whitepaper] Moving SQL Server from an on-premises data center to a public cloud such as AWS can enable your business to be more agile and more responsive to changing market requirements and customer needs. More on MSSQLTips: [Tips]( [Tutorials]( [Webcasts]( [tag] You are receiving this email as a subscriber of MSSQLTips.com. [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC | PO Box 682 | Wilton, NH 03086 | [Privacy Statement]( Sent to this e-mail address: {EMAIL}