#SQLHelp

High five to @SQLVariant for launching the #SQLHelp hash tag over a decade ago:

Whats the best/most active SQL forum out there? #sqlhelp

I'm new to docker. #sqlhelp #SQLServer isn't there a #SQL2019 image for #Windows #docker, or has SQL gone just full #Linux ?

#sqlhelp My understanding of transactional replication is that occasionally it's going to fail and require a new snapshot. But, I'll freely admit I'm not that great with replication. Is this true? Or am I wrong? And if it is true is there any MS documentation to that effect?

Anyone have any real world experience with comparisons of Postgres vs Microsoft SQL Server? I've got a friend whos company is considering Postgres as their new platform and only saying "well, its cheaper". No other benchmark, just license cost. #sqlhelp I'm trying to to be bias.

#sqlhelp Looking for info on transactional replication DOWNSIDES, bad experiences, post-mortem write-ups. Bad stuff only, legitimate problems that made folks stop using it. I want to investigate before I propose it, expecting resistance/opposition. SQL2019 if that helps. Thanks.

Table names. Plural or Singular. and why? I get making a standard for singular. But don't have a reason to argue why. #sqlhelp #sqlfamily

What's one piece of advice you wish you received when you first started to learn SQL? #SQL #SQLHelp #sqlserver

How are folks handling OS patching on larger (100+) SQL Server estates in production? Mostly manual? Relying on auto-failover? Something else? #sqlhelp

@SQLPartizan @SQLKohai @SqlrUs @SQLBalls @SQLEspresso @SQLRockstar @StackExchange also maybe a good time to mention the channel #sqlhelp in the @sqlslack where I spend too much time 🤗if you are new to that stuff hit me up (DM is fine too) and I would be glad to show the ropes

Can't install MDS 2012 SP1 add-in because "Excel 2010" isn't installed. Office 2016 is installed though. Running as admin doesn't help. Any ideas? #sqlhelp

I just noticed that #AzureSynapseAnalytics does not support global parameters for pipelines! Let's raise awareness and vote for this idea: #SynapseHelp #SQLHelp @Azure_Synapse

I have clients needing to implement caching layer for .net-based #sqlserver apps. one is web-scale. What's good these days? #SQLHelp

Index rebuild of 1TB index to add compression. Server is going to be rebooted tomorrow morning and likely index rebuild won't be done in time. ONLINE=ON was used. Lengthy crash recovery or no because of ONLINE=ON? #sqlhelp

I want to learn about how to re-architect SQL environments before you move them to the cloud. When people say that, what does that mean? Anyone have blog posts or anything you can point me to? #sqlhelp

Hey #sqlfamily - due to a Covid-19 related layoff I am looking for a new SQL job, here is my linked in if anyone needs #sqlhelp out there! I am open to both freelance gigs and full time jobs. Thanks!

Day 26: Still practicing SQL. This was the coding language I was most excited to learn but I'm starting to get frustrated with the tutorial I'm following. Does anyone have suggestions for free SQL resources for beginners? #100daysofCode #sqlhelp

Is #sqlhelp still a thing? A friend @KJ_Casemore is asking “Can you recommend any resources for learning SSIS, SSRS free or paid?” I don’t know the answer anymore, can anyone help?

#sqlhelp looking for your recommendations. Dev wants to use [ID] for PK. Instead of [TableNameID]. Argument is that ORMs love using [ID]. Many perks in the EF world for its use. I say EF shouldn't dictate best practice in DB. Your thoughts?

Is there an easy way to export a #PowerBI dataset to a csv from in an automated fashion? Dataset is in a Premium tenant. So perhaps REST API or an XML endpoint? #SQLHelp #PBIHelp