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

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

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

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

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

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

Featured Article(s) Parameters for Analysis Services Reporting: Introduction, Pt. 1 Part I: 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 […]

Last Day to Register – Class starts July 1 SSIS Class – Online, 12 Hours/class sessions Eric Johnson’s class starts July 1 and you can register now to attend! Brought straight to your desktop, this 12-session class includes weekly business hours with Eric, LOTS of information about SSIS and how you can put it to use in your own shop. […]

Web Seminar – Tomorrow Five things every SQL Server DBA needs to know when managing multiple database platforms, that will be the subject of tomorrow’s web seminar. While some DBAs work exclusively on SQL Server, you may have to support two or more types of database platforms today, and certainly multiple types of databases throughout the course of your career. […]

SSIS Class – Online, 12 Hours/class sessions (Only a couple of days left to register!) Eric Johnson’s class starts July 1 and you can register now to attend! Brought straight to your desktop, this 12-session class includes weekly business hours with Eric, LOTS of information about SSIS and how you can put it to use in your own shop. There […]