Speaking at SQL PASS Summit 2014

I am honored to be selected to deliver 2 sessions at the SQL PASS Summit 2014. I will be delivering a half day session on administering BI systems and a regular session on techniques for indexing. If you were selected to speak this year, congratulations. I look forward to attending many of your sessions! If you like the “I’m Speaking” image I added to my blog, feel free to use it in your own blog or other materials. If you
read more

Schema-only Backups and Restores

I was reading the blog post Time for a Quick Rant by Grant Fritchey (blog|@GFritchey) about people who choose to not back up a database simply because it is large. I agree wholeheartedly with Grant on this topic. Simply choosing not to back up a database is, well to put it nicely, reckless. The comments that followed brought up some good points about some scenarios where you might choose to not back up a very large database. I performed operations
read more

Day 4 of 31 Days of Disaster Recovery: Back That Thang Up

Day 4 of 31 Days of Disaster Recovery: Back That Thang Up Here we are at day 4 in my series focusing on disaster recovery. It’s Friday, so this will be a quick one for today. I want to talk about the importance backing up everything that needs it and point out some of the often overlooked things that you should be backing up. If you missed any of the earlier posts in the series, you can check them out
read more

Using Dynamic Values in XMLA

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 run. I proposed a different solution, The Question The following request was sent in a series of tweets: Is there a way to pass variables
read more

T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs

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 to read more blogs participating in this month’s theme: Prox ‘n’ Funx. For my part in this month’s blog party, I’m going to write about
read more

SQL PASS Summit 2011: Session Files

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 are the slide decks and demo files for the three presentations I made. All of these files have been uploaded to the SQL PASS Summit
read more

Presentation Files: 10 Things All BI Administrators Should Know

Presentation Files: 10 Things All BI Administrators Should Know I was very excited to get to present to the Pensacola SQL Server User Group tonight. I lived in Pensacola for a few years when I was a kid. I have a lot of memories from Pensacola like dancing to disco music on the dance floor at the Big Bang 4th of July celebration at Pensacola Beach. I wrote my first and only fan letter to a celebrity (Valerie Bertinelli) and
read more