Mike Byrd

Former rocket scientist and USAF Fighter Pilot -- now a SQL Server geek. Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and IT Director for Texas Windstorm Insurance Association (9 years), Currently senior database consultant for several companies. Presenter at many SQL Saturdays in US, Europe, and Australia. Ideal job is sproc and query performance tuning or TSQL instruction

Specialties
SQL Server performance tuning; database (OLTP & OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).

Video presentations (for local SQL Server user groups or SQL Saturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd

Looking only for part-time or short-time opportunities -- either performance tuning or TSQL training.
  • Interests: Water skiing, boating, tennis, Sudoku and KenKen puzzles

All authors

All authors

Blogs

T-SQL Tuesday #193 - Notes to Self

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

T-SQL Tuesday #193 – Notes to my past self and from my future self

By

It has been a while since my last T-SQL Tuesday blog. When I saw...

T-SQL Tuesday #193 – Notes to past and future me

By

The last T-SQL Tuesday of the year is hosted by my good friend Mike...

Read the latest Blogs

Forums

MAX_DISPATCH_LATENCY in extended event , is not clearly explained in msdn.

By rajemessage 14195

hi,   i have checked reducing it increasing it but could not get any...

What is the PRODUCT

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is the PRODUCT

Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...

Visit the forum

Question of the Day

What is the PRODUCT

In SQL Server 2025, what does this return? 

CREATE TABLE Numbers
( n INT)
GO
INSERT dbo.Numbers
(
n
)
VALUES
(1), (2), (3)
GO
SELECT PRODUCT(n)
FROM dbo.Numbers

See possible answers