SQL Server: Users Without Logins?
Anna P., a student in Learning Tree’s course 8420, Querying Data with Transact SQL, asks “What good is an SQL Server user with no login?”. No good at all, if you think of users just as people. Clearly, people need to login before they can use SQL Server. However, users can also be thought of […]
The SQL Server Interview Questions that Matter
If you’re worried about interviewing for a SQL Server job, here’s some advice from the former head of an IT department on what matters (along with examples from the three critical areas where you need to have answers ready). As an instructor for Learning Tree’s Querying SQL Server 2014 and 2016 courses, I’ve worked with […]
Save Time Writing T-SQL With Templates and Code Snippets
Time-savers are most important when you are busy – that seems obvious. The unfortunate irony is that when you are busy you cannot take the time to create them. The creation of time-savers drops to low priority the minute the rush is over. Well, today I am going to fight my natural laziness and create […]
How to Use CROSS APPLY with Derived Tables in Transact SQL Queries
Armelle G, a student in Learning Tree’s SQL Server Transact-SQL Programming course asks “Is CROSS APPLY only used with T-SQL Functions?” Great question Armelle! Many SQL Server folks would answer “yes” but the fact is that CROSS APPLY can also be used with subqueries. CROSS APPLY allows you to create the equivalent of correlated derived tables in […]
Which Standard Deviation & Variance to use in Excel (and SQL!).
A look at STDEV, STDEVP, VAR and VARP- Amy M., from Developing SQL Queries for SQL Server, writes… “I know there are two functions for standard deviation and for variance in Transact-SQL, but I can never remember when to use which.” You are so right, Amy. It is hard to know when to use STDEV […]