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 [...]
Feb
25
2010
25
2010
Jan
20
2010
20
2010
SQL SERVER :Date and Time Dimensions in T-SQL using CTE
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 [...]
Dec
31
2009
31
2009
Happy New Year in TSQL
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) + ‘ [...]
Dec
7
2009
7
2009
Creating a simple FrontEnd using Reporting Services and Merge
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 [...]
Nov
15
2009
15
2009
List of Temp Tables in your SQL server
select create_date,modify_date,OBJECT_NAME(object_id) as TableName from tempdb.sys.objects where name like ‘%#%’
Nov
7
2009
7
2009
Encryption in SQL SERVER using SSIS
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 [...]
Oct
13
2009
13
2009
Checking TSQL in SQL Server Reporting Services Datasets
Recently I have been checking all the Dependencies on the Reports in SSRS(Sql server Reporting Services) because of a Major deployment on the ETL. The ETL change was to accomodate the transfer of a few columns from old Table TableA to the new table TableB. Some of the Datasets in the Reports are Stored Procedures [...]
Oct
6
2009
6
2009
DMV Report for Index Fragmentation and Statistics Update
Recently the ETL load times of my Datawarehouse are increasing and so I decided to check the Indexes status on the tables . I found some fragmentation on the indexes and also some Statistics that are not being updated regularly . I searched online and found this blog by Ben Nevarez(SQL Blog). I decided to [...]
Jun
20
2009
20
2009
Extracting Account Name and Domain from Email using T-SQL
Storing the list of email subscribers is quite often seen in the web based companies. Once the emails are stored they are segmented based on the customer interests and products they have purchased on the website. In this article I will show the simple step of extracting the Account Name and Domain Name using T-sql. [...]
Jun
16
2009
16
2009
Playing with SQL SERVER CACHE
Yesterday Afternoon me and my friend were doing some serious Sql manipulation on some heavy datasets that needs to go inside the Cube.We have written some dynamic SQL statement that is going to insert some 40000 rows into a Control table for a Dimension. Weird Enough my friend accidently closed the Query window and for [...]
