Reluctant DBAs are those of us who aren’t formally trained in database administration, but manage through a combination of our wits, technical manuals, and online forums. This crash course will explore best practices for installing, configuring, and maintaining Microsoft SQL Server, and highlight some SQL Server features (and Easter eggs) that can improve your user …
Category :Database Administration
Auditing User Security Profiles
Once you have conceptualized and named your security groups and created them in the Database Configuration tool, it’s time to apply them to your userbase, and apply them consistently. Here is a Crystal Report that you can use to see users organized by security group and department. It’s a useful tool for being able to …
It’s 11PM – Do You Know Where Your Backups Are?
So it was the Friday before the Memorial Day weekend, and before leaving for the day I decided to follow my own advice and check my backup solution to ensure it was functioning properly. I’m glad that I did, because it had been silently failing for over a week. Now that it has been fixed …
TMS as a Remote Application
In a day and age when institutions are looking for ways to tighten the belt, network administrators are looking for ways to work smarter and reduce information systems infrastructure. Imagine being able to deploy TMS to multiple venues, while reducing maintenance costs and downtime, improving connectivity and facilitating end-user support. This presentation explores how the …
Happy Memorial Day
Today is officially the start of summer – so while you are enjoying your day off (Happy Memorial Day to you) and thinking towards your much deserved vacation, I’d like you to take a moment to think about something that never gets a day off or a vacation: your automated backup solution.