SQL SELECT DISTINCT Examples, What is an SSIS Package and Week In Review (MSSQLTips 4/5/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Machine Learning Tutorial]( [What is an SSIS Package]( [What is an SSIS Package]( This tip will teach you what a SQL Server Integration Services package is and what you can do with a SSIS package. This a high level overview to help you get started.... [SQL SELECT DISTINCT Examples]( [SQL SELECT DISTINCT Examples]( In this article we look at how to retrieve a list of distinct datasets from SQL Server without repeating information using the DISTINCT clause.... [Indexing for Performance: Query Strategies to Maximize Your SQL Server Indexes]( [Indexing for Performance: Query Strategies to Maximize Your SQL Server Indexes]( [Free Webinar] Few things influence the speed and performance of SQL statements within SQL Server as much as indexes. This session will help you understand the basics of query performance in relation to the indexes on your production database. We'll ... [Top Features in SQL Server Data Tools for Database Projects]( [Top Features in SQL Server Data Tools for Database Projects]( In this tip we cover some interesting features of SQL Server Data Tools to use when working on database projects.... [End to End Performance Monitoring for SQL Server Applications]( [End to End Performance Monitoring for SQL Server Applications]( End to End Monitoring | Health | Availability - I need to monitor the SQL Server instances in my environment and our IT team has a need to monitor the health and availability of our overall environment. We need to understand the issues in the environ... [INSERT INTO for SQL Server, Oracle and PostgreSQL]( [INSERT INTO for SQL Server, Oracle and PostgreSQL]( In this article we look at the different SQL syntax you need to use when inserting data into tables for SQL Server, Oracle and PostgreSQL.... [Improve Data Quality for SQL Server Reporting]( [Improve Data Quality for SQL Server Reporting]( Recently, we uncovered the root cause of our reporting issues: poor data quality for portions of our data. Some data is out of date, while other data is not formatted consistently based on numerous source systems, particular data does not properly m... [T-SQL Tips and Tricks]( [T-SQL Tips and Tricks]( In this article learn some TSQL tips and tricks working with CTEs, UPDATES, Window Functions, Duplicate Rows, Tally Tables and Concatenating string values in SQL Server.... [Smashing SQL Server Silos with APIs]( [Smashing SQL Server Silos with APIs]( [Webcast] DreamFactory is an API management platform best known for its ability to generate REST APIs for a wide variety of data sources, including Microsoft SQL Server. Organizations around the globe use the platform to reduce if not entirely elimin... MSSQLTips Week In Review [Common Data Transformations in Power Query]( [Common Data Transformations in Power Query]( In this article we walk through an example of using Power Query to transform source data that can be used in a Power BI report.... [Create a Python Wheel File to Package and Distribute Custom Code]( [Create a Python Wheel File to Package and Distribute Custom Code]( In this article we will explore how to create a Python wheel file using Visual Studio Code, load it to a Databricks Cluster Library, and finally call a function within the package in a Databricks Notebook.... [Drop All Tables in a SQL Server Database]( [Drop All Tables in a SQL Server Database]( In this article we cover different ways to drop all tables from a SQL Server database.... [Export SQL Server Data to Excel and Add New Columns with C#]( [Export SQL Server Data to Excel and Add New Columns with C#]( Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.... [File Handling in a SharePoint Document Library Using Python]( [File Handling in a SharePoint Document Library Using Python]( In this article we look at several Python script examples that all you to manipulate files within a SharePoint document library.... [Learn basics of Data Wrangling in SQL Server to handle Invalid Values]( [Learn basics of Data Wrangling in SQL Server to handle Invalid Values]( In this article we cover the topic of data wrangling which is steps you can take to cleanup and validate data prior to data analysis.... [Multi-Site Multi-Cluster SQL Server Installation with Clustering and Availability Groups]( [Multi-Site Multi-Cluster SQL Server Installation with Clustering and Availability Groups]( In this article we walk through the steps to setup a multi-site multi-cluster SQL Server installation for both high availability and disaster recovery using clustering and availability groups.... [Power Apps Canvas Apps Examples]( [Power Apps Canvas Apps Examples]( In this article we will focus on Power Apps canvas apps which are natively optimized for mobile devices and we will look at potential use cases for canvas apps. ... [Powershell Commands for SQL Server Always On Availability Groups]( [Powershell Commands for SQL Server Always On Availability Groups]( This article can contains a PowerShell script to help you monitor and failover any SQL Server Availability Group you manage.... [SQL Window Functions in SQL Server, Oracle and PostgreSQL]( [SQL Window Functions in SQL Server, Oracle and PostgreSQL]( In this article we look at using Window Functions in SQL Server, Oracle and PostgreSQL to see the differences and similarities of the syntax.... [SSMS Custom Report for SQL Server Database Metrics]( [SSMS Custom Report for SQL Server Database Metrics]( In this article we look at a custom SSRS report that you can download. The report collects and displays several different SQL Server database level metrics. ... [String to Numeric Geographic Coordinates in SQL Server with T-SQL]( [String to Numeric Geographic Coordinates in SQL Server with T-SQL]( In this article we look at TSQL scripts that can be used to convert city and country names into geographical latitude and longitude coordinates.... [Trick to Optimize TOP clause in SQL Server]( [Trick to Optimize TOP clause in SQL Server]( In this article we look at how the TOP clause could impact query performance and some tricks to make the optimizer work better.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] Edgewood Solutions LLC | PO Box 682, Wilton, NH 03086 [Unsubscribe {EMAIL}]( [Update Profile]( | [Customer Contact Data Notice]( Sent by newsletter@mssqltips.com