#SQLHelp

#sqlhelp anyone got a document on SQL Standards they'd share? all the things to put in front of Devs. Don't use guids. name PKs this way. Don't prefix tables with tbl. or do prefix tables with tbl. Whatever your standards are. I'm curious. And want to cheat and start with doc

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.

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

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

Well this is interesting - a table with 0 records using almost 100 GB of space. No open transactions, all columns are varchar(and none MAX) - any #SQLHelp ideas how this could happen?

Can someone confirm whether Azure Analysis Services can connect to Azure SQL DB data source via AAD auth for processing (refresh)? Or is SQL Auth the only option? #SQLHelp Cc/ @_christianWade

What is your favorite database design tool? #sqlhelp

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

Which is your favourite tool for T-SQL code formatting in SSMS? #sqlhelp

#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 Is there such a thing as learning, deeply learning, Synapse internals and infrastructure? If so, what are some resources to do so? I may just starting the search engine journey on this. Long term goal is to know how it works and how to make it work.

Is SQL Server Master Data Services a viable product (was it ever?) Does anyone actually use it? #sqlhelp

Okay #SQLFamily, tools to sanitize/anonymize data from Prod to load into Dev/Test environments? Experiences; the Good, Bad, and the Ugly... please share yours! Scripts, frameworks, open source, vendor products, blog posts. Anything is helpful at this point. #sqlhelp #SQLServer

I'd like to install the Standard edition of SQL 2017 to validate that some R and Python functionality doesn't require the Enterprise edition, but I don't have a license key. Do I have any options other than buying a Standard license or setting up a SQL VM in Azure? #sqlhelp

@SQLHA @lowrykoz @ChrisHyde325 Please file a feedback here: and we will evaluate. #sqlhelp If folks this is useful, please vote on it.

@banerjeeamit @lowrykoz @ChrisHyde325 Done. Now everybody go upvote this. #sqlhelp

#sqlhelp Looking for contacts to discuss the following virtualization technologies. Catalogic ECX SQL Clone from RedGate SAN Snapshotting from Pure ScaleArc Actifio Denodo SQL Virtual Database from Idera Delphix

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

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.

SQL BETWEEN Operator #sqlhelp #sqlskills #Database #mysql #PHP #Java #webdev #DevOps #tech #DataScience #tutorial

Websites to practice SQL🔥 👉w3resource 👉sqlzoo 👉w3school 👉sql-practice 👉hackerrank 👉sqlshack 👉metabase Want to add a few more..? Let me know👇 Follow @BhavishyaP9 for more tweets on resources/tips of Data Science, Job search etc 🥰 #DataScience #sqlhelp

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