Author: Stephen Wynkoop

Editorials

Mentoring and SQL Server

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. […]

Editorials

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 […]

Editorials

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 […]

Editorials

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 […]

Editorials

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 […]

Editorials

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 […]

Editorials

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 […]

Editorials

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? […]

Editorials

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 […]

Editorials

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 […]