TechRepublic

SQL basics: SELECT statement options

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Due to popular demand, we’re ...
Visual Studio Magazine

SQL Formatter Previews in Microsoft's MSSQL VS Code Tool

Microsoft's MSSQL extension v1.45 previews a configurable T-SQL formatter while two existing features reach GA.
Ars Technica

[SQL] Handle SELECT INTO #TempTable In IF/ELSE Statement

What the best way to work around this? I have the same SELECT statement but there are different criteria depending on the IF check. Well, if you happen to be using Sql Server you can do that sort of ...
Tech Critter

Tips for Improving Your SQL Server Performance

Database performance is rarely a single "fix it and forget it" task. SQL Server workloads shift over time. A sluggish ...
TechRepublic

Using Access to build a front end for SQL Server

What are the advantages of using Access as the front end to a SQL Server database? For starters, it’s likely that your client’s users will be more familiar with it, and it’s relatively easy to put in ...