Featured Article(s)
How to Truncate and Shrink the WSS_Content_log File
You might run into a scenario on your SharePoint development box where the WSS_Content_log file grows to be quite large. If you’re limited on hard drive space and need to know how to truncate and shrink this log file.
A New Approach to Cubing Data Part2: What is Cubing Services
In the first part of this series I discussed some challenges enterprises begine to face as they pursue a BI strategy acnhored around OLAP cubes. That isn’t to say OLAP cubes are bad, I merely presented some considerations that could lead for an new approach to OLAP that could cust costs and increase the quality and trustworthiness of the data. This article introduces you to InfoSphere Warehouse Cubing Services, compliment to any enterprise OLAP strategy. Specifically, you will get a glimpse into what’s behing Cubing Services and the rich toolset that promises to slash the TCO of OLAP, without hurting the benefits OLAP provides.
SelectViews Show – Special Edition!
(135) SelectViews: Special – Optimizing Backup and Restore Performance – Thomas LaRock
[Watch the Show Here]
Last Call – SSWUG Site Focus Group Membership Request
If you’re interested in being part of a SSWUG focus group to review ideas, provide direct input and get some other insider information, please let me know right away – we’re putting together the focus groups now and will be in touch early next week. I’ll need just a few bits of information:
Are you currently a full, paying member of SSWUG.ORG?
Have you attended a SSWUG.ORG vConference?
Are you a full-time or part-time database professional?
Where are you located (Country)? Timezone?
Do you use SKYPE?
There are NO RIGHT or WRONG answers – these just help us keep the groups focused and similar in their use of the site.
Please email your information to me here at the site for consideration.
Thanks for the many, many requests already received – this will be a great way to work closely with everyone going forward with ideas and features and the like.
[Email me your information here please]
Featured White Paper(s)
Aggregating and Pivoting Data
In this excerpt from Chapter 8 of Inside Microsoft SQL Server 2008: T-SQL Querying, Solid Quality Mentors’ Itzik Ben-Gan expl… (read more)
Top Ten Things You Should Know About Optimizing SQL Server
Optimizing SQL Server performance is difficult. There is a lot of information out there, but very little of it is specific o… (read more)