Publication My role
Beginning T-SQL Edition 4 Author
Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server ApplicationsTech Reviewer
Expert T-SQL Window Functions in SQL Server 2019 Author
Data Professionals At Work Co-Author
Let Her Finish: Voices from the Data Platform Co-Author
Pluralsight: Improve SQL Server Performance with Compression Author
Pluralsight: Build and Deploy SSRS Mobile Reports Author
Pluralsight: Configuring Kerberos for SSRS Author
Pluralsight: T-SQL Window Functions Author
Beginning SQL Server Reporting Services Author
Expert T-SQL Window Functions Author
Beginning T-SQL Author
Dynamic SQL: Applications, Performance, and Security Tech Reviewer
Professional Microsoft SQL Server 2014 Administration Tech Reviewer
Beginning SSRS 2012 Joes 2 Pros Author
Beginning T-SQL 2012 Co-Author
Beginning T-SQL 2008 Author
SQL Server MVP Deep Dives Contributor
Professional SQL Server 2005 Integration Services Co-Author
Microsoft SQL Server 2012 Bible Tech   Reviewer
Visual Intelligence: Microsoft Tools and   Techniques for Visualizing Data Tech Reviewer
Building Performance Dashboards and Balanced   scorecards with SQL Server Reporting Services Tech   Reviewer

2 Responses to Publications

  1. Anne says:

    I am working through “Beginning T-SQL 2012”, exercise 5-2-6 is “Write a query that returns the BusinessEntityID column from the Sales.SalesPerson table along with every ProductID from the Production.Product table”. The supplied answer uses a cross join, how would I know that a cross join is needed here?

  2. The key word here is “every”. If I want to join from one table to every row in another table, that is a clue to use cross join.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s