6,481 reputation
11143
bio website meltondba.wordpress.com
location Montgomery, AL
age 35
visits member for 3 years, 9 months
seen 41 mins ago

soaking up everything I can about SQL Server and PowerShell.

Twitter

Google+

LinkedIn


1d
comment What should I monitor on the SQL Server machine?
With regards to licensing for Remote Desktop, why are they allowing remote desktop connections? I would block this ability if I was allowed to because there is no reason to do that anymore unless I am patching or have a VERY specific reason and those would not require any more licenses that are available out of the box.
1d
comment What should I monitor on the SQL Server machine?
Mainstream support for Window Server 2008 R2 ends January 13, 2015. The last service pack released for Window Server 2008 R2 was in what 2010 I think. They are not going to release another one now that Window Server 2012 R2 is in full swing.
1d
comment What should I monitor on the SQL Server machine?
Understand possible restrictions but one bit of advise: Don't put a version of SQL Server on a OS version that will be out of support before SQL Server will be.
1d
comment Does a database backup reduce size/increase free space of the log file?
This may be more semantics but log file growth is not dependent necessarily on recovery model because a database in simple can still see log growth. The recovery model is more telling SQL Server how you want it to manage log file space.
Oct
20
reviewed Close Explicit transactions for each DML query are necessary or not?
Oct
20
reviewed Close Running more than one copy operations in IBM Datastage in a single job
Oct
20
reviewed Close In which situations is TokuDB higher performance?
Oct
20
reviewed Close DB Model for Small requiremnt
Oct
20
reviewed Close ASM configuration in linux
Oct
18
awarded  Fanatic
Oct
16
comment sqlsrv_connect: use Windows authentication?
You configure that within your site in IIS and believe it is the identity configured for the application pool.
Oct
16
answered sqlsrv_connect: use Windows authentication?
Oct
16
comment Is it possible to trace the password the application is attempting to use to connect?
There is a method to do this on the OS side that I have not heard Microsoft ever closed but I would not consider it an option.
Oct
16
reviewed Approve suggested edit on 'Prioritize' one column over another
Oct
16
comment How do I login to SQL Server via group membership in another domain
Not authoritative but some additional info
Oct
16
revised How to query a list of all the different errors?
just reformatted main query to make it more eye friendly.
Oct
16
reviewed Close HTML Form: Insert id into related table
Oct
16
reviewed Close to pivot or not to pivot - schema design question
Oct
16
reviewed Close Microsoft Active Directory and Oracle? Net Manager tns-04411
Oct
16
reviewed Close SQL Server, Mount Points and File Groups design