Data Quality is very important and you want to make sure the business users get the Correct data from the Cube or from the Datawarehouses. In some circumstances where the data loads may fail you may want to disable the subscriptions so that the business users dont get the wrong reports. I use the following [...]
Displaying the most recent of 45 posts written by
Vivek
At sometime in the afternoon today, I was alerted by the business that SQL reporting services is down. The first thing I checked was to open a report. I saw the following error message on the browser. The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError) Log on [...]
Everytime we create a cube for analysis services Date and Time Dimensions are needed to slice and dice the historical Data. Sql Server Analysis Services uses the Time Intelligence Features to populate the date and time. Its posted in detail in this blog. However we need to use them in our relational Databases to do [...]
Whenever you create a new Subscription in Sql server reporting services, a new job is created under the Sql agent as shown in the figure below. You can use the msdb.dbo.sp_start_job procedure to start the job. In SSIS create a new SQL task and run the job wherever required exec msdb.dbo.sp_start_job @job_name = ‘JobName’ For [...]
You may see the above error if you are using the SQL server Destination in your SSIS package. Sql server Destination cannot be used in packages that access a SQL Server database on a remote server. Instead use the OLEDB destination. Things to note for SQL Server Destination a. It offers the same speed as [...]
I did use SQL String manipulations a lot this year. I want to show an example of how to use CHAR. Open your Management Studio – and paste the following in your Query Window SELECT CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15) + CHAR(15) + CHAR(15) + CHAR(15) + CHAR(13) + CHAR(72) + CHAR(65) + CHAR(80) + CHAR(80)+ CHAR(89) + ‘ [...]
One good feature in SQL server Reporting Services is ToolTip . It is a simple feature but has more advantages if you want to show the complete information in a report. Its a great way of saving some Reporting space.I use it when Designing Dashboards or if you want add the redundant columns like the [...]
Problem: A Business User wants to update/insert/delete the values in a table that sits in the metadata of the Datawarehouse on a regular basis. Based on these values numerous calculations will be done in the warehouse which generates a data driven Report on a weekly basis. Initially I got the following Solutions 1. Create a [...]
select create_date,modify_date,OBJECT_NAME(object_id) as TableName from tempdb.sys.objects where name like ‘%#%’
I have been recently working on an Sql Server Encryption Project. It includes getting the data from a source and importing them into the Datawarehouse via the ETL(SSIS in this case) and then Encrypting it. I decided to blog on Encryption to share my experience. a. When you Encrypt the Data in SSIS make sure [...]
