May 3, 2013 10:25 AM
Posted by: Denny Cherry
In Person Events,
SQL,
SQL PASS,
SQL Server,
T/SQLAt the upcoming SQL Saturday in Atlanta, GA I have the honor of delivering a precon on database security which has several seats still available.
This precon is a full day session where we will be talking about all the security best practices.
Signing up for the precon is pretty simple, just...
March 27, 2013 2:00 PM
Posted by: Denny Cherry
BIDS,
SQL,
SQL Server,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012,
SSISSo while working with a client recently I was going some performance tuning on SSIS for them. While SSIS isn't exactly my normal workload, the problem wasn't really in SSIS, but just normal SQL Statements being called from SSIS.
While attacking this problem, the first thing that I did was look...
January 9, 2013 9:00 AM
Posted by: Denny Cherry
Avis,
Delta Airlines,
Hilton Hotels,
SQL,
SQL Server,
Travel,
United AirlinesEvery once in a while I put down a few notes designed to help out the new frequent fliers among us. Traveling a lot sucks there is just no getting around that. You are always away from home, you miss your family, and they miss you. You don’t have much of your stuff, and finding the stuff that...
December 12, 2012 2:00 PM
Posted by: Denny Cherry
Database,
Database Administration,
Microsoft Cluster Service,
Microsoft Windows,
MSCS,
SQL,
SQL Server,
SQL Server 2012,
StorageAs we all know by now AlwaysOn Availability Groups are an enterprise edition feature and SQL Server Clustering is a standard edition feature. Butt what happens when you have a small business that is running its apps on SQL Server Express. Can't SQL Express have any sort of high...
December 5, 2012 2:00 PM
Posted by: Denny Cherry
Auto Update Statistics Asynchronously,
Auto Update Stats,
Database,
Database Administration,
SQL,
SQL Server,
Statistics,
TablesA pretty cool feature that was introduced in SQL Server 2008 R2 SP1 is the ability to change the auto stats algorithm from the default of 20%+500 rows to a sliding scale. ...
November 21, 2012 9:00 AM
Posted by: Denny Cherry
Clustered Index,
Data Types,
Database,
Database Administration,
Database Design,
SQL,
SQL Server,
Stored Procedures,
T/SQL,
TablesDuring 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 29, 2012 10:15 PM
Posted by: Denny Cherry
SQL,
SQL ServerWhile preparing for a major disaster is what should be done ahead of time, that's a little...
October 29, 2012 6:33 PM
Posted by: Denny Cherry
SQL,
SQL ServerWith hurricane Sandy dropping into the East Coast of the US this week this is a perfect time to think about DR plans. DR planning isn't something that people should take personally when it is brought...
October 10, 2012 9:00 AM
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,
TablesI 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...
