SQL Server with Mr. Denny:

SQL Server


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


October 21, 2015  4:00 PM

The MERGE and large data sets

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server

Recently I was doing some work at a customer and they were having some performance problems with their ETL into their data warehouse (see I do know at least some BI). One of the steps which was taking a long time was a MERGE statement which was updating existing rows and inserting new rows. The...


October 16, 2015  8:21 PM

Recommended reading from mrdenny for October 16, 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. PASS Elections: Fuzzy Math Getting data into Azure Blob Storage


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: