We’ve added two more bloggers to our syndicated SQLServerPedia blogroll:
Jason Massie of StatisticsIO.com
Known as StatisticsIO on Twitter, Jason not only blogs, but produces the Captain Varchar(MAX) and the Pagelatch Posse comic:
- Great Moments in DBA Interview History – my title for his interview comic.
- DMV query to find unused indexes – Jason’s contributed several cool queries like this to the T-SQL Code Library section on SQLServerPedia.
- Finding index scans caused by implicit conversions – say you join two tables together on a date field – but it’s not really a date field, because one table uses a varchar field for it. Jason explains how this can slow you down more than you think.
Jeremiah Peschka of Facility9.com
Jeremiah is Peschkaj on Twitter, and some of his recent blog entries include:
- Retrieve the top X random results from a query – you just use select top X, right? Not so fast – Jeremiah shows an exposure to SQL injection.
- Flexible database-level roles – security roles come up a lot in enterprise-level deployments. If you’re a DBA in a small shop, you may want to start learning about role-based security to help you grow your career.
- How I get by without sysadmin – working for Quest, this stuff comes up a LOT! People want to know how they can work with the least permissions possible because the security team keeps locking them down. Jeremiah talks about how he does it.
We’ve got a few more in the works – stay tuned! If you’re interested in signing up too, just drop us a line at ask@sqlserverpedia.com.
