SQL Server Indonesia User Groups Community born to train, forced to code

Recent Posts

0
Comments

End to End SSIS Sample by MCA

This is a quick post of my presentation slide and demo codes for Singapore SQL Server User Group last week. I presented the following topics: What is data warehouse Data warehouse design How to load dimension and fact table Performance trade of Best practices...
Filed under: ,
0
Comments

Presentation Slide at Singapore CTU 2008 by MCA

I presented at Community Technology Update 2008 , organized by Microsoft Singapore DPE on November 22, 2008. It was a fantastic community event, a place when community members gathered together to share their passion on latest Microsoft Technologies....
Filed under: ,
0
Comments

Easy Server Monitoring with PAL by MCA

The first step in SQL Server performance tuning usually starts with finding bottleneck at the server side. It includes monitoring to some suspicious symptoms on CPU, Memory, Disk, and various SQL Server counter. Yes, Performance Monitor tool is already...
Filed under: ,
0
Comments

Extract and Transfer RDL files from SSRS by MCA

I was in the situation when I had to modify some reports, but I did not have the source code (RDL) files on hand. I tried to go to SSRS server, and looking for download or save-as menu. I was expecting there are some ways to download the report definition...
Filed under: ,
1
Comments

Configuring SSRS 2005 on Vista and Win Server 2008 by MCA

I never think that this is a difficult or exceptional. I never configure it before, because my job does not really require to deploy such configuration. Someday in the morning, one student asked me this question: Why I cannot run Reporting Service 2005...
Filed under: ,
0
Comments

Upgrade SQL 2000 to SQL 2008 by MCA

Upgrade from SQL 2000 to SQL 2008 is now officially supported. In the early release of SQL 08 (currently is RC0), we are not sure whether there will be an upgrade path from SQL 2000 to SQL 08. This uncertainty was over when I was installing RC0 last night...
Filed under: ,
0
Comments

Disable PDF Export in Reporting Services by MCA

One of my students came with a popup question: how do we disable the export to PDF feature in reporting services? Well, I should say that export to PDF is awesome. But some company don't allow their employee to do that, or maybe they want to disable...
Filed under: ,
0
Comments

SQL 2005 Data Encryption by MCA

One of the cool features of SQL Server 2005 is out of the box data encryption capability. Not like SQL Server 2000 that requires 3rd party support or creating your own custom script, SQL05 comes with built in function to do that. It supports both symmetric...
Filed under: ,
More Posts
Powered by Community Server (Commercial Edition), by Telligent Systems