Skip to main content
Database Administrators
Michael Green's user avatar
Michael Green's user avatar
Michael Green's user avatar
Michael Green
  • Member for 10 years, 5 months
  • Last seen this week
  • Melbourne, Australia
Profile Activity
Stats
25,003
reputation
2.2m
reached
843
answers
25
questions
Communities
View all
About

I am an experienced data architect, having worked in database application development for over 25 years. I have worked with SQL Server, Oracle, DB2, MySQL and NoSQL products. My teams have been both large and small, in consultancies, independent software vendors and multi-nationals’ in-house departments. Additionally I have good understanding of the middle tier and UI development. I find the breadth of my experience to be a great benefit, affording me a system-wide understanding of application development.

Badges
View all badges
13
gold badges
53
silver badges
98
bronze badges
Top tags
View all tags
872
Score
392
Posts
45
Posts %
500
Score
220
Posts
25
Posts %
177
Score
77
Posts
9
Posts %
151
Score
89
Posts
10
Posts %
118
Score
51
Posts
6
Posts %
98
Score
32
Posts
4
Posts %
Top posts
View all questions and answers
answer
52
Not using foreign key constraints in real practice. Is it OK?
Mar 30, 2017
answer
35
Why would SELECT * be magnitudes faster than SELECT foo?
Jul 27, 2014
answer
29
Does it save anything to use a smaller varchar or nvarchar size instead of some large value like 4000?
Feb 12, 2022
question
23
Implementation and contraindications for OPTIMIZE_FOR_SEQUENTIAL_KEY
Jul 1, 2019
answer
19
What is the benefit of indexing assuming that SQL server has huge memory to accomodate the entire database in memory?
Sep 1, 2022
answer
19
Does an excessive table violate normalization rules?
Oct 7, 2019
answer
18
Merge two SELECT queries with different WHERE clauses
Apr 19, 2014
answer
18
Memory Optimized Tables - can they really be so difficult to maintain?
Sep 1, 2014
answer
18
Business logic in stored proc vs middle layer (c#)
Jun 15, 2016
answer
15
What is the effect of having an opened transaction in MSSQL for too long?
Jun 27, 2016
Top Meta posts
3
14
17
Are two answers by a single person on one question A Good Thing™?
13
Should hyper link domain be in the body of the text
10
Should hyper link domain be in the body of the text
8
Comment of OP fundamental to question
6
Split the "master" tag?
Top network posts
View all network posts
10
How does SQLDataReader handle really large queries?
10
How to delete large data of table in SQL without log?
7
How is one or more aggregate function implemented in most SQL engines?
7
Faith in an extrapolated result
6
Sql Server Identity column -> values get reused?