SQL Server with Mr. Denny:

November, 2012

1

November 30, 2012  2:00 PM

Altaro gives away 50 free PC backup licenses to all Microsoft Hyper-V administrators



Posted by: Denny Cherry
Altaro

Altaro Software, a fast-growing developer of backup solutions for Microsoft Hyper-V, today announced that it is giving every Microsoft Hyper-V administrator 50 free licenses of Oops!Backup, their desktop...

November 28, 2012  2:00 PM

Why More People Should Be Working From Home



Posted by: Denny Cherry
Social Commentary, SQL Server

As database professionals there isn't much of a reason that we actual need to go into the office, other than to make other people in the office feel better because we are actually there in person.  In practice we don't ever need to actually touch the physical hardware.  Meeting can easily enough...


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  5:52 PM

SQL PASS Day 1 Keynote



Posted by: Denny Cherry
AlwaysOn, Availability Groups, SQL PASS, SQL PASS 2012, SQL Server, SQL Server 2012

Today was the 1st day of the SQL PASS Summit and the keynote was full of some great announcements and demos.  The keynotes are a massive with almost all of the 3894 conference attendees from 57 different countries.

All of the keynotes from this years conference not only are the...


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


November 1, 2012  6:17 PM

Lugging fuel up stairs shouldn’t have been needed



Posted by: Denny Cherry
AlwaysOn, Data Loss, DataCenter, Distaster Recovery, Recovery, SQL Server

While I applaud the hard work and ingenuity of the sysadmins who works through the days after hurricane Sandy to keep the generators running, one thing kept coming to my mind.  Why...


November 1, 2012  1:00 PM

You aren’t going to want to miss #sqlkaraoke at the #sqlpass #summit12.



Posted by: Denny Cherry
SQL Karaoke, SQL PASS, SQL PASS 2012, SQL Server

Like every year at Bush Garden in the international district of Seattle, WA the SQL PASS community will descend onto Bush Garden at 9:30pm Wednesday night...


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: