Featured Article(s) Using Bitwise Operators in T-SQL Using bitwise operations in SQL Server can reduce storage space and improve performance. This article will get you started. Watch the Latest SQL Server Show (132) SelectViews – Snapshots as Backups? David Penton, Keeping Customers, Database Inventory and More. Also find out about noise and news, tips tricks and other goodies. [Watch the […]

Watch the Latest SQL Server Show (132) SelectViews – Snapshots as Backups? David Penton, Keeping Customers, Database Inventory and More. Also find out about noise and news, tips tricks and other goodies. [Watch the Show] Previously: [Watch] Christopher Regan, Donald Belcham, John Welch [Watch] Herve Roggero, Jason Strate, and TJ Belt [Watch] Tim Heuer, Lynn Langit and Thomas LaRock. Featured […]

Featured Article(s) Understanding NOLOCK hint in SELECT clause- PART 2 Part 2 of the article series on understanding the NOLOCK hint in SELECT clause. Data Backup, Validation and Sourcing Comments Stephen writes: "Single source information (SSI?), interesting concept, however, here in the medical informatics world we call that ‘data quality’ and we have Data Quality working groups (of which I’m […]

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