桃子视频

Categories
PASS Summit Syndication

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 (). 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 () 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 ! 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.

Categories
Events PASS Summit Syndication

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!

Categories
24 Hours of PASS Events Syndication

24 Hours of PASS Fall 2012

Do you like training? Do you like FREE training? Then make sure you check out the 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 of events:

Thursday, September 20, 2012

Session 01 (BIA) – Starts at

Presenter: ,

Session 02 (DBA) – Starts at

Presenters:

Session 03 (AppDev) – Starts at

Presenter:

Session 04 (AppDev) – Starts at

Presenter:

Session 05 (CLD) – Starts at

Presenter: ,

Session 06 (AppDev) – Starts at

Presenter:

Session 07 (AppDev) – Starts at

Presenter:

Session 08 (DBA) – Starts at

Presenters:

Session 09 (BID) – Starts at

Presenter:

Session 10 (BID) – Starts at

Presenter:

Session 11 (DBA) – Starts at

Presenters:

Session 12 (PD) – Starts at

Presenter:

Friday, September 21, 2012

Session 13 (BIA) – Starts at

Presenter:

Session 14 (DBA) – Starts at

Presenters:

Session 15 (BIA) – Starts at

Presenter: ,

Session 16 (AppDev) – Starts at

Presenter:

Session 17 (BIA) – Starts at

Presenter:

Session 18 (AppDev) – Starts at

Presenter:

Session 19 (BIA) – Starts at

Presenter:

Session 20 (AppDev) – Starts at

Presenter:

Session 21 (BIA) – Starts at

Presenter:

Session 22 (BID) – Starts at

Presenter:

Session 23 (CLD) – Starts at

Presenter:

Session 24 (PD) – Starts at

Presenter:

* Please be sure to check our 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.

Categories
24 Hours of PASS Presentation Syndication

STOP! Consolidate and Listen

I just wrapped up my 聽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!

Categories
Featured PASS Summit Syndication

OMG I’m an MVP!

I can鈥檛 believe it, but I can finally say that I鈥檓 now officially a ! Last week I got the great news from my MVP lead, Ryan Bolz () in鈥 peculiar way. Allow me to explain. Typically MVP renewals and new awardees are notified four times a year, once every quarter. This past quarter鈥檚 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. . Now I say I was disappointed since I knew I鈥檇 been nominated the last few quarters but hadn鈥檛 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 鈥渙h well, keep it up and eventually鈥aybe鈥. Anywho, last week as I was at the 聽when聽I got a DM from Ryan with the following: 鈥淗i 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鈥檛 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鈥檇 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鈥檛 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鈥檛 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鈥檚 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鈥檚 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鈥檒l be presenting for the first time at !聽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 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!

Categories
SQLRally Syndication

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 .

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 ( | ) 鈥 SSRS

Grant Fritchey ( | ) – Indexing/Performance Tuning

Adam Jorgensen ( | )- SSAS

Devin Knight ( | ) 鈥 SSIS

Andie Letourneau ( | ) – Women in Technology

Brian Moran ( | )- Professional Development

Jorge Segarra (Blog | ) – Administration

Ed Wilson ( | ) – PowerShell

Categories
SQLRally Syndication

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 !

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鈥檝e 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鈥檒l 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, 鈥淕o!鈥 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!
Categories
Business Intelligence SQLRally Syndication

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 (| )

Devin Knight (| )

Adam Jorgensen (| )

Patrick LeBlanc (| )

In this full-day workshop, you鈥檒l 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鈥檒l start with how to design and data model a data warehouse including the system preparation. Then, we鈥檒l jump into loading a data warehouse with SSIS. After SSIS, you鈥檙e 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 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!

Categories
Events Syndication

24 Hours of PASS: Day 1

Yesterday聽was the first day of PASS’ . 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, )! 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 . 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!

Categories
Events SQL Saturday

SQLSaturday #62: Tampa

We’re 10 short days away from 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 (| ) presenting Storage and Virtualization for the DBA.聽 For the BI focus We have Stacia Misner (| ) presenting a Day of BI. This price includes coffee, juice and donuts, lunch, and course materials. To 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 (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