Featured Article(s) Data mining: The New Gold Fever. Information today more than ever, has an incredible value in the market. The race for getting the best and more accurate data for business intelligence purposes resembles the famous gold fever when everybody and their dogs moved to where the action exploded. Thinking Through Single Source of Data with SQL Server (and […]

Featured Article(s) SQL Server 2008 Unstructured Data and Filestream SQL Server 2008 Unstructured Data and Filestream Single Source of Truth – A Challenge for SQL Server For quite some time now I’ve been writing about, and Microsoft has been touting the concept of a single source of truth (phrased different ways). The concept has to do with knowing your information […]

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

Featured Article(s) Troubleshooting SQL Server 2005 Log Shipping In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 log shipping. He also tells how you can resolve these problems. Help and Tips for Performance Monitoring Have you ever tried to hunt down a performance problem, had to find out first where […]

Featured Article(s) Archiving Your Database (The technical Side) Once the data has been identified, you can start looking at the multiple ways to actually archive the data. There are a number of ways that you can accomplish this. This article will outline how I have done archiving in the past. SQL Server 2010^H^H 08 R2 Strange things happening with SQL […]

Featured Article(s) Adding custom context menu items to custom SharePoint lists and libraries In my previous article we looked at how you can attach your own document library or list custom context menu item to any existing document library or list type. This means that any library of that type will have your custom action displayed, which may not necessarily […]

Featured Article(s) Checklist for Configuring Oracle 10g Real Application Clusters on IBM AIX with SAN Storage Part 2 Checklist for Configuring Oracle 10g Real Application Clusters on IBM AIX with SAN Storage Part 2 New SQL Server Show Posted Interview show – Christopher Regan, Donald Belcham, John Welch on the show today. Tips, best practices, pet peeves, things encountered in […]

Featured Article(s) What do you execute once you have connected to your server with DAC? If your server is having problems and you can’t even connect to it what do you do? The DAC – Dedicated Administrators Connection tool is what you need. It comes with SQL 2005 and SQL 2008 and allow you to connect (with limited abilities) to […]

Featured Article(s) Tips for using Very Large Databases in SQL Server 2005 (Part 2) In this article, you can find some helpful Very Large Databases (VLDB) performance tuning and optimization tips. Why Can’t My Users Connect? I’m constantly hearing from people looking to find the best way to optimize their time and efforts with SQL Server. Hunting down issues with […]

Featured Article(s) XML-SERVER – Understanding Thin Clients Client side XML processing has its own limitations. Server Side processing of XML greatly reduces load on the client. It also improves performance, scalability and security of the applications. ASP, JSP and PHP are some of the server side languages that can generate and store XML on the server. XSLT on the server […]