Skip to main content
Database Administrators
mpag's user avatar
mpag's user avatar
mpag's user avatar
mpag
  • Member for 10 years, 1 month
  • Last seen this week
Profile Activity
Stats
968
reputation
511k
reached
23
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.
7
silver badges
23
bronze badges
Top tags
View all tags
16
Score
14
Posts
41
Posts %
11
Score
3
Posts
9
Posts %
8
Score
13
Posts
38
Posts %
6
Score
3
Posts
9
Posts %
4
Score
3
Posts
9
Posts %
3
Score
4
Posts
12
Posts %
Top posts
View all questions and answers
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
34
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