Running SQL code in SSMS starts with F5 or the Execute button. This post covers running only a selection, what a batch is, why GO is not T-SQL, why variables disappear after GO, and how GO with a number repeats a batch.
Data and Information: Why Every Business Runs on a Database
Data and Information are not the same thing. Data is the raw facts a business stores, and information is the answer you get when a query processes them. This post uses a small bookshop table to show the difference, and why a database does the job better than a ledger or a spreadsheet.
The Four Window Functions You Will Actually Use
Learn four practical window functions with SQL examples for numbering rows, ranking ties, comparing previous values, and calculating running totals.
SQL or NoSQL for a New Project
Choose SQL or NoSQL for a new project by testing data shape, consistency needs, query patterns, and the skills the team can operate.
SQL SERVER – Delay Command in SQL Server – SQL in Sixty Seconds #055
Need SQL Server to wait before it runs the next statement? This SQL in Sixty Seconds video shows the delay command, WAITFOR DELAY, in action.
What to Look For in a SQL Client Tool
Choose a SQL client tool by testing result handling, execution plans, transactions, and connection identity before trusting it with real work.
What Is a Trigger in SQL Server?
A trigger in SQL Server runs because something else happened, and you never call it. The inserted and deleted tables, why it fires once per statement and not once per row, and when to reach for something else.