I have a requirement to add the Log Shipping Monitor for an existing installation. I have heard you can only complete this by rebuilding the Log Shipping infrastructure. Is that true? Are there any other options? In this tip I will explain how we can add the Log Shipping monitor to a SQL Server 2005, 2008, 2008 R2 or 2012 environment without rebuilding the Log Shipping installation.
Defaults are important since so many people just accept them. Steve Jones thinks that SQL Server needs to add more defaults to the setup program that might help DBAs better manage their systems.
Instructions on how to set up the connection string and SSIS package to allow a 64 bit server to export to a 32 bit version of Excel
Get a free ebook from Red Gate Software and SQLServerCentral from MVP Grant Fritchey. Learn how to read and interpret execution plans.
With Report Builder and SSMS, there isn't much you can't do in the way of the common reports and visualisations. One of the more interesting visualisations uses maps, and that, combined with layers, makes for an impressive way of representing data.
Microsoft is asking for feedback, more and more from customers. Steve Jones sees that as a good thing.
The idea of moving to the cloud is scary, but it will happen for many of us. If not at this job, perhaps at the next. Learning more about the cloud is something Steve Jones thinks you should consider.
How to reset an identity field to the next contiguous value, after deletions.
I have to support a third party application that periodically creates a new database on the fly. This obviously causes issues with our backup mechanisms. The databases have a particular pattern for naming, so I can identify the set of databases, however, I need to make sure I'm always backing up the newest one. Read this tip to ensure you are backing up your latest database in a series.
A free day of training in the US nation's capital. Come join in if you are nearby.
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Comments posted to this topic are about the item Removing TDE
Comments posted to this topic are about the item The day-to-day pressures of a...
How do I remove TDE encryption of data from database xxx?
See possible answers