Check Out the SSWUG SQL Server Virtual Conference
No travel, no hotel rooms, 4 simultaneous tracks, more than 30 sessions 11 speakers. This is NOT what others call "virtual conferences" — it’s a full event with direct access to speakers for questions, demonstrations, real presentations with full video feeds of the speakers, their demonstrations, slides and them presenting and discussing the materials. It’s coming June 24, 25, 26. Get registered today!
Featured Article(s)
Stop Unnecessary Job Failures using Dynamic Holiday Functions
Many times jobs should not run on holidays and fail as a result. For all of us on call DBA’s, that leads to unnecessary phone calls and alerts. Here are some dynamic functions you can implement to avoid the job failures.
About Those SharePoint Installations – Tips!
Allison: "DBA’s should not be scared of SharePoint but rather try to learn as much as possible about the architecture and functionality of the entire system. I’ve been working with it for about 5 years now as both a DBA and SharePoint Administrator, have a SharePoint MCTS, and find that it is extremely helpful when it comes to troubleshooting and everyone is pointing fingers at SQL.
The number one thing to remember is MS does NOT support any changes made directly in the database schema. I believe the real reason is that service packs and hot-fixes will often make changes to the databases. If you do need to query anything from a SharePoint database always use the NOLOCK hint. Do not believe developers when they say they need direct database access. Any data they may need is available via the SharePoint API, they just have to learn how to code against it.
Size wise we try to keep our content databases under 100G primarily for maintenance and DR efficiency.
MS Support
My maintenance and best practices bible.
[Also,] Bill Baer is a good guy to check out if you have problems."
Mary: "I wish someone would have informed me that the Sharepoint SQL install needed additional collation settings defined (see pic below if needed). You need to add Accent-sensitive, Kana-sensitive and Width-sensitive to the collation during install or you will need to reinstall SQL."
Featured White Paper(s)
Get in the Groove With SQL Server Consolidation
Is your business a victim of SQL Server sprawl? In Quests new white paper, Get in the Groove With SQL Server Consolidation, S… (read more)
Whole Server Protection from a Single Solution
The complexity of traditional recovery solutions compounds an already difficult situation, and heightens the opportunity for … (read more)