6,108 reputation
1140
bio website meltondba.wordpress.com
location Montgomery, AL
age 35
visits member for 3 years, 7 months
seen 13 secs ago

soaking up everything I can about SQL Server and PowerShell.

Twitter

Google+

LinkedIn


1h
answered Avamar SQL Agent running against live SQL Server databases
14h
comment sql server grants access to specific login to database
In SQL Server "sa" is an account already created by default upon installation. SQL Server does not allow you create another login with the same name. Please clarify in your question.
15h
revised Changing compatibility level of database causes performance improvement of stored procedure
added 134 characters in body; edited title
15h
answered Changing compatibility level of database causes performance improvement of stored procedure
15h
comment Changing compatibility level of database causes performance improvement of stored procedure
To just clarify, is that forty clients or forty thousand clients?
23h
revised Break AG Cluster
added 5 characters in body
1d
reviewed Approve suggested edit on In PL/SQL what is the usage of row level and column level attributes?
1d
reviewed Approve suggested edit on 500GB Data Warehouse - how to split it into FileGroups?
2d
reviewed Approve suggested edit on Problem with a trigger (Oracle 11gR2)
Aug
22
reviewed Reject suggested edit on UOW's: Relating UOW's listed in MSDTC to SQL Server info
Aug
22
comment Slow SQL Server authentication, but fast SAN, fast querying?
You can find a decent list of wait type descriptions here.
Aug
22
comment Collect results of many sql server jobs
One thing I would be interested in is how you go about connecting to each server within the SSIS package [e.g. connect to table with list of servers and dynamically change OLE DB manager through expression variables]?
Aug
22
comment Please me an example of a database scope.
I sure hope this is a classroom project. Link found on first search on Google.
Aug
21
comment SSRS 2012 - Dynamically change value of textbox in report header
You might look at this blog post change value of textbox in report header. I don't know if it is exactly what you are trying but you can download the RDL file from the blog post as reference.
Aug
21
comment How do you pinpoint locations of data that is being fed to a SRS report.
Nope, not really.
Aug
20
answered Trying to filter msdb..sysjobs by job_id
Aug
20
revised My database is missing and disappeared after detaching it
added 291 characters in body
Aug
20
answered My database is missing and disappeared after detaching it
Aug
20
revised AlwaysOn FCI + HA Setup Question
edited tags
Aug
20
comment Is there a way to do a textual search through all stored procedures in a table?
@chollida just providing a link is not a proper etiquette for an answer on DBA.SE, hence just posting it as a comment.