Explore tweets tagged as #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?
2
1
0
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
1
0
1
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
0
0
0
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
1
0
2
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
1
0
0
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: But I'm getting the enclosed error message during the certificate creation. What am I doing wrong? #sqlhelp
1
0
0
How do I write a query that will get me a list of workers that earn above average salary?. #sqlhelp #DataAnalysis.
5
0
2
#sqlhelp @AndyLeonard I'm importing a csv into a db. The date (database time [DT_DBTIME]) are like .6/22/2023 18:30, 9/17/2023 23:18.In the db, they keep the same time, but the date changes to the current one as. 2023-11-28 18:30:50.000.2023-11-28 23:18:50.000.Please guide.
1
0
1
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.
3
1
2
Has anyone in the #SQLCommunity created a test suite for #SQLServer Audit that they can share? #sqlhelp #azuresql.
3
5
3
Are unnecessary #joins slowing down your query performance? Optimizing joins can be a huge boost for large datasets. Morgane Rouvroy explains how Yellowbrick's optimizer removes unnecessary joins - read it here. #SQL #SQLHelp #QueryTips.
1
1
2
#sqlfamily #Sqlhelp.I'm looking for an PowerBI contractor or expert that can look at our system of hundreds of reports and make sense of what is there. We had a report guy that was let go. And now it falls on my shoulders, and I am woefully unskilled nowadays in PBI.
5
4
2
#sqlhelp If you grant execute permissions to a schema, are any permissions needed to the objects being touched inside the SP?.
1
0
0