SQL Server with Mr. Denny:

SQL Server


January 14, 2015  5:00 PM

Monitoring SQL Replication Latency

Denny Cherry Denny Cherry Profile: Denny Cherry
Database replication, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server Distributor

When working with SQL Server replication, you don't have a whole lot of options for monitoring the latency of the replication. You've got the SQL Server Replication Monitor, and that's basically it. Well there is another option. You can manually run the code that the replication monitor uses to...

January 9, 2015  4:00 PM

Recommended reading from mrdenny for January 09, 2015

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

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


January 7, 2015  5:00 PM

If I have a filtered index, what do I need to have in my query to make SQL use it?

Denny Cherry Denny Cherry Profile: Denny Cherry
Database index strategy, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Filtered indexes are great, because they let you exclude rows from the index. But what do you need to include in your where clause to use the filtered index? The answer here is surprisingly straight forward. You need to use the exact same where clause value in your queries where clause as is...


January 2, 2015  10:08 PM

Recommended reading from mrdenny for January 02, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
Reporting Services, SQL, SQL Server, Windows 10

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


December 31, 2014  4:00 PM

2014 By The Numbers

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

2014 was another great year for my blog. This year I passed by


December 26, 2014  7:09 PM

Recommended reading from mrdenny for December 26, 2014

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


December 24, 2014  5:00 PM

What’s the Best Upgrade Path from SQL 2005 to SQL 2014?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server upgrades, Upgrades

I get this question a decent amount in my Intro to SQL Server Management Session (called "I've got a SQL Database Now What?" or "SQL Server Management for the non Database Administrator"). Frankly it doesn't really matter. As long as you attach the database to a SQL Instance that is somewhere...


December 19, 2014  6:13 PM

Recommended reading from mrdenny for December 19, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL, 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...


December 17, 2014  5:00 PM

Farewell TechEd

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server, TechEd

Last month I had the privilege of speaking at what is supposed to be the last Microsoft TechEd conference at TechEd Europe 2014. I've been lucky enough to speak at both the North American and European Microsoft TechEd events for a few years now, having spoken at the 4 most recent TechEd North...


December 12, 2014  4:58 PM

Recommended reading from mrdenny for December 12, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Database migration, 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...


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: