SQL Server with Mr. Denny:

Data Types

1

November 21, 2012  9:00 AM

Fixing a table that has overflowed its primary key



Posted by: Denny Cherry
Clustered Index, Data Types, Database, Database Administration, Database Design, SQL, SQL Server, Stored Procedures, T/SQL, Tables

During TechEd Europe I got a very scary phone call.  A very large table was throwing errors that the value being inserted into the primary key column was overflowing the data type that makes up that column.  In this case the data type in question was INT, so we were trying to stick the number...

October 10, 2012  9:00 AM

Encrypting data in the same column



Posted by: Denny Cherry
Data Encryption, Data Loss, Data Security, Data Types, Database, Database Administration, Database Design, Database security, Encryption, Identity theft, Security, SQL, SQL Server, SQL Server stored procedures, Stored Procedures, T/SQL, Tables

I wrote a little while ago about the fact that sensitive data needs to be encrypted within the database for all applications.  This is the first technique that is available to you to encrypt data...


October 11, 2010  11:00 AM

Using the wrong data type can have same major problems.



Posted by: Denny Cherry
Data Types, SQL Server

Apparently this weekend a small company which does something very important discovered the upper bounds of the INT datatype (or the equivalent in what ever database platform they are using).  This makes it very clear that whoever designed the database for them...


January 7, 2008  8:00 AM

XML in the database. What’s the big deal any way?



Posted by: Denny Cherry
Data Types, T/SQL, XML

So, we've had the ability to use XML within the SQL Server databases since SQL 2000 came out.  What's the big deal you ask?  How can I use it to make my life easier you also ask? When I first started looking into this whole XML thing I was thinking the same thing.  How is this blob of data...


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


November 28, 2007  7:38 AM

What’s up with the N in front of string values?



Posted by: Denny Cherry
Data Types, SQL, Uni-code

If you have looked at pretty much any Microsoft provided T/SQL code you have probably seen an N in front of a string value when setting a variable much like this. SELECT * FROM...


November 26, 2007  7:35 AM

Should I be using uni-code data types?



Posted by: Denny Cherry
Data Types, SQL, Uni-code

The path that Microsoft is going says yes.  They are moving all there samples and defaults to using uni-code.  In reality uni-code may not be needed in your environment.  If you are storing only Latin characters (the US alphabet characters) then you probably don't need to store uni-code...


1

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: