Just Released - Azure Ledger for Data Tampering Protection, Azure Purview for Data Governance, T-SQL Coding and Window Functions (MSSQLTips 6/8/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Redefining database operations to give you full control over your database farm, efficiently.]( [Getting Started with Azure Purview for Data Governance]( [Getting Started with Azure Purview for Data Governance]( In this article we will explore how to get started with Azure Purview and then explore some of the features within Purview Studio.... [Introduction to Azure SQL Database Ledger (Preview) for Data Tampering Protection]( [Introduction to Azure SQL Database Ledger (Preview) for Data Tampering Protection]( In this tip, we will explore different components, features, and benefits of Azure SQL Database Ledger for making sure your data has not been tampered with. ... [Redefining Database Operations]( [Redefining Database Operations]( Download the evaluation version of dbWatch Control Center to monitor all your instances, experience full insight and control over your database farm.... [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.... [Solved: SQL Server Management and Performance Complexity]( [Solved: SQL Server Management and Performance Complexity]( We need to transition our team from single instance management and monitoring to managing the overall environment and addressing our most pressing needs to support the organization. How can we move from managing the trees to managing the forest in an... [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.... [Confidently Slash Downtime with Fast SQL Server Backup and Restores]( [Confidently Slash Downtime with Fast SQL Server Backup and Restores]( Learn how to slash downtime for SQL Server backup and restores with FlashBlade® backup terabyte databases in minutes, make database restores your first choice for disaster recovery and protect your databases from ransomware.... [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.... [SQL Server Best Practices for Data Quality]( [SQL Server Best Practices for Data Quality]( Accurate data is imperative for an organization to conduct cost effective decision making, marketing promotions, mailings, database bloat impacting performance, storage and more. Like everything else, change is constant for your data. There is a ne... [By Greg Robidoux -]( [How to Read Log File in SQL Server using TSQL]( In this article we look at how to query and read the SQL Server log files using TSQL to quickly find specific information and return the data as a query result.... [By Jeremy Kadlec -]( [SQL Server Join Example]( I am new to SQL Server and want to learn about the JOIN options. What are all of the JOIN options in SQL Server? What is the significance of each of the options? I am a little confused on the differences and syntax, can you provide some examples and ex... [By Koen Verbeeck -]( [Implement a Slowly Changing Type 2 Dimension in SQL Server Integration Services - Part 1]( In this tip we look at how you can implement a type 2 slowly changing dimension with SQL Server Integration Services.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] Edgewood Solutions LLC | PO Box 682, Wilton, NH 03086 [Unsubscribe {EMAIL}]( [Update Profile]( | [Constant Contact Data Notice]( Sent by newsletter@mssqltips.com