Home
Videos uploaded by user “SQLInSix Minutes”
TSQL: How To Build A Dynamic Pivot Table
 
04:40
Building Pivot Tables: https://www.youtube.com/watch?v=EoJS0m2R1u8 Group Items By Comma Separation: https://www.youtube.com/watch?v=ylF6sqbOoLQ
Views: 8874 SQLInSix Minutes
TSQL: Building Pivot Tables
 
09:16
An example of how to build a Pivot table and how they can be useful.
Views: 12407 SQLInSix Minutes
TSQL: Get Last Row of Data In A Table
 
06:32
Return the final row of data in a table
Views: 7113 SQLInSix Minutes
TSQL: Working With XML Part I
 
09:28
Working with XML in SQL Server
Views: 4025 SQLInSix Minutes
TSQL: Group Items With Comma Separation
 
06:20
Grouping items separated by a column.
Views: 4082 SQLInSix Minutes
TSQL: How To Automate A Three-To-Many Columns Pivot Table
 
05:55
Previous video - TSQL: How To Automate A Two-To-Many-Column Pivot Table: https://www.youtube.com/watch?v=P4WDKYWm6mk GitHub Script Location: https://github.com/tmmtsmith/SQLServer/blob/master/Admin%20Tools/OutputColumns.sql
Views: 2892 SQLInSix Minutes
TSQL: How To Automate A Two-To-Many-Column Pivot Table
 
05:37
Previous video - How To Build A Dynamic Pivot Table: https://www.youtube.com/watch?v=r0r__N4OEVs GitHub script location: https://github.com/tmmtsmith/SQLServer/blob/master/Admin%20Tools/OutputColumns.sql
Views: 2541 SQLInSix Minutes
TSQL: Rebuild All Indexes In A Database
 
12:05
TSQL – Rebuild All Indexes https://www.fintekdev.com/tsql-rebuild-all-indexes/ (sponsored post) (Using Microsoft SQL Server 2008R2)
Views: 8625 SQLInSix Minutes
PowerShell: Unzip Multiple Zip Files To A Directory
 
02:44
GitHub script location: https://github.com/tmmtsmith/Powershell/blob/master/Administration/UnzipMultipleZipFiles.ps1
Views: 2643 SQLInSix Minutes
TSQL: How To Count NULL (And/Or Blank) Values
 
04:28
This covers the behavior of NULL vs 0s vs. Blanks when casting the column from VARCHAR to INT. When in doubt, use simple mathematics equation to determine.
Views: 2112 SQLInSix Minutes
.NET: Collection was modified; enumeration operation may not execute
 
03:38
C#, VB.NET or PowerShell error.
Views: 1380 SQLInSix Minutes
TSQL: Get the Standard Deviation
 
10:18
Finding the standard deviation the quick or long way.
Views: 1394 SQLInSix Minutes
PowerShell: How To End (Terminate) An Application/Process
 
03:41
Note that if you experiencing a "hanging application" with multiple applications, I would investigate the issue because it could be a deeper problem.
Views: 2562 SQLInSix Minutes
TSQL: Get Next (or Previous) Value
 
09:22
How to get the next (or previous) value, using a common table expression. Note that in SQL Server 2012, we have the LAG and LEAD functions and use those for previous values.
Views: 2214 SQLInSix Minutes
MongoDB: ISODate()
 
02:56
Views: 1923 SQLInSix Minutes
SteemIt: Bandwith Limit Exceeded. Please Wait To Transact or Power Up Steem
 
01:47
ETL Course: https://www.udemy.com/automatingetl/
Views: 1055 SQLInSix Minutes
Powershell: Uninstall One or Multiple Applications
 
03:07
How to uninstall one or multiple applications using PowerShell.
Views: 290 SQLInSix Minutes
PowerShell Error: "Could not load file or assembly ".dll" or one of its dependencies."
 
02:42
PowerShell Add-Content Error - "Could not load file or assembly ".dll" or one of its dependencies. Operation is not supported." Information about the 32-bit version of PowerShell: http://technet.microsoft.com/en-us/library/hh847733.aspx
Views: 559 SQLInSix Minutes
Wait Types Part IX: SOS_SCHEDULER_YIELD
 
04:33
Paul Randal's excellent article: http://sqlperformance.com/2014/02/sql-performance/knee-jerk-waits-sos-scheduler-yield
Views: 328 SQLInSix Minutes
MongoDB Error: Couldn't Connect To Server [IP]:[Port] src/mongo/shell/mongo.js:91 Exception
 
02:10
Couldn't Connect To Server [IP]:[27017] src/mongo/shell/mongo.js:91 Exception: Connect Failed. Note that if you get this error when you're already connected, it may mean the server terminated.
Views: 20532 SQLInSix Minutes
Clustered Column Store Indexes
 
04:59
Fun testing these
Views: 453 SQLInSix Minutes