SQL Server with Mr. Denny:

T/SQL


December 27, 2007  8:00 AM

Avoiding SQL Injection Attacks



Posted by: Denny Cherry
Attack Prevention, Security, SQL, T/SQL

The most common way for people to insert invalid data or cause damage to your database is through what is called a SQL Injection Attack.  This is when malicious code is placed within the responses which are expected and that code is not caught and it instead executed.  Depending on what level of...

December 15, 2007  5:38 AM

New Article: SQL Server encryption vs. hashing for data security



Posted by: Denny Cherry
Article, Data Types, Development, SQL, SQL Server 2005, SQL Server 2008, T/SQL

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


December 13, 2007  8:00 AM

So what’s the difference between null and a blank field



Posted by: Denny Cherry
Data integrity, Data Types, NULL, SQL, T/SQL

There is always a discussion going on somewhere over having NULL values in a database.  Some people (such as myself) are fine with NULL values.  Some people don't like having NULL values in there database for some reason.  I've heard all sorts of reasons; "The screw up performance", "They are...


December 10, 2007  8:00 AM

Temp Tables, Table Variables, and CTEs



Posted by: Denny Cherry
CTE, SQL, T/SQL, Table Variables, Temp Tables

There are some major differences between temp tables, table variables and common table expressions (CTEs).  Some of the big differences are: Temp Tables vs. Table Variables

  1. SQL Server does not place locks on table variables when the table variables are used.
  2. Temp tables...


November 30, 2007  8:00 AM

New Article: Tricks to increase SQL Server query performance



Posted by: Denny Cherry
Article, T/SQL, Temp Tables

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


November 15, 2007  7:23 PM

New tip published: Update SQL Server table statistics for performance kick



Posted by: Denny Cherry
Article, SQL, Statistics, T/SQL

I've published a new tip over at SearchSQLServer.com entitled Update SQL Server table...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


October 25, 2007  6:03 PM

New tip published about table statistics



Posted by: Denny Cherry
Article, SQL, Statistics, T/SQL

My next tip on SQL Server Statistics has been published on SearchSQLServer.com entitled   Bookmark and Share     0 Comments     RSS Feed     Email a friend


October 24, 2007  5:09 AM

Upgrade for sp_who2 called sp_who3



Posted by: Denny Cherry
DataManagement, sp_who3, SQL, T/SQL

I've published this before over on tek-tips.com, but I figured that I'd republish it here as well.  I've written an update for sp_who2 which I call sp_who3.  It can be most useful when trying to diagnose slow running queries as it can provide a wealth of information in a single...


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: