You can ORDER BY a column alias, so why not use it in WHERE? A simple example that shows how SQL Server assigns a Column Alias and where it is in scope.
Interview Question of the Week #022: How to Get Started with Big Data?
When an interviewer asks how you would get started with big data, a list of tools is the weakest answer. This post gives a short model answer: start from SQL, learn the core ideas, run one engine on a laptop and build one small project end to end.
Primary Data File Extensions: Does the .mdf Name Matter?
Can a primary data file end in something other than .mdf? I built a demo database with odd names, checked each file, then detached and attached it.
Reading a Workload Capture Without a Tool
Read a workload capture by grouping related queries, comparing total resource use, and separating one slow execution from repeated work.
Default Filegroup: Sending New Tables Away From PRIMARY
Changing the default filegroup only affects tables you create later. Here is what moves, what does not, and how a script can quietly ignore the rule.
What Is a Data Type, and Why the Wrong One Costs You
A data type decides what a column holds, what it costs in bytes, and how SQL Server compares it. Why NVARCHAR doubles your storage, why float will not compare cleanly, and the conversion that quietly kills an index.
When In-Memory OLTP Helps and When It Does Not
Learn when In-Memory OLTP can reduce transaction contention, which limitations still matter, and what to measure before changing tables.