Still Time To Register For Internals for Query Tuning
Profile: Denny Cherry
There is still time to register for the fantastic class 
0 Comments
RSS Feed
Email a friend
Basic Database Mirroring Monitoring
Profile: Denny Cherry
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. ...
0 Comments
RSS Feed
Email a friend
Buffer Pool Extension File Location
Profile: Denny Cherry
If you are planning on using Buffer Pool Extension (BPE) in SQL Server 2014 or SQL Server 2016 you need to think about where you want to put the BPE file on the SSD, especially as it relates to the Windows OS Security on the file system. The most important think to remember when placing the BPE...
0 Comments
RSS Feed
Email a friend
Random Unexplained Replication Job Failure in a large SQL Server Replication Topoligy
Profile: Denny Cherry
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...
0 Comments
RSS Feed
Email a friend
Reducing Locking by “Distribution clean up” Job
Profile: Denny Cherry
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...
3 Comments
RSS Feed
Email a friend
Monitoring SQL Replication Latency
Profile: Denny Cherry
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...
0 Comments
RSS Feed
Email a friend
If I have a filtered index, what do I need to have in my query to make SQL use it?
Profile: Denny Cherry
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...
0 Comments
RSS Feed
Email a friend
What’s the Best Upgrade Path from SQL 2005 to SQL 2014?
Profile: Denny Cherry
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...
2 Comments
RSS Feed
Email a friend
Recommended reading from mrdenny for October 24, 2014
Profile: Denny Cherry
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this...
0 Comments
RSS Feed
Email a friend
Recommended reading from mrdenny for October 10, 2014
Profile: Denny Cherry
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this...
0 Comments
RSS Feed
Email a friend
