Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

Stored Procedures

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

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

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

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

August 15, 2012  2:00 PM

Old Web Based Applications Need To Be Removed



Posted by: Denny Cherry
Data Loss, Data Security, Database, Database Administration, SELECT statement, SQL Injection, SQL Server, Stored Procedures

What happens to most obsolete web based applications at most companies?  They sit idle on a web server for months, sometimes years.  Why is this a problem? Because many of these old applications can be easily exploited via SQL Injection allowing access into the SQL Server databases which they...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

September 26, 2011  11:00 AM

SQL In The City is comming



Posted by: Denny Cherry
In Person Events, SQL Server, Stored Procedures

RedGate's SQL In The City is coming to the amazing Skirball Center in Los Angeles just a couple of weeks after the PASS summit.  This is a great change to see some great presentations giving by some of the top speakers in the SQL...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

September 11, 2009  7:43 AM

South Bay .NET User Group, thanks for having me over.



Posted by: Denny Cherry
Extended Stored Procedure, In Person Events, Indexing, South Bay .NET User Group, Stored Procedures

Tonight I spoke at the South Bay .NET User Group.  I had a blast talking with them.  They are a great group of programmers. Continued »

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1