Featured Article(s) Tips for using SQL Server 2008 indexed views Here you can find some useful tips to use SQL Server 2008 indexed views. SharePoint Performance Troubleshooting SharePoint Performance can be tough to troubleshoot. There are SO many variables! If you’ve found a great series of things you’re watching with SharePoint, you know that performance challenges can take many shapes. […]
Author: Stephen Wynkoop
Interesting Article about SQL Azure
Free Webcast: Understanding the new culture of SharePoint You have a sponsor for SharePoint development, you have a budget, now where are all the users? Online Collaboration powered by SharePoint is not only a new technology, but a new culture of doing work. In this session we’ll explore change management (the fluffy kind) strategies that can be tailored to your […]
PowerPivot Experiences with SQL Server
How Do YOU Find Bottlenecks for Performance? Figuring out what is causing the biggest drains on performance means you need to be able to see information about queries, execution times, resources and more. Getting this information on your own is, well, tough. When you realize that you have to be able to pull this information historically, as well as what’s […]
SSWUG.ORG Ultimate Virtual Conference – Fall 2010
Announcing: SSWUG.ORG Ultimate Virtual Conference – Fall 2010 Forget about travel, hotel rooms, rubber chicken dinners and being out of office for a week… we’re bringing top presenters, top content and outstanding vendor information directly to you – LOTS of it! I’m excited to announce that we’ve opened early-bird registration for the Fall Virtual Conference. We have a tremendous lineup […]
Last Thoughts on Indexing
Featured Article(s) DBA Learning Strategies (Part 1 of 4) DBA learning strategies: how we are going to take what you need to know and find out how you are going to learn it and then put that into practice. And this is just like anything else. It is a matter of discipline. Webcast: Using Log Shipping for High Availability Log […]
Database Maintenance (and Shrinking)
Featured Article(s) DTS Conversion to SSIS (Part 3 of 4) Profiling and converting DTS packages, and a look at tools that can help. Working with SharePoint? Moving to a new version of SharePoint, site consolidation, new applications and even reorganizing your site collections can be a major task with a lot different variables and challenges. This is where the SharePoint […]
Managing Fragmentation, Stats and More
Featured Article(s) Parameters for Analysis Services Reporting: Introduction, Pt. 2 Part 2: BI Architect Bill Pearson begins an extended examination of parameterization within Analysis Services reports. In this article, we get hands-on practice creating a parameter within the graphical user interface, and then examine the construction that Reporting Services 2005/ 2008 / 2008 R2 performs behind the scenes. Featured Script […]
Tips for using SQL Server 2008 triggers
Featured Article(s) Tips for using SQL Server 2008 triggers Here are some helpful tips to performance tune and optimize SQL Server 2008 triggers. Part I: Oracle Data Warehousing: A conceptual overview Oracle has made a commitment to support data warehousing applications with Oracle8i. Each new version of Oracle is an enhancement on the previous one. So what it data warehousing? […]
On Index Defragmentation and Automation…
Featured Article(s) Part I: Oracle Data Warehousing: A conceptual overview Oracle has made a commitment to support data warehousing applications with Oracle8i. Each new version of Oracle is an enhancement on the previous one. So what it data warehousing? What are its features. This article is a conceptual overview of data warehousing. The next few articles in this series will […]
Quick, Initial Feedback on Index (de)Fragmentation Practices
Featured Article(s) DTS Conversion to SSIS (Part 2 of 4) Understanding the differences between DTS and SSIS. Also, information on running packages. Quick, Initial Feedback on Index (de)Fragmentation Practices On this Friday before the US-holiday weekend, I wanted to pass along just a thought or two on defragmentation. I do have one question first though. Several people that have written […]