The big data movement has made grand promises to decipher signals within unstructured data. Even while (some) companies are abandoning analytics approaches for Big Data modeling, the most important business data is still “small” and lives in a structured database somewhere. To unlock that data in any meaningful way, you’ll need to know a procedural language, probably SQL.
- Who Should Learn T-SQL?
Transact-SQL (or T-SQL) is a flavor of the procedural language used specifically for Microsoft SQL Server that you probably won’t run across randomly. From learning SQL to T-SQL, you’ll need to forget a few things and learn a few more. Here’s why you should learn it.
- How Do You Pronounce SQL?
There are some significant phonological debates in the tech world. For instance, does GIF have a hard “g” (as in gift)? Or do you say GIF with a “j” sound? Another phonological debate has arisen among those who care about the pronunciation of SQL. We care. Here are the breakdown and history of both pronunciations.
- SQL, PL-SQL, T-SQL: What’s the Difference?
Microsoft has developed or licensed a number of SQL variants. Yes. They’re all procedural languages used to manage relational databases, but they’re used differently. They were also all created by different organizations. Here’s the difference between SQL, PL-SQL, and T-SQL.
- 4 Places Where T-SQL Just Makes Sense
Transact-SQL is well known as the Microsoft and Sybase implementation of the Structured Query Language used by all databases. But what might not be obvious at first glance is the increased set of capabilities that T-SQL brings to the database server. T-SQL is actually a full procedural programming environment that passes the Turing-completeness test.