SQL Server with Mr. Denny:

SQL


March 6, 2008  3:12 AM

I’ll be speaking at the San Diego SQL Server Users Group



Posted by: Denny Cherry
In Person Events, Query tuning, Resource Governor, SQL

The good folks of the San Diego SQL Server User Group has invited me to come speak to them on March 20, 2008.  The meeting starts at 6PM.  If you are in the area I urge you to come and check it out.  The topic of my talk will be Query Tuning as well as a bit of Query Governor.  If you...

March 6, 2008  2:26 AM

New Paper Published: Bullet-proof Change Management – Don’t just Cross your Fingers and Hope



Posted by: Denny Cherry
Article, Compliance, Quest Software, SQL

I've written a technical brief on how my company,

Bookmark and Share     0 Comments     RSS Feed     Email a friend


March 3, 2008  10:00 AM

T/SQL Back To Basics



Posted by: Denny Cherry
Back To Basics, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008

I've seen a lot of posts online over the last few weeks with people asking about basic query syntax.  So over the next few posts I'm going to show some basic T/SQL queries as well as some more "advanced" features and syntaxes. Hopefully you'll find these syntaxes useful. All the code...


March 2, 2008  11:45 AM

New Article: Configuring SQL Server memory settings



Posted by: Denny Cherry
Article, RAM, SQL

I've recently published a new tip on SearchSQLServer.com called "   Bookmark and Share     2 Comments     RSS Feed     Email a friend


March 2, 2008  4:43 AM

New Article: Create an upgrade plan for your move to SQL Server 2005



Posted by: Denny Cherry
Article, Config, Installation, SQL, SQL Server 2005, SQL Server 2008

I’ve published a new tip over on SearchSQLServer.com entitled “Create an upgrade plan for your move to SQL Server...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


February 28, 2008  8:00 AM

SQL 2008 Launch Event was Yesterday



Posted by: Denny Cherry
In Person Events, SQL, SQL Server 2008

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...


February 18, 2008  8:00 AM

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



Posted by: Denny Cherry
Config, Endpoints, SQL, SQL Server 2005, SQL Server 2008

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...


February 13, 2008  10:37 AM

New Article: Configuring SQL Server memory settings



Posted by: Denny Cherry
Article, Cache, RAM, SQL

I’ve published a new tip over on SearchSQLServer.com entitled “   Bookmark and Share     0 Comments     RSS Feed     Email a friend


February 11, 2008  8:00 AM

Getting those memory setting in SQL Server just right.



Posted by: Denny Cherry
Config, Microsoft Windows, RAM, SQL, Windows Computing

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...


February 7, 2008  12:20 AM

New Paper Published: Picking the Right Instrument for SQL Server Performance Management



Posted by: Denny Cherry
Article, In Person Events, Quest Software, SoSSE, SQL, SQL Server 2005, SSMS

The folks at Quest Software asked me to write a paper for them discussing the differences between managing a SQL Server using just the Microsoft provided tools and their Spotlight on SQL Server Enterprise product.  That paper has just been released and can be downloaded

Bookmark and Share     0 Comments     RSS Feed     Email a friend


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: