Read Dirty To Me...Isolation Levels in SQL Server
http://www.littlekendra.com/2011/02/08/isoposter/ (Kendra Little - FREE Poster!)
http://www.littlekendra.com/resources/isolation/ (Excellent reference page)
http://michaeljswart.com/?p=604 (Transaction Phenomena)
Nolock info:
http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
http://www.windowsitpro.com/article/news2/beware-the-nolock-hint
Visualizing Your Indexes: The Science Behind The Art
http://sqlchicken.com/sql-university/ (Grant Fritchey's Series on Indexing)
http://www.jasonstrate.com/2010/12/can-you-dig-it-missing-indexes/ (Jason Strate, finding missing Indexes)
http://performance.sqlpass.org/PresentationArchive.aspx (Paul Randal presentation)
http://sqlfool.com/2010/12/disposable-indexes/ (Michelle Ufford)
http://www.midnightdba.com/Jen/2009/12/get-index-included-column-info/ (MidnightDBA)
http://www.sqlteam.com/article/sql-server-indexes-the-basics
http://www.mssqltips.com/tip.asp?tip=1452
http://msdn.microsoft.com/en-us/library/dd171921(v=sql.100).aspx
http://www.mssqltips.com/tip.asp?tip=1339
http://technet.microsoft.com/en-us/library/cc917715.aspx (Indexed Views)
http://msdn.microsoft.com/en-us/library/ms191475.aspx (Reading Pages)
http://msdn.microsoft.com/en-us/library/ms177443.aspx (Clustered Indexes)
http://www.sqlservercentral.com/articles/Fill+Factor/70827/ (Fill Factor)
http://technet.microsoft.com/en-us/library/cc280372.aspx (Filtered Indexes)
Saturday, September 17, 2011
Friday, September 16, 2011
PASS Summit Memories
Another #memeMonday
Yeah, I know...It's Friday. Deal.
**Authors note: I scheduled this to post last Friday, apparently that did NOT happen.
All week, people have been posting some of their favorite memories from the PASS Annual Summit. I am fortunate that for me, there are many to choose from. Some, people have heard me tell a few times, others I'm under strict NDA, so you'll just have to hang out and catch those as they happen!
My first, and still my fondest Summit memory is from my very first Summit, back in Orlando in the Year of the Hurricane. The Summit was actually delayed a day, but I had no trouble arriving on schedule, so I did what any Midwesterner would do when in Florida in November...I went to Epcot! That evening, it was time for the Welcome Reception at the resort, so I spruced up, pushed the elevator button and waited to descend 30-some-odd floors to the party.
It was on that fateful elevator ride I met my first other attendee at the Summit*. A nice-looking guy with glasses and a mischievous smile was wearing a badge and reading it, I happened to notice he was from Kansas City. Having grown up in St. Louis, and having spent a few years just outside of KC and visiting family there often (my home-away-from-home, truly), I felt an immediate kinship with this fellow Missourian, so I introduced myself. Being horrible with names, I was happy that his was easy to remember: Bill. Whew, nothing like trying to meet new people and forgetting their names...Bill would be easy enough to commit to memory. So we chatted for a minute or two about KC and the Summit and he learned this was my first time attending. I was really excited when he mentioned he would like to introduce me to some other people he knew attending, as I wasn't much looking forward to standing around at a big party with no one to talk to.
As we enter the party, my new friend looks around for his other 'people' and spots them several feet away.
"Hey DENISE! I have another one for you!" I hear him call. Now that made me giggle :) This wasn't my first technical conference, so I get it that women are few and far between at these things**. Plus, I could tell this guy was being genuine and he really was excited to help the ladies network. I spent the rest of the evening, and the Summit that year hanging out with my new found friends.
And, that, dear reader, is how I met Bill Graziano and Denise McInerny at my very first Summit!
*Okay, that's stretching it a tad, I did meet some other folks on the bus to Epcot.
**It's impressive how the percentage of female attendes has grown at Summit over the years.
Yeah, I know...It's Friday. Deal.
**Authors note: I scheduled this to post last Friday, apparently that did NOT happen.
All week, people have been posting some of their favorite memories from the PASS Annual Summit. I am fortunate that for me, there are many to choose from. Some, people have heard me tell a few times, others I'm under strict NDA, so you'll just have to hang out and catch those as they happen!
My first, and still my fondest Summit memory is from my very first Summit, back in Orlando in the Year of the Hurricane. The Summit was actually delayed a day, but I had no trouble arriving on schedule, so I did what any Midwesterner would do when in Florida in November...I went to Epcot! That evening, it was time for the Welcome Reception at the resort, so I spruced up, pushed the elevator button and waited to descend 30-some-odd floors to the party.
It was on that fateful elevator ride I met my first other attendee at the Summit*. A nice-looking guy with glasses and a mischievous smile was wearing a badge and reading it, I happened to notice he was from Kansas City. Having grown up in St. Louis, and having spent a few years just outside of KC and visiting family there often (my home-away-from-home, truly), I felt an immediate kinship with this fellow Missourian, so I introduced myself. Being horrible with names, I was happy that his was easy to remember: Bill. Whew, nothing like trying to meet new people and forgetting their names...Bill would be easy enough to commit to memory. So we chatted for a minute or two about KC and the Summit and he learned this was my first time attending. I was really excited when he mentioned he would like to introduce me to some other people he knew attending, as I wasn't much looking forward to standing around at a big party with no one to talk to.
As we enter the party, my new friend looks around for his other 'people' and spots them several feet away.
"Hey DENISE! I have another one for you!" I hear him call. Now that made me giggle :) This wasn't my first technical conference, so I get it that women are few and far between at these things**. Plus, I could tell this guy was being genuine and he really was excited to help the ladies network. I spent the rest of the evening, and the Summit that year hanging out with my new found friends.
And, that, dear reader, is how I met Bill Graziano and Denise McInerny at my very first Summit!
*Okay, that's stretching it a tad, I did meet some other folks on the bus to Epcot.
**It's impressive how the percentage of female attendes has grown at Summit over the years.
Thursday, September 15, 2011
On Tour...Hope to Meet You Soon!
There have been a number of changes in my career these past few months, and one of the more exciting things for me was being picked to join five other SQL Server community members as part of Idera's ACE program! I am very happy that they will be assisting me and the others in making it out to more community events around the country.
So, where can you find me? Take a look!
Saturday, September 17th - SQL Saturday Kalamazoo
I'll be presenting TWO sessions and sitting on the Women In Technology panel during lunch
Tuesday, October 4th - Suburban Chicago SQL Server Users Group
Join us for a presentation from Microsoft on the new version of SQL Server, Denali
You will be able to RSVP the week prior to the event.
Thursday, October 13th - PASS Summit, Seattle WA
For the first time, I will be presenting a session at the flagship Summit event!
Saturday, October 29th - SQL Saturday Kansas City
The schedule has not been posted yet, so not sure if I'll be presenting, but I will be there anyway. Be sure to stop and say 'Hi!'
Tuesday, November 1st - Suburban Chicago SQL Server Users Group
TBD
*If you are interested in sharing your SQL Server knowledge with the community, send me an email and we can work you into our schedule!
You will be able to RSVP the week prior to the event.
Also, I'm working on making it out to Mountain View, CA or Phoenix, AZ early next year.
Finally, keep your calendar open for SQL Saturday CHICAGO, coming your way again Spring 2012!
So, where can you find me? Take a look!
Saturday, September 17th - SQL Saturday Kalamazoo
I'll be presenting TWO sessions and sitting on the Women In Technology panel during lunch
Tuesday, October 4th - Suburban Chicago SQL Server Users Group
Join us for a presentation from Microsoft on the new version of SQL Server, Denali
You will be able to RSVP the week prior to the event.
Thursday, October 13th - PASS Summit, Seattle WA
For the first time, I will be presenting a session at the flagship Summit event!
Saturday, October 29th - SQL Saturday Kansas City
The schedule has not been posted yet, so not sure if I'll be presenting, but I will be there anyway. Be sure to stop and say 'Hi!'
Tuesday, November 1st - Suburban Chicago SQL Server Users Group
TBD
*If you are interested in sharing your SQL Server knowledge with the community, send me an email and we can work you into our schedule!
You will be able to RSVP the week prior to the event.
Also, I'm working on making it out to Mountain View, CA or Phoenix, AZ early next year.
Finally, keep your calendar open for SQL Saturday CHICAGO, coming your way again Spring 2012!
Subscribe to:
Posts (Atom)