Subscribe to this blog
Nebraska SQL from @DBA_ANDY
I’m a forty-something Microsoft SQL Server DBA of 15+ years, a devoted husband, and a father of three young boys. I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a remote DBA with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.
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, 408 reads
Posted in Nebraska SQL from @DBA_ANDY on 28 March 2016
Pulling Security Info
A frequent request I receive is to pull a list of logins/users with certain accesses, role memberships, etc.
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,378 reads
Posted in Nebraska SQL from @DBA_ANDY on 24 March 2016
Update Your Scripts!
I had an incident today where a colleague was running a Wait Stats Report and the output looked like this:
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…
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,443 reads
Posted in Nebraska SQL from @DBA_ANDY on 9 March 2016
Another Source of Knowledge
It started with a tweet from one the many members of the #sqlfamily who always has something meaningful to say, Jes Borland (blog/@grrl_geek):
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…
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,746 reads
Posted in Nebraska SQL from @DBA_ANDY on 1 March 2016