Category Archives: Events

Upcoming Presentations

Just a quick note to let you know about a few upcoming presentations I’ll be doing. This week I’ll be presenting remotely for the Washington DC PASS User Group, PASSDC (event link). I’ll be presenting “Do More With Less: Consolidate and Virtualize“. Since all the stuff with Prism came up recently, and I’m presenting for a group in DC, I think I’ll be modifying my deck to have some “fun” with it. :-)

Next week I’ll also be presenting in person for the Tampa (Pinellas) SQL User Group (event link) where I’ll be presenting my “What is a BI DBA?” talk.

Also, I’m proud to say I’ll be presenting at this year’s PASS Summit conference in Charlotte! I’m honored to have secured a Spotlight (90-minute) session for the conference where I’ll be doing an extended version of “What is a BI DBA?” presentation.

Share

Speaking at PASS Summit 2013!

I’m happy to officially announce that I’ll be presenting at this year’s PASS Summit in Charlotte, NC! I’ll be presenting my talk “What is a BI DBA?” as a Spotlight Session (90 minutes). This is the second time I’ll have presented at the Summit and I’m honored and beyond excited to have a Spotlight Session so we can cover more material!

This year the conference runs from October 15-18. I hope to see you at the Summit this year! http://www.sqlpass.org/summit/2013/

Share

24 Hours of PASS Fall 2012

Do you like training? Do you like FREE training? Then make sure you check out the 24 Hours of PASS event that starts today at 12:00 GMT. If you miss the events of the day, no worries, the recordings will be up within a few weeks.

Check out the great schedule of events:

Thursday, September 20, 2012

Session 01 (BIA) – Starts at 12:00 GMT
Choosing the Right Reporting Platform
Presenter: Brian Knight, Devin Knight

Session 02 (DBA) – Starts at 13:00 GMT
Best Practices for Upgrading to SQL Server 2012
Presenters: Robert Davis

Session 03 (AppDev) – Starts at 14:00 GMT
Three Ways to Identify Slow Running Queries
Presenter: Grant Fritchey

Session 04 (AppDev) – Starts at 15:00 GMT
Fasten Your Seatbelt – Troubleshooting the Most Difficult SQL Server Problems
Presenter: Klaus Aschenbrenner

Session 05 (CLD) – Starts at 16:00 GMT
SQL Server Private Cloud != Azure
Presenter: Allan Hirt, Ben DeBow

Session 06 (AppDev) – Starts at 17:00 GMT
What are the Largest SQL Server Projects in the World?
Presenter: Kevin Cox

Session 07 (AppDev) – Starts at 18:00 GMT
Practical Demos of Text Mining and Data Mining using SQL Server 2012
Presenter: Mark Tabladillo

Session 08 (DBA) – Starts at 19:00 GMT
PowerShell 101 for the SQL Server DBA
Presenters: Allen White

Session 09 (BID) – Starts at 20:00 GMT
Mobile Business Intelligence
Presenter: Jen Underwood

Session 10 (BID) – Starts at 21:00 GMT
Slow MDX Queries: The Case of the Empty Tuples
Presenter: Stacia Misner

Session 11 (DBA) – Starts at 22:00 GMT
Using SQL Server 2012 Always On
Presenters: Denny Cherry

Session 12 (PD) – Starts at 23:00 GMT
Leadership – Winning Influence in IT Teams
Presenter: Kevin Kline

Friday, September 21, 2012

Session 13 (BIA) – Starts at 00:00 GMT
BI Architecture With SQL 2012 & SharePoint 2010
Presenter: Rod Colledge

Session 14 (DBA) – Starts at 01:00 GMT
DBCC, Statistics, and You
Presenters: Erin Stellato

Session 15 (BIA) – Starts at 02:00 GMT
SSIS Design Patterns for Fun and Profit
Presenter: Jessica Moss, Michelle Ufford

Session 16 (AppDev) – Starts at 03:00 GMT
Characteristics of a Great Relational Database
Presenter: Louis Davidson

Session 17 (BIA) – Starts at 04:00 GMT
What’s All the Buzz about Hadoop and Hive?
Presenter: Cindy Gross

Session 18 (AppDev) – Starts at 05:00 GMT
Taking SQL Server Into the Beyond Relational Realm
Presenter: Michael Rys

Session 19 (BIA) – Starts at 06:00 GMT
Agile Data Warehousing with SQL Server 2012
Presenter: Davide Mauri

Session 20 (AppDev) – Starts at 07:00 GMT
Digging Into the Plan Cache
Presenter: Jason Strate

Session 21 (BIA) – Starts at 08:00 GMT
Introduction to Microsoft’s Big Data Platform and Hadoop Primer
Presenter: Denny Lee

Session 22 (BID) – Starts at 09:00 GMT
Big Data Analytics with PowerPivot and Power View
Presenter: Peter Myers

Session 23 (CLD) – Starts at 10:00 GMT
Best Practices and Lessons Learned Using SSIS for Large Scale Azure Data Movement
Presenter: Steven Howard

Session 24 (PD) – Starts at 11:00 GMT
Mentoring for Professional Development
Presenter: Andy Warren

* Please be sure to check our time zone guide for exact times in your area. This 24 Hours of PASS event begins at 12:00 GMT on September 20 and runs for 24 consecutive hours.

Share

STOP! Consolidate and Listen

I just wrapped up my 24 Hours of PASS session on consolidation. A big THANK YOU again to everyone in attendance, who kindly put up with my horrendous rapping “skills”! As promised, below is the link to the slide deck. In the presenter’s notes you’ll find some good links and resources for consolidation.

Download link: STOP_Consolidate_and_Listen_24HOP (ZIP file)

If you have any additional questions around consolidation, virtualization or my general sanity feel free to leave them in the comments section below, thanks!

Share
The role of Willy Wonka played by The Community

OMG I’m an MVP!

I can’t believe it, but I can finally say that I’m now officially a Microsoft SQL Server MVP! Last week I got the great news from my MVP lead, Ryan Bolz (Twitter) in…a peculiar way. Allow me to explain. Typically MVP renewals and new awardees are notified four times a year, once every quarter. This past quarter’s notifications went out on July 1st. Like so many in the community, when the quarterly MVP day rolled around I was guilty of refreshing my inbox every 5 minutes for 24 hours hoping for that magic Wonka ticket into MVP-ville.

Felt a little something like this...

Alas, July 1st came and went with no email. Disappointed turtle was disappointed. Now I say I was disappointed since I knew I’d been nominated the last few quarters but hadn’t heard anything yet. And yes, I know “it’s the award you’re not supposed to want”, but still it’s stressful knowing you’re up for it but not hearing anything one way or the other. This time around I figured “oh well, keep it up and eventually…maybe”. Anywho, last week as I was at the JSSUG meeting when I got a DM from Ryan with the following: “Hi Jorge — Congratulations! You are a MVP. Call me so I can explain it all to you.”

Say WHAT?!? I checked and double checked the message to make sure it wasn’t some sort of sick prank. As soon as I got out of the meeting I gave Ryan a call to find out what was going on. I’d heard of folks getting awarded out of cycle before but I was still thoroughly confused as to what was going on! As it turns out, apparently I HAD been awarded MVP status in the July 1st batch but something went wrong with getting me the notification. For those not familiar with the process, Microsoft sends out the MVP emails en-masse to folks which seems to trip every spam filter around. Since this is the case, folks are told to check their spam folders on MVP day just in case. In my peculiar case it wasn’t a matter of spam filter black hole but rather an error in my contact information. Near as I can tell they had an invalid email address on file for me so they weren’t able to send me my notification!

Fast forward a few weeks and Ryan had gone on vacation and gotten sick during that period, when he finally got back to the office and catching up he somehow discovered that I had no idea I was awarded. That’s when he dug around and sent me a DM on Twitter as that was a guaranteed means of getting to me directly.

The Mushy Part

Story aside, I want to let you all know how truly grateful I am for this honor. It’s been a pleasure and privilege being a part of this amazing SQL community and this award just compels me to keep working even harder to deserve it. I want to thank everyone for the warm congrats and support, it means a LOT! I’d also like to send a special thank you to those who nominated me and sent me words of encouragement every quarter.

Speaking of working harder I got another piece of amazing news last week as well: I’ll be presenting for the first time at PASS Summit this year! What makes THAT even cooler is that the session is a Community Spotlight session, meaning you guys were gracious enough to cast your vote for me so I can bore educate the masses on Policy-Based Management at the Super Bowl/World Cup of SQL Server events! That being said thank you all so SO much for all your love and support and I look forward to continue serving this community for years to come!

Share

SQLRally Overdrive: Birds of a Feather Discussions Event

Just wanted to post a quick note/invitation to everyone to come join us on Thursday, May 12th from 5:45-7:00 for the SQLRally Overdrive: Birds of a Feather Discussions event.

We’ll have several tables, each with a dedicated expert in the field hosting conversations. Want to delve into some shop talk about PowerShell? Curious about how Analysis Services are being setup by other folks in the field? Care to swap architecture design ideas about SSIS with others? Well this is the place to do this and more! Here’s the list of folks who have graciously volunteered to host tables at this event:

Mike Davis (Blog | Twitter) – SSRS

Grant Fritchey (Blog | Twitter) – Indexing/Performance Tuning

Adam Jorgensen (Blog | Twitter)- SSAS

Devin Knight (Blog | Twitter) – SSIS

Andie Letourneau (Blog | Twitter) – Women in Technology

Brian Moran (Blog | Twitter)- Professional Development

Jorge Segarra (Blog | Twitter) – Administration

Ed Wilson (Blog | Twitter) – PowerShell

Share
SQLRally

SQLRally OverDrive Events!

So you’re going to SQLRally in Orlando next week? Want to take advantage of ALL of the awesome opportunities presented? In addition to all of the amazing training content you’ll see at the event itself, we’re holding some great stuff after-hours on Thursday. We’re calling this SQLRally OverDrive!

These are three different panel events being hosted by members of the SQL community. You have your choice of three cool events to choose from:

Birds of a Feather Discussions

Sit down with a group of people who are interested in the same SQL Server and BI topics as you are. Interested in SSIS? Gather with your peers to discuss the problems you’ve encountered and solved. Each table will be moderated by an expert in that area.

Conducting an Interview, Sponsored by OPASS

Conducting an interview can be intimidating and confusing. What makes a good interview? How do you differentiate candidates? This session will consist of 3 short interviews. After the interviews are complete, attendees will discuss how the interviews were conducted. Did the interviewers ask the right questions? Did the interviewers conduct themselves well? Which candidate would you hire and why? Quest SQL Server expert Kevin Kline will moderate the discussion.

Speed Networking, Sponsored by MagicPASS

Do you have trouble meeting people? Need help starting a conversation? Based on the speed-dating model, you’ll spend a few minutes with several different people with a set of pre-defined questions to ask and answer. Take the time to exchange business cards as well. When moderator Kendal Van Dyke says, “Go!” be ready to make some new contacts.

I’ll be hosting a table at the Birds of a Feather discussions so make sure to swing by and say ‘hi’ and we can talk shop. Just look for the tall guy with the rubber chicken on the table!
Share
Masters BIverse

Be the Master of your Data Warehouse Universe at SQLRally!

Do you have a data warehouse initiative in your current organization and looking for a way to learn how to properly build and support it? Would you like to learn how to do this straight from the Masters of the BIverse themselves? Well you’re in luck! Next month at SQLRally there’s going to be a great pre-conference session held by the following:

Mike Davis (Blog | Twitter)

Devin Knight (Blog | Twitter)

Adam Jorgensen (Blog | Twitter)

Patrick LeBlanc (Blog | Twitter)

In this full-day workshop, you’ll learn from the author team of Mike Davis, Adam Jorgensen, Devin Knight, and Patrick LeBlanc how to build a data warehouse for your company and support it with the Microsoft business intelligence platform. We’ll start with how to design and data model a data warehouse including the system preparation. Then, we’ll jump into loading a data warehouse with SSIS. After SSIS, you’re ready to roll the data up and provide the slice and dice reporting with SSAS. The team will walk through cube development and data enrichment with things like key performance indicators, which are essential for your future dashboards.  Lastly, we will cover how to report against the data warehouse with SSRS, including a primer in how to write MDX queries against the SSAS cube.

What you can expect to take away from this session:

  1. Practical knowledge of building a Dimensional Model
  2. Designing a simple ETL process using SSIS
  3. Designing a Cube
  4. Designing simple SSRS Reports
  5. Building an integrated process that fully leverages the entire MS BI stack to load a Data Warehouse.

You can register here and pre-con fee is $199 (which includes lunch). This is a great deal so what are you waiting for? Sign up today as slots are filling up fast! See you at SQLRally!

Share
24hop

24 Hours of PASS: Day 1

Yesterday was the first day of PASS’ 24 Hours of PASS event. For those not familiar, 24 Hours of PASS is an event that brings together 24 different presenters and they present on various topics on SQL Server ranging from performance tuning, internals to business intelligence and previews at vNext of SQL Server. This month’s event is quite special since March is Women’s History Month, PASS is celebrating it by having this event all delivered by women!

So far the event has been absolutely awesome and the awesomeness continues today with the last 12 hours of the event, starting at 8am EST. If you missed yesterday, don’t fret, all of the sessions are being recorded and will be available on the PASS website within a month. Yesterday’s sessions went well, we had some sessions that actually had over 750 attendees (or as Tom LaRock refers to it as, the Jetliner line)! There were a few surprises as well, such as in Isabel de la Barra’s session, where we were treated to a presentation in Spanish (and translated by moderator Jesus Gil). At first we thought it was going to be a big issue but it turns out that over 300 attendees stuck around for the session and feedback from the Twitter stream seemed positive.

Speaking of Twitter, if you wish to follow along with the event you can do so by following the event hash tag of #24HOP. We are also using #sqlpass as well as #passwit to help promote and discuss the event. Day one is in the book and day two is looking to be fantastic as well, see you in the sessions!

Share

SQLSaturday #62: Tampa

We’re 10 short days away from SQLSaturday #62 event and I just wanted to remind everyone about some of the amazing stuff that will be happening that weekend!

First off we have an incredible deal with a pre-con we call Day of Data. We have two all-day training options for you at the incredible price of $99 (after today 1/5, price jumps to $109)! For the DBAs we have Denny Cherry (Blog | Twitter) presenting Storage and Virtualization for the DBA.  For the BI focus We have Stacia Misner (Blog | Twitter) presenting a Day of BI. This price includes coffee, juice and donuts, lunch, and course materials. To register click here and make sure to share this with co-workers and your boss! I guarantee the ROI on this training will be off the charts!

As for the main event we have an AMAZING lineup of speakers for this free (yes, I said FREE) training event. Check out the schedule (time/rooms subject to change):

Cafeteria Room A Room B Room C
8:30
– 9:30
Introduction to SSIS Efficient Datawarehouse Design How SQL saved my Business Intelligence Platform DBA Repository Update 2010 Using SSIS and SSRS
9:45
– 10:45
SSIS Cafeteria DBA 101 Developing Date and Role-Playing Dimensions Implementing auditing in SQL Server
11:00
– 12:00
Cool Tricks to Pull from your SSIS Hat: Why I Use Stored Procedures Introduction to PowerPivot for Excel SQL Server Auditing 101
12:15
– 1:15
Accelerating BI Development with BI xPress
1:30
– 2:30
Do You Know the Data Flow? Zen and the Art of Writing SQL Query Indexing for performance Reporting Services 2008
2:45
– 3:45
SQL Smackdown: SSIS vs. PowerShell Page And Row Compression How, When, and Why SQL Server 2008 R2 Parallel Data Warehouse Revive the code: refactoring for performance
4:00
– 5:00
Iron Chef SQL Server Troubleshooting with the SQL Server 2008 DC & MDW Bad SQL SSIS and SSRS Better Together
More rooms below – keep scrolling
Room D Room E Room F Cantina
8:30
– 9:30
Why Learn PowerShell? Policy-Based Management in a Nutshell To click or to type, that is the question
9:45
– 10:45
SQL Server PowerShell Extensions (SQLPSX) Become a Bilingual DBA! Oracle for the SQL Server Sql Server Service Broker – An Overview
11:00
– 12:00
Windows PowerShell 2.0 Best Practices for DBA’s Introduction to Transactional Replication ITIL V3 for the Database Administrator
12:15
– 1:15
Lunch is served
1:30
– 2:30
You inherited a database Now What? MDX 201 Find Performance Problems by Reading the Waits WIT Discussion
2:45
– 3:45
Where should I be encrypting my data SQL Server Memory Deep Dive Spatial Data in SQL 2008 and Bing
4:00
– 5:00
DR Availability,You’re Wanted in the Recovery Room SSIS Data Flow Buffer Breakdown Creating a Metadata Mart w/ SSIS – Data


And I guess it’s worth mentioning I’ll be there presenting my Policy-Based Management in a Nutshell talk so if you come to the event swing by and say hi (even stay for my session if you’d like!). So grab yo kids, grab yo wife, grab yo coworkers and get to SQLSaturday cuz everyone’s learning up in there!*

*I apologize for the horrendous addition to an internet meme to my post

Share