7,221 reputation
21349
bio website meltondba.wordpress.com
location Montgomery, AL
age 35
visits member for 3 years, 11 months
seen 1 hour ago

soaking up everything I can about SQL Server and PowerShell.

Twitter

Google+

LinkedIn


11h
comment Identify unattached File Size in SQL Server
Nothing for me to look into as I don't get that error. Inspect what XML is being populated or returned from the PowerShell command.
1d
answered Identify unattached File Size in SQL Server
1d
comment Exclude a User From an Audit
SQL Server Audits use Extended Events in some fashion, just setup a session with the audit actions and filter the user you want to exclude.
1d
reviewed Close Automating SQL Server Merge Replication Processes
1d
revised attach/detach v.s. backup/restore
edited tags
1d
revised Help understanding SQL Server 2005 execution plan
edited tags
1d
revised Is there a performance hit by breaking out tables into different schemas in SQL Server?
edited tags
1d
revised Using IF in T-SQL weakens or breaks execution plan caching?
edited tags
1d
revised Howto use Windows Authentication with SQL Server 2008 Express on a workgroup network?
edited tags
2d
comment How to identify unused databases on my sql server
Yeah, things like SSMS refreshing the drop list for database names can make it increment the value for the Xevent session.
2d
comment How to identify unused databases on my sql server
I have used this from Jonathan Kehayias that utilizes Extended Events: Tracking SQL Server Database Usage. It works fairly well as a guide.
2d
revised Visualizing SQL Server Extended Events data
added 8 characters in body
2d
comment Restored database is missing user
If it does not appear in the list then the user does not exist in the database being restored. Could verify in the original database. I generally see SharePoint accounts created with sysadmin privileges so it might not be a user in the database for production.
2d
comment Restored database is missing user
Are you in the context of the user database when executing sys.database_principals query? Same goes for the sp_change_users_login.
2d
revised Restored database is missing user
added 6 characters in body
Dec
18
reviewed Close GROUP BY Returning Different Totals
Dec
18
reviewed Close How to Shift a column up in a ring buffer?
Dec
18
reviewed Close Phantom vs. Non-repeatable read
Dec
18
reviewed Leave Open Backup Database Task - What's the number at the end of the filename?
Dec
18
reviewed Close problem in connecting SQL Server for internet access