Presenting at SQL Saturday in Madison and Chicago

This week I am back in Madison, where I  will be presenting my newest  session on “How to baseline IO performance for your next SQL Server”  at  SQL Saturday #287 March 29, 2014. My next engagement will be in Addison for SQL Saturday #291 Chicago on April 26 2014 

Madison has a new location at 6000 American Parkway, Building A, Madison, WI 53783

There are 3 great Full day in-depth training sessions with respected SQL Server professionals on Friday , March 28  at  Globe University Madison East. Click a link for more information and registration!

Source: http://www.goodfreephotos.com

Chicago SQL Saturday  will be at the same great location  DeVry University Addison 1221 N Swift Road, Addison, IL 60101

There will be also 2 great full day in-depth training sessions with respected SQL Server professionals on Friday , April 25 2014. Click a link for more information and registration!

Better Performance Through Parallelism with Adam Machanic
Virtualization for SQL Server DBAs  with David Klee

Source: J. Crocker

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. 

Hope to see you there!

Speaking a PASS Summit 2013 in Charlotte, NC

Speaking at the PASS Summit last year was  the highlight of my career. I was picked to present a single regular session and  I got some good feedback.

This year I’m thrilled  to announce that I’ll be speaking for the second time in a row at PASS Summit 2013 in Charlotte, NC

I’ll be presenting my favorite  and most popular deck ,“Anatomy of a join” as a Regular Session.

I am extremely honored to be selected to speak a PASS Summit 2013, the greatest SQL Server conference of the year where I will join more than  150 of the industry’s leading speakers while having the unique chance to meet over 5000 database professionals from 57 countries. I would like to thank the PASS  Program Committee and Speaker review team for their support and for selecting my session for the second time .

I hope to see you in October at the PASS Summit and hope you can make it to my session or just come by and say hi at one of the other events.

Presenting session: Anatomy of a Join at SQL Saturday #242 in Indianapolis

I’m thrilled to announce that I will be presenting for the third time at SQL Saturday in Indianapolis my Internals session “Anatomy of a Join” on Saturday August 10, 2013

source: Tripadvisor

Location is:
Indiana Wesleyan University North
3777 Priority Way South Drive, Indianapolis, IN 46240

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.
If you are attending please stop by and introduce yourself. Also if you are on Twitter don’t forget to use hashtag #sqlsat242 and see what others are doing.

Hope to see you there!

T-SQL Tuesday #41 – A journey of a thousand miles begins with a single step

This post might come a bit late but this is in response to  Bob Pusateri‘s T-SQL Tuesday topic  about presenting. T-SQL Tuesday is a monthly blogging event, with a different community host each month.

So, how did I come to present and loving it?

“a journey of a thousand miles begins with a single step”

After getting my graduate degree I stayed as an  Assistant Professor at Politechnica University of Timisoara, my Alma Mater, teaching seminars and labs on Programming  101 (Turbo Pascal … oh my!) and Relational databases labs while being the resident Oracle DBA at the Software Engineering department. 3 years later, I switched to a full time job as Oracle DBA and later  moved to a different continent with a different language and being an ESL speaker I did not think I would be speaking at public events… until 2 years ago at SQL Skills Immersion Events in Chicago (with Bob Pusateri!! our blog host). On the fourth day of the IE 1 class I volunteered to present a slide deck on SSD technology . I was extremely embarrassed as I felt like I was not in the same league as the rest of the presenters, but everything went so well that it made me reconsider my thoughts. As a matter of fact it made me submit a couple sessions for SQL Saturday #82 in Indianapolis and this was the beginning of my public speaking adventure. Later that year I actually presented 2 sessions in a day at SQL Saturday #96 in Washington, DC and the feedback was excellent.

 Starting on a journey as a speaker that has been incredibly rewarding and even though most of the time I paid for it out of my own pocket, the knowledge and the friends that I made on this journey were worth every effort. Last year two of my goals came true: attending PASS Summit for the first time and presenting my session titled “Optimizing SQL Server I/O with Solid State Drives ” at PASS Summit 2012. To put things  in perspective, 2012 has proved to  be truly amazing: Being mentored by Joe Sack blog|@josephsack from  SQLskills, attending my third  SQLskills Immersion Event – IE3, speaking at 6 SQLSaturday events in Madison WI, Chicago IL, Indianapolis IN, Iowa City IA, Kalamazoo MI and Minneapolis MN. I was extremely honored to be selected to speak a PASS Summit 2012, the greatest SQL Server conference of the year where I was joined by more than  150 of the industry’s leading speakers while having the unique chance to meet over 5000 database professionals.

My friend Paul Timmerman mentioned  in his post that last year I inspired him  to  start presenting. I am deeply honored to grow the community and inspire others to start speaking at community events the same way as I was inspired by Brent Ozar, Jes Borland, Paul Randal, Joe Sack and many other folks that are now part of my #SQLfamily

…and it all started 2 years ago with a session that was not supposed to last more than 15 minutes.

This week I will be attending my 4th SQL Saturday in Chicago, second time as a speaker,  hope you can make it to my session or just come by and say hi.

 

Presenting session: Anatomy of a Join at SQL Saturday #211 in Chicago

I’m thrilled to announce that I will be presenting for the second time at SQL Saturday  in Chicago  my Internals  session “Anatomy of a Join” on Saturday April 13, 2013!Chicago

Location is:
Devry Addison Campus
1221 N. Swift Rd, Addison, IL 60101

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.
If you are attending please stop by and introduce yourself. Also if you are on Twitter don’t forget to use hashtag #sqlsat211 and see what others are doing.

Hope to see you there!

Things to do at PASS Summit 2012

Since there are over 5000 people that will be coming to Seattle this year for PASS Summit 2012 I was thinking to put together a list of things to do around the city.

Please feel free to add on to the list and I will try to update the content.Original Starbucks

First of all if you have not already done so, download the Guidebook app , search for Summit 2012 and load the official event schedule. This way any future updates will land right on your device.

  • #SQLRUN organized by Jes Borland @grrl_geek This will be a 5K run on Wednesday, November 7th at 6:00 AM.
  • Pike Place Market - about 6 blocks from the Convention Center  on Pike St – It is one of the oldest continually operated public farmers’ markets. If you are a coffee addict like me don’t miss the second Starbucks location in the original brown color scheme.
  • Seattle Monorail – You can ride a piece of history ($2.25 cash only/ one way) from Westlake Mall (2 blocks from Convention Center) to Space Needle and EMP
  • Space Needle -  Just like the monorail this iconic Seattle landmark was built for the1962 Seattle World’s Fair and featured in several movies like Elvis Presley’s It Happened at the World’s Fair
  • EMP Museum (formerly known as Experience Music Project and Science Fiction Museum and Hall of Fame)

I also recommend Denny Cherry’s SQL PASS 2012 1st Timers Webcast (low res only). He has a few more tourist attractions on the slides.

 

I will continue to add  items to this list, so come back soon.

 

My road to PASS Summit 2012

It’s been a while since I decided to give back to the SQL Server community  and start speaking at community events. I started on a journey as a speaker that has been incredibly rewarding and even though most of the time I paid for it out of my own pocket, the knowledge and the friends that I made on this journey were worth every effort. Next week two of my dreams will come true: attending PASS Summit for the first time and presenting my session titled “Optimizing SQL Server I/O with Solid State Drives ” at PASS on Friday, November 09, 2012, 1:00 PM – 2:15 PM in 302-TCC.
To put things  in perspective, this year has proved to  be truly amazing: Being mentored by Joe Sack blog|@josephsack from  SQLskills, attending my third  SQLskills Immersion Event – IE3, speaking at 6 SQLSaturday events in Madison WI, Chicago IL, Indianapolis IN, Iowa City IA, Kalamazoo MI and Minneapolis MN. On a personal note I have completed the Pewaukee triathlon and completed a Century ride (100 miles cycling)  with Bicycling Club of Lake County.

I am extremely honored to be selected to speak a PASS Summit 2012, the greatest SQL Server conference of the year where I will join more 150 of the industry’s leading speakers while having the unique chance to meet over 2400 database professionals. I would like to thank the PASS  Program Committee and Speaker review team for their support and for selecting my session .

I hope to see you next week at the PASS Summit and hope you can make it to my session or just come by and say hi and one of the other events.

 

 

 

A tale of two cities : Presenting Anatomy of a Join at SQL Saturday #160 and #149

Next 10 days will be pretty busy as  I will be presenting  my session “Anatomy of a Join” at  SQL Saturday #160  in Kalamazoo, MI on Saturday September 22, 2012 and the following week at SQL Saturday #149  in Minneapolis, MN on Saturday September 29, 2012

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.
If you are attending please stop by and introduce yourself. Also if you are on Twitter don’t forget to use hashtag #sqlsat160 For Kalamazoo or #sqlsat149 for Minneapolis and see what others are doing.

Hope to see you there!

Presenting session: Anatomy of a Join at SQL Saturday #161 in Iowa City

I will be presenting  my session “Anatomy of a Join” at  SQL Saturday #161 in Iowa City on Saturday August 11, 2012!

Location is:
University Capitol Centre Room 2520,University of Iowa,
201 S Clinton St, Iowa City, IA 52240

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.
If you are attending please stop by and introduce yourself. Also if you are on Twitter don’t forget to use hashtag #sqlsat161 and see what others are doing.

Hope to see you there!

Speaking at SQL Saturday #126 in Indianapolis

I will be presenting  my session on “Optimizing SQL Server I/O with Solid State Drives” at  SQL Saturday #126 in Indianapolis on Saturday July 28, 2012!

There is also a pre-con available: Allen White will present a one day Pre-Con on Friday July 27th from 8am to 5pm

Register Now at http://indysqlpowershell.eventbrite.com/

Location is:
University of Indianapolis,
1400 E. Hanna Ave, Indianapolis, IN 46227

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.
If you are attending please stop by and introduce yourself. Also if you are on Twitter don’t forget to use hashtag #sqlsat126 and see what others are doing.

Hope to see you there!

A SSD Technology a Day (8) – eMLC and MLC-HET

In the 2nd post off this series we have explored the differences between SLC and MLC and saw that the main issue with MLC is endurance which in the past prevented their use for enterprise applications. Because of the increased capacity of MLC is a right fit for enterprise use, flash memory manufacturers looked for a way to increase the endurance characteristic of MLC memories. When analyzing the reasons why MLC cells fail sooner than SLC the main culprit was the tight reference voltage that after a numbur of flash write cycles is being overlapped by the actual charge left in the cell leading to an incorrect value being read from that cell. When that happens a few times the cell is being marked as bad.
The solution was to try to make the programing cycles more precise in order to increase the interval around reference levels from and allow more room for error when the memory cell degrades. Also the silicon dies are being tested and only the ones having better endurance characteristics are selected for enterprise use. This flash memory has been marketed as eMLC or MLC-HET (high endurance).

eMLC reference levels - Image courtesy of www.tomshardware.com

This memory has improved endurance over consumer grade MLC with one downside that programming increases in order to allow for more precise reference levels.
The average Write cycles for this type of memory is between 10K and 30K times.

This post comes to you from the shores of Lake Michigan in Muskegon where we are spending the weekend at a cottage in the company of good friends. In order to continue this SSD saga I found myself forced to write this using the WordPress iPhone app much like the character played by Robin Williams in the movie RV. Please excuse any spelling errors that you might find.

A SSD Technology a Day (7) – Intelligent Bad Block Management

In previous posts I talked about the wear and RAISE algorithms implemented by SSD controllers. One of the inevitable issues solid state memory is how to gracefully deal with bad blocks.

Bad blocks are flash memory blocks that contain one or more invalid bits whose reliability is not guaranteed because of faulty dies, over-charge leaks or wear-out. Bad blocks may exist even on a new disk.

Bad Block Management or Intelligent Block Management is an algorithm that monitors and maintains bad blocks within the NAND device. The controller maintains tables of known bad blocks and can replace the new bad blocks with spare blocks that are reserved for use. typically 4-10% of the usable capacity is reserved for Bad Block Management This practice further enhances the overall SSD lifespan and ensures that a few bad blocks will not affect the integrity of the drive and the SSD device still operate.

Bad blocks are mapped as “do not use”and substituted with known good blocks from the percentage set aside for spare blocks. The percentage of bad blocks which can be accomodated is a product marketing decision and that is the reason why an 128GB SSD device will only present 120GB as available to use. The spare blocks come from over provisioning inside the SSD and using the capacity which is invisible to the user.

If the bad blocks exceed the remaining spare blocks for any reason- the SSD fails because the controller cannot safely substitute a block that has to be written on a new bad block and can result in data loss.

Retired block count

The measure for Bad Block Management is “Retired Block Count” but expect that count to go up as “SSD Life Left” nears 5-10%