This is probably a long shot, but I'll ask anyway: do any MS SQL Server folks use Machine Learning services?

And more specifically, does the "SQL Server Launchpad" service ever unexpectedly stop?

The "Recovery" configuration for SQL Server-related services (pictured) is usually good enough to ensure they don't have to be restarted manually.

But not in this case for the Launchpad service.

#SQLServer
#SQLHelp

Is there any information specifically on the impact of enabling wait stats capture in query store? I'm in a hyper-cautious company and am being asked about this.

Erin Stellato has never mentioned anything about it, and I don't recall it being me tioned in Tracy and Grant's book on query store.

#sqlhelp
#sqlfamily
#sqlserver

If anyone has an ANSI SQL compatible approach for formatting INT/BIGINT values as strings with thousands separators, I'd love a pointer. My hacking has been unproductive, and I'm unable to locate any examples online that don't use FORMAT or another proprietary approach.

#SqlHelp #FFS

Trying to build my first Data Vault model in #Snowflake. But I'm not quite understanding the concept of hash keys. My source system already has a sequence as a surrogate key and just creating a hash of that value seems to serve no purpose.

I can understand it if I didn't always have a surrogate key but why should I use them if I do?
#sqlhelp #datawarehouse #datavault #datadesign

OK
Someone around having some Infos regarding SSRS 2019 ( Dev or Ent ed) and mobile reports? See
https://learn.microsoft.com/en-us/sql/reporting-services/reporting-services-features-supported-by-the-editions-of-sql-server-2016?view=sql-server-ver15
Should be supported for above mentioned editions
But when setting ssrs up, there is no menu for mobile reports.
Compared with 2017 ssrs dev. There it is.
But not in 2019. See screenshot
Any ideas/hints ?

#sqlhelp
#sqlserver #ssrs

#SQLServer Permission question: Can I grant a user the ability to alter existing objects but not create new?

It doesn't look like based on what my tests are indicating.

#sqlHelp

I've got what might be a dumb question. #SQLHelp

Can a SQL stored procedure insert data into tables AND return a result set for a report? Would that be bad design/practice to set it up that way?

Context: it's a payroll process that has to update a set of custom tables with paycheck-specific data and then return that + other data back to generate the pay advice slips or checks. Both things are done at the time of printing these advice slips/checks.

My gut says create 2 procs, one for each purpose but looking for input/advice.

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://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-configure-how-to-scripts?view=azuresql&tabs=sql-server#import-azure-trusted-root-certificate-authority-keys-to-sql-server But I'm getting the enclosed error message during the certificate creation. What am I doing wrong? #sqlhelp

Tooting aloud but feel free to weigh in, my brain is fried, plus this is math(s), I think. Working with #TSQL #SQLHelp Fiddle at https://dbfiddle.uk/aesRm4jp

I have the values 0 to 360 degrees in a table, which corresponds to the cardinal directions. I want to round those to the nearest 15 so 8 to 22 are all "15"

I feel like there's a math function or two I could apply to make this work and modulus was initial reach but I'm not seeing it. Maybe I need to futz with case statements...

Anyone know of any upcoming demos of Microsoft Fabric out in the data community?

#SqlHelp

cc @SQLAllFather

#SQLHelp I have a stored procedure that's called thousands of times a minute, concurrently by 20+ threads.

How does an ALTER on it work? I assume it needs a schema lock to do so, but would it just start blocking new executions until the existing executions are done, then perform the ALTER?

#sqlhelp Is there a way to get Azure Data Studio to recognize SETVAR and SQLCMD variables?

#sqlhelp
Hello all,
I'm looking to find a way to enable system versioning (temporal tables) on an existing table "online"
https://dba.stackexchange.com/questions/330288

This is a _real_ dumb question but: anyone know how to kill SSMS via PowerShell? Neither of the following work because "Access is denied"

$Process.Kill()
$Process | Stop-Process -Force

#SQLHelp?

Has anybody running in Azure looked at using Azure SQL auditing to Log Analytics, and KQL, to save all DDL changes to a table or something? I'm trying to replace my Event Notifications solution on-prem. Thinking of a periodic runbook scraping from LA and saving to a table. #AzureSQL #SQLHelp

Help!

Is there any way in Azure Data Studio to force the ctrl-tab tab navigation shortcut to respect the left-to-right order of open tabs, and not the order in which the tabs have been most recently accessed?

#AzureDataStudio #SQLHelp #SQLFamily

#SQLHelp #Azure anybody run into issues on Azure Managed Instance where an extended event is hours behind/delayed, even if it's an in-memory target? I thought it was busted, but in the past 15 minutes it's pulled in events from over a 3 hour period.

(posted this in twitter, too - unsure how many of us are still over here)

Shoutout to the #sqlserver #dba crowd. If my ring buffer keeps telling me RESOURCE_MEMPHYSICAL_LOW I'm quite sure that there's a memory problem *somewhere*. But what is the root cause if it's constantly attributed to IndicatorsPool=2 ?

#sqlhelp

#sqlhelp I'm trying to decipher an issue with a union all view between to databases that has instead of triggers on it. The insert trigger works but update and delete throw "UNION ALL view not updatable because a partitioning column was not found"

SQL server 2016 and both databases are 130

@DaveMasonDotMe deligate that account the "Validated write to service principle name" on the domain in AD. See https://learn.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc731241(v=ws.10)?redirectedfrom=MSDN in the "Delegates Authority to Modify SPNs section #sqlhelp