SQL Server Developer Resources and Week in Review (MSSQLTips 4/26/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Instant REST APIs for SQL Server]( [Upgrade and Migrate SSIS Catalog and SSISDB to a New Server]( [Upgrade and Migrate SSIS Catalog and SSISDB to a New Server]( In this article we look several different options to upgrade and migrate the SSIS catalog and SSISDB to a new SQL Server.... [Introduction to Python Bar Charts and Line Charts]( [Introduction to Python Bar Charts and Line Charts]( In this article learn how to create bar charts and line charts using Python.... [Siloed Data Locked In Your SQL Server?]( [Siloed Data Locked In Your SQL Server?]( Database APIs are the most effective way to liberate and secure valuable organisational data, to get it to the people and platforms who need it the most. DreamFactory smashes data silos with automatic API generation for SQL Server, freeing up develop... [Date and Time Conversions Using SQL Server]( [Date and Time Conversions Using SQL Server]( In this article we look at several different date and time formats you can use in SQL Server.... [Secure and Fast SQL Server REST APIs]( [Secure and Fast SQL Server REST 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... [SQL Server Loop through Table Rows without Cursor]( [SQL Server Loop through Table Rows without Cursor]( In this tip we look at a comparison of a SQL Server cursor and a While Loop to show how to perform the same operations using the two different looping mechanisms. ... [SQL Server Performance and Operational Monitoring for DBAs]( [SQL Server Performance and Operational Monitoring for DBAs]( Learn about the SQL Server performance and operational monitoring capabilities for DBAs with ManageEngine Applications Manager.... [Searching and finding a string value in all columns in a SQL Server table]( [Searching and finding a string value in all columns in a SQL Server table]( Sometimes there is a need to find if a string value exists in any column in your table. This script will help you find all occurrences in all columns in the table.... [Separating the facts and myths of HA and DR in cloud deployments]( [Separating the facts and myths of HA and DR in cloud deployments]( While the benefits of the cloud may be clear for applications that can tolerate brief periods of downtime, it is not as clear for business critical applications, such as SQL Server that require high availability and disaster recovery protection.... MSSQLTips Week In Review [Customize SharePoint online list and library forms with Power Apps]( [Customize SharePoint online list and library forms with Power Apps]( In this tip we will show how to customize the default SharePoint online list and library forms using Power Apps.... [Date and Time Conversions Using SQL Server]( [Date and Time Conversions Using SQL Server]( In this article we look at several different date and time formats you can use in SQL Server.... [Designing an Azure Data Lake Store Gen2]( [Designing an Azure Data Lake Store Gen2]( This article explore things to consider when designing an Azure Data Lake Storage Gen2 account such as data lake layers, zones, files, and security.... [Five facts about the SQL Server MSDB Database]( [Five facts about the SQL Server MSDB Database]( In this article we take a look at the SQL Server system database msdb and how this is use to support some of the functionality within SQL Server.... [How to Manage Date Formats in the Power BI Service]( [How to Manage Date Formats in the Power BI Service]( Learn how to properly configure input date formats for Power BI reports for any type of browser so users always get the results they expect.... [PowerShell Commands for SQL Server Instance and Database Settings]( [PowerShell Commands for SQL Server Instance and Database Settings]( In this article we present a PowerShell script that can gather SQL Server instance settings and database settings that you can use to review configurations and use for disaster recovery if ever needed.... [Relational Database Comparison between SQL Server, Oracle and PostgreSQL]( [Relational Database Comparison between SQL Server, Oracle and PostgreSQL]( Learn about the similarities and differences of SQL Server, Oracle and PostgreSQL related to instances, databases, schemas and linked servers.... [SQL LEFT JOIN Examples]( [SQL LEFT JOIN Examples]( In this article we look at how to do a SQL LEFT JOIN with SQL Server tables with an example dataset and example scripts.... [SQL Server Row Count for all Tables in a Database]( [SQL Server Row Count for all Tables in a Database]( In this article we look at 4 different ways to get rows counts for all tables in a SQL Server database.... [SQL Server Sequence Numbers]( [SQL Server Sequence Numbers]( In this tip we look at the Sequence Number feature in SQL Server and compare it to the use of identity columns.... [SQL Server T-SQL CASE Statement Examples]( [SQL Server T-SQL CASE Statement Examples]( This tip will teach you when and how you can use CASE in T-SQL statements with several code examples to give you a better understanding.... [Techniques for Collecting Stock Data with Python]( [Techniques for Collecting Stock Data with Python]( This tip shows how to use Python for collection of time series data for stock data for data collection and analysis of stock prices.... [Using a calendar table in SQL Server - Part 1]( [Using a calendar table in SQL Server - Part 1]( In a previous article we covered how to create a calendar table for SQL Server queries and this article shows many ways that a calendar table can be used to answer questions much easier.... [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