SQL Server with Mr. Denny:

SQL Server 2012


January 28, 2015  5:00 PM

Random Unexplained Replication Job Failure in a large SQL Server Replication Topoligy

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

One of the environments that I work with includes a very large replication topology. While there are only a few servers involved there are dozens of publications between those servers. One of the problems that replication has is that it can only run so many agents at a time. Now remember that...

January 21, 2015  7:00 PM

Reducing Locking by “Distribution clean up” Job

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

Anyone who has had to manage a large SQL Server replication environment has had to deal with strange locking within the distribution database. This is because the distribution database is basically a giant named value pair database which has a TON of jobs inserting, updating, querying and deleting...


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


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


May 28, 2014  3:53 PM

SQL Server 2014 Licensing

Denny Cherry Denny Cherry Profile: Denny Cherry
Microsoft licensing, SQL, SQL Server, SQL Server 2012, SQL Server 2014, SQL Server licensing

I've gotten a lot of questions about SQL Server 2014 licensing. The good news is that nothing has really changed since SQL Server 2012. There's some minor wording changes to make it more clear what you have to purchase to get free secondary servers when using Clustering or AlwaysOn Availability...


May 23, 2014  6:21 PM

Recommended reading from mrdenny for May 23, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Recommended reading, SQL Server, SQL Server 2012, SQL Server 2014

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 13, 2013  2:00 PM

Old Versions of SQL Server On New Hardware Can Be Interesting

Denny Cherry Denny Cherry Profile: Denny Cherry
NUMA, SQL Server, SQL Server 2008, SQL Server 2012

Recently a friend was working on one of his clients SQL Servers and he ran into an interesting problem. The hardware in question was a HP DL 580...


November 10, 2011  2:00 PM

More SQL Server 2012 Licensing Info

Denny Cherry Denny Cherry Profile: Denny Cherry
Microsoft licensing, SQL Server, SQL Server 2012, SQL Server licensing

So as a followup to My SQL Server 2012 licensing blog post I wanted to follow up on what exactly is a core license good for. When working in the physical world it's pretty easy to figure out. ...


November 3, 2011  5:06 PM

SQL Server 2012 Licensing Changes

Denny Cherry Denny Cherry Profile: Denny Cherry
Microsoft licensing, SQL Server, SQL Server 2012, SQL Server licensing

So you may have heard earlier today about the license changes that are coming out for SQL Server 2012.  I know that the official announcement can be a little hard to get through and the changes can be a little confusing at first (or even second or third) glance.  The SQL Server licensing team was...


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: