SQL Server with Mr. Denny:

Development


March 21, 2008  6:11 AM

I had a great time speaking at the San Diego SQL User Group



Posted by: Denny Cherry
In Person Events, Query tuning, Service Broker

I'd like to thank the San Diego SQL Server User Group for having me come and speak to them tonight.  I had a great time presenting both my

March 20, 2008  12:00 PM

Remote Desktop, it’s better than ever



Posted by: Denny Cherry
Microsoft Windows, Software

Remote desktop is something that we've all used.  It's easy to find, right there under Programs > Accessories.  But there is so much more that you can do than simply connect to a remote session with it.  If you start the program manually from the run line by running "mstsc.exe" with some...


March 18, 2008  10:24 AM

Slide Decks and Sample Code for San Diego SQL Users Group Meeting



Posted by: Denny Cherry
In Person Events, Query tuning, Service Broker

Below you will find links to download file files with the MS PowerPoint slide decks and sample files which I'll be using at this weeks presentation at the San Diego SQL Users Group Meeting. There is a lot of sample code in the Query Tuning file.  We'll look through as much of it as we can...


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 13, 2008  8:00 AM

SQL 2008 prevents schema changes if the table must be dropped



Posted by: Denny Cherry
Config, SQL, SQL Server 2008, SSMS

When editing the table schema in the SQL Server 2008 UI and the required change requires that the table needs to be dropped and recreated by default the UI will not let you make the change. The kinds of changes that would require that the table be dropped and recreated would be inserting a...


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


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: