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 […]
Read More ›

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 […]
Read More ›

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 […]
Read More ›

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 […]
Read More ›

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 […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.