Alter SQL Server User Defined Table Type, Create Entity Data Model and more (MSSQLTips 08/08/2019)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [SQL Server Integration Services Tutorial - Start Learning]( [How to Alter User Defined Table Type in SQL Server]( In this tip we look at the steps do modify a user defined table type in SQL Server because a simple ALTER or DROP doesn't work.... [Create Entity Data Model using a Database First Approach]( This article presents a discussion on how we can create an Entity Data Model using the Database First approach in Entity Framework Core. ... [Data Protection Rules for SQL Server Apply to You Too]( [Webcast] Join us for this webcast to learn about data protection guidelines like GDPR and CCPA and how to make sure that your SQL Server environment is compliant to these regulations before your company gets hit with fines.... [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... [How to fix SQL Server Database Corruption]( Needless to say, downtime is costly and directly impacts the business with lost productivity and sales. As SQL Server DBAs we have a number of responsibilities, one of which is to ensure the uptime of our databases. Unfortunately, practicing to resol... [Troubleshooting transactional replication latency issues in SQL Server]( I have several clustered SQL Server 2012 instances installed and I am having issues with replication latency. The environment has a dedicated SQL Server instance for the distributor. One instance has publisher database(s) and another instance has subscrib... [How to create a SQL Server foreign key]( In this tip we look at how to create a SQL Server foreign key using both T-SQL and the SSMS GUI.... [SQL Server Reporting Services (SSRS) Controlling Report Page Breaks]( The final report display for Reporting Services reports various depending on the method of output and I want to know how to control and appropriately set pages and page breaks in SSRS? In this tip we look at different options for control soft and hard pag... [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}