|
|||||
|
This post discuss about configuring the AdventureWorks Analysis Services Database in SQL Server 2008 R2. You can download the sample databases from here. By default when you install the setup you would not see the analysis services database, you need to do some configurations to get it appear in analysis services database. To deploy the analysis services . . . → Read More: SQL Server 2008 R2 Hosting :: Chart Reports in SQL Server 2008 R2 reporting services A stored procedure is a group of sql statements that has been created and stored in the database. Stored procedure will accept input parameters so that a single procedure can be used over the network by several clients using different input data. Stored procedure will reduce network traffic and increase the performance. If we modify stored . . . → Read More: SQL 2008 Hosting :: Stored Procedure in SQL Server and the Advantages This latest release of the SQL Server presents new features and improvements that increase the power and efficiency of architects, developers, and administrators who design, develop, and maintain data storage systems. This article will walk you through all new features that are introduced in SQL Server 2012 especially high availability. For guarding application databases in an enterprise . . . → Read More: SQL Server 2012 Hosting :: New Features SQL Server 2012 HostForLIFE.EU has supported Web Deploy technique on all our hosting plans. With a web deploy technique, a customer can efficiently synchronize sites, applications or servers across your IIS 7.0 server farm by detecting differences between the source and destination content and transferring only those changes which need synchronization. What is Web Deploy 2.0? Web Deploy (Web Deployment Tool) simplifies . . . → Read More: HostForLife.EU now supports Web Deploy 2.0 Hosting Do you ever come across a requirement where you need to use user defined colors instead of default colors in a chart (for example Pie Chart). In this article, I’ll explain how to create a Custom Palette and how to use that palette in a Pie Chart. In the above screen-shot, I am using color Blue, Red, Teal and Gold for . . . → Read More: SSRS 2008 Hosting :: Adding Custom Color in SSRS Chart Reports SQL Server use ASPState database to store the session information for SQL Server Session mode. ASPState database having two tables ASPStateTempApplications and ASPStateTempSessions. ASPStateTempApplications table contains Application ID and Application Name which is specific to each and every application which are using SQL Server session mode on the particular database. ASPStateTempSessions table having numbers of fields . . . → Read More: SQL 2008 Hosting :: How to Calculate Session Data Size for SQL Server Session Mode? 1. Login to your Dynamic Dedicated Server through Remote Desktop. 2. Open Microsoft SQL Server Management Studio. This is found under the Start Menu, All Programs, Microsoft SQL Server, SQL Server Management Studio. 3. When prompted to login use Windows Authentication. Make sure the Server Name is the name of your Dynamic Dedicated Server. Click on connect. 4. Once . . . → Read More: SQL 2008 Hosting :: How to Add Users to MSSQL Using SQL Management Studio So, yesterday I was trying to resolve one issue that led to another, pretty much a daily occurrence right? This SQL issue was littering the application logs every minute with Event ID 18456, as you can see in the screenshot. Opening up the individual error showed the following (note my spray paint skills): Login failed for user . . . → Read More: SQL 2008 Hosting :: Cleaning up the Error Logs – SQL Error 18456 In this article, I am going to explain how to create a Recursive Hierarchy Group in SSRS 2008 to display hierarchical levels. This is helpful when we want to display hierarchical data in a report e.g. employees in an organizational chart as shown below: Pre-requisites for this article: SQL Server 2008 along with SSRS installed Today in this article I’m going to explain yet another new tool in Visual Studio 2010 which is nothing but the DATA COMPARISION tool. This tool is of extreme use for the developers to compare data in 2 tables in different environment (in real time say a reference table data should be compared from Development to . . . → Read More: SQL Server Hosting :: SQL Server Data Comparison Tool in Visual Studio 2010 |
|
|
|||
|
Copyright © 2012 SQL 2008 Hosting News (SuperBlogAds Network) - All Rights Reserved |
|||||
