SQL Server Tempdb Facts, SQL Date Format YYYY-MM-DD, Azure Synapse Analytics, Power BI Smart Narrative and more (MSSQLTips 3/4/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Reduce time to troubleshoot data platform performance issues up to 90%]( [How SQL Server handles the date format YYYY-MM-DD]( [How SQL Server handles the date format YYYY-MM-DD]( I this article we look at why using the date format of YYYY-MM-DD in SQL Server may not always give you the results you expect and we show you why.... [Power BI Smart Narrative]( [Power BI Smart Narrative]( A new feature in Power BI is the Smart Narrative that allows you to add a textual narrative to your reports to help provide additional information to the user.... [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.... [Exploring the Capabilities of Azure Synapse Spark External Tables]( [Exploring the Capabilities of Azure Synapse Spark External Tables]( In this article we explore additional capabilities of Azure Synapse Spark and SQL Serverless External Tables.... [Indexing for Performance: Query Strategies to Maximize Your SQL Server Indexes]( [Indexing for Performance: Query Strategies to Maximize Your SQL Server Indexes]( [Free Webinar] Few things influence the speed and performance of SQL statements within SQL Server as much as indexes. This session will help you understand the basics of query performance in relation to the indexes on your production database. We'll ... [Scripts to Automate Creating and Loading a SQL Server Table]( [Scripts to Automate Creating and Loading a SQL Server Table]( Use these T-SQL strategies for dropping, creating, and populating tables in custom schemas across different SQL Server versions from SQL Server 2019 back to SQL Server 2005.... [Need SQL Server High Availability?]( [Need SQL Server High Availability?]( If you need to migrate to Azure at end of support (EOS), and you require HA for SQL Server 2008/2008 R2, there is only one solution recommended by Microsoft: SIOS DataKeeper. SIOS DataKeeper enables clustering in the cloud, including the creation of ... [Ingest and process real-time data streams with Azure Synapse Analytics]( [Ingest and process real-time data streams with Azure Synapse Analytics]( In this tip we show how real-time data can be ingested and processed, using the Spark Structured Streaming functionality in Azure Synapse Analytics.... [Five facts about the SQL Server Tempdb Database]( [Five facts about the SQL Server Tempdb Database]( In this article we cover some interesting facts about the SQL Server TempDB database that could be useful to know.... [By Manvendra Singh -]( [How to read the SQL Server Database Transaction Log]( In this tip we will take a look at a SQL Server function that you can use to read the SQL Server transaction log to see what entries are made for database transactions.... [By Greg Robidoux -]( [Delete duplicate rows with no primary key on a SQL Server table]( Every once in awhile a table gets created without a primary key and duplicate records get entered. The problem gets even worse when you have two identical rows in the table and there is no way to distinguish between the two rows. So how do you delete th... [By Nat Sundar -]( [Importing JSON Files Using SQL Server Integration Services]( In this tip we look at how to import JSON files using SQL Server Integration Services.... [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