SQL Server with Mr. Denny


February 28, 2008  8:00 AM

SQL 2008 Launch Event was Yesterday

Denny Cherry Denny Cherry Profile: Denny Cherry

Well I just got back from the Launch event.  The event was excellent.  Microsoft was giving out a lot of really excellent information about all the products.  The turnout was just amazing.  I heard that about 5000 people registered, and that based on prior events about 3500 were expected to actually show up.  Somewhere around 6500 people actually attended so the show was very busy.

Tom Brokaw and Steve Ballmer both gave excellent speeches at the keynote speakers.  Because of the large number of people in attendance the check in process seamed to take quite a while for a lot of people.  The demos which were done were very interesting.  There was only one occasion of the “cooking show magic” where you go from the before to after without showing the changes with SQL Server Reporting Services Report Designer when adding a column.  Everyone seamed to know why we weren’t shown the work of adding a column to a report because it’s not as easy as they wanted it to seam.  We all got the gist of what they were getting at though.  Many of the sessions were packed so full that there were more people then could actually get into the session rooms.

Because of the extra people in attendance the lunch situation wasn’t the greatest, but it seamed that they were able to deal with it.  I didn’t see anyone going without lunch so I guess they were able to deal with it pretty quickly.

The only real complaints that I have are that the Microsoft pavilion was in a separate room from the main pavilion room so it was a little hard to find.  I didn’t even realise that there was a Microsoft pavilion until half way through the day, and by then I didn’t have time to go and check it out.

Because I was one of the first 1000 people to register for the event I was invited to the AMD / Microsoft party after the launch event.  The party was awesome to say the least.  The Barenaked Ladies performed a full set, and it was a great show.  Now I admit, I’m not the biggest fan of the Barenaked Ladies, but they put on a great show.  They appeared to be having a great time, and the music was great.  It was a top notch way to end a great day of learning.

Be sure to check out the event when it comes to a town near you.

I tried to take some photos, but my camera just didn’t cut it.  Some folks that I know took some pictures with me.  As soon as I get them, I’ll post them up on the site for all to see.

Denny

February 26, 2008  8:00 AM

SQL 2008 Launch Event is Tomorrow

Denny Cherry Denny Cherry Profile: Denny Cherry

Well, tomorrow is the official launch event for Microsoft SQL Server 2008 (as well as Windows Server 2008 and Visual Studio 2008 but really cares much about them).

If you can’t make it to the launch event I’ll be posting to my blog as often as I can through out the day to everyone updated on the information which is released.

I highly recommend that everyone check out the launch event in thier area.

Denny


February 26, 2008  3:07 AM

Webcast recording available online

Denny Cherry Denny Cherry Profile: Denny Cherry

The recorded webcast which I did a couple of weeks ago now is available for viewing on Quest Software’s Web Page.  The slide deck is also available for downloading.

 The URL is http://www.quest.com/events/listdetails.aspx?contentid=6907&searchoff=true&technology=&prod=24&prodfamily=&loc=

The original webcast was on Feb 7, 2008.  More info can be found here.

Thanks,

Denny


February 21, 2008  2:00 PM

Great post about IT audits

Denny Cherry Denny Cherry Profile: Denny Cherry

Arian over on the Sister CISA CISSP blog has a great post entitled Security by Auditor: Don’t Make Me Do It.  It’s not specifically focused on databases, but I think that it’s a great read for every DBA.

Denny


February 21, 2008  8:00 AM

Don’t forget about the SQL Server 2008 Launch Event

Denny Cherry Denny Cherry Profile: Denny Cherry

Don’t forget that the Microsoft Launch Event in Los Angeles is next week.  If you are in town, you should try to make it to the event.

 You can register here.

 Denny


February 18, 2008  8:00 AM

So I’ve heard about endpoints, but what are they and how do I use them?

Denny Cherry Denny Cherry Profile: Denny Cherry

In a nutshell Endpoints are ways that people, or applications can connect to the SQL Server.  There are several different kinds of end points which can be created; four to be specific.  Two are system specific, the SERVICE_BROKER and DATABASE_MIRRORING endpoints can only be used for the SQL Service Broker and Database Mirroring respectively. The other two are for general use.  They are the SOAP and TSQL endpoints.

Without knowing it you use an endpoint to connect to the SQL Server each time you connect.  There are actually 5 endpoints created by default on each instance of SQL Server.  You can check then out by querying the sys.endpoints DMV.  When you connect to the SQL Server using TCP (port 1433 by default) you are using the TSQL Default TCP endpoint.  By default all users have the rights to connect to this endpoint.  You can create other TCP endpoints on different ports for specific users to connect to.  This would be handy if you have several applications coming into the SQL Server from a single server, and you wanted to be able to separate there traffic through the firewall so that the network admins could watch the traffic in the event of an issue.  You could create a TCP endpoint for each application, and assign only that application IP rights to use that endpoint.  You then have the application specify the port number that it will be connecting through in the connection string.

The SOAP endpoints are used in a similar way, but instead of allowing regular TSQL connections they allow SOAP calls to be made directly against the database.  (I’m not that up to speed on SOAP so that’s about all I’ve got on that topic.)

 Endpoints are created with the CREATE ENDPOINT command with various switches depending on what kind of endpoint you are creating and how much security you require on the endpoint.

The endpoint that I’ve used the most would have to be the service broker endpoint.  It’s used to allow SQL Server service broker on one SQL Server to talk to the Service Broker of another SQL Server.

One thing to remember about endpoints is that they are used for inbound connections only.  Outbound connections do not require or use an endpoint.

Denny


February 14, 2008  10:13 AM

Eat more chicken…

Denny Cherry Denny Cherry Profile: Denny Cherry

Well, this has absolutely nothing to do with SQL Server, but I just had to post this anyway.

 We were having dinner at Chick-fil-A and the Chick-fil-A cow was there.  My wife snapped this photo, that I just had to share with everyone.  How totally awesome is this.  (Comments are very much welcome.)

Denny

Denny and the cow…


February 13, 2008  10:37 AM

New Article: Configuring SQL Server memory settings

Denny Cherry Denny Cherry Profile: Denny Cherry

I’ve published a new tip over on SearchSQLServer.com entitled “Configuring SQL Server memory settings“.  In it I talk about how to correctly setup the memory settings for SQL Server to get SQL setup correctly.

Denny


February 11, 2008  8:00 AM

Getting those memory setting in SQL Server just right.

Denny Cherry Denny Cherry Profile: Denny Cherry

When using 64bit SQL Server getting the memory settings right is pretty easy.  Simply set the maximum to what you want and you are good to go.

Getting them right in the 32bit versions of SQL Server is a bit harder.  You have to deal with the OS level of enabling the Physical Address Extensions (PAE) and the 3GB switches.  You then need to enable AWE within SQL Server and then set the max memory setting.

If you are using Windows 2003 SP1 or later PAE will enable for you automatically.  The /3GB switch however won’t.  Since I have to add the /3GB switch I like to add the /PAE switch in there as well.  My theory is why make Windows decide to do something automatically when I can simply override the logic and turn it on every time, especially when it’s something that I’m going to want enabled every time the server boots.

 Now as to the max memory setting for SQL Server… There are pretty much two prevailing schools of thought. 

  1. Give Windows between .5 and 1 Gig of memory and give SQL the rest.
  2. Give SQL 75% of the physical memory and leave the rest for Windows.

I’ve tried both and both seam to work fine.  If you have less memory to work with you will probably want to stick to option 1.  When you start working with huge amounts of RAM (64 Gigs plus) is when Option 2 starts to look more workable.

These rules obviously all start to change when you have more than one instance installed as you need to balance your max memory between the instances.

If you are using less then 2 Gigs of RAM for the instance don’t enable AWE on the instance.  I’ve seen it lead to SQL Server acting strangely and performing very strangely.  When setting your max memory setting for more than one instance don’t forget to add up the max memory for all the instances and make sure to leave Windows room to work with or your server will suffer.

Don’t forget about my post on setting the min server memory setting in SQL Server.

Denny


February 7, 2008  5:43 PM

Webcast turnout was fantastic

Denny Cherry Denny Cherry Profile: Denny Cherry

Thanks to all who attended this morning webcast ‘Under The Hood of SQL Server – Checking Out Internals’.  This mornings webcast was a complete success.  The number of people attending was fantastic, and some excellent questions were asked.  If I remember correctly there were about 140 people in attendance.  For those who weren’t able to attend the webcast this morning, it was recorded and as soon as it’s published I’ll post the link to the video.

If you have a question specific to the webcast please email my good friend Andy Grant with your questions and he will route them to myself or Jason Hall.

Don’t forget to check out the tech brief which we were talking about.

Denny


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: