Week in Review + SQL Aggregate Functions, Learn Performance Tuning and Collect Securities Prices (MSSQLTips 6/27/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server belongs on Azure]( [Overview of How to Collect Securities Prices for SQL Server]( [Overview of How to Collect Securities Prices for SQL Server]( The options for collecting securities prices are rapidly evolving and in this article, we look at different approaches to get data to load into SQL Server.... [SQL Aggregate Functions Having, Order By, Distinct, Partition By and more in SQL Server, Oracle and PostgreSQL]( [SQL Aggregate Functions Having, Order By, Distinct, Partition By and more in SQL Server, Oracle and PostgreSQL]( Learn about similarities and differences of aggregate functions when using Having, Order By, Distinct, Partition By and more in SQL Server, Oracle and PostgreSQL.... [Get better performance for less on Azure]( [Get better performance for less on Azure]( In a recent study commissioned by Microsoft, Principled Technologies found Azure SQL Managed Instance leads in mission critical price-performance, providing up to 5 times faster performance and costing up to 93% less than AWS RDS. Read the report.... [Getting Started with Databricks Delta Live Tables]( [Getting Started with Databricks Delta Live Tables]( Learn how to get started with Delta Live tables for building pipeline definitions with Databricks notebooks to ingest data into the Lakehouse and declaratively build live pipelines to transform raw data and aggregate business level data for insights ... [Solve SQL Server Performance Issues Fast!]( [Solve SQL Server Performance Issues Fast!]( In this webinar we will discuss things you should be aware of when optimizing your SQL Server environment. We will cover how you can quickly identify issues, collect and analyze data and make the right changes to resolve the problems.... [SQL Server Connection Strings using SqlClient, OLDEDB and ODBC]( [SQL Server Connection Strings using SqlClient, OLDEDB and ODBC]( In this article we look at different ways to define a connection string to connect to SQL Server using SqlClient, OLDEDB and ODBC connections.... [Application Performance Monitoring for all of IT]( [Application Performance Monitoring for all of IT]( We need to understand the performance issues in the environment at a high level, prioritize our findings then drill into the root cause in order to correct the issues. Ideally, we would like to have a single monitoring tool for the DBA, Development a... [SQL Server Management Studio Dark Mode]( [SQL Server Management Studio Dark Mode]( Learn how to configure SQL Server Management Studio to use dark mode in this step-by-step article.... [Healthcare, Clinical and Life Sciences Organizations - Improve Your Data Quality]( [Healthcare, Clinical and Life Sciences Organizations - Improve Your Data Quality]( All companies fundamentally have the need to improve data quality for decision making. For healthcare, clinical and life sciences organizations, merging, reconciling and enhancing data is challenging for electronic medical records, clinical trials an... MSSQLTips Week In Review [5 use cases of SQL Average]( [5 use cases of SQL Average]( Learn various ways to calculate the average of a set of SQL Server rows using the AVG function along with several use cases and examples.... [Becoming a Cloud Data Platform Driven Organization - Part 2]( [Becoming a Cloud Data Platform Driven Organization - Part 2]( This article explores the benefits of adopting a cloud data platform by defining the guiding principles of a Cloud Data Lakehouse, along with what a foundational data journey into the cloud might look like. ... [How to Increase the Vertical Orientation of Power BI Report Page]( [How to Increase the Vertical Orientation of Power BI Report Page]( In this article we take a look at how to make the size of a Power BI canvas larger so you can have more space to add visuals to the report.... [How to Query SQL Data with Python pyodbc]( [How to Query SQL Data with Python pyodbc]( In this tip we examine pyodbc an open-source module that provides easy access to ODBC databases along with several examples of how it could be used.... [Learn about SQL SSMS Ports for SQL Server]( [Learn about SQL SSMS Ports for SQL Server]( In this article we learn about network ports used for SQL Server and how to find and use the correct port to connect to SQL Server using SSMS or any application.... [SQL Server vs Oracle: Semantic Search]( [SQL Server vs Oracle: Semantic Search]( Learn about semantic search capabilities in SQL Server and Oracle as well as how to configure databases to use semantic search.... [What is a data pipeline?]( [What is a data pipeline?]( In this article we cover what data pipelines are, how they compare to ETL and some of the tools that are available.... [Why shouldn't I create 15,000 SQL Server partitions in advance?]( [Why shouldn't I create 15,000 SQL Server partitions in advance?]( In this article we look at SQL Server table partitioning and why you would not want to create the maximum 15,000 partitions that are possible for a table.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}