[Shameless Plug] Can We Have Your Vote?

SQL PASS SQLRally
Argenis Fernandez (|@DBArgenis) and yours truly have submitted a Pre-Conference for SQL Rally 2012 in Dallas, TX called “Demystifying Database Administration Best Practices”. We think it’s going to be an epic session with just loads and loads of tips and best practices on multiple aspects of Database Administration, from Windows/AD setup to Daily Operations to Code Reviews.
While our session wasn’t chosen by the committee in the first round, it made it to the community voting round – so this post is to kindly ask for your vote. We promise we’ll deliver great content! Argenis and I have combined over 25+ years of experience. I am an MCM, and Argenis is halfway there (he actually will take a shot at the MCM lab Thursday, February 9, 2012).
Please vote here:
http://www.sqlpass.org/sqlrally/2012/dallas/UserLogin.aspx?returnurl=/sqlrally/2012/dallas/CommunityChoice.aspx
If you haven’t become a member of PASS yet (You haven’t? What are you waiting for?) It’s free, go sign up now here:
http://www.sqlpass.org/RegisterforSQLPASS.aspx
And even if you do not feel that our session would be the best choice, please vote and make your voice heard. Do your part in keeping our community strong.

Loading ...
Breaking Down TempDB Contention (part 2) I wrote a somewhat popular script and blog post a while back called Breaking Down TempDB Contention. This post explains how to identify tempdb contention. This past Friday, Jonathan Kehayias (blog|@SQLPoolboy) contacted me about the script. Jonathan said that he thought the math was off just a little bit…
Continue Reading »

Loading ...
The Kind of DBA I Want to Be I was a big fan of the original Iron Chef tv show, as in the original show from Japan. And my favorite Iron Chef was Iron Chef Japanese Rokusaburo Michiba. If you don’t know the show, it probably seems redundant to refer to a Japanese chef on…
Continue Reading »

Loading ...
Including Missing Values in Data Ranges Without a Lookup Table One of the ways that I learn new things is by helping others with their issues or questions. In my career, this has served me well by exposing me to a vast array of experiences that I may not have otherwise seen. I try to…
Continue Reading »

Loading ...
Webcast: Putting a Better SQL Server in Production Webcast: Putting a Better SQL Server in Production Date: Wednesday, January 18, 2012 3:00 PM to 4:00 PM Eastern Time / 2:00 PM CT / 12:00 PM PT Problems come up everyday that could have been avoided by simply configuring SQL Server appropriately before using it. The…
Continue Reading »

Loading ...
Using Dynamic Values in XMLA A question was raised on Twitter today via the #sqlhelp hash tag about passing parameter values to XMLA for a backup script. The popular answer at the time I saw it was to dynamiclly create and drop a SQL job to run the script every time you need it to…
Continue Reading »

Loading ...
Undocumented Gotchas of Transactional Replication This discussion started on Twitter via the #sqlhelp hash tag. The question that was asked is, “What are the undocumented gotchas of Transactional Replication? #SQLHelp”. I responded with several things that came to mind. I thought these would be good to capture in a blog post and hopefully others would…
Continue Reading »

Loading ...
PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses Subject: Row Versioned Data Warehouses Start Time: Thursday, December 15, 2011 6:00 PM US Pacific Time (December 16, 2011 2:00 AM GMT) End Time: Thursday, December 15, 2011 7:00 PM US Pacific Time (December 16, 2011 3:00 AM GMT) Presenter: Jeremy Huppatz (Blog|@OzzieMedes) Live Meeting Link: https://www.livemeeting.com/cc/UserGroups/join?id=B77TSH&role=attend&pw=dGC-%3B88%275…
Continue Reading »

Loading ...
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong? Subject: On beyond Zebra AdventureWorks or where did I go wrong? Level: 200 (Intermediate) Start Time: Thursday, November 17, 2011 8:00 PM US Eastern Time (November 18, 2011 1:00 AM GMT) End Time: Thursday, November 17, 2011 9:00 PM US…
Continue Reading »

Loading ...
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs This blog entry is participating in T-SQL Tuesday #024, hosted this month by Brad Schulz (Blog). You are invited to visit his blog to join the blog party. You are welcome to write your own participating blog post for the party or just…
Continue Reading »

Loading ...