24 Hours of Education

Azure, PASS
You absolutely need to learn more. I need to learn more (lots more). We all should be constantly learning more about our jobs, our businesses and the technology that makes it all happen. When presented with the opportunity, especially a free one, you should jump on it, with both feet. Here you go. Beginning at 12:00 GMT on the 31st of July you can attend the 24 Hours of PASS, for free. 24 Hours of PASS has been put on several years now in various forms. This year it's being put on as a "Summit Preview." What you're getting is 24 individual presentations by 24 different people on 24 different topics, all meant to whet your appetite for the PASS Summit. I'm quite privileged to get to take part this year.…
Read More

24 Hours of PASS, Fall 2012

PASS, SQL Server 2005, SQL Server 2008, Tools, TSQL
It's time to get your learn on again. The schedule for the Fall 24 Hours of PASS is up and ready for registration. This is the Summit preview session, so many (most, all) of the speakers are showing off some of what you can learn at their sessions at the PASS Summit 2012 itself. It looks like a pretty exciting bunch of topics given by some of the best professionals in the industry. I'll be presenting Three Ways to Identify Slow Running Queries on September 20th, 1400 GMT. This is just a sub-set of the information that I'll be presenting during my all day pre-conference seminar, Query Performance Tuning: Start to Finish. The full seminar I talk about how to measure the performance of your systems, identify which queries are…
Read More

Upcoming Presentations: #24HOP & #SQLSAT46

PASS
Blogging has been a bit quiet of late. That's because I've been spending a lot my spare time getting ready for presentations that I have to give. Two of them are in about two weeks. First, and this one is going to be a big deal, is 24 Hours of Pass: Summit Preview. At the PASS Summit this year I have two spotlight sessions, both on tricks and tools for tuning queries, one on using execution plans and the other on using DMVs. Since the 24HOP presentation is supposed to be a lead-in to the PASS presentations, I decided that before you started tuning queries, you need to know which queries to tune. The presentation is titled: Identifying Costly Queries. I understand there are already nearly 2000 people registered. Let's…
Read More

24 Hours of PASS: Summit Preview

PASS, SQL Server 2008, SQLServerPedia Syndication, TSQL
Registration is open for the second 24 Hours of PASS this year. This one is going to be a preview of the Summit itself. So all the sessions are tied, in some manner, to sessions being given at the summit.Here's a link to go and register. I'm very excited to be able to say that I'll be presenting in this 24HOP. One of my presentations at the Summit this year is Identifying and Fixing Performance Problems Using Execution Plans. It covers pretty much what it says, methods for fixing performance problems by exploring the information available within execution plans. But, how do you know you have a performance problem? That's where my preview session comes in. Identifying Costly Queries will show you several ways to gather metrics on your system so that you…
Read More

24 Hours of PASS v2.0

PASS, SQLServerPedia Syndication
The kids over at the Professional Association of SQL Server Users have done it again. They're hosting 24 Hours of PASS: Celebrating SQL Server 2008 R2. That's 24 hours of free training by top names in the business, providing you with the information you want and need. I'm not presenting this year (I may cry), but who cares. This is going to be a great chance to get some serious learning. I'm sure going to attend as many sessions as I can. First one that I've already got marked is Andy Leonard's on database development patterns. That's a topic that's near & dear to my heart. So follow the link, look the offerings over, and register right away.
Read More

LaRock on Monitoring

SQL Server 2005, SQL Server 2008, TSQL
Since I just spent a bit more than half of my 24 Hours of PASS presentation on tuning queries talking about monitoring performance, you could probably tell that I think that the two are inextricably linked. I'm not alone. Tom LaRock has put a post on why it's important to understand the extent of your problem prior to attempting to fix it. It's absolutely spot-on and a must read. Remember, if someone says performance on a system you manage is slow, you have to ask, as compared to what? You need to understand what "normal" performance is on your system in order to arrive at the ability to identify a particular process as performing in an abnormal manner. That's not to say that you couldn't tune a query in complete…
Read More

24 Hours of PASS

PASS, SQL Server 2005, SQL Server 2008, SQLServerPedia Syndication, TSQL
This was a pretty cool event. The advertising leading up to it seemed to really cover the community very well. There was even a link to 24 Hours of PASS in my team's local web site. Unfortunately, I'm not an iron man like Tom LaRock, watching all 24 hours. I only hit a few sessions. The first session I hit was Allen White's PowerShell for SQL Server. I have attended a couple of  his presentations at the PASS Summit. I think he's done a great job of gleaning better and better examples out of his presentations. This one was good. I loved the way he put together the backup processes for automating backups. It looked good, took into account common issues, it just worked. I was really happy I got…
Read More

24 Hours of PASS

PASS
Or, as you should tell your boss, 24 hours of free training by many of the leaders of the industry presenting original sessions that will teach you about topics from SSIS to Spatial Data to Index Selection to CLR performance to... well, you get the idea. This shouldn't be a hard sell for anyone to their boss. "Hey, remember that problem we had the other day with the database that was in simple recovery mode? Yeah, well, Kalen Delaney is presenting for an hour on just that topic." Your follow-up question to the boss, should then be, not, can I, but "Do you want me to get a meeting room and project this for everyone?" Developers, designers, architects, administrators, and managers are going to be able to find something interesting…
Read More

24 Hours of PASS

PASS, SQL Server 2008, SQLServerPedia Syndication
I'm fairly certain Jack Bauer isn't involved with this new initiative from PASS. Just as I'm also certain I won't be the only person to invoke 24 while referring to 24 Hours of PASS. But even without Jack Bauer, I'm on the edge of my seat. 24 different sessions by top names in the industry from all around the world. I wonder if I can do this without sleep? Probably not. I'll still being trying to attend as many of these as I can work in. I'm really looking forward to it.  People you want to hear are going to be there. Jessica Moss is going to talk about Reporting Services. Adam Machanic is going to introduce CLR. Gail Shaw will be presenting (at something like 2:oh my flipping god…
Read More