Do You Have a DTS/SSIS Mixed Environment? The solution to migration, having code reusability and a whole lot more is found in BI xPress. If you’ve experienced the challenges of migrating packages from DTS to SSIS, learning about the re-coding, seeing what’s involved and thing figuring out how to re-work code and modules in your environment, you know it can […]

Webcast: SQL Server Reports and OLAP cubes in SharePoint Quickly see how easy it is to use SSRS web part to display SSRS reports on SharePoint pages. Quickly see how to display an OLAP cube KPI on SharePoint page by using the included web part. PResented by: Lynn Langit > Register Now – Webcast date: 7/1/2009 at 12:00pm Noon Pacific […]

Looking for SQL Server help? By popular request – We can help! Check out SQL on Call – from consulting to how-to information to performance tuning and management, SQL on Call, which includes both fellow SQL Server MVP Chris Shaw and Stephen Wynkoop (that’s me!) are available for select consulting projects that we can also work with on a research […]

Featured Article(s) SQLXML : How to Work With XML Elements (or Nodes) in SQL Server This article shows you how you can work with SQL Server XML elements – adding elements, updating element values, deleting elements Webcast: SQL Server Reports and OLAP cubes in SharePoint – Quickly see how easy it is to use SSRS web part to display SSRS […]

Featured Article(s) SQL Server 2005 DBCC Optimization Tips (Part 2) In this article, you can find some helpful SQL Server 2005 DBCC performance tuning and optimization tips. Standardize Your Servers and Their Configurations Making sure you apply the same rules across servers, across installations and assuring the same options and settings are in place is key to running your SQL […]

Featured Article(s) Using the Oracle SQL Developer 1.5.4 Oracle SQL Developer Tool (a.k.a Project Raptor) is a stand alone graphic database developer tool that connects to Oracle as well as third-party databases which can be used to perform a variety of tasks from running simple queries to migration of databases from third party vendor products to Oracle. The product has […]

Featured Article(s) How to Write An SPQuery Using Multiple AND OR Operators This article outlines some techniques when working with the SPQuery object within SharePoint to query lists.Basics of Working with CHECKSUM This Article talks about what CHECKSUM and BINARY CHECKSUM are and how they can be used effectively in SQL Server. SelectViews Show – Special Edition! I posted this […]

Featured Article(s) Check IDENTITY Columns in a database Identify all the IDENTITY columns present in a given database with filtering option available for specific tables.Oracle Change Data Capture Step By Step — Part 1 Oracle Change Data Capture Step By Step — Part 1 New! SelectViews Show – Special Edition! I posted this show previously in mistake – it’s live […]

Featured Article(s) How to Programmatically Impersonate Users in SharePoint Sometimes when creating SharePoint web or console applications, you may need to execute specific code blocks in another user’s context. This article shows you how you can programmatically impersonate users in SharePoint.Molecular MDX: Select Part 3: Welcome to the new, SSWUG-exclusive Molecular MDX series! Join BI Architect Bill Pearson as he […]

Featured Article(s) SQL Server 2005 DBCC Optimization Tips (Part 1) In this article, you can find some helpful SQL Server 2005 DBCC performance tuning and optimization tips. Announcement: New Idera SQLSafe Released! Idera has just released new SQL safe backup version 5.0. The new version adds log shipping to the already robust feature set. Save on disk space, network bandwidth […]