Concurrency in Entity Framework Core and ADF Pipeline Dependencies (MSSQLTips 07/29/2019)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [SQL Server Performance Monitoring and Tuning Tutorial - Improve Performance Now]( [How to handle concurrency in Entity Framework Core]( In this tip we look at how to handle SQL Server database concurrency issues using Entity Framework Core for both pessimistic and optimistic concurrency.... [Stairway to Azure Data Factory: Building pipeline dependencies]( In this tip we look at Azure Data Factory dependencies and how to build a pipeline using different types of dependencies. ... [Moving your SQL Server 2008/2008 R2 to Azure - Everything Enterprises Need to Know!]( [Webcast] Support for SQL Server 2008 and 2008 R2 ends July 9th. What does that mean for your Enterprise workloads? Attend this webcast to learn what steps you can take to keep your systems running.... [Streamline SQL Server Job Management]( Our job scheduling is so complex, from a business perspective. We have a number of related processes that we need to call over the course of the day. We have setup many of these processes in SQL Server as jobs across numerous SQL Server instances th... [Do you need a faster 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... MSSQLTips Week In Review [Find SQL Server Integer Columns to Make Skinnier]( In this tip we look at a SQL Server script you can use to determine if you can convert your big integer columns to smaller integer data types to save storage space.... [Getting Started with SQL Server Indexing for Performance, Covering Indexes, Implicit Conversions and Parameter Sniffing]( In this tip we continue our series on best practices for improving T-SQL performance with tips on sargability, parameter sniffing, covering indexes and more.... [Getting Started with SQL Server Maintenance Plans - Part 1]( In this article we look at how to use the SQL Server Maintenance Plan Wizard to create maintenance tasks.... [How to use @@ROWCOUNT in SQL Server]( In this tip we look at how to use the SQL Server @@ROWCOUNT system variable and things you should know about its usage.... [Query SQL Server Agent Jobs, Job Steps, History and Schedule System Tables]( In this tip we look at different queries you can use to directly get information about SQL Server Agent Jobs instead of using SQL Server Management Studio.... [Relational Databases vs Graph Databases]( In this tip we will address questions that will help relational database developers understand the various considerations for using a graph database.... [SQL Server Hierarchyid Example for Bill of Materials]( This tip leverages a prior tip introducing the hierarchyid data type with examples for creating and querying a bill of materials table with hierarchyid values.... [SQL Server Logon Trigger Examples]( In this tip we look at how to create SQL Server Logon Triggers and show different examples of how this can be used.... [Two big reasons to use SQL Server Management Studio 18 - High DPI Support and Query Results Output Now 2 MB]( In this tip we look at two new features of SQL Server Management Studio that are worth getting, high definition interface support and increased query results output size to 2MB.... [Twitter]( [Facebook]( [LinkedIn]( 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}