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

Finding fields used in a Power BI report in PBIR format with Semantic Link Labs

By

Have you ever wondered where a certain field is used in a report? Or...

Adding Test data to msdb.sysjobhistory

By

One of our internal people was looking to test some process in (I assume)...

Microsoft Ignite Announcements Nov 2024

By

Announced at Microsoft Ignite last week were some new product features related to the...

Read the latest Blogs

Forums

Primary and Secondary Filegroup

By nshete

Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...

Import data from json file with special characters

By don075

I am using the following script to import data from a json file. This...

% processor Time in Activity monitor is greyed out

By IT researcher

When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...

Visit the forum

Question of the Day

The Hash Join II

Which of these inputs is the smaller input to a hash join?

See possible answers