Week in Review + Getting Started with SqlQueryStress, SQL ALTER TABLE and Performance Monitoring Webcast (MSSQLTips 9/19/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Stored Procedure Tutorial]( [Change SQL Server Table Structures with SQL ALTER TABLE]( [Change SQL Server Table Structures with SQL ALTER TABLE]( In this article, we look at how to make changes to SQL Server table structures using T-SQL commands to add, delete and change columns in a table.... [Getting Started with SqlQueryStress]( [Getting Started with SqlQueryStress]( Learn how to install and use SqlQueryStress to help with tune your SQL Server databases, stored procedures, indexes, and more.... [SQL Server Performance Monitoring Webcast]( [SQL Server Performance Monitoring Webcast]( Application downtime or milliseconds of slowness can cost a business millions in lost revenue. Reducing downtime/slowness is a significant source of return on investment (ROI) for database monitoring solutions. You need to be alerted as soon as issue... [How to tell what SQL Server versions you are running]( [How to tell what SQL Server versions you are running]( Check out this tip to easily find out what version of SQL Server you are running.... [Poor SQL Server Data Quality is Rampant]( [Poor SQL Server Data Quality is Rampant]( Data is being generated at breakneck speed, and more companies are moving towards a data-driven culture. But many data professionals and companies still struggle with the challenge to improve data quality and accuracy in their systems.... [Add and Subtract Dates using DATEADD in SQL Server]( [Add and Subtract Dates using DATEADD in SQL Server]( Date manipulation is a common scenario when retrieving or storing data in a SQL Server database. There are several functions that are available and in this tip we look at how to use the DATEADD function.... [Monitor, Manage and Improve Database Performance]( [Monitor, Manage and Improve Database Performance]( Around the globe, SQL Server professionals are being asked to support more applications, infrastructure and code, while continuously ensuring all applications are performing optimally. That is a tough mission to uphold without a means to monitor, di... [Install SQL Server Integration Services in Visual Studio 2019]( [Install SQL Server Integration Services in Visual Studio 2019]( Learn the step by step process to install SQL Server 2019 Integration Services in Visual Studio as well as the history for the tool.... [Analyze Real Time Data from Snowflake with SSAS]( [Analyze Real Time Data from Snowflake with SSAS]( Learn how to use the CData ADO.NET adaptor for Snowflake and SSAS Multidimensional to create a solution where users can connect live to Snowflake using tools like SSAS and Power BI.... MSSQLTips Week In Review [Azure Cloud Data Orchestration, Ingestion and Data Preparation]( [Azure Cloud Data Orchestration, Ingestion and Data Preparation]( In this article, we look at things to consider when selecting tools and developing your data processing strategy when working with various technologies in the Azure cloud.... [Build Conditional SQL Server Logic - SQL IF, BEGIN, END, ELSE, ELSEIF ]( [Build Conditional SQL Server Logic - SQL IF, BEGIN, END, ELSE, ELSEIF]( Learn how to build conditional logic when writing SQL code using IF, BEGIN, END, ELSE, and ELSEIF logic.... [Create, Read, Update and Delete Data in SQL Server Tables]( [Create, Read, Update and Delete Data in SQL Server Tables]( Learn the basics to create, read, update and delete data in SQL Server tables with these various examples.... [Designing a Data Lake Management and Security Strategy]( [Designing a Data Lake Management and Security Strategy]( As organizations move away from traditional data warehouse platforms to cloud data Lakehouse platforms they need to think about design and security differences which we cover in this article.... [How to Create a Bar Chart with SQL Code]( [How to Create a Bar Chart with SQL Code]( In this article, we look at how to build a simple bar chart using SQL code along with a couple examples of how you can do this with your data.... [How To Retrieve the Last Non-NULL Value in SQL Server]( [How To Retrieve the Last Non-NULL Value in SQL Server]( In this article, we show different ways of using SQL to get the last non-NULL value from a set of records so the result set always includes a valid value.... [Introduction to AWS RDS SQL Server Features]( [Introduction to AWS RDS SQL Server Features]( In this article, we take a look at an overview of Amazon RDS and what it has to offer when moving SQL Server to a fully managed platform in the cloud.... [Resolving could not open a connection to SQL Server errors]( [Resolving could not open a connection to SQL Server errors]( Sometimes you may have issues connecting to SQL Server and you may get messages such as could not open a connection to SQL Server. In this tip we look at different things you can check to resolve this issue.... [SQL Date Calculation Simplifications in SQL Server]( [SQL Date Calculation Simplifications in SQL Server]( In this tip, learn how to simplify date calculations such as the first day of the month, the last day of the month, the nth Monday of the month, and more both with and without a calendar 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}