Profile cover photo
Profile photo
Allen McGuire
229 followers
229 followers
About
Posts

Post has attachment
Using Synonyms with Availability Groups
I'm a big fan of using synonyms to point to objects in other databases, but if you've tried to use them in conjunction with Availability Groups you may have encountered a slight issue: upon failover, the synonyms are no longer valid because the instance nam...
Add a comment...

Post has attachment
Monitor and stop long-running SQL Server Agent Jobs
In recent days I've been having a periodic issue with the distribution cleanup job for replication. The vast of the time it runs in a few seconds.  There are times at night when it may take a few minutes which is not an issue.  But recently I've had a coupl...
Add a comment...

Post has attachment
VMware Host Performance and Configuration Reports
So you are a DBA and you are in a virtual environment - VMware in particular.  You are curious what the health is of the VMware host in terms of CPU and RAM, but you really don't know how to get the data you need and you're not certain if the information yo...
Add a comment...

Post has attachment
SSMSBoost - A Productivity Tool
SSMSBoost - A Productivity Tool
allen-mcguire.blogspot.com
Add a comment...

Post has attachment
SSMSBoost - A Productivity Tool
SSMSBoost Tips and
Trips     ( http://www.ssmsboost.com ) Today I typed up a little "tips and tricks" document for the various teams I work with and figured heck, why not share it with everyone?  As you can see, I had to obfuscate some of the database/conne...
SSMSBoost - A Productivity Tool
SSMSBoost - A Productivity Tool
allen-mcguire.blogspot.com
Add a comment...

Post has attachment
Custom Backup Exec SSRS Report
I'm not a Backup Exec administrator, but recently one of my co-workers wanted a custom SSRS report to track our backups, which also allows him to receive this report on a regular basis via a subscription.  This is what I came up with - perhaps you too will ...
Add a comment...

Post has attachment
Chances are if you've used System Center (SCCM) you'll find that the reports are less than adequate for keeping tabs on software updates in your environment.  Because of that, I decided to author a couple of Reporting Services (SSRS) reports...
Add a comment...

Post has attachment
Custom System Center Reports for Windows Updates
Chances are if you've used System Center (SCCM) you'll find that the reports are less than adequate for keeping tabs on software updates in your environment.  Because of that, I decided to author a couple of Reporting Services (SSRS) reports to inform me wh...
Add a comment...

Post has attachment
Evergreen Campground
Evergreen Campground
campfirereviews.com
Add a comment...

Post has attachment
Work Smarter, Not Harder - The UTILITY Instance
If your a SQL Server DBA, chances are you've walked into environments that were pretty disorganized to say the least.  Nobody seems to have a complete list of SQL Server instances, the instances are not configured consistently, database recovery models and ...
Add a comment...
Wait while more posts are being loaded