T Sql Quotes & Sayings

Microsoft has no SQL Server developers. We have only Azure developers. — Satya Nadella

Master Oracle Advanced PL/SQL concepts with the book — Saurabh Gupta

In addition to transitioning to the cloud, our customers continue to invest in premium versions of our on-prem server products like Window Server, System Center and SQL Server. — Amy Hood

Management OS should be nothing but a Management OS for Hyper-V. Don't make it a domain controller, don't install SQL Server, don't turn it into a Remote Desktop Services session host; Microsoft's support services won't like it. Instead, install those applications in virtual machines that are running on the host. — Aidan Finn

SQL Server itself and SQL Server Management Studio (SMSS). — D. Armstrong

With Dremel, engineers could formulate queries using an SQL-like syntax, speeding up the process of iterative analysis without dealing with the overhead of defining raw MapReduce jobs. — Anonymous

This had all the earmarks of an SQL-injection attack, and he had a favorite one. In the logon and password boxes he entered: 'or 1=1-- — Daniel Suarez

All the PHP code I've seen in that experience has been messy, unmaintainable crap. Spaghetti SQL wrapped in spaghetti PHP wrapped in spaghetti HTML, replicated in slightly-varying form in dozens of places. — Tim Bray

Microsoft SQL Server, Oracle, DB2, and PostgreSQL let you create user-defined types (UDTs). The simplest UDT is a standard or built-in data type (CHARACTER, INTEGER, and so on) with additional check and other constraints. You can define the data type marital_status, for example, as a single-character CHARACTER data type that allows only the values S, M, W, D, or NULL (for single, married, widowed, divorced, or unknown). More-complex UDTs are similar to classes in object-oriented programming languages such as Java or Python. You can define a UDT once and use it in multiple tables, rather than repeat its definition in each table in which it's used. Search your DBMS documentation for user-defined type. UDTs are created in standard SQL with the statement CREATE TYPE. — Chris Fehily

Index design is also a largely iterative process, based on the SQL generated by application designers. However, it is possible to make a sensible start by building indexes that enforce primary key constraints and indexes on known access patterns, such as a person's name. As the application evolves and testing is performed on realistic sizes of data, certain queries will need performance improvements for which building a better index is a good solution. — Andrew Holdsworth

SQL, Lisp, and Haskell are the only programming languages that I've seen where one spends more time thinking than typing. — Philip Greenspun

My particular interest for the past couple of years has been to really think deeply about the big impendence mismatch we have between programming languages, C# in particular, and the database world, like SQL or, for that matter, the XML world, like XQuery and those languages that exist. — Anders Hejlsberg