SQL in the City San Francisco Videos

Posted on Dec 5, 2012 in SQL Server | 0 comments

Red Gate Software came to San Francisco on October 23rd, as part of their SQL in the City tour.  This was a one-day event, with speakers from the Red Gate team, along with a few local experts.

It was great to catch up with Grant Fritchey and Steve Jones, and to hear some excellent presentations. I also got to chat with Red Gate’s Chief Marketing Officer, John Theron, Ernest Hwang, Denny Cherry, and a lot of the Red Gate crew.

SQL in the City covered at lot of great info useful not only to SQL Server folks, but also to .NET professionals.  You can see all the SQL in the City videos here.  Thanks for dropping by San Francisco, Red Gate!

Adam Machanic on the ‘Ten Commandments of SQL Server Monitoring’

Read More

PowerPivot Delivers On Self Service BI Promise

Posted on Jul 26, 2011 in SQL Server | 0 comments

Peter Myers of SolidQ gave a great overview of SQL Server PowerPivot to the Bay Area Microsoft Business Intelligence User Group.  The timing was good because we haven’t had an in depth discussion of PowerPivot since the  group launched in April of 2010 in conjunction with the SQL Server 2008 R2 launch events.

About 20% of the attendees had used PowerPivot so far.  Peter gave a good overview, and then walked us through an example app, step by step, using a variety of data sources, including SQL Server and Excel.  He’s a great speaker (and very fast typist!), and we learned a lot.

The timing of this meeting was ideal for me.  I had just met that afternoon with a client about how they pull data from spreadsheets, line of business applications, and other sources. Their process is tedious, labor intensive, prone to error, and needs to be repeated weekly.  I could clearly see how we could solve their problems with PowerPivot and easily distribute the information across their global organization via Access Services and their SharePoint 2010 portal.  Thanks again for a great talk, Peter!

Microsoft SQL Server PowerPivot

View more presentations from Mark Ginnebaugh

Read More

SQL Saturday #73 in Orange County

Posted on Apr 14, 2011 in SQL Server | 0 comments

Last Saturday I headed down to “the OC” for SQL Saturday #73 in Huntington Beach, California.  The main organizer was Andrew Karcher, and the participating PASS Chapters were Los Angeles, Orange County, and San Diego.SQLSaturday SQL Saturday #73 in Orange County

It was a terrific meeting.  Here’s what I was able learn and do:

•    Represent and evangelize PASS and meet more PASS Chapter Leaders and members.
•    Talk to the organizers to learn how they pulled it all together.
•    Observe how a SQL Saturday actually runs – the venue, logistics, number of organizers and volunteers required, speaker evaluations, giveaways, and door prizes.
•    Meet as many speakers, sponsors, and attendees as possible.

And of course I wanted to learn more about SQL Server.

•    Clint Kunz of Microsoft gave a very high level talk on the current state of Microsoft’s Business Intelligence efforts.  Other speakers would be presenting the details in later sessions.
•    I then heard Rob Kerr of BlueGranite speak on delivering BI solutions with SQL Server and SharePoint.  I really enjoyed his practical examples.
•    Ted Tasker of Microsoft gave a really good intro to Microsoft’s Parallel Data Warehouse (AKA PDW, Project Madison).  This was great information about a very exciting project.  PDW is big, powerful, and pretty expensive, but is a bargain compared to competing products from Terradata and others.  I had a great talk with Ted afterward.
•    The Women in Technology Virtual Chapter had a great panel on the theme “Encouraging the Next Generation.”  Kudos to Denise McInerney, Meredith Ryan Smith, Lynn Langit, and Diana Dee.
•    Clint Kunz talked about the Largest SQL Server Projects in the World.  Very interesting!
•    Harold Wong is a hoot!  He gave a talk on virtualization basics that was really useful, and at the same time, very entertaining.map1 SQL Saturday #73 in Orange County
•    The last session I attended was with Bret Stateham on SQL Server Reporting Services Map Visualizations.  I enjoyed the interesting examples that Bret walked us through, step by step.

We closed out the event with a drawing for some great raffle prizes, and adjourned to Michael’s Sports Bar for food and drinks.

Congratulations to everyone who worked so hard to put on this great event!

Read More