Data Platform Options, SSIS Configuration File, SQL Tutorials and Week in Review (MSSQLTips 2/6/2023)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Machine Learning Tutorial]( [Getting started with SSIS External Configuration File]( [Getting started with SSIS External Configuration File]( This article illustrates how to use an SSIS external configuration file to enable the properties of package objects to be dynamically updated at run time.... [Data Platform Options - Relational, NoSQL, Graph, Apache Spark and Data Warehouses]( [Data Platform Options - Relational, NoSQL, Graph, Apache Spark and Data Warehouses]( Learn about various data platforms such as relational databases, NoSQL databases, Graph databases, Apache Spark, and Data Warehouses for your next data platform project.... [SQL Server Performance Tuning and Operational Monitoring]( [SQL Server Performance Tuning and Operational Monitoring]( Learn about the SQL Server performance and operational monitoring capabilities for DBAs with ManageEngine Applications Manager....... [SQL Server 101 Tutorial Outline and Overview]( [SQL Server 101 Tutorial Outline and Overview]( In this tutorial we look at the different components that make up SQL Server to give you an overview of the various parts and how they work together....... [Powerful SQL Server Data Quality Tools for Cleansing and Validation]( [Powerful SQL Server Data Quality Tools for Cleansing and Validation]( Learn how Data Stewards can leverage Unison from Melissa Data to solve data quality issues such as duplicate records and enrich contact data for better decision making....... [SQL Server Performance Tuning and Monitoring Tutorial]( [SQL Server Performance Tuning and Monitoring Tutorial]( Learn about different ways you can collect data from SQL Server to help improve performance....... [Build a Secure SQL Server REST API in Minutes]( [Build a Secure SQL Server REST API in Minutes]( Learn how to build a secure SQL Server REST API in minutes with DreamFactory which is middleware that connects all of your applications across the enterprise in a secure manner....... [SQL Server Integration Services Tutorial]( [SQL Server Integration Services Tutorial]( This is an overview of the SSIS 2016 tutorial and the various things that will be covered....... [Encryption Protection for your Application and SQL Databases]( [Encryption Protection for your Application and SQL Databases]( Your organization has a number of "legacy" SQL Server instances and data centric applications that have grown over the years to support your core business needs and come up to compliance. The time, energy, costs (hardware, software licensing, etc.) ...... MSSQLTips Week In Review [An Introduction to Assessing Normal Distribution with Python]( [An Introduction to Assessing Normal Distribution with Python]( This tip illustrates graphical and statistical techniques for assessing if values are normally distributed using Python code.... [Automate the Extraction of Email Attachments and Save Files in SharePoint Folder]( [Automate the Extraction of Email Attachments and Save Files in SharePoint Folder]( This article covers how to use Power Automate to automate the extraction of email attachments for a given email account and uniquely save the files in a SharePoint folder.... [Deploy SQL Server in Google Cloud]( [Deploy SQL Server in Google Cloud]( Learn how to deploy SQL Server instances on a virtual machine (VM) inside the Google Cloud Platform (GCP) in this step-by-step article.... [json_object and json_array Functions SQL Server 2022 Tutorial]( [json_object and json_array Functions SQL Server 2022 Tutorial]( Learn about the new functions JSON_OBJECT and JSON_ARRAY to work with JSON formatted data in SQL Server.... [Managing Teams, Empowering Growth and Enhancing Performance in the Digital Age]( [Managing Teams, Empowering Growth and Enhancing Performance in the Digital Age]( As a cloud tech leader, it can be challenging to effectively manage digital teams, especially in the current climate where remote work is more prevalent. This article covers various aspects of how to overcome these challenges and effectively manage digita... [Resources for PL-900 Microsoft Power Platform Fundamentals Certification Exam]( [Resources for PL-900 Microsoft Power Platform Fundamentals Certification Exam]( This resource includes several links to related topics to help you prepare for and pass exam PL-900 Microsoft Power Platform Fundamentals.... [Retrieve a File from Azure Blob Storage with an Azure Function]( [Retrieve a File from Azure Blob Storage with an Azure Function]( In this tip, we'll cover a solution that retrieves a file from Azure Blob storage into the memory of an Azure Function.... [SSIS Interview Questions and Answers for Developers and DBAs]( [SSIS Interview Questions and Answers for Developers and DBAs]( This article contains over 50 questions that can help prepare you for an interview for a SQL Server Integration Services (SSIS) related job.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}