Arshad Ali

Introduction As the infrastructure grows to sustain the growth of an enterprise so does the number of DBAs to support this infrastructure. Different groups of DBAs perform separate sets of roles and responsibilities; for example there can be one group of DBAs responsible for the overall management of SQL instances and there cam be another […]

Introduction It is not an uncommon requirement to move your database from one SQL Server instance to another instance, either for migration or for setting up a failover scenario. But the problem is, a database relies on some of the data that resides outside the database and hence you have more overhead than just moving […]

Introduction It is not uncommon to have stored procedures returning result sets, and  although it sounds like a good idea, it becomes a problem when you want to have control of the name of the columns and data type of the columns being returned as part of the result set. SQL Server 2012 (Code name […]

Introduction Subscription and Delivery (Reporting Services) Subscriptions Page (Report Manager) Managing Subscriptions See all articles by Arshad Ali

Introduction Subscriptions Page (Report Manager) Managing Subscriptions See all articles by Arshad Ali

Introduction Report Definition XML Diagrams Report Definition Language Reference See all articles by Arshad Ali

Introduction 1. Report snapshots are stored in ReportServer database and hence you need to plan for additional storage requirements for this database. Though you can minimize it by limiting the maximum number of snapshots to be maintained at a time in the report history. 2. All the data sources used in the report must have […]

Introduction   Subscription and Delivery (Reporting Services)

Introduction Report Parts (Report Builder 3.0) See all articles by Arshad Ali

SQL Server Reporting Services (SSRS) has a report development/authoring tool called Report Designer (Business Intelligence Development Studio) for creating managed reports. Though Report Designer has an intuitive interface for creating simple to complex reports, it can be a little complex for business users who want to create ad-hoc reports. SQL Server Reporting Services has a […]

In my last article I talked about SQL Server Utility, Utility Control Point, what it is, how it helps SQL Server DBAs in multi-server administration, and finally I demonstrated creating Utility Control Point step-by-step. In this article, I will be talking about enrolling multiple SQL Server instances in an already created UCP for health data […]

As your business grows, the number of applications grows as well, as do the SQL Server instances to support these applications. As a SQL DBA, you need to have a multi-server management dashboard that proactively tells you about the resource utilization on each SQL Server instance. SQL Server 2008 R2 introduced the SQL Server Utility […]