SQL Server with Mr. Denny:

Stored Procedures

1

May 22, 2013  2:00 PM

The Optimizer Isn’t As Smart As You Might Want It To Be



Posted by: Denny Cherry
Database, Database Design, Index Performance, Performance, Performance Problems, Problems, SELECT statement, SQL Server, SQL Server 2008 R2, Stored Procedures, T/SQL, Tables

A little while back I got one of those phone calls.  You know the one, the lovely 6am phone call about random performance problems.  There were two...

May 15, 2013  2:00 PM

Error Handeling and DBCC CHECKDB



Posted by: Denny Cherry
Database Administration, Error Message, ERRORLOG, SQL Server, SQL Server stored procedures, Stored Procedures

A client that I've been working at for a while needed to start doing DBCC CHECKDBs on their production server.  We hadn't been for a little...


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


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


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


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 »


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: