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 ...
How Do I Spell #SQLFamily? #SQLNomz Of Course It’s time for Meme Monday again, and this month’s theme is #SQLFamily. One of the overwhelming themes of this year’s SQL PASS Summit was community. And that’s what most people mean when they talk about SQL family. When you talk about family, scope is important. There are…
Continue Reading »

Loading ...
SQL PASS Summit 2011: Session Files This past week was the SQL PASS Summit 2011 in Seattle, WA. I presented three sessions (regular session, lightning talk, panel discussion) plus ran a focus group on advanced certification and hosted a Birds of a Feather lunch table on disaster recovery. It was a busy, busy week. Below…
Continue Reading »

Loading ...