Category: Tech and Learning

Applied SQL: sys.sql_modules

Post author By Jen McCown
Post date August 18, 2011
Categories In Applied SQL, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, TSQL
15 Comments on 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

Post author By Jen McCown
Post date August 17, 2011
Categories In Applied SQL, Beginner, sql server, sqlserverpedia-syndication, SSC
15 Comments on 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 […]

Applied SQL: You Have Homework

Post author By Jen McCown
Post date August 17, 2011
Categories In Applied SQL, sql server, sqlserverpedia-syndication, SSC
9 Comments on Applied SQL: You Have Homework

I found myself saying this week – for the N-zillionth time – that while studying is vital, it isn’t everything. What do we really need to understand SQL Server and internalize it? Practice. Bearing this in mind, I’m starting up an Applied SQL series of blogs, with the sole purpose of giving you homework. You’re […]