Learn about SQL Server on AWS Cloud, Entity Framework Core and DevOps (MSSQLTips 09/13/2019)

Free SQL Server Resources [SQL Server on AWS Cloud]( [Webcast] With many cloud providers and options available, it's hard to decipher what would work best for your SQL Server environment. Tom Staab, of AWS, and Dave Bermingham, of SIOS Technology Corp., discuss the benefits of running SQL Server business-critical application workloads on AWS while addressing key requirements of price, performance and availability. And they welcome AWS and SIOS customer, Beth Israel Deaconess Medical Center, Database Engineer, Huili Shao, to explain their journey to the AWS cloud and how the decision was made to use SIOS for high availability. [Entity Framework Core Raw SQL Queries Examples]( In this article we look at how to run SQL Server queries with Entity Framework Core using the DbSet.FromSql method, parameterized queries, stored procedures and using the Database.ExecuteSqlCommand property. [Free E-book: The DBA's Guide to the Cloud, Open Source and DevOps]( [Whitepaper] Gone are the days of the Oracle or SQL Server shop. Just when you've mastered one approach to database management and monitoring, business decides to cut costs by adopting the cloud and open-source databases. As if those massive changes weren't enough, the shift toward a DevOps culture, in which companies can remain competitive by accelerating release cycles, is also becoming more prevalent. [SQL Server Database Encryption]( In this tip we will focus on protecting online client data. SQL Server natively offers a number of ways to encrypt and protect your data. One option is Column Level Encryption. A second is Transparent Data Encryption. You also have the ability to add passwords to your backups and Windows offers some native encryption options. [Tutorial - SQL Reporting Services]( SQL Server Reporting Services or SSRS has been the go to reporting solution for SQL Server for almost a decade now. In many organizations, the ease of development, the web front end, and the security integration with Active Directory allowed SSRS to reign in as the reporting tool of choice. Still today it is a highly competent and able tool which has grown in feature availability and overall usage. For this tutorial we will focus on SQL Server 2017, but many of the features to be highlighted in this tutorial series apply to SQL Server 2016 and prior versions. [Five Costly Myths About High Availability in Cloud]( [Whitepaper] While the benefits of the cloud may be clear for applications that can tolerate brief periods of downtime, it is not as clear for business critical applications, such as SQL Server, Oracle, and SAP that require high availability and disaster recovery protection. 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. [Tutorial - Windows Performance Monitor]( Performance Monitor (PerfMon) is a tool that comes built-in with Windows and allows you to look into the performance of your system and the applications that are running on it. It gives you a way to view data points that are associated with these applications and link them with the effect they have on your system. You can monitor data points both in real-time or collect them for analysis at a later time. Collection can also be scheduled for specific times of the day if there are only specific windows of time where you are experiencing an issue that you would like to monitor. 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}