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

soaking up everything I can about SQL Server and PowerShell.

Twitter

Google+

LinkedIn


2h
revised Way to test alerts for backups?
edited tags
5h
comment What permissions do I need to grant on service accounts on SQL root path when relocating?
To improve the answer a bit, you might add reference, if it applies, to the specific section of that MSDN article that pointed you in the right direction; or you could update your link to include the bookmark of the section like this: http://msdn.microsoft.com/en-us/library/ms143504.aspx#Serv_Perm.
5h
revised What permissions do I need to grant on service accounts on SQL root path when relocating?
breaking out statements to make it a bit easier to follow, minor changes to use of words/abbreviations; added tag for version
1d
comment Why is Excel File Opened Exclusively By Another?
You might give process monitor a try to see what has it. You can filter by file name or path.
1d
reviewed Approve suggested edit on Database design: 4 types of users but have different functionality , separate or one table?
1d
awarded  Popular Question
2d
comment How to determine the size of my tables in the SQL Server database
This answer on SO has a script that is pretty simple and does not require undocumented procedure.
2d
reviewed Approve suggested edit on SET IDENTITY_INSERT inside INSTEAD OF INSERT trigger not working
Oct
28
awarded  sql-server-2008
Oct
27
comment How to enable windows authentication on server that is not part of domain
@user38729 That is something to speak with your AD administrators about. Terminal Services access (RDP) is something that is controlled by AD Group Policies. The default domain policy will be applied to the server when it is first added to the domain. Generally most AD administrators are going to place a server into an OU (e.g. like folder) that will have additional group policies to modify access. You will need to speak with them on what policy they have and what you need.
Oct
27
answered How to enable windows authentication on server that is not part of domain
Oct
25
comment SQLCMD.exe in SQL Server 2012 does not give real-time output logging
And what result do you get using Invoke-Sqlcmd?
Oct
24
comment Effects of renaming FC and using its original name for AG network name
Rename a SQL Server Failover Cluster since you have default instances, renaming to MainSQL-NY you would no longer reference MainSQL.
Oct
24
awarded  Excavator
Oct
24
revised How το find last time database was accessed and the inventory of all application and users accessing it?
formatting
Oct
22
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.
Oct
22
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.
Oct
22
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.
Oct
21
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?