Home
Videos uploaded by user “Aaron Buma”
SQL XML Modes - RAW, AUTO and PATH
 
24:42
The Lesson: http://www.aaronbuma.com/2015/06/xml-modes-raw-auto-path/ Follow the Books: http://amzn.to/1RjjJCf Other Trainings: www.AaronBuma.com/free-sql-server-training/ For previous presentations and notifications of upcoming events, checkout my blog: www.AaronBuma.com or follow @AaronDBuma Slides and scripts are also available at: www.AaronBuma.com
Views: 11789 Aaron Buma
SQL Query Training   70 461 TOP Ranking and Analytic functions
 
01:26:16
Additional Training: http://amzn.to/1RjjJCf Other Trainings: www.AaronBuma.com/free-sql-server-training/ We cover features around the TOP(N) in your query, followed by using the RANK(), DENSE_RANK and ROW_NUMBER. Then on to Analytic Functions to help with your statistical analysis of data. Similar to aggregate functions, analytics functions compute over a group of rows with multiple results within each group. Learn how to properly use each of these analytics functions in combination with enhancements to the OVER clause. Learn the value of CUME_DIST and PERCENT_RANK in your analysis, use LAST_VALUE and FIRST_VALUE along with PERCENTILE_DISC, PERCENTILE_CONT, LEAD and LAG you can look at data in the next and previous row. For previous presentations and notifications of upcoming events, checkout my blog: www.AaronBuma.com or follow @AaronDBuma Slides and scripts are also available at: www.AaronBuma.com
Views: 10255 Aaron Buma
SQL Server Aggregate functions and the OVER clause
 
57:32
Follow the Books: http://amzn.to/1RjjJCf SQL Server Training for the Microsoft 70-461 exam. This session includes Aggregate functions and the windowing functions (OVER, PARTITION BY). Slides and scripts available at: www.AaronBuma.com
Views: 3993 Aaron Buma
SQL Review of JOIN Types
 
01:27:47
Materials and Books: http://amzn.to/1RjjJCf Website: http://www.aaronbuma.com/2015/03/eleven-join-types-of-tsql/ Outline: — Basic SELECT —INNER JOIN —LEFT OUTER JOIN —RIGHT OUTER JOIN —LEFT OUTER JOIN with exclusion —RIGHT OUTER JOIN with exclusion —SEMI JOIN —ANTI SEMI JOIN —CROSS JOIN —FULL OUTER JOIN —FULL OUTER JOIN with exclusion —CROSS APPLY —OUTER APPLY —Multiple combinations of JOINs
Views: 2159 Aaron Buma
XML Importing and Exporting with BCP
 
08:26
Follow the Books: http://amzn.to/1RjjJCf To download the scripts and slides visit: http://www.aaronbuma.com/2016/02/xml-export-import/ This week's SQL Training covers Exporting data via BCP and also Importing XML from disk via OPENROWSET and OPENXML
Views: 1306 Aaron Buma
SQL GUIDS
 
17:00
Follow the Books: http://amzn.to/1RjjJCf The slides and scripts for this training are available at: http://www.aaronbuma.com/2015/10/guids/ Thanks for watching! Check out the other SQL Training videos on my channel.
Views: 1041 Aaron Buma
SQL XML Queries
 
23:10
Follow the Books: http://amzn.to/1RjjJCf Get the slides and Scripts at: http://www.aaronbuma.com/2015/09/xml-queries-xquery-relative-absolute-and-data-function Lots of other free SQL Sessions at: http://www.aaronbuma.com/category/sql-training/
Views: 5905 Aaron Buma
XML Data Binding
 
04:57
Follow the Books: http://amzn.to/1RjjJCf To download the scripts and slides visit: http://www.aaronbuma.com/2016/02/xml-data-binding/ This week's SQL Training covers XML data binding, but XML to SQL and SQL to XML.
Views: 1126 Aaron Buma
tSQL - Stored Procedures
 
44:41
Follow the Books: http://amzn.to/1RjjJCf A part of the 70-461 training, sponsored by Emergency Reporting.  This week's training will cover stored procedures how to create/alter/drop and execute SQL Stored Procedures and how to use input and output parameters. As a bonus we cover User Defined Datatypes (as tables to pass into sprocs as an input parameter). Get the slides and scripts on my blog: http://www.aaronbuma.com/2015/04/stored-procedures-inputs-outputs-and-everything-between/
Views: 1227 Aaron Buma
Makauwahi Cave
 
01:39
Makauwahi Cave in Kauai http://cavereserve.org/index.php 21°53'19.3"N 159°25'07.3"W Filmed by hand with a GoPro 4. Check out my blog at: www.AaronBuma.com
Views: 203 Aaron Buma
SQL XML - Shredding, OpenXML and Options
 
24:47
Follow the Books: http://amzn.to/1RjjJCf Sorry for stopping the video early, I missed my contact info! You can contact me at: [email protected] The slides and scripts are available at: http://www.aaronbuma.com/2015/07/sql-xml-shredding-row-and-column-patterns-with-options Many more training sessions available at: http://www.aaronbuma.com/2015/01/free-sql-server-training/
Views: 1822 Aaron Buma
TSQL: Time, Logical Functions User Defined Functions
 
01:26:32
Follow the Books: http://amzn.to/1RjjJCf This video is covers: Time and Logical Functions User Defined Functions: Scalar, Single-Statement and Multi-Statement Table Value Functions (and how they can be in views). Download the slides and scripts (and view other presentations) at: http://www.aaronbuma.com/2015/03/tsql-time-logical-and-user-defined-functions/
Views: 187 Aaron Buma
XQuery Extensions
 
36:37
Follow the Books: http://amzn.to/1RjjJCf The slides and scripts for this training are available at: http://www.aaronbuma.com/2015/10/xquery-extensions/ Thanks for watching! Check out the other SQL Training videos on my channel.
Views: 362 Aaron Buma
SQL Server Training  OUTPUT Clause and Derived Tables
 
01:05:32
Follow the Books: http://amzn.to/1RjjJCf A free training provided by Steve Stedman and Aaron Buma at Emergency Reporting to prepare for the Microsoft 70-461 SQL Queries exam. This video covers the OUTPUT Clause and Derived Tables. This is provided free of charge to give back to the SQL community. Get more information at http://www.aaronbuma.com/2015/02/sql-correlated-subqueries-subquery-extensions-and-output-clause
Views: 532 Aaron Buma
Aerial Drone footage from Kauai - full clips
 
08:15
Start filming with this drone: http://amzn.to/1QLFZnG Aerial Video From: Waimea Canyon Kamoohoopulu Ridge Poipu Beach Poipu Bay Golf Course Makauwahi Cave Reserve Gillin Beach Panoramas available at: http://www.aaronbuma.com/category/aerial-photography-and-videos/ Contact: http://www.bellinghamaerialmedia.com/
Views: 963 Aaron Buma
tSQL Cursors and String Functions
 
01:25:21
Materials and Books: http://amzn.to/1RjjJCf Slides and scripts available at: http://www.aaronbuma.com/2015/03/tsql-cursors-and-string-functions/
Views: 828 Aaron Buma
SQL Query Training - Set Operators, Derived Tables and CTEs
 
01:33:12
Follow the Books: http://amzn.to/1RjjJCf Presentation to prepare for the SQL Queries 70-461 exam: —Set Operators —Derived Tables —Common Table Expressions Slides and scripts available at: www.AaronBuma.com
Views: 839 Aaron Buma
SQL Table Delete and Truncate, Schemas and Synonyms
 
29:38
Follow the Books: http://amzn.to/1RjjJCf To get the materials for this presentation: http://www.aaronbuma.com/2015/04/sql-table-data-operations-schemas-and-synonyms/ For any of my previous presentations visit: http://www.aaronbuma.com/category/sql-training/
Views: 293 Aaron Buma
SQL Errors and Error Handling
 
35:33
Follow the Books: http://amzn.to/1RjjJCf Topic covers Error Messages, what causes them, what they mean and how to force them with Custom Error Messaging. I also go over how to handle them with TRY CATCH, also incorporating TRANSACTIONS. To get the materials: http://www.aaronbuma.com/2015/04/sql-error-messages-and-error-handling-try-catch/ All other FREE SQL Trainings: http://www.aaronbuma.com/category/sql-training/
Views: 1239 Aaron Buma
Dynamic SQL - Exec and SP_ExecuteSQL with SQL Injection and Query Plans
 
31:53
Follow the Books: http://amzn.to/1RjjJCf Slides and Scripts are available: http://www.aaronbuma.com/2015/05/dynamic-sql-exec-sp_executesql-sql-injection-and-query-plans/ Today's training was on Dynamic SQL, what it is and how to do it (dangerously and safely). I cover "EXEC" and "SP_ExecuteSQL", their differences, how they are cached and how they do or don't protect against SQL Injection. A part of the Free 70-461 Queries SQL Training Series sponsored by Emergency Reporting.
Views: 882 Aaron Buma
Airsoft at the Mill - November 3rd, 2018
 
12:18
Cobbled together from GoPro clips.
Views: 43 Aaron Buma
SQL 70-461 Training: MERGE Statement and Recursive Queries
 
01:20:51
Follow the Books: http://amzn.to/1RjjJCf A free training provided by Steve Stedman and Aaron Buma at Emergency Reporting to prepare for the Microsoft 70-461 SQL Queries exam. This week we will be two topics, first on the MERGE Statement, then Recursive Queries. This is provided free of charge to give back to the SQL community. Slides and Scripts available at:
Views: 1180 Aaron Buma
SQL Views
 
16:56
Follow the Books: http://amzn.to/1RjjJCf Slides at: http://www.aaronbuma.com/2016/01/views/ This week's session is on SQL Views: what they are, how to create them, how to insert, update and delete data through them along with other key details to know!
Views: 163 Aaron Buma
Woodstck Farms, Bellingham
 
07:21
http://www.cob.org/services/recreation/parks-trails/woodstock-farm.aspx It was too windy at the start, so I moved and didn't fully stop the recording so skip in a few minutes or so. View my blog post for this video and others at: http://www.aaronbuma.com/2015/02/footage-from-the-past-woodstock-farms-bellingham-wa/
Views: 304 Aaron Buma
Aerial View of Bellingham from Galbraith Mountain
 
03:20
Watch in HD! It was a windy day at that height which the gimbal didn't like. Here's a few clips from the walk that day. Youtube's auto-stabilization was causing artifacts in the video, so this is a re-upload of the raw footage. I hope I did my hometown a little justice, getting the San Juans, Bellingham Bay, Canada, Lake Whatcom and Mount Baker all in one shot! This video isn't from the future, just a late-night rookie editing typo. Check out the other videos on my channel or visit my website: www.AaronBuma.com
Views: 304 Aaron Buma
SQL Server - Constraints
 
17:11
Follow the Books: http://amzn.to/1RjjJCf The slides and scripts for this training are available at: http://www.aaronbuma.com/2015/10/constraints/ Thanks for watching! Check out the other SQL Training videos on my channel.
Views: 276 Aaron Buma
tSQL Training: 70 461 - Section 1 Review
 
01:28:21
Follow the Books: http://amzn.to/1RjjJCf If you have been following our training over the last six weeks, this presentation marks 25% of the way through the certification training, we have decided to do a review of the last 6 sessions. This session will be mostly code examples, and will be a review of the following topics to prepare for the SQL Queries 70-461 exam: Null Expressions Identity Aggregation Top, Ranking and Aggregation OUTPUT Clause Correlated Subqueries and Subquery Extensions Merge Statement Set Operators Derived Tables Common Table Expressions Recursive QueriesNull, Expressions, Identity, Aggregation, Top, Ranking, Aggregation, OUTPUT Clause, Correlated Subqueries, Subquery Extensions, Merge Statement, Set Operators, Derived Tables, Common Table Expressions, Recursive Queries,
Views: 363 Aaron Buma
Down from Road, Woodstock Farms, Bellingham
 
03:46
http://www.cob.org/services/recreation/parks-trails/woodstock-farm.aspx View my blog post for this video and others at: http://www.aaronbuma.com/2015/02/footage-from-the-past-woodstock-farms-bellingham-wa/
Views: 406 Aaron Buma
Samish Overlook - Raw 2 of 2
 
06:37
A raw video (no edits). Camera: http://amzn.to/1X5Z8Y9 Lens: Non-fish eye 5.4mm
Views: 23 Aaron Buma
Path to Beach, Woodstock Farms, Bellingham
 
04:25
http://www.cob.org/services/recreation/parks-trails/woodstock-farm.aspx View my blog post for this video and others at: http://www.aaronbuma.com/2015/02/footage-from-the-past-woodstock-farms-bellingham-wa/
Views: 179 Aaron Buma
End of Summer 2014
 
04:22
My first video edit, still learning the process. Shot at 1080p at 48fps on a Hoverthings Flip FPV Pro G frame. Check out my blog at: www.AaronBuma.com
Views: 66 Aaron Buma
SQL Triggers
 
15:31
Follow the Books: http://amzn.to/1RjjJCf The slides and scripts for this training are available at: http://www.aaronbuma.com/2016/01/SQLTriggers/ Thanks for watching! Check out the other SQL Training videos on my channel.
Views: 128 Aaron Buma
Paintball Station 8/11/18 - Sneak Up Attacking Snipers in the back corner 3 of 3
 
06:35
My first time playing with a GoPro and first time at Paintball Station
Views: 5 Aaron Buma
Bellingham Aerial Media: Kauai Promo
 
04:41
Aerial Video From: Waimea Canyon Kamoohoopulu Ridge Poipu Beach Poipu Bay Golf Course Makauwahi Cave Reserve Gillin Beach Panoramas available at: http://www.aaronbuma.com/category/aerial-photography-and-videos/ Editing by: Josh Bradley Contact: http://www.bellinghamaerialmedia.com/
Views: 15 Aaron Buma
Wind Turbine Blade on I5
 
00:26
Seeing this on the road totally blew me away.
Views: 31 Aaron Buma
Aerial Video of Hovander Homestead Park
 
06:20
Filmed at Hovander Homestead Park in Ferndale, WA. http://www.BellinghamAerialMedia.com/ http://www.aaronbuma.com/category/aerial-photography-and-videos/
Views: 82 Aaron Buma
618 13th Street, Bellingham, WA
 
01:54
My partner Josh Bradley and I were able to get out on a nice sunny day to do some filming. Josh did a great edit with this one! www.AaronBuma.com
Views: 58 Aaron Buma
SQL Views
 
00:00
Views: 0 Aaron Buma
Skydive Snohomish
 
10:13
Views: 28 Aaron Buma
Paintball Station 8/11/18 - Center Flag with Nick
 
04:32
My first time playing with a GoPro and first time at Paintball Station
Views: 7 Aaron Buma
Paintball Station 8/11/18 - Crawling Attacking Snipers in the back corner 2 of 3
 
11:51
My first time playing with a GoPro and first time at Paintball Station
Views: 2 Aaron Buma
Paintball Station 8/11/18 - game 1
 
01:17
My first time playing with a GoPro and first time at Paintball Station. Encounter at: https://youtu.be/N-nLGpi8gAI?t=58
Views: 3 Aaron Buma
Cape Mears, Oregon via Drone
 
01:55
It was quite a windy day. This place makes you feel small!
Views: 30 Aaron Buma