Featured Article(s)
Archive your Database
Is your database getting to the size where it is becoming unmanageable for you? Are you running out of time to do maintenance and/or running into places where you may need disk space? Maybe you can Archive your data off.
Interesting Lessons Learned with SQL Server
As we work with different tools, different configurations and such, we are seeing more and more a deeper dependence on vanilla installations for utilities. By this I mean to simply suggest that, as you’re using different tools, make sure you’re very careful about tweaks, modifications and changes in general to your SQL Server – changes that may impact your installation of the tools.
For example, if you have third party encryption tools, make sure your system support this from backup and recovery to managing the keys to decrypting the data. If you’re using tools that help you in your backup, make sure you have configurations that support swapping out the standard backup and recovery with SQL Server for the one you’re installing and using.
If you don’t test, test, test – you can end up surprised, sometimes when it’s too late, that the software or tool isn’t quite working as needed. Just make sure you test both in your development system and in your production system after you take a tool live. It can save you a great deal of heart-ache later. This applies even if a vendor asserts that their tool is ok – always check and test with your specific and particular installation configuration. It’s too important to miss.
SQL Server Show
[Watch] We have some excellent technical guests on the show today – Brian Knight, Matt Masson and Shannon Bray – all talking about what they see in the field, tips and more.
Also Available:
[Watch] Donald Farmer, Jeremy Lowell and Ben Hoelting.
[Watch] Chris Shaw, Daniel Galant, Rachel Appel and Rebecca Isserman
[Watch] Adam Levithan, Vishal Shukla, Sarah Barela and Shannon Callaway.
Featured White Paper(s)
Protecting SharePoint for Windows 5.0
As the distributed workforce grows, the need for online collaboration and document management grows with it. MSFT SharePoint®… (read more)