A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...
On Tuesday Microsoft announced the release to manufacturing for SQL Server 2012 as well as an "evaluation version" for download, with general availability coming April 1. With this release, Microsoft ...
In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...
First introduced in SQL Server 2012, columnstore indexes can give you major performance gains -- provided you have the right workloads. Here's how columnstore indexes work and what types of data work ...
SQL Server 2012 is a large, complex product that represents Microsoft's vision of where data is headed. If that vision were to be summed up in one word, that word would be: big. To meet the challenges ...
Microsoft strengthened its hand in the database market Thursday by releasing the first 64-bit version of SQL Server. The product should help Microsoft address a broader segment of the database market, ...
In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...