Has anyone here ever setup a CI/CD pipeline for #PowerBI composite models? #sqlhelp

#sqlhelp Does anyone know of any downsides to using OPTIMIZE_FOR_SEQUENTIAL_KEY?

@sqlstudent144 You can only adjust that upon creation. In order to change it you have to nuke the MI and start over IIRC. I do not know of any way to change it after it's been created. learn.microsoft.com/en-us/azure/az… #sqlhelp

#sqlhelp Has anyone figured out a way to change the time zone setting on an Azure Managed Instance? I know the documentation says it's not possible, I'm just hoping it's wrong or out of date or maybe someone figured out a hack?

@SteveClementJax From my understanding, that trace flag is applicable to SQL Server 2016, 2017, and 2019. SQL 2022 should be functional without the trace flag applied. #sqlhelp support.microsoft.com/en-us/topic/kb…

For SQL friends - is TF 8291 needed to enable the associated patch in SQL 2022, or is it on by default and the TF is only needed in 2019 and lower? #sqlhelp

@bmerri19 @TalesftField Also is this in SSMS & what version if it is? #sqlhelp

@bmerri19 @TalesftField Right off the top of my head back up to URL is not supported in Azure SQL DB or in Fabric SQL DB. However, back up to URL is supported on Azure SQL MI or in SQL Server if you have a configuration to Azure or if you are in an Azure SQL VM #sqlhelp

Trying to run Azure blob backups to URL but getting this error: "Exception 0xc06d007e EXCEPTION_MOD_NOT_FOUND for module 'sqlfabric.dll' (Error: The specified module could not be found." - what feature or setup option did we miss during install? @SQLBalls @TalesftField #SQLhelp

l am testing @Veeam plug-in for #sqlserver . lt seems like their concept of full and different restore is the same. #sqlhelp community am l doing something wrong ?

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

Looking for a SQL Server expert to help boost your company's performance? Look no further! Contact us today for more information and let's take your database to the next level. #ContactUs #TechSolutions #SQLHelp #DatabaseConsultant #SQLPerformance #TechSupport #SQLOptimization

Database giving you trouble? SQL, MySQL, PostgreSQL — I design, fix, and optimize databases for you. DM today. #DatabaseHelp #SQLHelp #ProgrammingExpert

@erikdarlingdata Yes. That is the DMV I was using. If I can consistently cause spills, I expect to see the write values on data files change. If that's the cause of the latency, I can probably use xEvents to find when the spills are happening. #sqlhelp

I have 2 questions about SSMS 21: 1. How to best install and upgrade it in an offline environment at scale? 2. Will it still be security patched via Windows Update? #sqlhelp

@leemarkum I most certainly could be wrong (and I'm jetlagged), but yeah, my understanding is that those are physical writes. Memory first, yes, but also down to disk. #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 All, app jobs running slower after applying window patch v4.0.30319. Wintel uninstalled patch but still slowness. Observation: queryenumerator::current exception detected. System.componentmodel.win32exception: wait operation timed out. Any help will be appreciated.

Does Oracle support sorting dates with a sense of humor, or do they strictly prefer chronological sarcasm? Source: devhubby.com/thread/how-to-… #Database #TechTips #SQLHelp #oracleHelp #oracle #date