T-SQL Tips and Tricks, SQL Window Functions, SSIS Webcast and more (MSSQLTips 2/16/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Indexing Tutorial - Start Learning Today]( [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.... [Using Window Functions to Create Smart, Quick Queries]( [Using Window Functions to Create Smart, Quick Queries]( Learn how to use SQL window functions in SQL Server for easier code development and improving performance with these code examples.... [Intelligent SQL Server and VMware Performance Monitoring]( [Intelligent SQL Server and VMware Performance Monitoring]( We have a large SQL Server environment supported by physical servers, VMware and cloud infrastructure. Unfortunately, we are facing a number of performance challenges. We have frequent situations where the end user experience degrades.... [SQL Server LIKE Examples]( [SQL Server LIKE Examples]( Learn how to use the SQL LIKE operator to search for various string patterns within SQL Server data. This covers several examples of how the SQL LIKE statement can be used.... [Getting Started with SSIS]( [Getting Started with SSIS]( [Webinar] Learn how to get started with SQL Server Integration Services and how to build an SSIS project with this demo focused webinar.... [SQL Server Overview]( [SQL Server Overview]( I am new to SQL Server and I have heard the term used in a number of different capacities and in different contexts. So what exactly is it? What are the common components? How does it work? How do people use it? I am brand new to the technology, wher... [SQL Server Data Warehouse Cleansing, Verification and Matching]( [SQL Server Data Warehouse Cleansing, Verification and Matching]( Data Quality | SSIS Workflow | Downloadable Solution - How can we clean, validate and enhance our Contact dimension in our SQL Server Data Warehouse without writing code?... MSSQLTips Week In Review [5 Groups to Network with During Your SQL Server Jobs Search]( [5 Groups to Network with During Your SQL Server Jobs Search]( Searching for a job is not an easy task in today's online world, but one great option is to use your network of contacts to help you find that next job. Read this article to learn more.... [Comparing with T-SQL and Excel a Decision Tree Regression to a Bagged Regression]( [Comparing with T-SQL and Excel a Decision Tree Regression to a Bagged Regression]( Learn how to do a comparison of a decision tree regression versus a bagged regression based on two different test datasets using both T-SQL and Excel.... [Getting exclusive access to restore SQL Server database]( [Getting exclusive access to restore SQL Server database]( Learn how to get exclusive access to a SQL Server database so you can restore a backup without getting exclusive access error.... [How To Check Disk Space in SQL Server]( [How To Check Disk Space in SQL Server]( One of the DBA tasks is to monitor free space on the drives where SQL Server files reside and in this article we look at a way to easily capture all of this data from all of your instances for analysis and reporting.... [How to Install SQL Server Management Studio on your Local Computer]( [How to Install SQL Server Management Studio on your Local Computer]( Learn how to install SQL Server Management Studio on your local computer via the Installation Center, direct download and installation ini file.... [INSERT INTO SQL Server Command]( [INSERT INTO SQL Server Command]( Learn how to use INSERT INTO with many different examples of how to insert data into an existing SQL Server table.... [Power BI Reports with Animated GIF]( [Power BI Reports with Animated GIF]( In this article we demonstrate how to create a GIF recording and use the GIF in Power BI desktop reports to help users understand the report.... [Server and Database Level Auditing for Azure SQL databases]( [Server and Database Level Auditing for Azure SQL databases]( Learn how to audit Azure SQL Database in this step by step article using either server level or database level auditing.... [SQL Drop Table Examples with T-SQL and SQL Server Management Studio]( [SQL Drop Table Examples with T-SQL and SQL Server Management Studio]( In this article we look at how to delete a SQL Server table using the DROP TABLE command along with using SQL Server Management Studio.... [SQL Server DBA Utility Dashboard]( [SQL Server DBA Utility Dashboard]( Create a quick application that stores your favorite queries that you can use to quickly connect to any server and return the results.... [sqldf in R Example for SQL Server]( [sqldf in R Example for SQL Server]( R has a package called sqldf that allows developers to manipulate data inside a dataframe in the same way a SQL developer queries a SQL table which we will cover with examples in this article.... [Step by Step Installation of Microsoft Azure Data Studio on Windows Machine]( [Step by Step Installation of Microsoft Azure Data Studio on Windows Machine]( In this article we look at how to install Azure Data Studio on Windows and cover a few of the features to get you started with managing SQL Server.... [Step by Step Installation of SQL Server Management Studio 18.6]( [Step by Step Installation of SQL Server Management Studio 18.6]( In this article learn how to quickly download and install SSMS 18.6.... [Using Azure SQL Data Sync to Replicate Data]( [Using Azure SQL Data Sync to Replicate Data]( Learn how to setup and use Azure SQL Data Sync to synchronize and replicate data from various locations including Azure SQL Database, cloud and on-premises databases.... [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