Tag: Applied SQL

Applied SQL: Server Side Traces

It’s time to get your server side trace on, with a little practical application! I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page. Prerequisites: basic T-SQL, basic experience with SQL Profiler Reading: SQLServerPedia article: The Server-side Trace: What, Why, and How    SQL Server Books Online […]

Applied SQL: sys.sql_modules

I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page. Prerequisites: basic T-SQL (including JOINs and LIKE), basic knowledge of catalog views Reading: SQL Server Books Online sys.sql_modules article. Level 1 Assignments: Using sys.sql_modules, write a query for each of the following: Find all object definitions […]

Applied SQL: sys.objects

I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page. Prerequisites: basic T-SQL (including JOINs and LIKE), ability to search BOL Reading: SQL Server Books Online sys.objects article. Level 1 Assignments: Using sys.objects, write a query for each of the following: Get a list of all […]