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

Featured Article(s) Microsoft Access 2003 Linked Server on SQL Server 2008 using the JET and MSDASQL Providers This article is about configuring a linked Microsoft Access 2003 Server on SQL 2008 to access data on a Microsoft Access database. The article describes in detail how to set up and use such a linked server on Microsoft’s latest database product, the […]

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

Featured Article(s) Incremental Loads using SQL Queries The article talks about a few methods for loading data incrementally when we do not have access to any ETL Tool or SSIS in particular.Windows Shadow Copy for SQL Server Online backup and restoration Windows Shadow Copy for SQL Server Online backup and restoration New SelectViews Show – Special Edition! (135) SelectViews: Special […]

Featured Article(s) A More Effective Index Rebuild/Reorganize Strategy in SQL Server In one of companies I worked for, we used to do nightly index rebuilds. This, of course, is not efficient because rebuilds are very resource intensive. However, what was baffling is that even after the nightly rebuilds, the fragmentation for some of the tables remain high. I did some […]

Attend Today Tools for SQL Server Backup Heroes Recent trends in the database industry have lead to a number of challenges for managing SQL Server. Most databases grow in size over time. Regulatory requirements mandate maintaining certain amounts of data online. Users also want to see more of their data. And the number of users for database applications grows over […]

Webcast Tomorrow – Register Now Tools for SQL Server Backup Heroes Recent trends in the database industry have lead to a number of challenges for managing SQL Server. Most databases grow in size over time. Regulatory requirements mandate maintaining certain amounts of data online. Users also want to see more of their data. And the number of users for database […]

Webcast – just 2 days left to register Tools for SQL Server Backup Heroes Recent trends in the database industry have lead to a number of challenges for managing SQL Server. Most databases grow in size over time. Regulatory requirements mandate maintaining certain amounts of data online. Users also want to see more of their data. And the number of […]