Mark C
@MarkSQLDev
It's SQL AdventureWorks Time with Mark! Kind of like Sliders but in a SQL Server environment! Open to new adventures and new opportunities!
You might like
Hi Mark, I believe MVA retired this seminar. You can find coverage of APPLY in the following two part session. Part 1: m.youtube.com/watch?v=-m426W…, Part 2: m.youtube.com/watch?v=goyWzA….
youtube.com
YouTube
SQLug.se - Itzik Ben-Gan - Creative Uses of the APPLY Operator,...
On my journey to getting an #msca in #Tsql, I came across this really interesting application of intersect in a query. #SQLServer
Since owning a @AmazonKindle , I started a sampler reading of, "The Data Warehouse Toolkit" by R. Kimball & M. Ross. 100% at the end of the Table of Contents? Huh...
Subsets within the Tables: Proceeding from the previous article, now let's say there's a subset contained in ... bit.ly/2eN9de4
Multiple Tables, Same Key, Dependent on Another Column: Let's say you're working with a table that has simila... bit.ly/2dEhL6D
Table Finder Tool: Here's a tool I developed to help me in my search through a data warehouse for columns and... bit.ly/2dmWNs0
Optimizing Case Statements: In my previous position, I was blown away by the creative uses of case statement ... bit.ly/2cNHHMo
SQL Technical Interview Questions #5: Revisited: Looking back at this previous post, having done a lot more w... bit.ly/2d1dY0I
SQL Technical Interview Questions #5: Two Million Served: I recently completed another technical interview, o... bit.ly/23XkNEx
SQL Technical Interview Tip: When taking a technical interview coding test, it's important to look over the te... bit.ly/23IMIrs
"Inheriting" Temporary Tables: There is an interesting behavior that really rocked me when I first saw it out ... bit.ly/1oS54GN
SQL Tech Interview Overall (Questions 2-4): Now that we've answered all the questions, let's take an overall l... bit.ly/23byfnO
SQL Technical Interview Questions #4: Everyone in Categories: I recently completed another technical intervie... bit.ly/1Rv5CNa
SQL Technical Interview Questions #3: Everyone, with or without that.: I recently completed another technical ... bit.ly/22IOdpa
SQL Technical Interview Questions #2: Details, Details, Details: Going forward, I will be utilizing SQL Fiddle... bit.ly/1UafoYz
A less than ideal use of Variables in SQL: This is actually spurred from my previous post, so here's an exampl... bit.ly/1SZ3hwQ
Got a taste of how sql server handles xml docs. As someone who used java to load xml docs data into sql server, I wish I learned sooner!
This might show my greenness, but fighting over resources is kind of stupid. Why is it even a thing?!
Crap, looks like it'll be another month for me to go to sql pass. Couldn't get back in the city on time for it
United States Trends
- 1. FINALLY DID IT 487K posts
- 2. The PENGU 227K posts
- 3. The JUP 80.2K posts
- 4. The BONK 137K posts
- 5. The Jito 33.1K posts
- 6. Good Wednesday 31K posts
- 7. #keyboard 2,836 posts
- 8. Mariah 39.4K posts
- 9. The WET 28.6K posts
- 10. #wednesdaymotivation 1,919 posts
- 11. #daring 2,510 posts
- 12. #NoWarYesPeace 2,361 posts
- 13. #vulture 2,980 posts
- 14. Robert E Lee 12.5K posts
- 15. Hump Day 11.8K posts
- 16. Hut 8 1,279 posts
- 17. Happy Hump 7,496 posts
- 18. Ephesians 3,426 posts
- 19. Buck Rogers 6,094 posts
- 20. Gil Gerard 6,026 posts
You might like
Something went wrong.
Something went wrong.