SQL Server Subquery Code Options, PowerShell Script to Parse HTML, Git Branching and more (MSSQLTips 10/30/2020)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [SQL Server Stored Procedure Tutorial]( [Choose Between SQL Server Subquery T-SQL Code]( In this article we look at performance metrics for different T-SQL approaches to achieve the same results using CTEs, view, subqueries, temp tables, and table variables.... [SQL Database Project with Git Feature Branch Workflow]( In this tip we look at how to work with SQL Database Projects using Git source control and using branching to work on different features.... [PowerShell Script to Parse HTML Code with SQL Server Build Numbers]( In this article we look at a PowerShell script that will read SQL Server build numbers from a web page and present the data in a easy to use manner.... [Controlling Cloud Costs without Sacrificing Availability or Performance]( Shortly after contracting with a cloud service provider, a bill arrives that causes sticker shock. There are unexpected and seemingly excessive charges, and those responsible seem unable to explain how this could have happened. The situation is criti... [SQL Server CROSS APPLY and OUTER APPLY]( The APPLY operator allows you to join two table expressions; the right table expression is processed every time for each row from the left table expression. As you might have guessed, the left table expression is evaluated first and then the right ta... [Quickly Pinpoint SQL Server Performance Issues]( My team needs to quickly pinpoint the performance issues in my SQL Server environment. With all of the demands at work, our team needs to find and understand the issues, then review the code and take corrective actions. We need to ensure our producti... [Rolling up multiple rows into a single row and column for SQL Server data]( I need a way to roll-up multiple rows into one row and one column. I know I can roll-up multiple rows into one row using Pivot, but I need all of the data concatenated into a single column in a single row. In this tip we look at a simple approach t... [Simple Email Verification with SQL Server Integration Services]( [Webcast] There is far more to email verification than just a binary valid-or-invalid verdict. In this session, we will cover: the world of email verification, using SSIS to verify your emails and implementing your own solution using Global Email.... [How to tell what SQL Server version you are running]( One issue that I am often faced with is determining what service pack is installed on the SQL Server. In this tip we look at how to find the version of SQL Server that is running and also what service pack or hotfix is installed.... [Faster SQL Server Clustering]( Making SQL Server deployments resilient to failures is a goal most want to achieve. Whether you are trying to account for high availability and/or disaster recovery, there are various methods to achieve the end goal. One of the most popular approache... [Change Not For Replication Value for SQL Server Identity Columns]( In this tip we look at how to change the SQL Server setting for a tables identity column to not for replication for existing tables.... [SQL Server differences of char, nchar, varchar and nvarchar data types]( Learn about some of the differences of char, nchar, varchar and nvarchar when working with SQL Server data.... [Study material for exam 98-364 Database Fundamentals]( In this tip I cover several links you can use to help study for Microsoft exam 98-364 Database Fundamentals.... [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}