As of May 31, 2023, we have updated our Code of Conduct.
Database Administrators
mpag's user avatar
mpag's user avatar
mpag's user avatar
mpag
  • Member for 8 years, 6 months
  • Last seen this week
Profile Activity
Stats
968
reputation
454k
reached
22
answers
11
questions
Communities
View all
About

I administer two SQL Server 2008 R2 databases on a single Microsoft Server 2008 R2 server. I've also created some associated MS Access databases for offline "field" use. Additionally, an interfacing website on a second server is in development, using tSQL stored procedures to query the databases on the first server indicated previously.

Other programming projects in R are in-the-works. Previous programming includes contributions to BioEdit and Ferion. Please also see my GitHub repository.

Badges
View all badges
This user doesn’t have any gold badges yet.
6
silver badges
23
bronze badges
Top tags
View all tags
16
Score
14
Posts
42
Posts %
11
Score
2
Posts
6
Posts %
8
Score
13
Posts
39
Posts %
6
Score
3
Posts
9
Posts %
5
Score
2
Posts
6
Posts %
4
Score
3
Posts
9
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
question
21
Access (Jet) SQL: DateTime stamps in TableB flanking each DateTime stamp in TableA
Sep 30, 2015
answer
9
Get multiple columns from a select subquery
Oct 1, 2015
question
7
Lead/Lag Implementation in SQL Server 2008 R2: Max memory exceeded
Dec 11, 2015
answer
5
Lead/Lag Implementation in SQL Server 2008 R2: Max memory exceeded
Dec 17, 2015
question
3
SSMS: Import from flat file (.csv)
Feb 9, 2016
question
3
tSQL Stored Procedure with CTE; CASE statement in WHERE slowing run
Aug 27, 2016
question
3
T-SQL: CSV->table pipeline with custom parsed numeric data, lookup values
Oct 23, 2017
question
3
multi-condition left join conditions in MS access
Jul 18, 2018
answer
3
How to select multiple columns but only group by one?
Jan 14, 2016
answer
3
Using TOP in INSERT INTO statement
Jul 1, 2016
Top Meta posts
3
2
8
Should I have posted at CodeReview instead?
4
canned responses for "leave a comment"
Top network posts
View all network posts
33
permission error when installing ttf-mscorefonts-installer/Can't drop privileges as file couldn't be accessed by user '_apt'
11
.NET System Type to SqlDbType
8
How to create an empty datatable with columns names and then append datatables to it?
6
How do I fix the errors listed in this CheckSUR.log file?
5
Retrieve list of indexes in an Access database

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.