SQL Server 2022 T-SQL Enhancements, OneLake in Microsoft Fabric, SQL Server APIs and VLOOKUP in Power BI

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [What is OneLake in Microsoft Fabric?]( Learn about Microsoft Fabric and OneLake the storage layer for every possible compute in Fabric. OneLake is a single logical data lake for the entire Fabric platform in your organization.... [Read Now]( [mssqltips image]( [Grant SQL Server Permissions to a Folder]( In this article, we look at the steps to grant SQL Server access to new folders for backups or database files.... [Read Now]( [mssqltips image]( [NEW Developer Nation survey is live!]( Unlock the future of tech! Participate in the Developer Nation survey and have your say in the next big tech trends. Your opinions matter, and you might just win exciting prizes! For every survey response we donate to an organization of your choice.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Secret to Doubling DBA Productivity]( Learn how DBAs are doubling productivity and minimizing complexities across numerous database platforms including: prioritization, consistency, automation and more. ... [Read Now]( [mssqltips image]( [Backup SQL Server on Linux Databases]( In this tip, we're going to look at the steps to backup SQL Server on Linux databases using SQL Server Agent on a Windows server.... [Read Now]( [mssqltips image]( [Build a Secure SQL Server REST API in Minutes]( Learn how to build a secure SQL Server REST API in minutes with DreamFactory which is middleware that connects all of your applications across the enterprise in a secure manner.... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [My Favorite T-SQL Enhancements in SQL Server 2022]( A few of the most useful changes in SQL Server 2022 so far are GREATEST, LEAST, STRING_SPLIT, DATE_BUCKET and GENERATE_SERIES and I will cover each one and show practical use cases. ... [Read Now]( [mssqltips image]( [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?... [Read Now]( [mssqltips image]( [RELATED vs LOOKUPVALUE in DAX for Power BI]( In this article we cover how and when to use the DAX functions RELATED and LOOKUPVALUE in Power BI to perform similar VLOOKUP capabilities in Excel.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]