SQL Server with Mr. Denny:

SQL Server 2005


March 24, 2008  10:00 AM

Back To Basics: The INSERT Statement



Posted by: Denny Cherry
Back To Basics, INSERT statement, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008, T/SQL

While the SELECT statement is probably the most important command, the INSERT comes in handy.  The INSERT statement is used to do exactly what it sounds like, it inserts data into a table.  There are two ways to insert data into a table.  The first is to pass in each of the values, and the...

March 17, 2008  11:00 AM

Back To Basics: Using Common Table Expressions



Posted by: Denny Cherry
Back To Basics, Common Table Expressions, CTE, SQL, SQL Server 2005, SQL Server 2008, T/SQL

CTEs (Common Table Expressions) are one of the very cool features introduced in SQL Server 2005.  In there simplest most common form, think of them as a temporary single use view who's context is only within the command which follows them directly.  The syntax of a CTE is very...


March 10, 2008  10:00 AM

Back To Basics: The SELECT Statement



Posted by: Denny Cherry
Back To Basics, SELECT statement, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008, T/SQL

There are four basic commands in databases.  They are SELECT, INSERT, UPDATE and DELETE.  Probably the most important of these is the SELECT command.  The SELECT command is how the data in the database is retrieved and displayed. (All these code samples can be run on all versions of Microsoft...


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  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 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 7, 2008  5:43 PM

Webcast turnout was fantastic



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

Thanks to all who attended this morning webcast ‘Under The Hood of SQL Server - Checking...

Bookmark and Share     1 Comment     RSS Feed     Email a friend


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


February 1, 2008  12:27 AM

Webcast: ‘Under The Hood of SQL Server – Checking Out Internals’



Posted by: Denny Cherry
SQL, SQL Server 2005, SQL Server 2008, Webcam

On Thursday Feb 7, 2008 at 8am Pacific (11am Eastern, 4pm GMT) myself and Jason Hall, Systems Consultant at Quest Software will be co-hosting a webcast looking into the challenges in seeing exactly what is happening within SQL Server (including SQL Server 2008) using Spotlight® on SQL Server...


January 28, 2008  11:56 PM

Slide Decks and Sample Code from SoCal Code Camp



Posted by: Denny Cherry
Beta, Cache, CLR, Config, In Person Events, Query tuning, Resource Governor, SQL, SQL Server 2005, SQL Server 2008, SSMS

The SoCal Code Camp was this last weekend.  I had a great time attending and speaking at the code camp this time around.   I hope that everyone who attended my sessions had as much fun attending the sessions as I did speaking at them.  I did my best to make them as much fun and interactive as I...


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: