SQL Server with Mr. Denny:

Database


December 12, 2012  2:00 PM

The Least Expensive SQL Server 2012 High Availability Solution



Posted by: Denny Cherry
Database, Database Administration, Microsoft Cluster Service, Microsoft Windows, MSCS, SQL, SQL Server, SQL Server 2012, Storage

As 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

Databases With Large Tables Should Use Auto Stats Async Update Feature



Posted by: Denny Cherry
Auto Update Statistics Asynchronously, Auto Update Stats, Database, Database Administration, SQL, SQL Server, Statistics, Tables

A 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

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


November 17, 2012  2:00 PM

Backup Databases on Creation



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_subdir

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


November 7, 2012  2:00 PM

Passive AlwaysOn Replicas, not as free as you might think



Posted by: Denny Cherry
AlwaysOn, Availability Groups, Clustering, Database, Microsoft Cluster Service, MSCS, SQL Licensing, SQL Server, SQL Server 2012

With the release of SQL Server 2012 and specifically the AlwaysOn feature we need...


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


September 12, 2012  2:00 PM

When clustering guests, host them on different LUNs



Posted by: Denny Cherry
Clustering, Hyper-V, SQL Server, Storage, VMware

When building virtual clusters under any HyperVisor you need to make sure that all the nodes of the cluster are being hosted on different LUNs on the hosts. If you build the VMs on the same LUN and that LUN fails for some reason then both of the nodes of the cluster will be down, and the whole...


September 5, 2012  2:00 PM

The world does not revolve around cloud computing or coding.



Posted by: Denny Cherry
Database, DataCenter, Development, Social Commentary, SQL Server

Back on August 28th another ITKE poster wrote a blog post titled "The elephant not in the room" in which they talk about how if you want to work in IT in the future you better plan on working at one of...


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


August 6, 2012  10:00 AM

Vendor Apps and AlwaysOn Availability Groups



Posted by: Denny Cherry
AlwaysOn, Availability Groups, Database, Microsoft Cluster Service, MSCS, SQL Server, SQL Server 2012, SSMS

By now hopefully everyone knows about AlwaysOn Availability Groups in SQL Server 2012 and the high availability options that they provide to databases.  One problem with AlwaysOn Availability Groups when combined with third party applications is that the third party application may configure the...


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: