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, 3 months
  • Last seen this week
  • Melbourne, Australia
Profile Activity
Stats
24,948
reputation
2.2m
reached
841
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
870
Score
391
Posts
45
Posts %
500
Score
220
Posts
25
Posts %
177
Score
77
Posts
9
Posts %
150
Score
88
Posts
10
Posts %
118
Score
51
Posts
6
Posts %
98
Score
32
Posts
4
Posts %
Top posts
View all questions and answers
52
Not using foreign key constraints in real practice. Is it OK?
Mar 30, 2017
35
Why would SELECT * be magnitudes faster than SELECT foo?
Jul 27, 2014
29
Does it save anything to use a smaller varchar or nvarchar size instead of some large value like 4000?
Feb 12, 2022
23
Implementation and contraindications for OPTIMIZE_FOR_SEQUENTIAL_KEY
Jul 1, 2019
19
What is the benefit of indexing assuming that SQL server has huge memory to accomodate the entire database in memory?
Sep 1, 2022
19
Does an excessive table violate normalization rules?
Oct 7, 2019
18
Merge two SELECT queries with different WHERE clauses
Apr 19, 2014
18
Memory Optimized Tables - can they really be so difficult to maintain?
Sep 1, 2014
18
Business logic in stored proc vs middle layer (c#)
Jun 15, 2016
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?