Twitter | Search | |
Andrew J. Kelly
SQL Server Consultant, Senior Technology Subject Matter Expert with B3 Group Inc.
4,237
Tweets
255
Following
1,881
Followers
Tweets
Andrew J. Kelly Jan 21
Replying to @GFritchey
I don't even want to try. Good luck with that
Reply Retweet Like
Andrew J. Kelly Jan 21
Replying to @GFritchey
Isn't that just another reason not to use extended events. :) :) :) :)
Reply Retweet Like
Andrew J. Kelly Jan 21
Replying to @GlennAlanBerry
It is. So if you are looking for something different then there you go.
Reply Retweet Like
Andrew J. Kelly Jan 21
Replying to @GlennAlanBerry
Have you done a Hef?
Reply Retweet Like
Andrew J. Kelly Jan 15
Replying to @ChrisHyde325
Good to hear. It's close enough that I can drive if chosen as a speaker so I will submit some sessions. Hope to see you there.
Reply Retweet Like
Andrew J. Kelly Jan 14
Replying to @GFritchey
You should have been a good dad and stood behind him
Reply Retweet Like
Andrew J. Kelly Jan 13
Replying to @GFritchey @way0utwest
Well the first time I was told I didn't do as much as the year before. Never knew each year I needed to do more than the last. Sounds like a pretty obtainable model I say. However this time I know I spent more time and effort than last year but still not enough.
Reply Retweet Like
Andrew J. Kelly Jan 13
Replying to @way0utwest
Just found out I was turned down again for MVP. Apparently I need a higher level of impact to the community. So sad that they can't see the amount of personal time and money I spend for the community. Never thought I would say this but I think they have lost their way these days.
Reply Retweet Like
Andrew J. Kelly Jan 13
Replying to @way0utwest @Kevin3NF
Yeah that is what I figured but I just wanted to make sure the venue hadn't changed from what I last heard. If I don't get selected to speak at Bit's I am on the fence about going so this write up was good timing. Thanks
Reply Retweet Like
Andrew J. Kelly Jan 13
Replying to @way0utwest
Hey Steve. PASS is in Houston this year unless you heard something I didn't
Reply Retweet Like
Andrew J. Kelly Jan 8
Replying to @SQLBek @timweigel and 2 others
Sounds like an Andy good time
Reply Retweet Like
Andrew J. Kelly Jan 4
Replying to @RHBTroglodyte
Maybe he should take up fireworks :)
Reply Retweet Like
Andrew J. Kelly Jan 3
Replying to @GlennAlanBerry
According to Google maps it's 12 hours and 36 minutes. Be there soon
Reply Retweet Like
Andrew J. Kelly Jan 3
Replying to @GlennAlanBerry
Do we get samples if we read the blog?
Reply Retweet Like
Andrew J. Kelly Jan 2
Replying to @way0utwest @Spid
I first assumed I would just use the db_id of _exec_sessions using @ but the schema binding of the UDF would not allow it. So far this appears to be working as expected.
Reply Retweet Like
Andrew J. Kelly Jan 2
Replying to @way0utwest
I am pretty sure the connection string will override the default db if the db specified in the connection string is valid. So that works for what I want.
Reply Retweet Like
Andrew J. Kelly Jan 2
Replying to @GunneyK
OK just FYI, it appears that ORIGINAL_DB_NAME() does the trick for the RG Classifier function. Sweet
Reply Retweet Like
Andrew J. Kelly Jan 2
Replying to @GunneyK
I found an example using ORIGINAL_DB_NAME() but according to the docs it is what was specified in the connection string. Does anyone know if this is works for the DEFAULT_DATABASE property of the LOGIN as well?
Reply Retweet Like
Andrew J. Kelly Jan 2
I want to check to see what the database context is for the Resource Group classifier udf but it wont allow a call to dm_exec_sessions. Any ideas how to do that so I can assign users to a RG by dbid?
Reply Retweet Like
Andrew J. Kelly Jan 2
Replying to @vickyharp
Didn't you wonder why it seemed you used more bandwidth each month than you thought?
Reply Retweet Like