SQL Server Backup Compression, New Features in Entity Framework Core 3.0 and more (MSSQLTips 12/31/2019)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [SQL Server Graphical Query Plan Tutorial - Get Started]( [SQL Server Backup Compression using WinRAR]( Backup Compression | Split Files | Restore - In this tip we look at how to use WinRAR to backup and compress a SQL Server database backup and write to multiple smaller files.... [SQL Server Performance Tuning Hints and Tricks]( [Webcast] The goal of this presentation is to give you a set of steps you can follow that will detect and fix a lot of the most common SQL Server performance issues you will encounter.... [New Features in Entity Framework Core 3.0]( Whats New | Code Samples - This article provides an overview of the new features and enhancements in Entity Framework Core 3.0 with code examples to explain the concepts.... [Get the facts - Is SQL Server HA and DR just too expensive?]( Understand the costs associated with high availability and disaster protection in a SQL Server environment. Learn about the changes in SQL Server 2012 that have nearly doubled the cost of licensing... [How to Build your First Power BI Dashboard]( Power BI | Getting Started | Step by Step - In this tip we will learn how we can start building our first Power BI dashboard.... [Improve SQL Server Virtual Machine Storage Performance]( Whether you are running in an on-premises or cloud environment, your virtualized storage may not have the performance needed to support your user base. Do not be misled, there are options in SQL Server, Windows and your infrastructure beyond upgradin... [SQL Server Data Mining Tutorial]( SQL Server Analysis Services contains a variety of data mining capabilities which can be used for data mining purposes like prediction and forecasting. This tutorial aims to explain the process of using these capabilities to design a data mining mode... [SQL Server Analysis Services Administration Tutorial]( Any IT environment employing SSAS as its OLAP technology typically involves the following administrative tasks. These tasks are an integral part of any SSAS solution that Developers as well as DBAs need to perform in production and/or non-production ... MSSQLTips Week In Review [Create Tables in SQL Server with T-SQL]( Development | Sample T-SQL Code | CREATE TABLE - In this tip we look at different T-SQL examples to create SQL Server tables.... [SQL Server Maintenance Plan Execute T-SQL and SQL Server Agent Job Tasks]( Custom Tasks | Step By Step - In this tip we look at how to use the Execute T-SQL Statement and Execute SQL Server Agent Job tasks in SQL Server Maintenance Plans.... [Types of SQL Server Indexes]( Query Performance | Indexes | Design - In this tip we will go through each type of index that is available in SQL Server and give an overview as well as advice on which index types fit each particular use case. ... [When To Give Letter of Recommendation During Interview]( Interviewing | Best Practices - Read these tips to truly stand out throughout the submission, interviewing and selection process to effectively market yourself as a strong technical and culture fit.... [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}