Videos uploaded by user “SQLInSix Minutes”
TSQL: How To Build A Dynamic Pivot Table
Building Pivot Tables: https://www.youtube.com/watch?v=EoJS0m2R1u8 Group Items By Comma Separation: https://www.youtube.com/watch?v=ylF6sqbOoLQ
Views: 8956 SQLInSix Minutes
TSQL: Building Pivot Tables
An example of how to build a Pivot table and how they can be useful.
Views: 12567 SQLInSix Minutes
TSQL: Working With XML Part I
Working with XML in SQL Server
Views: 4075 SQLInSix Minutes
TSQL: Group Items With Comma Separation
Grouping items separated by a column.
Views: 4312 SQLInSix Minutes
TSQL: How To Automate A Three-To-Many Columns Pivot Table
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: 2985 SQLInSix Minutes
PowerShell: Unzip Multiple Zip Files To A Directory
GitHub script location: https://github.com/tmmtsmith/Powershell/blob/master/Administration/UnzipMultipleZipFiles.ps1
Views: 2735 SQLInSix Minutes
TSQL: Get Last Row of Data In A Table
Return the final row of data in a table
Views: 7341 SQLInSix Minutes
TSQL: Rebuild All Indexes In A Database
TSQL – Rebuild All Indexes https://www.fintekdev.com/tsql-rebuild-all-indexes/ (sponsored post) (Using Microsoft SQL Server 2008R2)
Views: 8770 SQLInSix Minutes
TSQL: How To Count NULL (And/Or Blank) Values
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: 2192 SQLInSix Minutes
TSQL: How To Automate A Two-To-Many-Column Pivot Table
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: 2574 SQLInSix Minutes
.NET: Collection was modified; enumeration operation may not execute
C#, VB.NET or PowerShell error.
Views: 1413 SQLInSix Minutes
PowerShell: How To End (Terminate) An Application/Process
Note that if you experiencing a "hanging application" with multiple applications, I would investigate the issue because it could be a deeper problem.
Views: 2741 SQLInSix Minutes
TSQL: Get the Standard Deviation
Finding the standard deviation the quick or long way.
Views: 1448 SQLInSix Minutes
TSQL: Get Next (or Previous) Value
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: 2263 SQLInSix Minutes
Powershell: Uninstall One or Multiple Applications
How to uninstall one or multiple applications using PowerShell.
Views: 327 SQLInSix Minutes
TSQL: How To Find Unused Stored Procedures
GitHub location: https://github.com/tmmtsmith/SQLServer/blob/master/Admin%20Tools/Cleaning/procmaintenance.sql
Views: 581 SQLInSix Minutes
MongoDB Error: Couldn't Connect To Server [IP]:[Port] src/mongo/shell/mongo.js:91 Exception
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: 21433 SQLInSix Minutes
Paul Randal's excellent article: http://sqlperformance.com/2014/02/sql-performance/knee-jerk-waits-sos-scheduler-yield
Views: 345 SQLInSix Minutes
SteemIt: Bandwith Limit Exceeded. Please Wait To Transact or Power Up Steem
ETL Course: https://www.udemy.com/automatingetl/
Views: 1073 SQLInSix Minutes
TSQL: How To Loop Through All Databases On A Server
Useful if you have tasks that need to be completed on each database using common table expressions. Note that using a temp table for the loop will be faster; this does show an alternative method, which is longer.
Views: 1666 SQLInSix Minutes
Clustered Column Store Indexes
Fun testing these
Views: 465 SQLInSix Minutes
PowerShell Error: "Could not load file or assembly ".dll" or one of its dependencies."
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: 602 SQLInSix Minutes
Powershell: How To Download A File
For how to get the flat file imported into SQL Server automatically, check out my course on Automating ETL at https://www.udemy.com/automatingetl/
Views: 655 SQLInSix Minutes

Microsoft office 2010 professional edition product key
Hard drive tach windows 7
Minhateca app windows phone
Hwgpci 54 windows 8
Andersen windows doors uk