Home
Videos uploaded by user “Mike”
Moving SQL Server Logins
 
04:50
Move SQL Server logins from one instance to another
Views: 20779 Mike
What Are Logical Reads
 
01:47
What the difference between physical and logical reads.
Views: 1894 Mike
SSIS - Union All
 
03:23
A very simple UNION ALL example within SSIS.
Views: 6232 Mike
Data Mining - Decision Tree
 
10:05
Use a view to make predictions about bike purchases.
Views: 11665 Mike
Attach SQL Database Without Log File
 
03:27
Attach Data File Without the Log
Views: 12126 Mike
SSIS - Derived Column Transformation
 
09:48
Simple derived column transformation
Views: 17356 Mike
What is AWS?
 
02:12
http://bit.ly/1EJsBPK - Real World Performance Tuning http://bitly.com/1Ige2Sh - Real World Troubleshooting Skills
Views: 3077 Mike
Parameter Sniffing 101
 
05:01
What is Parameter Sniffing?
Views: 1373 Mike
Stored Procedures with Common Table Expression
 
05:16
Turn CTE into stored procudure.
Views: 3066 Mike
Keras Introduction
 
06:15
The Keras Model Building Procesds
Views: 2823 Mike
Automate sp_whoisactive
 
09:20
whoisactive
Views: 2069 Mike
DON'T touch MAXDOP
 
06:37
Why you should rarely remove parallelism.
Views: 1859 Mike
Playing With The Resource Database
 
08:21
Restoring the Resource DB
Views: 772 Mike
BI Semantic Model Overview
 
11:51
Why the new model?
Views: 1632 Mike
Table Relationships
 
07:56
Join thesqlspot.io today!
Views: 228904 Mike
Deadlocks With Xevents
 
03:32
Using the system health check to find deadlocks
Views: 197 Mike
Creating a Simple Table Valued Function
 
03:58
Craft Simple Inline TVF
Views: 4981 Mike
Azure Machine Learning: Binary Classification
 
03:35
Uploading the Titanic Data Set
Views: 866 Mike
FullText Search - 2008
 
08:13
iFTS Example
Views: 4562 Mike
Spinning Up Your First EC2 Instance
 
05:16
AWS Reduced Rate: http://bit.ly/1KZBUvy
Views: 699 Mike
ASYNC Network IOs
 
02:40
Wait Stats
Views: 185 Mike
Setting Up Transactional Replication
 
08:47
Quick Replication Set up
Views: 3228 Mike
Contained Databases
 
09:07
SQL Server 2012 Contained Databases
Views: 463 Mike
Identity Seeds
 
06:28
Creating A Simple Identity Column
Views: 1885 Mike
Logging Into AWS Using Two Factor Authentication
 
01:23
How to Log Into AWS With Multi-Factor Authentication
Views: 638 Mike
Simple Wait Stat Example
 
07:56
WRITELOGS
Views: 234 Mike
Using the Default Trace
 
06:20
Looking at the Properties of the Default Trace
Views: 405 Mike
Write Ahead Logging
 
06:21
High Level Write Ahead Logging
Views: 10520 Mike
Script Data and Schema in SQL Server
 
06:17
Scripting Data in SQL Server
Views: 706 Mike
Removing VLF Fragmentation
 
05:58
Shrinking Excessive VLFs
Views: 627 Mike
Move TempDB
 
04:16
Move TempDB to a separate drive
Views: 639 Mike
Alternate Row Colors in Report
 
03:01
Alternate Row Colors in SSRS Report
Views: 1660 Mike
What is Tokenization in NLTK
 
02:50
Let's break up some text.
Views: 1740 Mike
Camtasia For Mac Udemy Upload
 
04:46
Upload to Udemy with Mac Organically
Views: 196 Mike
Using Table Variable
 
04:28
Overview of Table Variable
Views: 537 Mike
tempdb spills and memory grants
 
03:47
Memory Grants - Part 1
Views: 394 Mike
AdventureWorks Sample Install
 
05:04
Installing SQL Server Sample Databases
Views: 2871 Mike
What are Latches
 
06:47
Latch Overview
Views: 4143 Mike
FileGroups
 
06:35
FileGroups and their applications
Views: 3005 Mike
Transaction Log Architecture
 
07:01
What's Inside the Transaction Log
Views: 14597 Mike
DBCC LOGINFO
 
04:27
Output of LOGINFO and column desc
Views: 571 Mike
Move Master Database
 
06:22
Move the Master Database to separate drive
Views: 3587 Mike
BI Stack Intro
 
10:37
What is the BI Stack?
Views: 553 Mike
How The Query Optimizer Works
 
01:58
http://bit.ly/1EJsBPK Code Above Is For Performance Tuning Course. Limited Number at this price.
Views: 3101 Mike
Emergency Repair
 
06:21
Using Emergency Repair on Corrupted Tran log
Views: 682 Mike
Using a Temporary Table
 
06:35
How to use a temp table
Views: 7426 Mike
Plan Cache Bloat
 
05:51
Plan Cache Bloat and Easy Button Fix
Views: 117 Mike
Code Snippets
 
04:15
Quick Look at Code Snippets in 2012
Views: 1086 Mike
tempdb is NOT recreated
 
04:23
Views: 89 Mike