Data Science for SQL Server Professionals (MSSQLTips 05/14/2018)

[View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [Free SQL Server Tutorials]( [Data Science for SQL Server Professionals]( In this tip we do an overview of Data Science and the high level process. Take a look at this tip to get started.... [Geocoding and Generating Map Images Using R in SQL Server 2017]( In this tip we look at how you can use R inside of SQL Server to generate geocoded map images using the Google APIs.... [Surprise! Welcome to Your First Cloud Bill]( One of the many promises of cloud computing is that it can be more cost-effective than traditional on-premises data centers. However, when many organizations migrate their workloads to the cloud, they experience sticker shock in the first couple of m... [Create a High Performance SANLess SQL Server Cluster]( Making SQL Server deployments resilient to failures is a goal most want to achieve. Whether you are trying to account for high availability and/or disaster recovery, there are various methods to achieve the end goal. One of the most popular approache... [SQL Server Transparent Data Encryption Alternative Solution]( Our challenge is to offer the organization a seamless solution across numerous applications as well as editions and versions of SQL Server. How can we properly encrypt our SQL Server data to protect the organization?... MSSQLTips Week In Review [4 Factors When Choosing to Automate SQL Server Tasks]( Learn about four factors when choosing to automate SQL Server tasks including time savings, security vulnerabilities, data validation and manual interventions.... [Azure SQL Database Table Partitioning Example]( Learn the steps to perform Azure SQL Database table partitioning.... [Benefits of using SQL Server Temporal Tables - Part 1]( In this tip we look at the benefits of using SQL Server Temporal tables for quick recovery of deleted data or accidental data updates.... [Calculating Employee Attrition with DAX – Part 2]( In this tip we show how you can calculate employee attrition rates with SSAS. We look at using DAX with related and unrelated dimensions to show how this can be done.... [Customizing Dashboards in SQL Operations Studio]( In this tip we look at how you can create customized dashboards in SQL Operations Studio.... [Issue with UNION and columns with mismatched data types in SQL Server]( In this tip we take at look at the impact with using UNION when column data types do not match and SQL Server does an implicit conversion.... [Migrate a database from SQL Server 2008 to 2016 and use new features]( Learn the step by step process to migrate a SQL Server database from 2008 to 2016 including compatibility levels, query store, new filegroups, heap tables, blob tables and more.... [SQL Server Stored Procedure to Calculate Area of a Polygon and Draw its Shape]( Learn how to create a SQL Server T-SQL stored procedure to calculate the area of a polygon and draw its shape for circles, squares, pentagons, etc.... [Understanding SQL Server Service Broker Communication Flow Between Databases]( In this tip we look at how the SQL Server transaction log is used to transmit service broker messages between the source and target databases.... [Using Advanced Publish Settings for Visual Studio Database Project]( In this tip we look at how to use some of the advanced publishing settings when deploying database changes using Visual Studio.... [Twitter]( [Facebook]( [LinkedIn]( [Google+]( You are receiving this as a subscriber of MSSQLTips.com. If you wish to discontinue receiving email, please send us an email to [unsubscribe](mailto:unsubscribe@mssqltips.com?subject=UNSUBSCRIBE). Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}