Database Administrators
Michael Green's user avatar
Michael Green's user avatar
Michael Green's user avatar
Michael Green
  • Member for 9 years, 8 months
  • Last seen this week
  • Melbourne, Australia
Profile Activity
Stats
24,708
reputation
2.1m
reached
839
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
51
silver badges
95
bronze badges
Top tags
View all tags
862
Score
389
Posts
45
Posts %
493
Score
220
Posts
25
Posts %
174
Score
76
Posts
9
Posts %
148
Score
88
Posts
10
Posts %
115
Score
51
Posts
6
Posts %
95
Score
45
Posts
5
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
47
Not using foreign key constraints in real practice. Is it OK?
Mar 30, 2017
answer
34
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
Does an excessive table violate normalization rules?
Oct 7, 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
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
16
Merge two SELECT queries with different WHERE clauses
Apr 19, 2014
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 to delete large data of table in SQL without log?
9
How does SQLDataReader handle really large queries?
7
Faith in an extrapolated result
7
How is one or more aggregate function implemented in most SQL engines?
6
Sql Server Identity column -> values get reused?

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.