SQL Server with Mr. Denny:

SQL Server 2005

1

April 12, 2016  4:00 PM

And with that, SQL 2005 is out of support

Denny Cherry Denny Cherry Profile: Denny Cherry
performance tuning, SQL Server, SQL Server 2005

As of today (April 12, 2016) Microsoft no longer supports SQL Server 2005. If something goes wrong with your SQL 2005 database server at this point, there's not going to be anyone at Microsoft who can help...

March 2, 2016  4:00 PM

Now is time to upgrade your SQL 2005 Servers

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

Time is running out for your SQL Server 2005 instances.  In just a few short weeks SQL Server 2005 support from Microsoft will be ending.  This means that it's time to get those servers


October 7, 2015  4:00 PM

Basic Database Mirroring Monitoring

Denny Cherry Denny Cherry Profile: Denny Cherry
Database mirroring, Disaster Recovery, DR, High Availability, Monitoring, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

If you have database mirroring setup and running, you'll notice that it has a lack of built in monitoring. And if you have a lot of databases having monitoring for each potential state that each database can be in can flood you with email if the network between sites goes down and comes back up. ...


May 22, 2015  5:49 PM

Recommended reading from mrdenny for May 22, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
CDC, SQL Azure, SQL Server, SQL Server 2005, VMware vSphere, Windows Azure

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


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


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


April 20, 2009  11:00 AM

Yes DBAs you really do have to deal with licensing

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

Probably one of the least fun things about being a DBA is having to deal with the licensing of SQL Server. Continued »


1

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: