Featured Article(s)
Corporate Computing Models
All businesses small and large, must manage the company data in a fashion that allows the business to run smoothly. Some business might use filling cabinets to manage their data, but most companies choose to use computerized database management systems that efficiently store, retrieve and manage large amounts of data. If your company works with computers, then there is no doubt that you have heard the terms such as database database server and client/server what exactly are meaning of these terms and why an understanding of this is so important in the information systems industry? To study about this let us first go through the evolution of computing models.
SelectViews Show Posted
SelectViews: Interview Series, Dr. Neil Roodyn – Microsoft MVP and Regional Director. We talked about where development is headed, tools and ideas. Also, talked about different ideas for interface development, development methodologies and more.
[Watch the Show]
Looking for Experiences and Feedback
Are you using the FileStream option new to SQL Server 2008? I ask because if you follow the newsgroups, you’ll see that people continue asking about, blogging about and trying to understand the storage of unstructured objects (you know, word documents, PDF files, graphics) in SQL Server.
For years the suggestion was always to just store the object on disk, then store a pointer (the url or file name and directory) in the database. More work, not included in the database, but it worked around some limitations in SQL Server, both things that it simply didn’t do (objects over a certain size) or was not optimized to do (working with the unstructured info).
Now, with the FileStream approach, you can store these objects within SQL Server. The catch is that they’re still stored separately on disk, outside the database. One additional item – if you’re using encryption at the database level, this encryption is not applied to the object stored on disk. If you have sensitive documents, you’ll have to manage and control both access and use another way.
But, what I’m really curious about – are you using this feature yet? Planning to? Thought about it? Want to hear more?
Do You Use Microsoft Office?
We just posted two new video shows to our sister site, OfficeUsers.org. They summarize articles, provide tips and get you the latest information in under 8 minutes.
Show 1 – Easy macros in Excel, Word redaction tools and more
Show 2 – Vista compatibility, Using Excel and Access for "database" jobs and other tips
Check it out – they’re open access for everyone.
Featured White Paper(s)
MS SQL Server – An Overview
Whether you’re running a small business that’s ready to take the next step in its growth or an SMB that’s ready to “grow into… (read more)
EMC Long Distance Recovery for SQL Server 2005 Reference Architecture
Read Long Distance Recovery for SQL Server 2005 and learn about this data recovery solution which was developed in partnershi… (read more)