SQL Server with Mr. Denny


November 30, 2008  11:15 PM

Webcast: SQLServerPedia.com — The Definitive SQL Server Knowledge Base



Posted by: Denny Cherry
SQLServerPedia.com, Webcast

Gain access to SQL Server experts and learn more about SQLServerPedia.com by attending this webcast. SQLServerPedia.com is the free reference resource created for SQL Server professionals, by SQL Server professionals. See how you can access video training, as well as sample scripts for backup and recovery, index maintenance and performance tuning. Plus, boost your SQL Server rock star street cred in the SQL Server community by contributing articles yourself.

The Editor-In-Chief of SQL Server Pedia, myself and some (hopefully all) of the other editors of the SQLServerPedia.com Wiki will be on the webcast.

You can register for the webcast on the registration page.

See you on the webcast.

Denny

November 28, 2008  10:58 PM

January SoCal Code Camp Sessions Being Posted



Posted by: Denny Cherry
SoCal Code Camp

The SoCal Code Camp website has started accepting sessions for the next Code Camp in January. I’ve put a couple of sessions up there already.

I’ve got one on SQL Server Indexing for the Client Developer, and one on SQL Server Service Broker Advanced Performance Tips and Tricks.

I’m open to suggestions as to what the folks in the area who might be attending as to anything else SQL Server they night be interested in hearing about.

At the moment on Woody Pewitt and I are the only people who have sessions posted. I’m sure that will change shortly.

Denny


November 27, 2008  12:15 PM

Back To Basics: Creating Indexes



Posted by: Denny Cherry
Back To Basics, CREATE INDEX, SELECT statement

After you have created your tables, and stored procedures you will have a basic idea of what queries are going to be running against your database.  If you haven’t already done so, its now time to start adding indexes to your database.  The catch with index is that there is such a thing as to much or a good thing.  As you add more and more indexes to your database your INSERT, UPDATE and DELETE commands will being to slow down, as each time you insert a record the insert is committed to the table, as well as to each index on the table. Continued »


November 25, 2008  11:39 PM

How to configure storage in SQL Server DB with more writes than reads



Posted by: Denny Cherry
Storage

All to often articles and presentations about storage work under the assumption that you have a typical OLTP database with mostly reads. However there are plenty of databases out there which are mostly writes and very few reads. Setting these systems up takes a different technique for best performance.

In my just released article on SearchSQLServer.com called “How to configure storage in SQL Server DB with more writes than reads” I go over some of the differences between a normal OLTP database and a high write OLTP database.

Denny


November 24, 2008  1:00 PM

Back To Basics: What’s the difference between a Scan and a Seek?



Posted by: Denny Cherry
Back To Basics, Index Performance, Index Scan, Index Seek, SQL Server, Table Scan

There are a few basic operations which SQL will perform when looking for the data that you need.  Here they are listed in the order of worst to best.

  • Table Scan
  • Clustered Index Scan
  • Index Scan
  • Clustered Index Seek
  • Index Seek

The basic rule to follow is Scans are bad, Seeks are good.

Continued »


November 23, 2008  12:00 PM

ITKE is getting an upgrade soon



Posted by: Denny Cherry
ITKE grandparent

I’ve been informed that at some point in the near future (within the next couple of weeks probably) that we’ll be upgrading the version of Word Press that we use for the blogs.

Continued »


November 22, 2008  7:08 PM

PASS 2008 Wrapup



Posted by: Denny Cherry
PASS, SQL

Well the PASS 2008 summit must be official over as I’m sitting at the airport waiting for my plane.  I was expecting a very long security line here at SeaTac but I was through security within maybe 10 minutes.  While means that the two hours I was planning on standing in line I instead get to sit at Terminal D3 (after just moving from N11 on the far side of the airport) and wait for my flight to Ontario.  I guess the upside is that I got to get some lunch before my flight.

Overall I would have to say that the PASS  2008 summit was a success.  I got some good info about SQL Server, and met a lot of people that I either know from forums or who’s writings I’ve been reading for quite a while now.  Overall the sessions were very informative, and I know that I got something out of just about every session I attended.

Last night a group of MVPs got together for dinner with our MVP lead.  The dinner was a blast with about 30 people attending the dinner.  It was on Friday night so a lot of people had already gone home.  It was great to be able to sit and chat and relax with other people after the rush of PASS being over.

It was great to meet everyone, as well as say high again to people that I met at PASS 2007, SQL 2008 Launch and other conferences.

There were a couple of people that I didn’t have a chance to run across that I wish I did.  Hopefully next year.

See you at PASS 2009 back here in Seattle, Washington.

Denny


November 22, 2008  12:43 AM

PASS 2008 – Day 3



Posted by: Denny Cherry
Kevin Kline, PASS

Today was a pretty slow day. I spent most of the day kicking back in the MVP room talking to the MVPs and the Microsoft folks. I did make it to a couple of sessions however.

Continued »


November 21, 2008  5:08 AM

PASS 2008 – Day 2 Recapped



Posted by: Denny Cherry
Bob Ward, Brent Ozar, Hugo Kornelis, Tom LaRock

Today was another excellent day here at PASS 2008 in rainy Seattle, WA.

Continued »


November 20, 2008  8:31 AM

Congratulations to Tom LaRock and Douglas McDowell!



Posted by: Denny Cherry
Brent Ozar, Douglas McDowell, Tom LaRock

Two of my fellow SQLServerPedia.com editors Tom LaRock and Douglas McDowell, have been nominated for elections on the PASS Board of Directors.

Continued »


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: