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

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

How To Run SQL queries in phpMyAdmin #php #sql #sqlhelp #webdev #DevOps #webdevelopment #webdeveloper #Programming

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

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

#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

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

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 am failing to find decent documentation around HBA queue depth settings for SQL Server. There are a few mentions on blog posts and a thing about Azure VM settings, but not specific for SQL Server Anyone got ideas/suggestions? Best would be a MS "official" statement #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

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

What is your favorite database design tool? #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

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

Hear from David Terry, Senior Systems Engineer & Product Trainer at IDERA Software, on Tue, Jan 17, 2023, 11 AM - 11 AM EST. He will discuss how to proactively find & fix existing & developing #SQL Server performance problems. #sqlhelp #engineer #software

@Idera_Software Really Idera, you won't take the hint about not marketing/advertising to the #SQLHelp Hashtag? You are going to end up blocked by a large number of people in the very community you are trying to reach.

Does anyone know of any free #ssrs usage reports? Don't wan't to reinvent the wheel... Thank you #sqlhelp

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

Hey folks, I have a SQL Server with some issues @fatherjack noticed there are high numbers of spinlocks, but 4 out of the top 5 we have don't seem to be documented. Anyone know what these are? Thanks! LOGLFM SOS_RINGBUFFER_RECORD CONNECTS BASE_XACT_HASH #sqlhelp

I am learning SQL..but I'm in a stage I'm about to run..how I won remember all these statements: case, group by, on, join, outer&inner joins, union, union all, Desc, arse, exec, from, where, then, that,...these things are limitless..haba..#sqlhelp #mysql #SQLServer @Greyisheep

Oh dear @PSBPEI - the Healthy School Food Program is a great initiative, but if your website isn't ready to go you should not be sending emails to parents telling them to place their orders. It's pretty broken right now! #queryexception #sqlhelp #peipoli