SQL Server with Mr. Denny:

Storage


February 19, 2014  2:00 PM

Old vSphere, Large VMs, and Some Really “Funky” Problems



Posted by: Denny Cherry
SQL, SQL Server, Storage, vCenter, Virtualization, VMware, vSphere 4.1, vSphere 5.0, Windows 2008 R2

[caption id="attachment_3110" align="alignright" width="346"]RAM Chips Courtesy...

December 18, 2013  2:00 PM

Encryption and Compression



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Data Loss, Data Security, Database, Database Administration, Database security, Indexing, Security, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, Storage, Tables

We have a variety of options when it comes to compression and encryption in SQL Server. When using both compression and encryption you...


October 16, 2013  2:00 PM

Replication and VLFs



Posted by: Denny Cherry
Database, Replication, SQL Server, SQL Server 2008 R2, Storage, System Objects, Transaction Log

Every once in a while you run across a problem that shouldn't be causing people as much problems as it is, yet there it is causing all sorts of problems for long...


August 21, 2013  2:00 PM

Back To Basics: Files, File Groups and Disks



Posted by: Denny Cherry
Back To Basics, SQL Server, Storage

SQL Server has three different storage terms which you need to know when dealing with physical file storage.  These...


July 3, 2013  7:00 AM

Backups & the Buffer Pool



Posted by: Denny Cherry
Back To Basics, Backup & recovery, BACKUP DATABASE, SQL Server, Storage

    As we know with Microsoft SQL Server everything is processed from disk and loaded into the buffer pool for processing by the query engine.  So...


May 1, 2013  2:00 PM

I’m using simple recovery, so the log file isn’t important right?



Posted by: Denny Cherry
Bulk Logged Recovery Model, Database Administration, Full Recovery Model, Manageability, Recovery Model, Simple Recovery Model, SQL Server, Storage, Transaction Log

One of the big myths of SQL Server resolves around the transaction log, and how it's used with the simple recovery model. Many people think that...


January 16, 2013  2:00 PM

Pleased to Announce That I’m an EMC Elect Award Winner for 2013.



Posted by: Denny Cherry
EMC, EMC Elect, MVP Summit, SQL Server, Storage

I'm pleased to announce that I'm adding another IT award to my collection.  EMC has created an award program which is designed to


December 19, 2012  2:00 PM

Moving a Sharepoint Site Between Farms With Different Templates



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Database, PowerShell, SharePoint, SharePoint 2012, SQL Server

A client came to be with a pretty scary problem.  Their SharePoint site was totally down.  The databases were there but the actual SharePoint farm was totally dead.  All of the SharePoint tools said that the farm wasn't configured yet so there were some pretty big problems.  Thankfully they had...


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


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


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: