March 13, 2013 2:00 PM
Posted by: Denny Cherry
Andre Kamman,
Database,
Database Administration,
DBCC PAGE,
Mladen Prajdić,
Paul Randal,
SQL Saturday,
SQL Saturday 194,
SQL Server,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012,
System Objects,
TablesWhile attending SQL Saturday 194 in Exeter over in England one of the attendees came to Mladen Prajdić, Andre Kamman and myself with an interesting problem. She had a database table which was about 200 Gigs in size which she wanted to...
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...
November 17, 2012 2:00 PM
Posted by: Denny Cherry
Backup & recovery,
BACKUP DATABASE,
CREATE TRIGGER,
Data Loss,
Database,
Database Administration,
DDL Trigger,
Recovery,
SQL Server,
SQL Server 2008 R2,
SQL Server 2012,
T/SQL,
Transactions,
Trigger,
xp_create_subdirOne of the companies which I work with has the occasion to create new databases when they do releases of their software. Normally this isn't a problem, except that they are setup to use maintenance plans to handle the backup and pruning of their transaction logs. As all the new databases are...
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...
August 15, 2012 2:00 PM
Posted by: Denny Cherry
Data Loss,
Data Security,
Database,
Database Administration,
SELECT statement,
SQL Injection,
SQL Server,
Stored ProceduresWhat 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...
August 9, 2012 2:00 PM
Posted by: Denny Cherry
AlwaysOn,
Availability Groups,
Azure,
Data Loss,
Data Security,
Database Administration,
Database security,
Microsoft Windows,
Security,
SQL,
SQL Server,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008,
SQL Server 2008 R2,
SQL Server 2012,
StorageIn case you missed the blog post over on securingsqlserver.com, I wanted to repost it here...
I'm afraid that I've got some bad news. You can no longer pre-order
August 2, 2012 4:00 PM
Posted by: Denny Cherry
Data Encryption,
Data Loss,
Data Security,
Database Administration,
Database Design,
Database security,
Encryption,
Exploit,
Hashing,
Security,
SQL,
SQL ServerThe title of this post pretty much says it all. If you store sensitive data in a database you have to work under the assumption that someone is going to try and break into the system and steal that data. Thinking otherwise simply isn’t responsible as the developer and/or administrator of the...
