7,862 reputation
21650
bio website meltondba.wordpress.com
location Montgomery, AL
age 36
visits member for 4 years, 2 months
seen 14 hours ago

Database Consultant @ Pythian. Love working with SQL Server and automating anything with PowerShell, SSIS, or T-SQL.

You can find me online:

Twitter
LinkedIn

profile for Shawn Melton on Stack Exchange, a network of free, community-driven Q&A sites


Mar
14
accepted SSIS Event Handler at Package Level
Mar
14
awarded  Notable Question
Mar
10
comment Poorly Performing Query - SQL Server Best Practices
You might also check with the vendor (Idera). Generally they offer a certain amount of time in tech support to assist with some initial setup like this, worth asking.
Feb
28
comment Can't connect to SQL Server
What port is the service set for? Can you telnet to that port from the source server? You have a default instance so all you should have to supply is the IP.
Feb
26
answered One SQL Server. One SSIS. Two versions of DTExec.exe?
Feb
23
comment Restore master database from SQL Server 2008 R2 on SQL Server 2012
@DMason documentation that spells it out completely, this is Microsoft we are talking about. It is just something that is known. You can reproduce this on most any version of SQL Server that I know of by restoring an older version of master, no matter what you call it.
Feb
16
comment List Active Directory Users
Now if you did that just to get the list results, that is not the purpose of using this method. If you are being asked to just pull in the user list of any random AD group use PowerShell.
Feb
16
answered List Active Directory Users
Feb
16
revised List Active Directory Users
code formatting, spelling corrections, removed "thanks" and simplified the two questions on the end.
Feb
13
comment SQL Server 2012 Installation failing on Windows 8.1
I have basic, no pro edition.
Feb
13
comment SQL Server 2012 Installation failing on Windows 8.1
I installed on it with no issues, used to have 2014 installed as well. If you go into Control Panel (viewing it by small icons) and User Accounts, do you see "Administrator" under your account?
Feb
12
comment Looking to find a way to determine replicated objects from subscriber
Might check this answer on SO
Feb
12
revised Looking to find a way to determine replicated objects from subscriber
format code
Feb
12
revised Looking to find a way to determine replicated objects from subscriber
format code
Feb
11
awarded  Notable Question
Feb
7
comment SSIS Package fails to “Transform File and create output file”
You may need to check the permissions on the folder itself, not just the shared permissions. It will need access through both places in Windows.
Feb
2
comment Export SQL Agent jobs with steps and scripts
Yeah, export from SSMS either to file or copy/paste is not going to format into Excel correctly. It is more likely they handled friendly formatting for that information outside of SQL Server.
Feb
1
comment Is there an easy way to update connection strings to a database moved to a different instance
This is an overall design decision to me, and just an opinion. How you configure or point your application to any database instance can be done various ways. I have seen it done a few different ways but doesn't mean it is an acceptable answer over what someone else may have seen or done.
Jan
31
comment Return List of Database Users and Server Logins
When you say "database" are you referring to the accounts default database or all databases they have access to?
Jan
31
comment Return List of Database Users and Server Logins
Is this something you want to collect for historical purposes, documentation, just a one-time thing? What have you tried so far or looked at doing?