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!
Anda mungkin suka
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
Read the SQLServerCentral blogs: Execute SSIS Package from PowerShell rd.gt/2vIavy7
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 Tren
- 1. #WWERaw 12K posts
- 2. Cuomo 118K posts
- 3. Koa Peat N/A
- 4. Cowboys 30.2K posts
- 5. #OlandriaxCFDAAwards 6,985 posts
- 6. Monday Night Football 8,555 posts
- 7. Walt Weiss 2,746 posts
- 8. Caleb Wilson N/A
- 9. Harvey Weinstein 8,511 posts
- 10. Teen Vogue 4,996 posts
- 11. Braves 11.7K posts
- 12. Arizona 30.6K posts
- 13. Sliwa 33.3K posts
- 14. Schwab 5,859 posts
- 15. #RawOnNetflix N/A
- 16. Diane Ladd 6,643 posts
- 17. Hamburger Helper 2,826 posts
- 18. Ben Shapiro 40.2K posts
- 19. Myles Turner 1,671 posts
- 20. Stefan Vaaks N/A
Anda mungkin suka
Something went wrong.
Something went wrong.