Week in Review + Calculate Values for Fiscal Weeks, Split Delimited String into Columns and Getting Started with BI (MSSQLTips 2/7/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Machine Learning Tutorial]( [Calculate Values for the Same Fiscal Week in a Previous Fiscal Year with Power BI and DAX]( [Calculate Values for the Same Fiscal Week in a Previous Fiscal Year with Power BI and DAX]( In this article we look at how to use DAX logic in Power BI to enable calculating values for previous year's weeks compared to that of the current year.... [Visualize Your Data Environment with Database Mapper]( [Visualize Your Data Environment with Database Mapper]( SQL Server database documentation is critical for bringing new technical and business users up to speed on the underlying tables, views, columns, stored procedures, functions, SSRS and Power BI reports, ETL processes and more.... [SQL GETDATE Function]( [SQL GETDATE Function]( The GETDATE() function returns the current server time stamp using the datetime format. This function returns the same value as the CURRENT_TIMESTAMP function. GETDATE() is used mostly in SQL Server, but CURRENT_TIMESTAMP is the ANSI SQL standard.... [Seamlessly Cleanse Your SQL Server Data]( [Seamlessly Cleanse Your SQL Server Data]( Melissa also understands how to seamlessly integrate their solution into key business processes with minimal code changes for organizations to quickly recognize the benefits. For organizations that rely on the SQL Server Data Platform, Melissas solu... [Split Delimited String into Columns in SQL Server with PARSENAME]( [Split Delimited String into Columns in SQL Server with PARSENAME]( In this tip we look at how to parse or split SQL Server data from one column into multiple columns using the parsename and other T-SQL functions.... [New SQL Server Backup and Restore Options]( [New SQL Server Backup and Restore Options]( SQL Server backup and restore are the life blood of a production DBA. Doing it fast and doing it well are as important as ever, in today's data climate. In this webinar Microsoft PM Melony Qin, will explain and demonstrate the new S3 object store fea... [My First SQL Server Business Intelligence Project Tutorial]( [My First SQL Server Business Intelligence Project Tutorial]( In a Business Intelligence project, data is the currency and analytics is the merchandise. Without having the right type, amount and shape of data, one cannot get the right kind of analytics.... [Simple SQL Server Data Masking and Protection]( [Simple SQL Server Data Masking and Protection]( Data breaches are becoming too common place with some accounts reporting more than 1000 breaches per year with close to 50 million records exposed yearly. Learn about how DbDefence protects your data.... MSSQLTips Week In Review [Assessing Time Series Model Performance with T-SQL]( [Assessing Time Series Model Performance with T-SQL]( This article describes the use of T-SQL code for artificial intelligence models that recommend when to buy and sell financial securities.... [Build SQL Server CLR Triggers]( [Build SQL Server CLR Triggers]( In this article we look at how to create SQL Server triggers using Common Runtime Language (CLR) along with examples and a step-by-step guide.... [Comparison of the VARCHAR(max) and VARCHAR(n) SQL Server Data Types ]( [Comparison of the VARCHAR(max) and VARCHAR(n) SQL Server Data Types]( You are developing a SQL Server application and at some point in your code you received the “String or binary data would be truncated” error message. After digging into the code you discovered that this error message is caused because a table has a VARCHA... [Converting between Data Types with the SQL Server CAST Function]( [Converting between Data Types with the SQL Server CAST Function]( In this article we look at how to use the CAST function in SQL Server to convert from one data type to another data type along with several examples and alternatives.... [Detect the Language with Azure AI Language Service]( [Detect the Language with Azure AI Language Service]( In this article we take a look at the Azure AI Language service and how this could be used in conjunction with Azure SQL Database to detect the language of text stored in a table.... [Implement Surrogate Keys Using Lakehouse and Azure Synapse Analytics]( [Implement Surrogate Keys Using Lakehouse and Azure Synapse Analytics]( In this article we cover how to create surrogate keys in Azure Synapse Analytics to simplify your data warehouse and allow you to track changes easier. ... [Learn Python Complex Built-in Data Types including List, Tuple, Range, Dictionary and Set ]( [Learn Python Complex Built-in Data Types including List, Tuple, Range, Dictionary and Set]( In this article we present complex built-in data types in Python along with several examples of how to use complex data types.... [MSSQLTips.com Authors and Rookie of 2021]( [MSSQLTips.com Authors and Rookie of 2021]( Let's take some time to recognize the MSSQLTips.com Authors and Rookie of 2021 as well as all of the Authors on the Team. ... [Performance Testing Azure SQL Edge on Intel and M1 MacBooks]( [Performance Testing Azure SQL Edge on Intel and M1 MacBooks]( In this article we do performance comparisons of running Azure SQL Edge using Intel Mac versus M1 Mac to see what kinds of differences there are in performance.... [Surrogate Key vs Natural Key Differences and When to Use in SQL Server]( [Surrogate Key vs Natural Key Differences and When to Use in SQL Server]( In this tip we cover the pros and cons to using a surrogate key vs natural key. Check it out to learn more.... [Varchar Data Types in SQL Server, Oracle and PostgreSQL]( [Varchar Data Types in SQL Server, Oracle and PostgreSQL]( Learn about the differences in SQL Server, Oracle and PostgreSQL on how to specify data types to store large textual data as well as how to adjust column settings.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}