Search results matching tag 'sql saturday'

SQL Saturday #220 (Atlanta): Demos

Adam Machanic — Sat, 18 May 2013 18:33:00 GMT

Today at SQL Saturday #220 in Atlanta I presented a new brand new session, "SQL Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance Headaches."

This session is designed to help people quickly analyze query plans and find likely culprits without being query tuning experts; I find that in a huge number of cases the root cause of problems is one of just a few potential situations.

Thanks to everyone who joined me today for the deliveries! In addition to it being a new session this was also the first time that I've ever been asked to present the same session twice in a single day. So it was quite an experience.

The demo script is attached. As always, let me know if you have any questions or comments.

Enjoy!

Speaking about Relational DB Design the next two weeks (Knoxville, then Atlanta)

drsql — Mon, 06 May 2013 01:57:54 GMT

On Friday, May 10 I will be speaking for the Knoxville SQL Server User Group, and on May 18, I will be speaking at SQL Saturday in Atlanta. Both days, my session is my old chestnut “Database Design Fundamentals”. It is my favorite session to do because of two things. 1. I love to talk about database design 2. No demos :). The abstract is:

In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently).

It is a session that I haven’t done in short form since PASS 2011, and submitting this as a session was one of my resolutions this year, because it is truly my favorite regular session (my second favorite session is the precon version, because we get to spend a good amount of time on the subject.)

Additionally, at SQL Saturday Atlanta, I will be doing a lunch session for Red-Gate called: What Counts For a DBA: Observant. It is a session that is 33% professional development, 33% about where to find info about your server, 33% about monitoring your server and 11% demo of the SQL Monitor (and a lack of math skills is part of the show.) This is not the normal advertisement session, I wrote it myself, but is intended to be useful to anyone immediately without buying their tools, and to show you how Red-Gate’s tools can assist in observing your server’s behavior

Weekend reading – Data Explorer, Quandl, Flatmerge and a SQL Saturday app

jamiet — Sat, 09 Mar 2013 18:30:04 GMT

Here are some things that have piqued my interest on the interwebs over the last few days.

Parameterized queries and Security in Data Explorer

Chris Webb put a post up on the Data Explorer forum asking about parameterizing queries in Data Explorer and Miguel Llopis from the Data Explorer product team replied with some useful information:

…there is some risk for users to leak information to external sources when doing this, and so we try to prevent this from being done "by default". You can disable this level of protection by clicking the "Fast Combine" button in the Data Explorer ribbon tab. More information about Fast Combine and Privacy Levels can be found in our Help contents: http://office.microsoft.com/en-us/excel-help/privacy-levels-HA104009800.aspx

Following Miguel’s link shows this information:

So, default behaviour in Data Explorer is that the user is protected from inadvertently leaking information to 3rd parties. Its good to know that security has been prevalent thinking within the Data Explorer team however users do need to be aware that this behaviour exists, hence my mentioning it here.

Quandl – a search engine for datasets

I have stumbled across a site called Quandl that looks interesting, it bills itself as “Intelligent search for numerical data”. Essentially this is a search engine for finding datasets on the web which should be a useful resource in the emerging world of self service BI.

I’m writing this on a train so as an example I used Quandl to search for data on UK train journeys and first result was Train movements : 1000 Train-kilometre : Passenger trains : United Kingdom:

Here we have some raw data pertaining to train movements in the UK from 2004 to 2011. Quandl provides a chart of the data, a link to the source and an indication of the age of the data. It also enables us to download the data and provides Excel, CSV, JSON & XML as choices of data format.

An interesting idea indeed, Quandl is in its infancy though I shall be keeping a watching brief to see if it turns out to be a success or not.

Publish your own datasets with Flatmerge

The aforementioned Chris Webb put me onto this one. Flatmerge is a startup from Michigan, US that enables one to publish their data for public consumption:

With the FlatMerge data storage platform it's easy to share data in the cloud and use it in other applications. Just upload data and let FlatMerge discover it's actual data types and make the data and metadata available in JSON or XML format through (OData) URL queries.

Flatmerge are using OData-compliant URI query formats and they tell me that OData output is coming soon:

We currently support some OData queries. Data/Meta is returned in plain JSON or XML. OData output is coming soon!

That Flatmerge chose to use OData to publish their data is interesting – I’ve long suspected that greater OData adoption wouldn’t be far away once Excel natively supported it as an external data source and Flatmerge have realised the value in doing this. Flatmerge enables one to publish data to the web, Quandl helps people find data on the web – perhaps these two should go out for coffee sometime

SQL Saturday app for Windows Phone

Michael Wells has built a Windows Phone app for SQL Saturday (particularly pertinent for me at the moment as I am on my way home form SQL Saturday 194).

It provides data about each event, including the all important schedule information.

I have slightly mixed feelings about this. On the one hand its fantastic to see a community member voluntarily build a great FREE resource for the SQL community – massive credit to Michael for doing this. On the other hand it highlights one of my pet peeves about the current app culture that is prevalent on smartphones – this is an app that you can only use if you have a certain type of phone. The information presented here is valuable and given away for free, why is it hidden behind a gated app store? Should there not be a SQL Saturday website that is optimised for and viewable on any mobile web browser? Better still, its the schedule data here that is most valuable so why not publish that data in a format that allows one to view that schedule in one’s phone/PC/tablet calendar regardless of the type of device they are using? That data format, by the way, is iCalendar which is something that regular readers are probably fed up of me banging on about.

I hope that doesn’t detract from Michael’s great efforts here; his app is fulfilling an important need, I just happen to think its a shame that that need even exists when there are mechanisms already in place for delivering this data to us in a more efficient matter. On the other hand its hard to argue with the ease at which apps deliver information to us so perhaps I should just quietly climb down off of my soapbox! Comments are welcome!

@Jamiet

More Fun in Atlanta: Parallelism at SQL Saturday 220

Adam Machanic — Mon, 25 Feb 2013 19:25:00 GMT

May 18, SQL Saturday returns yet again to the Atlanta area. At this point I've become a bit of a regular at Atlanta's events; this will be my third one in a row. The team that puts them together is amazing, and produces top quality, super fun and educational days every time. Plus: Taco Mac.

Friday, May 17, the event is running a few pre-conference seminars, and I'll be delivering one focused on parallelism in SQL Server. This is an updated version of the seminar I delivered at the 2010 PASS conference; you can read Kendra Little's review of that day on her personal blog, littlekendra.com.

To get full information on the Atlanta seminar, visit the EventBrite page for the event: http://surfmulticore.eventbrite.com/

Any questions? Let me know in the comment section.

Hope to see you there!

Itzik Ben-Gan in Atlanta: May 13-17

Adam Machanic — Tue, 05 Feb 2013 21:10:00 GMT

This year Data Education is offering a few more classes with Itzik Ben-Gan, the world's foremost T-SQL instructor.

Our first offering has just been announced: Atlanta, May 13-17.

Neither Itzik nor his class needs much introduction, but click through for a full outline and other details.

We think that Atlanta is a great city, with an amazingly vibrant SQL Server community. Hope you'll be able to join us there!

By the way: if you're joining the class stick around town for a SQL Saturday event that is taking place, coincidentally, on May 18.

[New England] SQL Saturday #203: April 5-6, Cambridge MA

Adam Machanic — Tue, 29 Jan 2013 16:10:00 GMT

SQL Saturday returns to the Boston area this April, with what is certain to be an exceptional speaker and session lineup. (The actual schedule will be posted soon, but in the meantime you can see the submitted sessions.)

The free event ($10 if you'd like to eat lunch) will take place on Saturday, April 6. Highly recommended for anyone in the area who is interested in bettering your database skills!

Friday, April 5, as a lead in to the Saturday event, I'll be delivering my popular full-day "No More Guessing!" seminar. This seminar teaches a solid, proven performance troubleshooting methodology designed to help you quickly find the actual root cause of performance problems. Full information is available on the registration site.

This seminar has sold out at events like PASS Summit and SQLBits, and it is being offered in Boston at the discounted price, so book early to avoid disappointment.

Huge thanks to Mike Hillwig for taking the lead on putting together this event. Looking forward to seeing many of you there!

Portfolio changeover time for the PASS board

rob_farley — Fri, 28 Dec 2012 05:13:33 GMT

The last PASS board meeting for the year has happened, and the portfolio handovers are well under way.

Sadly, having new board members elected means having existing board members step down, and this last board meeting was the last one for both Allen Kinsel (@sqlinsaneo) and Kendal van Dyke (@sqldba). In 2012, these guys had the portfolios of local chapters and SQL Saturdays, respectively.

Newly elected board member Wendy Pastrick (@wendy_dance) is taking over from Allen on local chapters, while I’m taking over SQL Saturdays from Kendal. In 2012, my portfolio was 24 Hours of PASS, which is being rolled into the Virtual Chapters portfolio, headed still by Denise McInerney (@denisemc06).

I have to admit that I’m really excited that the 24HOP portfolio is being merged with Virtual Chapters, as the two are so linked. I had been on the 24HOP committee before I joined the PASS board, and had recommended that the two portfolios be merged around the time I was elected to the board. During my term I even recruited Virtual Chapter leaders to be on the committee for 24HOP, as I believe their experience in the online experience makes them best suited to influence PASS’ premier online event – the semi-annual 24HOP.

2012 was a good year for 24HOP, although it was the riskiest for some time as well.

Two of the more obvious changes that we made were to look at a new platform, and to return to the 24-hours straight format (rather than two 12-hour blocks). This more continuous format meant that numbers dropped (the largest audience is in the US, so any sessions that are overnight for the US are obviously going to have smaller attendance). However, this format meant we reached over 100 different countries, which I think was really significant. Comparing the first 2012 event with the first 2011 event (which used the 2x12 format), we jumped from reaching 54 countries in 2011 to 104 in 2012.

While I was still on the committee, we had discussed the need for a new platform, as the LiveMeeting platform wasn’t coping well with the numbers we were seeing. A number of options had been considered, some too expensive, some not capable of scaling sufficiently, and a decision had been made to use a platform called IBTalk. It was obviously more expensive than LiveMeeting (which had been available for free), but looked like it was going to scale much more nicely. We used it for both 2012 events and it will also be used for the next event (on Jan 30). The decision to use IBTalk was very risky, but as an experiment it seemed to work okay. There were both good and bad elements of the platform, which I’m not going to go into in a forum like this, although the second event that we used IBTalk for ended up being much smoother than the first, and I anticipate that the Jan30 event will be event smoother still.

I felt like the first event of 2012 was dominated by the new platform. It was held two weeks after the SQL Server 2012 launch, which had also been a large virtual event using a new platform. I guess experimenting with new platforms was a large topic of discussion that month. One thing that didn’t really work for us was the closed captioning. It turns out that when you have someone providing closed captioning live, any typos that come through, or anything that is misheard by the person providing the service, etc… well, it doesn’t always work for being able to feed a translation service. We tried, and it was good to try – but it didn’t work so well. Despite all that, PASS members can view the session recordings at http://www.sqlpass.org/24hours/spring2012/Home.aspx

The main 24HOP event in the second half of the year was the annual Summit Preview event. We didn’t try to pursue the closed captioning again, but we did continue with IBTalk. Going back to LiveMeeting was never going to be an option for us, and we wanted to take a second look at the platform, in light of the various things we’d learned from the experience in Q1. It was a better experience from a number of perspectives, and we certainly got to test the scalability.

Over the course of the day, we had good numbers – only a handful shy of 10,000 attendees across the course of the day (okay, a handful if you count fingers, toes, and were inbred – we had 9979). The lowest attendances were around the 100 mark, but the largest reached 1421 attendees. The highest from any previous events was around the 800 mark, so this was a significant improvement – and the platform handled it just fine. If we’d had that many people trying to access the LiveMeeting platform it simply wouldn’t’ve coped, and the IBTalk platform deserves praise for that.

The platform decision isn’t over yet. A new search has taken place in light of what we’ve learned in the past year, and including a lot of what people have expressed to us on platforms such as Twitter. There are platforms that are way out of our price range (it can be very expensive to present 10,000 man-hours of content using some platforms), and there are ones that won’t cope with some of the things we would like to do. With some of the Virtual Chapters growing fast, a new platform needs to be able to cope with them too, with a wide variety of attendances needing to be handled. I wish Denise all the best for that, and have been able to happily assure her that the PASS HQ team that does most of the work behind the scenes for 24HOP (particularly Jane and Vicki) is excellent and will make her look brilliant this year.

Another change in 2012 was the sponsorship story. For a long time, Dell had been a major sponsor of 24HOP, and I want to thank them for that. However, 24HOP wasn’t a priority for them in 2012, and new sponsors needed to be found. The first event saw sponsorship come in from Microsoft, SQL Sentry and Idera, with Idera being replaced by RSSBus for the second event. But what really excited me was to see a second tier of sponsors join the fray, with Melissa Data and Confio joining Idera as ‘Alliance Sponsors’. It was really good to have six fantastic companies sponsoring the event, and providing extra options for them.

I haven’t even mentioned the non-English events that have taken place! PASS has seen 24HOP events in Russian, Portuguese and Spanish this year, although my personal involvement with those events have been somewhat less. Again, the PASS HQ staff have been great in enabling these events, and helping them run smoothly.

So I leave 24HOP in capable hands.

Instead, I pick up the SQL Saturday portfolio – another fast-growing facet of PASS. Already the 200th SQL Saturday event has been scheduled, and I’m finding myself getting onto a moving train. Luckily, I won’t be battling anyone on the roof Bond-style, but there are a lot of things that will need attention to make sure that the SQL Saturday model can continue to be successful.

The PASS HQ staff most responsible for the SQL Saturdays that happen all around the world are Karla and Niko. If you’ve ever met either of these two, you’ll know that they run quickly and are nothing if not achievers. I suspect that I could just tell them to keep doing their thing and the portfolio would be considered successful. This is incredibly useful to me, because I should be able to focus on identifying and solving some of the things that might need to change as these events become larger in both size and number. I’m keen to look into some of the edge cases, such as international events (including non-English), and both the larger and smaller events that are around – but all the time trying to serve Niko, Karla and all the community leaders in what they do.

@rob_farley

SQL Saturday #146 : Nashua, NH

AaronBertrand — Sun, 21 Oct 2012 01:35:00 GMT

Today was SQL Saturday #146, put on by Mike Walsh, Jack Corbett, and a host of other volunteers and organizers.
Scott and I missed the speaker dinner last night, but we headed up from Rhode Island at 6:00 AM and made a good day of it. We had lots of great conversations with both existing friends and potential customers.

After lunch I participated in a panel discussion with Joey D'Antoni and Andrew Kelly, led my Mike. We basically talked about various things DBAs are responsible for - and ultimately take the blame when they don't work. My favorite part of the discussion was around backups, and how you shouldn't have a backup plan, but a recovery plan. Meaning - essentially - don't bother taking backups unless you've tested that they can be restored successfully.

I had the last session of the day against some tough competition. About 35 people attended, but I don't like the last time slot because there are almost always conversations that extend past the end time. In a lot of cases it's ok to cut into someone's lunch or networking time if they want to stay longer, but you absolutely cannot cut into raffle time. Anyway, the feedback was fantastic - it's amazing how much feedback you can solicit when you offer up a raffle prize like a free license to SQL Sentry Plan Explorer PRO. :-) Also have to love a write-in vote for speaker expertise (and no I don't think this was a bribe):

You can download the slide deck and samples from my session here.

Kudos to Mike et. al. for a great event!

Recap - SQL Saturday 151 in Orlando

KKline — Tue, 02 Oct 2012 14:19:00 GMT

It's always a feel-good experience for me to return to SQL Saturday in Orlando, the place where SQL Saturdays were started by Andy Warren (Twitter | Blog). On this trip, I delivered a full-day, pre-conference seminar on Troubleshooting and Performance Tuning SQL Server. I also delivered a session on SQL Server Internals and Architecture to a totally packed house. For those of you who emailed me directly, here's the link for the special SQL Sentry offer.

I got to attend the extended events session by Jack Corbett (Twitter | Blog), middle in the photo above. Good stuff, Jack! Jack led the Orlando PASS Chapter for a few years and, although he relocated back up to New England, he enjoys getting back to Orlando when the opportunity presents itself.

I also got a chance to do a podcast with Rodney Landrum (Twitter | Blog), in the SQL Saturday chef's outfit on the right. Rodney, you should get your blog details up at the PASS SQL blogger page, btw. Rodney is also known as "the guy with the Red-Gate tatoo". Ask him why, when you meet him in person. I'll post the direct link to our podcast when I get it from Rodney. But in the meantime, be sure to check out his SQLBeat webcast. There are lots of great speakers and respected authorities to hear on his podcast.

As I mellow with age, I've found that I most enjoy connecting with friends and building relationships. The above picture shows me, Eddie Weurch (Twitter | Blog), and Pam Shaw (Twitter), head of the Tampa PASS Chapter. Pam, Eddie, and I were swapping some hilarious stories about our early years in snowy climates. Pam had the good fortune to be pulled, face first, through the snow by her mom during a trip to the school bus stop on the first big snow of the season. Mom, it seems, wanted to make sure she got to the bus stop safely, but instead fell down two steps from the front door of their home, sliding all the way to the bus stop firmly clutching Pam's hand. ROFL!

I got to spend some time with Ryan Adams (left) and Kendal Van Dyke (right), as well. There may have been some liquor involved. However, the highlight of my evening was definitely when Kendal yelled "FINALLY!" at the waitress bringing our plates out ten minutes after the appetizers were served. Kendal was actually paying no attention to the waitress or the plates and was instead yelling at the TV where the Florida State vs South Florida football game was playing. The waitress, on the other hand, was mortified. Hilarity ensued as he tried to explain that he was not the least bit cross with her. :^)

Ryan is going to be presenting at the upcoming spring 2013 SQLCruise event. You should definitely attend! Ryan Adams has lot more content here (Twitter | Blog). Kendal, by the way, is a standing member of the current PASS Board of Directors. He's written some excellent content and, just recently, moved to Upsearch consultancy where my friend Allen White (Twitter | Blog) works. Kendal Van Dyke has more content here (Twitter | Blog).

I hope you're planning to attend a SQL Saturday event soon. And not just the event, but also the after-event gatherings as well. You can almost always be sure that most of the speakers will be there. It's a great way to enlarge your professional network as well as to make real and lasting friendships!

Enjoy,

-Kev

-Follow me on Twitter

SQL Saturday #156 : Providence, RI

AaronBertrand — Sun, 16 Sep 2012 03:09:00 GMT

Well, East Greenwich, RI. Another successful event, this one put on by John Miner, Brandon Leach, Steve Simon, Scott Abrants and a host of other folks. Several #SQLFamily friends in attendance as well: Grant Fritchey, Mike Walsh, Jack Corbett, Wayne Sheffield and others. I gave a session in the morning and then a session to cap off the day. Thanks to everyone who attended! The downloads are here:

T-SQL : Bad Habits & Best Practices

The Ins & Outs of Contained Databases