Featured Article(s)
A Developers Guide to Data Modeling for SQL Server (Book Review)
Books are starting to get a little repetitive. There are the ones that you can count on for the core of your knowledge; there are ones that you use for reference, but what happens when you need a book that teaches you something that may be foreign to you? You want to start from the beginning. A Developers Guide to Data Modeling for SQL Server does just that and more.
SharePoint Needs Monitoring Too
If you’re supporting SharePoint, make sure you grab your free copy of Idera’s Pointcheck – it’s a brand new tool for monitoring your SharePoint, IIS and Windows OS systems – make sure you are aware if things have trouble. Get your copy and you’ll be all set to monitor your systems. It’s free, you can’t go wrong. Get it here.
Office and SQL Server?
Are you using Office with your SQL Server? I ask because I’ve been considering an article or series of articles on doing pivot tables in Excel against a SQL Server database. I get a lot of questions on this when running around, but I don’t know if this is something the "integration team" does at your business. Do you work with your end-users in building out applications that integrate Office and SQL Server?
If you are doing this, have you set up views for your users (and appropriate permissions) so you can both control what they are able to see and make it easier for them to see it?
I think you’ll find that building views for your end-users coming in with Office applications (or other reporting applications) can make a lot of sense because you can take care of rationalizing the tables from your SQL Server, apply security and generally make sure that people are coming into, and using, your SQL Server information in ways you can control. Of course once the data is extracted, you can’t really control how it’s used, but at least you can make sure the information’s original source in your database is well-thought-out and pulls back appropriate information for your users, while protecting your systems and data.
Let me know – are you using SQL Server and Office (or your users any way?)
Featured White Paper(s)
Uncovering a Hidden SQL Server Performance Killer
So youve checked all the likely suspects, but your SQL Server performance is still poor. Before you put that capital request… (read more)
SQL Server Data Protection with Auto Snapshot Manager
This Technical Report describes using Dell EqualLogic Auto-Snapshot Manager V3.0, PS Series groups, and Microsoft SQL Server… (read more)