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

Featured Article(s) Configure and Implement Database Mail in SQL Server 2005 Configure and Implement Database Mail in SQL Server 2005 Performance Management – Hardware or Tuning? The question was – for performance, do you "throw hardware at it" or "tune it?" Send in your feedback here. I have received SO MUCH feedback on this that I really want to keep […]

Featured Article(s) 7 things to check to resolve “A network-related or instance-specific error occurred while establishing a connection to SQL Server…” This article identifies 7 possible ways to resolve a common SQL Server connectivity error : “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that […]

Register here for the vWorkshop – Friday – June 5 – SQL Server 911 (Check out the course outline here, at the site) Featured Article(s) Troubleshooting SQL Server 2005 System Stored Procedures (Part 2) In this article, Alexander Chigrik explains some problems that you can have when you use SQL Server 2005 system stored procedures. He also tells how to […]