Amazon Web Services (AWS) has made it possible to connect to its Virtual Private Cloud (VPC) service using static routing, while also allowing enterprises to run SQL Server within the private cloud, ...

Note – This book abbreviates SQL Server 2008 Reporting Services as SSRS and SQL Server 2005 Reporting Services as SSRS2K5. New features available in SSRS and not in SSRS2K5 are labeled with “New in ...

SQL Server Management Studio or SSMS allows you to connect to the SQL server and execute queries. In this tutorial, we will see how you can install and configure SQL Server Management Studio in ...

One of the most useful features in Microsoft's System Center Operations Manager (SCOM) product is its reporting engine. Even though there is nothing overly difficult about its installation process, ...

Organizations can use SQL Server to reduce downtime, manage and secure databases, and discover patterns in mission-critical information to improve business intelligence. To rebuild a corrupted master ...

Storage and performance can be quite different in the cloud. It's important to choose the right VM size and configure your storage properly to keep SQL Server workloads running smoothly. Microsoft ...

FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder. FileTables is a new feature introduced in SQL Server 2012. It's a ...

After months of criticism that the test build of its cloud-based SQL Data Services (SDS) lacked the horsepower for enterprise-grade applications, Microsoft is scrapping the effort and moving to a pure ...