Azure Synapse Analytics Workspace Capabilities, SSIS vs ADF, Azure Cosmos DB Consistency Levels and SQL Server Download Quick Links (MSSQLTips 3/3/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Migrating and Optimizing Databases in the Cloud]( [Azure Cosmos DB Consistency Levels - Strong, Bounded Staleness, Session, Consistent Prefix and Eventual]( [Azure Cosmos DB Consistency Levels - Strong, Bounded Staleness, Session, Consistent Prefix and Eventual]( In this article we cover the different data consistency levels in Cosmos DB such as Strong, Bounded Staleness, Session, Consistent Prefix and Eventual.... [Understanding the Capabilities of Azure Synapse Analytics Workspace]( [Understanding the Capabilities of Azure Synapse Analytics Workspace]( In this article learn about Azure Synapse Analytics workspace offerings like storage, development notebooks, integration capabilities, monitoring and management. ... [Managing ETL Data Migration into the Cloud]( ) [Managing ETL Data Migration into the Cloud]( ) Moving to cloud platforms like Amazon RDS or Azure SQL Database/Managed Instance, can be challenging, especially to developers coming from an on-premises background. Read this eBook to learn more about how to Manage an ETL Data Migration into the Clo... [Choosing Between SQL Server Integration Services and Azure Data Factory]( [Choosing Between SQL Server Integration Services and Azure Data Factory]( In this article we look at the similarities and differences of SSIS and Azure Data Factory and provide some insight as to when you would use one over the other.... [Find, Analyze and Optimize SQL Server Performance]( [Find, Analyze and Optimize SQL Server Performance]( As a SQL Server Professional, application performance is one of my top priorities. I know our applications have numerous inefficiencies and we are constantly firefighting to keep our internal and external users productive. Our team collects data al... [SQL Server Download Quick Links]( [SQL Server Download Quick Links]( SQL Server download quick links are included in this tip for the SQL Server engine, Express Edition, Service Packs, tools and more. Be sure to bookmark this page to use as a quick and comprehensive reference guide.... [How to Conduct a Security Review on SQL Server]( [How to Conduct a Security Review on SQL Server]( Learn about standard SQL Server requirements for auditing to meet all your compliance criteria. Next, learn about recommended security ... [SQL Server CTE vs Temp Table vs Table Variable Performance Test]( [SQL Server CTE vs Temp Table vs Table Variable Performance Test]( In this tip we will go through a few simple SELECT queries in order to compare the performance using each type of object, temp table, table variable and a CTE, to store the temporary data.... [SQL Server Data Quality - Measured]( [SQL Server Data Quality - Measured]( [Survey] With the proliferation of data across the globe, data quality, accuracy and management present significant challenges for data professionals in the SQL Server community. Share your experiences.... [By Ashish Kumar Mehta - ]( [Steps to Rename a SQL Server Database]( In this tip we look at what steps should be taken to rename both the database as well as logical and physical files names for a SQL Server database.... [By Tim Wiseman - ]( [Using Parameters for SQL Server Queries and Stored Procedures]( One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this t... [By Koen Verbeeck - ]( [Introduction to Business Intelligence Markup Language (BIML) for SSIS]( Every ETL project has some repetitive tasks, but with SSIS out-of-the-box, you are forced to create multiple individual packages which is very time consuming due to the lack of easy code reuse. In this tip we show how you can get reuse using Business Inte... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}