Nebraska SQL from @DBA_ANDY
Archives: March 2016
Why I Love #SQLSaturday
PASS SQLSaturdays are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Whether you're attending a SQLSaturday or thinking about hosting your own, we think you'll find it's a…
0 comments, 454 reads
Posted in Nebraska SQL from @DBA_ANDY on 28 March 2016
Pulling Security Info
I had a query to use xp_logininfo to pull group membership chains - that is, DOMAIN\Andy has access, but not directly - DOMAIN\Andy has access because he is a member of DOMAIN\DBAGroup.…
0 comments, 1,416 reads
Posted in Nebraska SQL from @DBA_ANDY on 24 March 2016
Update Your Scripts!
As soon as he showed me the report I knew he had an outdated script.
Each new version of SQL Server introduces new wait types, often (but not always) related…
0 comments, 2,536 reads
Posted in Nebraska SQL from @DBA_ANDY on 9 March 2016
Another Source of Knowledge
The referenced link is http://www.ted.com/talks/celeste_headlee_10_ways_to_have_a_better_conversation.
I followed Jes's advice, paused the other items I was working on, and watched the talk. It…
0 comments, 1,792 reads
Posted in Nebraska SQL from @DBA_ANDY on 1 March 2016