It's not uncommon to move your database from one SQL Server instance to another, but there's more involved than just moving your database; you also need to move data that resides outside of the database--miss a single object and your new instance can prevent your application from running as expected.
In order to keep your SQL Server up and running smoothly you need to constantly be performing routine maintenance and monitoring work. Greg Larsen discusses some of the daily tasks a DBA should be performing, providing a few scripts and suggestions to help minimize the amount of time spent performing these daily tasks.
Marcin Policht presents a high-level overview of SQL Server 2012 Integration Services, covering some significant advances in the areas of usability, productivity, and manageability.
Having stored procedures returning result sets can become a problem when you want to have control of the name and data type of the columns being returned. Arshad Ali explains a new SQL Server 2012 feature, which lets you redefine the name and data types of the columns being returned from the stored procedure.
SQL Server 2008 R2 Integration Services offer a wide range of pre-built components, which deliver generic functionality commonly required when performing ETL tasks. While most of them are fairly straightforward to deploy in their basic form, there are caveats that should be taken into account as part of their implementation. Read on to learn more.
Learn how to acquire data or parameter values required during the execution of a report from a database query, using Data-Driven Subscription in SQL Server Reporting Services (SSRS).
Row Sampling Transformation and Percentage Sampling Transformation, which provide data sampling functionality, are useful in a number of Analysis Services and Data Mining-based scenarios. Marcin Policht demonstrates the functionality of both transformations.
SSRS allows you to create two types of subscriptions, e.g., Standard Subscription and Data Driven Subscription. This article discusses the standard subscription in which you need to specify the parameters the report expects at the time of subscription creation and which cannot be changed at runtime.
The SSIS component, Partition Processing Data Flow Destination, is capable of performing direct data load from a fact table into an arbitrarily chosen partition of a measure within an Analysis Services cube. In this article Marcin Policht examines its counterpart known as Dimension Processing Data Flow Destination, which provides equivalent functionality in regard to dimensions.
SSRS reports are defined in Report Definition Language (RDL), which is nothing but Extensible Markup Language (XML) adhering to a defined report definition language schema. This article examines RDL and some of the elements that you will notice in your report's RDL.
The only formatting capabilities that SQL Server has had until now were the CAST and CONVERT function, forcing developers to write user defined functions using native string functions/date functions or CLR. The long wait for this format function is over; SQL Server 2012 RC0 is leveraging the .NET format capabilities by introducing the FORMAT() function.
The primary purpose of Integration Services technology is to deliver ETL functionality that supports core features of SQL Server database management systems. However, many times its role involves interaction with components that provide Business Intelligence-related features. This article discusses one such scenario, which leverages built-in SSIS Partition Processing Data Flow Destination in order to facilitate Analysis Services processing.
Learn how to enable the logging functionality for SQL Server Integration Services (SSIS) and how to capture detailed information for immediate troubleshooting without re-running the package.
Arshad Ali explores the report snapshot feature in SQL Server Reporting Services (SSRS). Learn how to show data at a point of time or how you can subscribe to your published reports.
While SQL Server 2008 R2 Integration Services' Changing Attribute and Historical Attribute options facilitate a variety of different data analysis scenarios, its wizard-driven configuration is relatively inflexible and generates a Data Flow structure whose performance tends to be suboptimal. This article presents a few methods of remediating these shortcomings.
» 
