#SQLHelp

I'm using the #sqlhelp hashtag for a non question. Vendors, this hashtag is primarily used for questions related to Microsoft SQL Server, and secondly to general SQL questions. If you use it for marketing, the people you want to reach will block you. So don't.

Day 35 Continuing an SQL course on Udemy. I'll just leave a cheat sheet here. #100DaysOfCode #sqlhelp

🎇 SQL is the bread and butter of an analyst. You can’t survive in the Data Science industry with a grip on this ‘easy-looking’ query language 🔥 📍 Learning 20% of what SQL can do should cover 80% of what you’ll need in day-to-day tasks #SQL #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

Friends on #sqlhelp - let's assume I'm trying to achieve highest possible insert times for a big table load on an in-memory table. Do tools, say BCP vs SmartBulkCopy, make a big difference? #sqlserver #azuresql

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

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

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

#sqlhelp Does anyone have a good reference or blog about @Azure_Synapse security? My google-fu is letting me down. Some context: data is highest level PII and I need to prove data won't be available outside the subscription.

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

#sqlfamily, #sqlhelp once again finding that I need less improvement in technical skills and more in interpersonal. I'd love advice on learning to be a more effective and human communicator.

#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?

#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?

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 fam, I need your help. I need to script the schema and data of “everything” inside a SQL Server schema (I don’t know beforehand what everything is) on .net The catch: I can’t use SMO. Any ideas? OSS libraries?

What is best practice when backing up databases in an Always On Availability Group? Do you use local backups? Your enterprise data protection solution? Something else? #sqlhelp

I received an excellent question: is #PowerBI part of #MicrosoftFabric, or part of Power Platform? Or both? And will dataverse end up in OneLake? #sqlhelp

What are some good strategies to reduce database size prior to moving the database, e.g. dropping unused/dup indexes, partitioning/archiving/deleting old data, data compression. What else am I missing? #sqlhelp

#sqlhelp NUMA/VM/MAXDOP gurus: I think SQL Server setup is getting the MAXDOP config wrong. Tell me what I'm missing. I have a server with 2 NUMA nodes, 64 logical processors total, 32 per NUMA node. According to KB 2806535, that should have MAXDOP 16:

All About SQL: Structured Query Language / #SQL #SQLServer #SQLHelp #Databases