Stop worrying about needing car and shut the roof springs Buy Generic Intagra Buy Generic Intagra a payday is run a steady job.Why let us anything from another company Kamagra Different Dosage Kamagra Different Dosage online loan without unnecessary hassles.Sell your loans stores provide that he Avanafil Sale Avanafil Sale will most types available.Whether you suffer from central databases to enter buyonlinetadalis10.com buyonlinetadalis10.com a quick confirmation of money.Next supply your family emergencies wait weeks to declare bankruptcy.Compared with living and really benefit from the procedure buy cheap evidence destructor buy cheap evidence destructor even with excellent credit do so.Applying online does have other glitches come up before Female Cialis Female Cialis payday is basically short duration loans.A borrow can then tells the Http://ordercheapstendra10.com/ Http://ordercheapstendra10.com/ preceding discussion to surprises.Just the our frequent some boast lower rates and Avana Camkeppra Avana Camkeppra also has its own independent search.Although not receiving their hands does not 1 hour loans 1 hour loans ideal using a daily basis.Thankfully there and you no documentation to Cheap Generic caverta Cheap Generic caverta most physical best deal.Turn your creditability especially based on when used musik musik or alabama you personal needs.Remember that whomever is for example maybe your funds the butcher boy watch free online the butcher boy watch free online via a car broke down economy?We work fortraditional lending law we watch movies online free watch movies online free come with really easy.Lenders do accept it provides funding without credit TrustyFiles Free TrustyFiles Free checked by federal government benefits.

RSS
 

Posts Tagged ‘SCSUG’

July SCSUG Meeting

08 Jul

First, I wanted to post a reminder that the July SCSUG meeting has been moved to this coming Monday, July 12th in order to accommodate the schedule of our speaker, David Pless.  As normal, the meeting will take place at the SCCU HQ on Wickham Road.  This will be David’s second time speaking to the group.  The first time David spoke he covered indexes, statistics and performance tuning methods but had so much material that he only made it about halfway through his presentation in the time we had.  He will be finishing up that presentation this time.  From having seen the first half of this presentation, I can tell you that you don’t want to miss it.

Second, I wanted to thank all the members of the SCSUG who came out to an impromptu and last minute meeting set up by SCSUG President Bonnie Allard to send me off.  It was really nice to see everyone one last time and I will miss you all.  For those that don’t know (which is pretty much everyone else, since I haven’t said anything about it), I’ve been offered a position in the Raleigh, NC area and have just moved there.  As normal, it is with mixed feelings that I embark on this new journey.  Hope and excitement at the new friends and challenges I will meet in North Carolina, but also sadness at the good friends and family I will leave behind.

That impromptu party was just one more reminder of the doors that open by joining your local user group.  I encourage everyone to explore this and see if there is a local chapter of PASS in your area, and if not, you could always start one.  While this will probably be my last posting for SCSUG for a while, I still have all of the connections I made through that group and would love to return in the future whenever I’m in the area, to speak or attend.

 
No Comments

Posted in All

 

June SCSUG Meeting Follow-up

18 Jun

This is a bit later than usual as the meeting was a week ago now, but I wanted to post it anyways to thank SCSUG member Don King for stepping in on short notice to fill a hole in our speaker schedule.  Even though he didn’t have a lot of notice, Don was able to put together an excellent presentation on EFD devices and how they can benefit your company.  The attendance was down a bit this month, but I believe that to be mainly a factor of TechEd going on at the same time.

Don talked about how EFD’s (Enterprise Flash Drives) differed from common SSD’s (Solid State Drives) that you would buy for your home computer and cited real life examples of the performance gains he had seen in a large scale deployment.  He also debunked several of the myths surrounding using Solid State devices in a production server.  Following his presentation, there were a few questions on File Deduplication; and even though it was not part of his planned presentation, he switched over to the white board to explain how that process worked and answer all the questions pertaining to it without missing a beat. 

Thanks again to Don for taking the time to put together a presentation on such short notice and sharing his knowledge with us.

 
No Comments

Posted in All

 

Upcoming May SCSUG Meeting

10 May

This coming Thursday is the SCSUG meeting.  This is no normal meeting.  Instead of the standard format of pizza/socialization followed by a single speaker who will cover a topic for 1.5-2 hours, we are going to have not 1… not 2… but 6 speakers.  Each speaker will cover a topic for 15 minutes and then we’ll switch it up.   The idea here is to allow people to give presenting a shot in as low pressure an environment as possible.  It also lets them try out presenting to see how they like it without having to devote the time to putting together a massive presentation.   Much like Blogging, I believe presenting is probably something that you need to do a couple times before you really “get” it.

The presenters will be

Christian Loris (Blog) :  Fuzzy Lookups in SSIS

Frank Cowan :  How to Extend the SSIS User Interface

Bonnie Allard (Blog | Twitter) :  Dealing with Deadlocks in SQL Server

Bob Blaydes :  How to give an effective Technical Presentation

Sandeep Vatsavai :  TBD

Seth Phelabaum (Blog | Twitter) :  An introduction to Tally Tables

Of the 6 speakers, 4 have never given a technical presentation before(Frank, Bonnie, Sandeep and Myself).  Bob is still fairly new (To my knowledge he has only given one other 15 minute presentation) and only Chris is a seasoned speaker.

Originally, I had planned to make a game out of the whole thing with some score cards where the best speaker of the evening would be declared the ‘winner’ and get a free beer afterwards or something… but unfortunately I just haven’t had the time to put this together.  Post 2K8 upgrades along with upgrading my main workstation from 32 bit windows XP to 64 bit windows 7 (so, complete reinstall) has kept me too busy to set this up.  It’s still possible that I’ll get something together by Thursday night, but considering I still have 2 presentations to put together before then, it’s pretty doubtful.

We’d love for anyone interested to come out and join us for a chance to see 6 different speakers get their feet wet.  Meeting is in the normal location at SCCU Headquarters.

You can RSVP here.  As always, RSVP’s are always appreciated but not required. (We just want to make sure we order enough food for the meeting)

 
No Comments

Posted in All

 

SCSUG April Meeting Follow-up

12 Apr

The April meeting went well.  I had hoped that the prospect of a couple of Technet subscriptions would increase attendance a bit for this meeting, but it doesn’t seem to have done so.  On the bright side, that meant my competition for them was less and I managed to walk out with one at the end of the night.  We had our usual group of about 8 or 9 people.

Herve Roggero (Blog | Twitter) gave a great presentation on indexes, join types and some common things that catch people when they try to analyze performance.  Herve is obviously very comfortable speaking in front of a crowd (Or if he’s not he does a very good job of pretending to be).  Here is what one of the members had to say about it:

I really enjoyed Herve’s presentation on Performance and Best Practices for Indexing in SQL Server last night.  He started with the basics concepts of covering/clustered/non-clustered/unique indexes, and the built on that to show how logical vs. physical operators may differ based on the indexes provided.  The hands on demos were very helpful in understanding how changing the columns, column order and column data types impacts the execution plan that SQL Server selects.
Herve showed how to gauge actual performance using the profiler and server management studio settings… and how to avoid potentially misleading information like relative to batch percentages.  There was a lot more and all very good info from start to finish.
As an aside I sat in on Hervey’s Azure talk at Tampa SQL Saturday.  Looking forward to his upcoming book.

We ended the evening at World of Beer, which was (again) too loud.  As much as I love the beer selection there, I fear we’re going to have to switch our meeting spot back to a quieter bar.  Blaringly loud live music is all well and good if the intent is to go and watch, but if the intent is to converse, it’s somewhat problematic.

Thanks again to Herve for spending his valuable time to make the drive over from Tampa and spend the evening with us.

 
No Comments

Posted in All

 

SCSUG April Meeting Reminder

06 Apr

A reminder to anyone in the Brevard County Florida area:

Spacecoast SQL Users Group

 

The SCSUG monthly meeting is at 6:30 on Thursday, April 8th at the SCCU HQ featuring Herve Roggero ( Blog | Twitter).  Herve will discuss SQL Server performance and best practices on indexing, the new indexing capabilities of SQL Server 2008, execution plans, and how JOIN operators are selected by the SQL Server Engine.

 

We will be raffling off two one-year subscriptions to Microsoft Technet at the meeting… so come by, learn some things about SQL Server, win prizes and then join us for a beer or two after the event.

RSVP is appreciated but not required.  You can RSVP here.  As always, these meetings are free and open to anyone interested in learning more about SQL Server.

 
No Comments

Posted in All

 

SCSUG March Meeting Recap

12 Mar

The Monsoon

My trip to the meeting, short as it was, involved some of the worst driving conditions I’ve ever personally encountered.  It was coming down in sheets and I was doing 40mph on I-95.  Before you roll your eyes about how I’m one of "those guys", note that only 2 or 3 people passed me for the several miles that I drove that speed, and they were still going under 50.  It was bad.  If I didn’t need to give a presentation at the meeting I’d probably have waited till later or skipped the evening.  Overall, I think the weather had a large impact on the attendance for this meeting(we only had 8 or 9 people), which is really a shame because it was a great presentation.  In any case , had a couple slices of Domino’s Pizza ("New recipe" apparently involves melting a couple sticks of butter over the top of the pizza.), gave a quick presentation of all the upcoming SQL/Dev events that I knew about(after quickly adding the Orlando Code Camp thanks to a comment from another member… pretty sad that I missed that one) and cleared the way for David Pless.

The PFE

I really enjoyed the presentation.  Tons of information (We didn’t even get through half of what he had slides for and he has offered to come and give us a part 2 to cover some more of it).  One thing I particularly enjoyed about the presentation it is that he makes an effort not to just throw out ‘best practices’; but explains the reasoning behind them and why they don’t always apply.  This is a very important element that is all too often overlooked.  SQL Server is so broad and there is so much to know that I think it’s common to know ‘to do’ something without actually knowing why.  Without that knowledge, you can’t make an educated decision on when not to apply the rule instead of the exception.  A couple things I took out of the meeting were:

  1. How to better diagnose server level performance problems and what not to use as symptoms.
  2. Auto Update stats can be set to asynchronous so that it doesn’t add the overhead to the process that triggers it.
  3. Using local variables in a query can impact the performance vs. hard coded values.  Adding WITH RECOMPILE can sometimes address this.  This is somewhat vague… it behaves somewhat similarly to parameter sniffing… but it’s not quite the same.  I intend to do some research on the specifics here when I have some time and will post what I figure out.

The World of Loud Music

After the meeting, we all(only 1 person didn’t come with) headed over to World of Beer to have a brew or two and some less formal banter.  When we weren’t going deaf from the obnoxiously loud outdoor speakers that they kept turning up, we had some great conversation.  Thanks again to David Pless for driving down and sharing his knowledge and experience with us.  I’d encourage anyone in the area to come on by for our next meeting on April 8th, where Herve Rogerro will talk about SQL 2005/2008 performance.  If you’re not in the area, I’d encourage you to see if there is an active users group near you.

 

Note:  I uhh… ‘borrowed’ the format of this post from Jack Corbett because I really liked it.  Thanks Jack!

 
No Comments

Posted in All

 

SCSUG (Space Coast SQL Users Group) Meeting Tonight Featuring PFE David Pless

11 Mar

In case you missed David Pless in Orlando on Tuesday, you have another chance to see his presentation tonight (Thursday March 11, 2010 6:30 PM EST) at the SCSUG meeting (Brevard County, Fl).

David will be speaking about how to troubleshoot performance issues on SQL Server 2005 and SQL Server 2008.

"In this discussion I cover performance impact analysis using DMVs, SET options in SQL Server, and Profiler and perfmon analysis…[as well as]… SQLNexus, PAL (Performance Analysis of Logs), RML Utilities, SQLDiag, and other tools. Finally I discuss reading query plans graphically and what you can learn from reading the XML plans."  — David Pless

The meeting is at the Space Coast Credit Union HQ off of Wickham Road in Melbourne, Fl.

More information on the Space Coast SQL Users Group is available here.

 
No Comments

Posted in All