Mark Polino's Blog, page 290
December 8, 2011
Dynamics Confessor Blogspot: Demystify Monthly Maintenance Routines Transcript
Leslie Vail has a transcript of questions from her Demystify Monthly Maintenance Routines presentation at Decisions Fall 2011.
The Consultant Identity: Can Your Microsoft Dynamics GP Pro Deliver? | MSDynamicsWorld.com
My new article on The Consultant Identity: Can Your Microsoft Dynamics GP Pro Deliver? is up now at MSDynamicsWorld.com.
I'm a consultant so I pick on consultants. What do you expect?
Weekly Dynamic: SQL Script to Monitor Transaction Log Backups
We see a surprising number of huge transaction logs in clients who should know better. This commonly happens when transaction logs are not being backed up regularly and the database is running in Full recovery mode. If the log grows large enough, SQL Server can stop working leading to a lot of excitement.
Typically, this solved with a properly setup maintenance plan in SQL Server but what if that's not the case? What if the maintenance plan is failing and not providing notifications? Short of regularly monitoring transaction log growth, how can a DBA ensure that logs are being properly truncated?
Thanks to the MSSQLTips site, we've now got this SQL Script designed to show any databases in Full or Bulk-Logged recovery model that have had a full backup without any subsequent transaction log backups.
SELECT
D.[name] AS [database_name], D.[recovery_model_desc]
FROM
sys.databases D LEFT JOIN
(
SELECT BS.[database_name],
MAX(BS.[backup_finish_date]) AS [last_log_backup_date]
FROM msdb.dbo.backupset BS
WHERE BS.type = 'L'
GROUP BY BS.[database_name]
) BS1
ON D.[name] = BS1.[database_name]
LEFT JOIN
(
SELECT BS.[database_name],
MAX(BS.[backup_finish_date]) AS [last_data_backup_date]
FROM msdb.dbo.backupset BS
WHERE BS.type = 'D'
GROUP BY BS.[database_name]
) BS2
ON D.[name] = BS2.[database_name]
WHERE
D.[recovery_model_desc] <> 'SIMPLE'
AND BS1.[last_log_backup_date] IS NULL OR BS1.[last_log_backup_date] < BS2.[last_data_backup_date]
ORDER BY D.[name];
This script returns database names and recovery models allowing administrators to dig deeper into the underlying problem. Running this script is much easier than monitoring transaction log growth and it can save a lot of pain and expense by helping keep the size of log files manageable.
More information on this script and similar scripts is available from MSSQLTips.com
Originally Posted by Mark at 1/11/2010 09:00:00 AM 
December 7, 2011
The Dynamics GP Blogster: The Dynamics GP Blogster's YouTube Channel launches with Decisions Fall 2011
Mariano is launching The Dynamics GP Blogster's YouTube Channel with Decisions Fall 2011
Find out more about the Support Debugging Tool from Mariano's videos.
Microsoft Dynamics GP Year End Release 2011 – Analytical Accounting Year End Close - Dynamics GP Support and Services Blog
The Microsoft Support and Services blog continues their look at year end with Analytical Accounting Year End Close
How to Lose Your LIFO Preserver
CFO.com looks at the impact of the loss of LIFO inventory valuation with IFRS. Fortunately Dynamics GP maintains the cost layers throughout so it's possible to switch from LIFO to something else.
December 6, 2011
Hidden total cost of public cloud ownership–CFO.com
One of the interesting things I learned at last year's GPUG Summit (2010) was that a number of people were looking at cloud deployments because they were unhappy with IT an wanted them out of the mix.
Well, the cloud is all the rage and it certainly has some areas where it's a great fit. CFO's have to deal with additional considerations when deciding whether moving to the cloud is the right answer. Currently CFO.com has a look at the Hidden total cost of public cloud ownership.
It's worth a read to make sure that you are taking a 360 degree look at your business when considering ANY solution.
GPUG Summit 2011 Presentations
For those of you looking for GPUG Summit 2011 presentations, you can find them at
http://www.dynamiccommunities.com/summit2011/GPUG/presentations.html.
All of my presentations are also available on the home page of DynamicAccounting.net.
