Synapse pipeline most useless error message ever! Pipeline validates but debug results in this!!! Anyone have any idea how to figure out what it's mad about! It worked before and then I made some changes. I really don't want to undo all I did. #SQLHelp

#SQLHelp #AzureSynapse What do I need to do so that the view I created (with a SQL Script in Synapse) show up in the Views in the Synapse Studio UI? I can see it from SSMS?

Does anyone know which command you should use to override a default Lakehouse in a Notebook in #microsoftfabric? So you can parameterize it in an easy way. You can see it in DevOps, but how to overrule this data. #sqlhelp #mvpbuzz

How do I fix this? Can't get to the top of the pane. #SQLHelp

Anyone know where I can grab the Synapse Spark pool icon in lossless format such as png? Tried the usual places (az glyphs and icon packs) and haven't found it yet #sqlhelp cc. @MarkPM_MSFT

#sqlhelp does a parallel batch mode hash aggregate need a lot more memory than what SQL Server normally estimates? 44 billion row columnstore table. Query is simple: SELECT DISTINCT column_one, column_two. Data types are bigint and nvarchar(500). Optimizer guesses about 5 million

Is there a set of sample end user queries that can be used to simulate a workload on WideWorldImportersDW similar to what is available from the TPC datasets? I need to simulate a user load but can't seem to find anything to use as a starting point. #SQLhelp

I'm trying to import the Azure-trusted root certificate authority keys to #sqlserver to set up a SQL Managed Instance Link as described here: https://t.co/h5rAOs2qA0 But I'm getting the enclosed error message during the certificate creation. What am I doing wrong? #sqlhelp

whyyyy would a query run FASTER after DBCC DROPCLEANBUFFERS vs a warm cache? like, 10% faster! i am vexed #sqlhelp

#sqlhelp Howdy! Anyone run two (or more) concurrent DiskSpd tests to simulate a workload? Wonder if there are any special considerations.

in a powerbi report, i used conditional formatting with icon on the values of 0 and 1, coloring them red and green. Most fields work. A few simply refuse to work. I cannot determine why. They are all configured the same way. Some seemingly ignore the values #sqlhelp

#sqlhelp Anyone else using a business-critical managed instance on Azure? When I go to the compute & storage tab it's showing that we have 4 vCores and 1tb of storage. Both of which are very much not true.

Does Oracle support sorting dates with a sense of humor, or do they strictly prefer chronological sarcasm? Source: https://t.co/AjId6kOsWN #Database #TechTips #SQLHelp #OracleHelp #oracle #date

Should a SQL Server VM be configured for dynamic memory? #sqlhelp

I noticed avg write stalls on tempdb of over 100ms. I raised the issue and was told it doesn't hurt user queries because those writes happen in memory. I always thought writes to data files were physical IO that happen during working in tempdb. Can someone clarify? #sqlhelp

#sqlhelp does anyone know how the index usage data is reset in azure sql? on prem it's since last restart. in one DB I checked I only see scan times going one day back but haven't checked every DB

Has anyone in the #SQLCommunity created a test suite for #SQLServer Audit that they can share? #sqlhelp #azuresql

#sqlhelp @erinstellato where is the right place for SSMS questions/requests? Connect is gone, UserVoice has multiple categories for SQL on VM, or azure sql, or various flavors, but not seeing anything for SSMS. #sqlhelp

Friends on #sqlhelp - let's assume I'm trying to achieve highest possible insert times for a big table load on an in-memory table. Do tools, say BCP vs SmartBulkCopy, make a big difference? #sqlserver #azuresql