May 2013 - Learn about six tips that can help you get the most out of Power View, as well as the enhancements made to Power View in SQL Server 2012 SP1....More
March 2013 - The growth of several new technologies like Big Data and in-memory databases are significantly changing the role of enterprise database platforms like SQL Server....More
February 2013 - When you use solid state disks (SSDs), you need to change the way you think about designing storage for production SQL Server machines....More
January 2013 - By Using an SSIS package to pull catalog and execution log data from SSRS instances into a central repository, you can easily run queries to obtain report statistics....More
December 2012 - The SQL Server Pro Editors' Best and Community Choice Awards recognize the best products on the market. Our contributors and editors chose their favorites, and hundreds of readers also voted....More
November 2012 - Visual Studio 2012 continues to be the hands-down leader in the applications development space. Learn about some of the major new features in Visual Studio 2012....More
October 2012 - With a basic understanding of how the Kerberos pieces fit together and a step-by-step implementation guide, you can easily and correctly configure Kerberos for your SSRS environment....More
September 2012 - Find out how the technologies in SQL Server and SharePoint can work together to deliver business intelligence in organizations....More
August 2012 - Virtualized SQL Server instances can benefit greatly from Hyper-V Dynamic Memory because it addresses memory problems head-on by dynamically allocating and deallocating memory....More
July 2012 - With Transparent Data Encryption (TDE), you can encrypt an entire database and have the encryption be completely transparent to the applications that access it....More
June 2012 - Microsoft Power View is an easy-to-use business intelligence (BI) tool. Power View's interactive, web-based data exploration, visualization, and presentation technology helps DBAs make sense of their data....More
May 2012 - Discover insights, techniques, and resources for troubleshooting performance, connectivity, and other types of problems commonly encountered in SQL Server environments....More
April 2012 - Understanding what you see in a query plan can help you determine the reasons for poor query performance. Therefore, learning to understand plans is a key element in efficient query tuning....More
March 2012 - SQL Server 2012 promises to be an exciting release. Learn about some of its new features and enhancements, as well as system requirements, the upgrade process, and changes in the setup program....More
February 2012 - Configuring authentication in SSRS isn't always straightforward because it occurs at multiple points and involves multiple technologies. This guide will get you started with the basics....More
January 2012 - AlwaysOn Availability Groups in SQL Server 2012 is the next evolution of database mirroring. Find out what AlwaysOn Availability Groups is and how to use it to create and manage availability groups....More
IT/Dev Connections
Las Vegas
September 30th - October 4th
Our Experts will show you: • Common SQL Server Problems • Best Practices for T-SQL • SQL Server Integration Services • Database Development
Out of the box, SQL Server is (and has been) able to take advantage of multiple processors/cores without any effort on behalf of administrators....More
My family recently just "officially" announced that we're in the process of adopting a child from South Africa. We're quite excited, of course, but there's a ton of paperwork to do—along with the need for gobs of signatures....More
In this blog post, Mark Kromer walks you through using SSIS as a way to use ETL techniques using Microsoft's Hadoop on Windows (HDInsight) as a source using Hive connectors...More