MarkSQLDev's profile picture. It's SQL AdventureWorks Time with Mark! Kind of like Sliders but in a SQL Server environment! Open to new adventures and new opportunities!

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!

내가 좋아할 만한 콘텐츠
Mark C 님이 재게시함

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….

ItzikBenGan's tweet card. SQLug.se - Itzik Ben-Gan - Creative Uses of the APPLY Operator,...

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

MarkSQLDev's tweet image. On my journey to getting an #msca in #Tsql, I came across this really interesting application of intersect in a query. #SQLServer

Mark C 님이 재게시함

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...

MarkSQLDev's tweet image. 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 트렌드

내가 좋아할 만한 콘텐츠

Loading...

Something went wrong.


Something went wrong.