​​SQL Server 2012 AlwaysOn Availability Groups provides a unified high availability and disaster recovery (HADR) solution that improves upon legacy functionality previously found across disparate features. Prior to SQL Server 2012, several customers used database mirroring to provide local high availability within a data center, and log shipping for disaster recovery across a remote data center. With SQL Server 2012, this common design pattern can be replaced...

​This guide carries on the rich tradition SolidQ began with the SQL Server 2005 Upgrade Guide to provide customers with the comprehensive information they need to make a smooth and successful move to a new SQL Server version.

Three SolidQ have teamed up to write the new Dell white paper "What You Need to Know About SQL Server 2008 Community Technology Preview 5 (November 2007)"-exploring what's new in this projected next-to-last look at SQL Server 2008 before it's released to manufacturing.   Using the broad-reaching Community Technology Preview (CTP) program instituted with SQL Server 2005 and Visual Studio 2005-instead of a small beta-testing program-Microsoft ...

On Thursday, 24 Jan 2008, I presented New Features In SSIS 2008 to the Richmond SQL Server Users Group. Most of the presentation was dedicated to demonstrating Change Data Capture (CDC) interacting with SQL Server 2008 Integration Services. I started seriously working on this demo the first week of January, thinking I'd put 2 - 6 hours into it to get it running using the detailed instructions in Books Online. Things were going relatively well working through the demo until I hit ...​

Most of the presentation was dedicated to demonstrating Change Data Capture (CDC) interacting with SQL Server 2008 Integration Services. I started seriously working on this demo the first week of January, thinking I'd put 2 - 6 hours into it to get it running using the detailed instructions in Books Online. Things were going relatively well working through the demo until I hit calls from SSIS to table-valued functions created by CDC.​

Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical capabilities. This capability frequently comes with a substantial cost in query performance due to the runtime join required by Analysis Services to resolve many-to-many queries. This best practices white paper discusses three many-to-many query performance optimization techniques, including how to implement them, and th ...

​SolidQ played a leading role at Microsoft’s Tech- Ed Conference and Expo in Barcelona as the only Spanish-speaking company in attendance. Francisco “Paco” González and Maciej Pilecki represented SolidQ Iberoamericana as speakers at the two-week event for developers and IT Pros, with Maciej winning a speaker medal. In addition, Eladio Rincón, a representative in the Ask-the-Experts section, participated in the Speaker’s Ido ...

​When designing your SQL Server 2005 Analysis Services (SSAS) dimensions and related attributes—appropriately called attribute relationships—you should consider how changes in your dimension data will affect the underlying dimension aggregations and, in turn, processing and query performance. If you aren’t careful in defining attribute relationships, you’ll likely run into dimension processing problems such as processing errors—and seemingly at the most inconven ...

With the introduction of Visual Studio 2005 Team System (VSTS), Microsoft for the first time offers software developers and test engineers a complete and integrated suite of tools for software testing. And the new Wrox book Professional Software Testing with Visual Studio 2005 Team System: Tools for Software Developers and Test Engineers (John Wiley and Sons, ISBN 978-0-0470-14978-2) shares best practices for software testing using VSTS test and development tools, covering all phas ...​

The central goal of any database system is to allow the user to query the data to answer business questions, and the most important of these questions always involve dates. Querying date/time data in SQL Server has some interesting pitfalls, but for the most part they're easily avoidable if you understand how the database management system (DBMS) treats temporal data. - Adapted from Expert SQL 2005 Development (Apress, 2007), Chapter 10, "Temporal Data". To start thin ...