Mike

Automate sp_whoisactive

How The Query Optimizer Works

Using Table Variable

Script Data and Schema in SQL Server

SQL Server Profiler in ONE Hour

Transaction Log Architecture

What Does SQL Server DO?

A Cost Based Optimizer

What is AWS?

How to Ace the SQL Server Technical Interview

What Are Logical Reads

Spinning Up SQL Server Inside AWS

Spinning Up Your First EC2 Instance

SSIS - Derived Column Transformation

Emergency Repair

websiteScribeHandBrakeFinal

Introduction to SciKit-Learn

Deadlocks With Xevents

DBCC LOGINFO

SQL Query Processor Process

BCP - SQL Azure

tempdb is NOT recreated

Seaborn

What is Tokenization in NLTK

Career Options

WhatAreWaitStats

Get Black Box... Your Applications Will Thank You

Azure Machine Learning: Binary Classification

What Do Min and Max Memory Control?

Write Ahead Logging

FileGroups

Anatomy of SciKit-Learn End to End Model - FREE COURSE

Automate sp_whoisactive

Truncating IS A LOGGED OPERATION

Simple Wait Stat Example

Tune the instance... not just one database

Attach SQL Database Without Log File

Dataming with Excel? Sort of.

An Introduction to Wait Statistics in SQL Server

Alternate Row Colors in Report

Simple Stored Procedure

Logging Into AWS Using Two Factor Authentication

Real World SQL Server Replication

Using a Temporary Table

Setting Up Transactional Replication

YouTube Intro

Code Snippets

tempdb spills and memory grants

Simple Case Statement

Moving SQL Server Logins

Contained Databases