SQL Server with Mr. Denny:

SQL Server


January 13, 2016  7:00 PM

Creating a cluster without Domain Admin permissions

Denny Cherry Denny Cherry Profile: Denny Cherry
Cluster, Cluster management, Clustering, Clustering/High availability, Clusters, SQL Server, SQL Server availability

If you've ever watched a presentation when someone sets up a cluster you've probably noticed that it goes pretty smoothly. The reason for this is because the account which the presenter uses is a domain administrator. But what about the real world? In the real world unless you are a systems...

January 5, 2016  4:51 PM

2015 By The Numbers

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server

This post is a little later than normal. It's been a very busy few weeks with family over until the 3rd of January. Well 2015 was a hell of a year for my blogging. I recorded just under 250k page views (244,305) which isn't even all of them (2016 will be the first year that I get a truly...


December 23, 2015  9:00 AM

Introducing Microsoft SQL Server 2016 ebook (Preview Edition)

Denny Cherry Denny Cherry Profile: Denny Cherry
eBook, SQL Server, SQL Server 2016

I'm pleased to report that what is probably one of the first books on Microsoft SQL Server 2016 has been released, or at least the


December 16, 2015  5:00 PM

Get Operation Status of an Azure Async Operation

Denny Cherry Denny Cherry Profile: Denny Cherry
Azure, Powershell, PowerShell Scripts, SQL Server, Windows Azure

Recently I was trying to make a drive bigger on an Azure VM by simply using Set-AzureOSDisk PowerShell commandlet (and the -ResizedSizeInGB switch). The problem is that this command is asynchronous meaning that it tells you that it's done, even if it hasn't finished yet. The problem with this,...


December 3, 2015  4:05 PM

Announcing Internals for Query Tuning Training Class By Kalen Delaney

Denny Cherry Denny Cherry Profile: Denny Cherry
DBA training, IT training, SQL Server, Training

We at Denny Cherry & Associates Consulting are thrilled to announce that we have partnered up with the SQL Server internals guru Kalen Delaney to deliver training classes.  Our first class will be Internals...

0 Comments     RSS Feed     Email a friend


December 2, 2015  2:00 PM

DR Planning in Azure Requires More Than Replicating VMs to Another Data Center

Denny Cherry Denny Cherry Profile: Denny Cherry
Disaster planning, Disaster Recovery, Disaster recovery planning, SQL Server

While flipping through the Microsoft Azure website recently I ran across this page which talks about HA/DR configurations for SQL Server VMs. Seeing...


November 25, 2015  4:00 PM

Inline Nonclustered Indexes

Denny Cherry Denny Cherry Profile: Denny Cherry
Index, SQL Server, SQL Server Indexes

One of the new features that I just recently learned about in SQL Server 2014 is the ability to create nonclustered indexes on a table inline with the creation of the table. This is handy in a couple of...


November 21, 2015  12:06 AM

Recommended reading from mrdenny for November 20, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.


November 18, 2015  2:00 PM

I Don’t Want To Create Indexes Because It Will Slow Down My Application

Denny Cherry Denny Cherry Profile: Denny Cherry
Indexes, SQL Server, SQL Server Indexes

"I Don't Want To Create Indexes Because It Will Slow Down My Application." I hear that argument all the time from software developers at clients when I tell them that we need to create indexes. This is usually followed up by "If we add indexes it will slow down the INSERT, UPDATE and DELETE...


November 11, 2015  4:00 PM

The Dangers of Indexing Temp Tables

Denny Cherry Denny Cherry Profile: Denny Cherry
Data Tables, SQL Server, SQL Server tables, TempDB, Temporary files

Indexes are good, except when they aren't. Everything that you do in SQL Server has trade offs. Usually those tradeoffs are easy to see, unless they aren't. Indexes are generally a good thing. They make performance of queries within the database engine go faster, often a lot faster. Indexes on...


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: