SQL Server with Mr. Denny:

ITKE grandparent


February 13, 2015  11:56 PM

Recommended reading from mrdenny for February 13, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server

Happy Friday the 13th.  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.

February 11, 2015  4:00 PM

The New Nimble Caching Algorithm is Awesome

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I've been working with a client who has been having some performance problems with their Nimble array for...


February 7, 2015  5:17 AM

Recommended reading from mrdenny for February 06, 2015

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

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


February 4, 2015  5:00 PM

No, I Will Not Be Using Your “Secure” Email System

Denny Cherry Denny Cherry Profile: Denny Cherry
Adobe security, Consumer confidence, Document retrieval, IT security, SQL

I get the occasional email with some attachment, that I then have to log into some "secure" system...


January 30, 2015  6:10 PM

Recommended reading from mrdenny for January 30, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL, SQL Server, SQL Server 2005, Windows Server 2003

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


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 24, 2015  6:46 AM

Recommended reading from mrdenny for January 23, 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 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 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...


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: