Down the Rabbit Hole
Category:
career
You often don’t realize you’ve gone too far until it’s too late.
kendra little
What Do You Call a Group of Experts?
Category:
database-administration
, career
What’s an expert?
A variety of definitions of “expert” get tossed around – a specialist, someone with comprehensive knowledge, the person who knows more about a topic than anyone else within six feet. Many people go the way of the Supreme Court and say they know an expert when they see it.
SQLPeople events
Category:
database-administration
Not too long ago, Andy Leonard (blog|twitter) dreamed up the idea to create the SQLPeople community. The community is forming around the stories and ideas of its members. The SQLPeople website shares stories.
Using APPLY for calculations
Category:
tsql-programming
Here’s a little TSQL snack. I picked this up in a presentation by Itzik Ben-Gan at the PNWSQL user group recently, and it’s become a fast favorite.
Dynamic Management Quickie: Explore SQL Server system views and functions as you work
Category:
database-administration
There’s a lot of dynamic management and system objects to keep track of in SQL Server. We all sometimes have the moment when we can’t remember exactly which DMV, DMF or other system view/function returns a particular column, or if something even IS accessible from the system objects.
Be My Date Next Tuesday, March 15 at 24 Hours of PASS
Category:
database-administration
Next week the Professional Association for SQL Server will be providing 24 hours of free, online training on SQL Server.
Come get your learn on.
Dirty Pages and Statistics IO
Category:
query-performance
Warning: The DROPCLEANBUFFERS command referenced in this post is appropriate for test systems only and impacts the entire SQL Instance. If you are new to SQL Server, please use this commands with care, and be careful to read the linked Books Online documentation. Happy testing!