SQL Server with Mr. Denny:

SQL Server


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


November 5, 2015  11:55 PM

Congrats to Our PASS Booth Prize Winner

Denny Cherry Denny Cherry Profile: Denny Cherry
IT conferences and events, SQL Server

We have done our raffle for the PASS 2015 Consultants Corner prize, which is a $1000 Amazon gift card. Our winner this year is ... David Sun from MasterCard. (We actually did the drawing a few days ago, but being that David works for a large company there was a lot of checking to be done...


November 4, 2015  4:00 PM

In Azure CApS MatTers

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

Recently I was doing some work for a client moving some vDisks from standard storage to premium storage. Overall it was a pretty easy migration to do, just requiring a little PowerShell to make it all happen. The part that made it hard to get done is that the PowerShell parameters for file...


October 28, 2015  4:00 PM

My Experience Moving WordPress From @GoDaddy to @Azure

Denny Cherry Denny Cherry Profile: Denny Cherry
Azure, SQL Server, Web hosting, Web hosting providers

leakRecently I got fed up with the lack of...


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: