Reputation
27,419
Next tag badge:
364/400 score
84/80 answers
Badges
5 48 90
Impact
~1.2m people reached

Jan
14
answered Get last full backup and transaction log backup for each database
Jan
14
answered When does SQL Server determine to use a new index?
Jan
13
comment Script Rename of SQL Server Database and Database Files
That could quite easily be automated through PowerShell. Using SMO, the SQL work is concise and straightforward, and then the rename of the database files is a one-liner.
Jan
13
revised Script Rename of SQL Server Database and Database Files
edited tags
Jan
9
revised How do you run T-SQL commands on multiple servers from one place?
edited title
Jan
9
comment How do you run T-SQL commands on multiple servers from one place?
What does your script specifically do? That may allow us to get more specific with a recommendation.
Jan
9
answered How do you run T-SQL commands on multiple servers from one place?
Jan
9
comment Database size after importing the .sql file
There is absolutely no way to determine that. If the .sql file is 34.5 GB of comments then you'd have no problem :-) What is in the SQL file? (this comment is assuming SQL Server)
Jan
8
comment How can I filter an extended event by database in SQL Server 2008 R2
@JackDouglas That's awesome :-)
Jan
8
revised How can I filter an extended event by database in SQL Server 2008 R2
added 17 characters in body
Jan
8
comment How can I filter an extended event by database in SQL Server 2008 R2
@JustinDearing Honestly, all I do is just hard code the database ID and then put a comment right next to it with the database name so my future-me knows what I intended without having to resolve it. It has worked for me with no issues.
Jan
8
comment How can I filter an extended event by database in SQL Server 2008 R2
@ShawnMelton No, I'm saying the package is spelled "sqlserver" not "sqlsever". Also, there is no database_name action in 2008 R2.
Jan
8
answered How can I filter an extended event by database in SQL Server 2008 R2
Jan
8
comment How can I filter an extended event by database in SQL Server 2008 R2
You have a typo. Should be "sqlserver.database_name".
Jan
8
answered Getting ApplicationName (sqlserver.client_app_name) to show up in an xevent
Jan
7
comment Getting ApplicationName (sqlserver.client_app_name) to show up in an xevent
You could also just try changing your event session target with a different file name. My guess is that would work for you too and be equally as effective.
Jan
7
comment Getting ApplicationName (sqlserver.client_app_name) to show up in an xevent
There is no way (outside of xp_cmdshell, of course).
Jan
7
comment Getting ApplicationName (sqlserver.client_app_name) to show up in an xevent
Did you add that action after the fact? With the event file I have seen it where the GUI doesn't show new columnar data when you add columns (actions or fields). I.e. start session, stop session, add action, start session - don't see it show in the GUI. Either query the target, or move the old XEL files. That has worked for me in the past.
Jan
7
comment AlwaysOn Availability Groups go to Resolving status
If the replicas can't talk to each other over the database mirroring endpoint then that would be a cause for this issue. Check the connectivity between the two servers' DB mirroring endpoints (permissions, etc.). Therein lies your problem, most likely.
Jan
7
comment AlwaysOn Availability Groups go to Resolving status
Do the AGs recover from the resolving status or do they stay in resolving? Look in the error log of SQL Server to find out during the time of the changing state. Also take a look in the alwayson_health XE session data during this time.