December 27, 2007 8:00 AM
Posted by: Denny Cherry
Attack Prevention,
Security,
SQL,
T/SQLThe 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 19, 2007 8:00 AM
Posted by: Denny Cherry
Development,
In Person Events,
SQL,
SQL Server 2008The Microsoft Code camp is coming upon us shortly.
I've submitted three sessions (so far) to the organizers of the code camp. They've told me that odds are I'll be able to do all three sessions. I've tagged all my sessions with
December 17, 2007 8:00 AM
Posted by: Denny Cherry
In Person Events,
SQL Server 2008Microsoft has announced the schedule for the SQL 2008 launch event.
You can register here.
The official launch is being held in Los Angeles this time around. I'll be there,...
December 15, 2007 5:38 AM
Posted by: Denny Cherry
Article,
Data Types,
Development,
SQL,
SQL Server 2005,
SQL Server 2008,
T/SQLI've published a new tip over on SearchSQLServer.com entitled "
December 13, 2007 8:00 AM
Posted by: Denny Cherry
Data integrity,
Data Types,
NULL,
SQL,
T/SQLThere 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
Posted by: Denny Cherry
CTE,
SQL,
T/SQL,
Table Variables,
Temp TablesThere 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
- SQL Server does not place locks on table variables when the table variables are used.
- Temp tables...
December 5, 2007 8:00 AM
Posted by: Denny Cherry
Family,
SupportDoing a code freeze at this time of year can be crucial to keeping your sanity this time of year. Often times the business unit likes to push out last minute changes before the year end. This often means pushing last minute code (which as everyone knows isn't always perfect) which can lead...
December 3, 2007 8:00 AM
Posted by: Denny Cherry
Beta,
CLR,
Installation,
SQL Server 2008We'll I've finely gotten around to installing the SQL 2008 November CTP. While walking through the installer I have seen some excellent changes. Not only is the option to change the paths of the data files no longer hidden, there are more than just two options. There are at least 7 paths that...
