Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
med-mastodon.com is one of the many independent Mastodon servers you can use to participate in the fediverse.
Medical community on Mastodon

Administered by:

Server stats:

363
active users

med-mastodon.com: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.8

#sqlhelp

0 posts0 participants0 posts today
Dave Mason<p>This is probably a long shot, but I'll ask anyway: do any MS SQL Server folks use Machine Learning services?</p><p>And more specifically, does the "SQL Server Launchpad" service ever unexpectedly stop?</p><p>The "Recovery" configuration for SQL Server-related services (pictured) is usually good enough to ensure they don't have to be restarted manually.</p><p>But not in this case for the Launchpad service.</p><p><a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLServer</span></a><br><a href="https://mastodon.social/tags/SQLHelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLHelp</span></a></p>
leemarkum<p>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. </p><p>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.</p><p><a href="https://dataplatform.social/tags/sqlhelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlhelp</span></a><br><a href="https://dataplatform.social/tags/sqlfamily" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlfamily</span></a><br><a href="https://dataplatform.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlserver</span></a></p>
SQLAllFather<p>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.</p><p><a href="https://techhub.social/tags/SqlHelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SqlHelp</span></a> <a href="https://techhub.social/tags/FFS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FFS</span></a></p>
Frank Henninger<p>Trying to build my first Data Vault model in <a href="https://dataplatform.social/tags/Snowflake" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Snowflake</span></a>. 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. </p><p>I can understand it if I didn't always have a surrogate key but why should I use them if I do?<br><a href="https://dataplatform.social/tags/sqlhelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlhelp</span></a> <a href="https://dataplatform.social/tags/datawarehouse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>datawarehouse</span></a> <a href="https://dataplatform.social/tags/datavault" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>datavault</span></a> <a href="https://dataplatform.social/tags/datadesign" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>datadesign</span></a></p>
Dirk Hondong<p>OK<br>Someone around having some Infos regarding SSRS 2019 ( Dev or Ent ed) and mobile reports? See<br><a href="https://learn.microsoft.com/en-us/sql/reporting-services/reporting-services-features-supported-by-the-editions-of-sql-server-2016?view=sql-server-ver15" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">learn.microsoft.com/en-us/sql/</span><span class="invisible">reporting-services/reporting-services-features-supported-by-the-editions-of-sql-server-2016?view=sql-server-ver15</span></a><br>Should be supported for above mentioned editions<br>But when setting ssrs up, there is no menu for mobile reports. <br>Compared with 2017 ssrs dev. There it is. <br> But not in 2019. See screenshot <br>Any ideas/hints ? </p><p><a href="https://nrw.social/tags/sqlhelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlhelp</span></a><br><a href="https://nrw.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlserver</span></a> <a href="https://nrw.social/tags/ssrs" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ssrs</span></a></p>
Bill Fellows<p><a href="https://dataplatform.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLServer</span></a> Permission question: Can I grant a user the ability to alter existing objects but not create new? </p><p>It doesn't look like based on what my tests are indicating.</p><p><a href="https://dataplatform.social/tags/sqlHelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlHelp</span></a></p>
Jen Kuntz 🇨🇦<p>I've got what might be a dumb question. <a href="https://techhub.social/tags/SQLHelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLHelp</span></a> </p><p>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?</p><p>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.</p><p>My gut says create 2 procs, one for each purpose but looking for input/advice.</p>
josh (they/them)<p>Anyone know of any upcoming demos of Microsoft Fabric out in the data community?</p><p><a href="https://tech.lgbt/tags/SqlHelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SqlHelp</span></a> </p><p>cc <span class="h-card" translate="no"><a href="https://techhub.social/@SQLAllFather" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>SQLAllFather</span></a></span></p>
josh (they/them)<p>This is a _real_ dumb question but: anyone know how to kill SSMS via PowerShell? Neither of the following work because "Access is denied"</p><p>$Process.Kill()<br>$Process | Stop-Process -Force</p><p><a href="https://tech.lgbt/tags/SQLHelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLHelp</span></a>?</p>
Frank Henninger<p><a href="https://dataplatform.social/tags/sqlhelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlhelp</span></a> 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"</p><p>SQL server 2016 and both databases are 130</p>
Bill Fellows<p>I have an Extended Event that records anything over severity 10 to the ring buffer. I've used it plenty of places so I don't think there's anything special about it on the Managed Instance.</p><p>It shows that it's an active session but there have been plenty of errors that ought to be there that aren't. Before I stop and restart the session, any idea on what's awry here? <a href="https://dataplatform.social/tags/sqlhelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlhelp</span></a> </p><p>Session definition as image otherwise it's too long of a toot</p>
josh (they/them)<p>Is it super weird or unreasonable for me to expect a BI team to manage their ETL tool's application server (i.e. they can see to ensuring the proper SQL connection drivers are installed etc.)? I am generally glad to help them but on the other hand 6 years into their run they also seem quite helpless? <a href="https://tech.lgbt/tags/SQLFamily" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLFamily</span></a> <a href="https://tech.lgbt/tags/SQLHelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLHelp</span></a></p>
Ves<p>When spinning up an AG in Azure, if you use an Azure virtual network for all VMs (across regions or availability zones), do you need either DNN or VNN/load balancer? And does this mean you could setup a DistAG from an on-prem deployment to the Azure AG? Or even span the on-prem AG into the cloud? <a href="https://mastodon.online/tags/sqlhelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlhelp</span></a></p>
tjaybelt<p><a href="https://data-folks.masto.host/tags/sqlhelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlhelp</span></a> <a href="https://data-folks.masto.host/tags/sqlfamily" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlfamily</span></a> any experts out there using Airflow and DAGs against Snowflake and DBT that I can ping for some architectural questions about breaking out our environment to be PROD and STAGE worthy instead of a single environment?</p>
Dave Mason<p>This doesn't make much sense either: why would SQL need hundreds of MB (or more) of plan cache memory to generate an execution plan for a single query?</p><p>On numerous other SQL Server instances, the "largest" plans are in the 5-15 MB range.</p><p><a href="https://mastodon.social/tags/SQLHelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLHelp</span></a></p>
josh (they/them)<p>Trying to set up the DTC on a new server and Start-DiagnosticResourceManager keeps throwing an error "Invalid Operation" and cannot open the host. Any <a href="https://tech.lgbt/tags/SQLHelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLHelp</span></a> that can keep me from at least going down useless rabbit holes?</p><p>All the firewall rules have been enabled and Test-Dtc fails when it goes to actually run the test.</p>
mbourgon<p>Does anybody know if you can use Azure Log Replay Service in continuous mode, issue the cutover command, (so it does the tail-of-the-log restore) test, then redo continuous, wiping the databases and restoring all the backups that are now in the bucket (and any future ones)?</p><p>We want to run QA/Regression tests on the Managed Instance with the restored databases, a few days in advance of our cutover. Then, once we know everything is working, we can plan for the actual cutover. <a href="https://dataplatform.social/tags/SQLHelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLHelp</span></a> <a href="https://dataplatform.social/tags/Azure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Azure</span></a></p>
Justin Dearing<p><a href="https://hachyderm.io/tags/sqlhelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlhelp</span></a> has anyone actually restored a backup from blob storage to an <a href="https://hachyderm.io/tags/azure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>azure</span></a> SQL managed instance THROUGH the private endpoint when public access to the container was disabled?</p><p>The VNET the managed instance is on has custom DNS entries but ifconfig /a in a SQL agent job shows the default azure DNS server, but we changed the DNS on the VNET AFTER creating the SQL managed instance</p>
Todd Salzman<p><a href="https://dataplatform.social/tags/SQLHelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLHelp</span></a> SSIS recurring 'Protocol Error in TDS Stream' Has anyone actually solved this issue?</p>
Frank Henninger<p>Ok <a href="https://dataplatform.social/tags/sqlfamily" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlfamily</span></a> need to brainstorm on how to migrate from on-prem <a href="https://dataplatform.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlserver</span></a> 2016 to <a href="https://dataplatform.social/tags/azure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>azure</span></a> SQL database. The size is around 700gb so an outage and bacpac migration is out. So far I'm thinking some form or transactional replication. Maybe an upgrade to 2019 and using a distributed ag? This is Enterprise licensed <a href="https://dataplatform.social/tags/sqlhelp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlhelp</span></a></p>
ExploreLive feeds
About