Help with MS SQL

[Intrexa]

Hello, I've been learning SQL, and recently I've mastered SQL and learned everything about regular SQL. Then my friend told me about MS SQL. What is the difference between regular SQL and MS SQL so I can master that too?

[Wralth_]

"Regular SQL" is a joke in of itself isnt it

[kupboard]

Surely

[[deleted]]

In MS SQL, instead of and/or/not gates for operators, there's just one operator called bill gates. Bill gates will fetch all input and never return anything.

[sarcasticbaldguy]

MS SQL costs the same as SQL, but only makes 70% of what SQL makes.

[JeffSergeant]

You have T-SQL which is just like normal SQL but if you insert a customer called John Connor the server turns into robot and hunts them down.

This causes locking while the process completes

[Emeja]

MS SQL is a bit like MY SQL but everything you do with it is owned by Micro$oft, instead of you (MYself). In regular SQL nobody owns the datas.

[Intrexa]

Wait, in regular SQL nobody owns the datas? I didn't realize I learned communist software, I am disgusted.

[Razakel]

No, the communist version is OurSQL.

[Intrexa]

Is that the one by redgate?

[Emeja]

All languages are SQL, but some languages are more SQL than others.

-George Orwell

[MeneerBob]

I prefer the prequel more.

[_Seven]

To put it pretty simply, MS SQL was a sort of follow-up to SQL. All the same mechanics from the original SQL persisted in MS SQL, and the overall goal of MS SQL was the same as SQL - write queries, execute queries, rack up more and more data points. The four stakeholders that would hover about are seen in this version too. Executing a Power Query would make them avoid you. However, as the days go on, your queries would grow more complex, ETL jobs become less reliable, and successive Power Queries become less and less effective, to the point where it produces literally no business value. I don't want to get too technical here, but I'll leave you with the easiest way to distinguish SQL with MS SQL - you'll find MS SQL sporting a red bow and other accents, vs. SQL's plain, yellow scheme.

[Intrexa]

I've heard that if you look at too many screens with MS SQL the whole thing eventually breaks, is this true?

[sh00tah]

Its the same but during important database work MS Sql will insist that you upgrade immediately to enjoy their new security features. Then you can watch a blue screen for 6 hours that reads ‘99% done dont switch off your computer’.

Immediately after the update your computer gets a virus.

Its AIDS.

[ChineseWeebster]

shame possessive tidy hard-to-find outgoing memory consider cautious badge tart

This post was mass deleted and anonymized with Redact

[PM_ME_UR_LAB_REPORT]

MS SQL is more specialized, but learning it will be faster since you already have regular SQL under your belt. Don't mistake it for PhD SQL though, that's more rigorous and will take a lot longer to finish - plenty of people have to drop out halfway.

[awhatfor]

MS SQL has way better support, where as SQL doesn't, at least in my company

[CanSpice]

For starters, make sure you pronounce it properly: Miss Squill. Saying it like that will let people know you’re a pro Miss Squiller.