Posts filed under 'SQL Server'
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. The option to upgrade from SQL 2000 instance is there.
Ok dude, the menu is there. What about the guidance? We know that there is more than 300 pages whitepaper available for SQL 2005 upgrade. But the one for SQL 08 is not available as of this writing, please be patient to wait. The Microsoft Official Curriculum for this topic is under development now, and I am also involved in it. The alpha run of this training will be held around September 08, and is expected to hit the market 2-3 months after that.
My advice for you that still stick with SQL 2000 is: don’t upgrade to SQL 2005. Please wait until the release of SQL 08, and do direct upgrade to SQL 08 instead 
July 3rd, 2008
One of my student 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 export to XML as well.
There are several option to do that. On the report level, we can utilize the query string to inject the parameter, and disable the parameter and export bar on top. Another elegant method is jump to the configuration file of the Reporting Services installation, and comment ot the PDF rendering extension.
Open the rsreportserver.config xml file with any editor of your choice. This file is located under ReportServer folder of the SSRS installation. Here is the capture:
If you’re not sure where is the file located, go to the IIS console and read the home directory of the ReportServer virtual directory.
Continue Reading April 23rd, 2008
One of the cool feature 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 and asymmetric encryption, as well as hashing. I created a sample script to do symmetric encryption. A slide deck presentation also available for a quick review about encryption architecture.
Actually I created this material for one day SQL Server security workshop at Avantus. This one day workshop covers encryption, SQL injection, SQL Lock down, and security administration. I decide to release the encryption module here along with the sample script, but not include the detail manual. Some of the material comes from Lara Rubbelke’s presentation.
For some of you that still stick on SQL 2000, Michael Coles already created an encryption toolkit with no cost.
Download the presentation.
Download the sample script.
October 11th, 2007
I did SQL Server 2005 migration discussion last April with several engineers of Freeport Indonesia. I used white board, chalk talk style at that time. I did the presentation again yesterday but in more formalized format. It was an SQL Server 2005 Technical Upgrade Workshop held by Microsoft Singapore. There were 3 sessions in that half day workshop:
- Transparent Benefits of Upgrading to SQL Server 2005
- How to Upgrade to SQL Server 2005
- Get The Most of SQL 2005 BI Tools, Benefits, and Upgrading
Continue Reading July 25th, 2007
I received Friend of Red Gate gift several weeks ago. It’s a very good package, contained of T-Shirt, mug, USB drive, and pen handler. Red Gate treated community building seriously. As a one of the major player of SQL Server and .Net toolkit, the importance of community building is make sense. Community leader spread a good word about the product and helps increase revenue in the long term
Another advantage of becoming Friend of Red Gate is get the free copy of all Red Gate tools. Of course only for non commercial purpose. I really love SQL Compare, save me a lot of time when doing deployment and testing between development machine and production server. It compares all of the database structures and schema, and I can choose to merge or override between those databases. Also, SQL Data Compare is able to compare the database content, examine the differences, and decide to merge or override. It’s really eliminate my headache during development and maintenance.
Continue Reading July 10th, 2007
I spoke on SQL Server User Group Indonesia
monthly meeting last month, discussed about a developer perspectives of SQL Server Security. I covered most of the session with some SQL Injection techniques, completed with real sample code in web application.
I started with the awareness that network administrator is not the only person who’s responsible for computer security. Networking guys are only responsible at the network (firewall) and host (OS) level. At the application level, is a developer responsiblity for the software security. Ensure that no single line of code contains a hole, something that can be utilized by an attacker to compromise the system.
Continue Reading May 13th, 2007
I will speak for SQL Server User Group Indonesia monthly meeting on April 30, 2007. Yes, I will be in Jakarta at that time. Meet with many old friends, community enthusiast, most of them are SQL Server and .Net addict
.
I’m preparing 2 hours presentation about SQL Server Security. This is a big topic, so I limit the scope just for development area. The title should be SQL Server Security: A Developer Perspective. It contains some demos about common developer mistakes when dealing with SQL Server. It’s about something beyond the firewall, yes. When your firewall offers NO protection 
.
I’m proud with the growth of SQLUG-ID. Since I established this group about 2 years ago, It shows tremendous growth. New member come every week, and new posting appear everyday. We have consistent monthly meeting that attended by 20-30 members on average. We even made one MVP (yes Kiki!) that has the root from this group. I hope there will be more new MVP awarded to the active member of this group.
See you at BEJ Building 18th floor, Microsoft Office.
April 24th, 2007
Migration and upgrading are often overlooked by many developers and DBA. They never take care about it until they face the real problem in upgrade and migration. I recalled this matter when I was doing interesting discussion with several senior engineer at Freeport Indonesia on last April 5th, 2007. It was Dondy who called me and asked for an appointment, if I have a time to do technical presentation about this topics for his colleagues. Dondy is working for Freeport now, as he need, as a Software Archictect. Blah 
.
Actually I was on vacation at that time, but I agreed to do that. I’m willing to share anything I know to anybody who keen to learn. As usual, I opened my library and did some reviews before I went to Freeport office. Upgrade and migration is not a daily job, so that’s why every DBA is definitely miss many things about it.
To summarrize the discussion with Mera and Emal who’re responsible for big database at Freeport, these are the things that we need to take attention on migration:
Continue Reading April 14th, 2007
When we deal with large data warehouse, it needs specific trick for best performance. I did presentation about this on last Oct 17 for Mini TechReady in Microsoft Singapore. Basically here are some guidances:
- Take advantage from table partitioning for large fact table.
- Put clustered index on fact table key, specially for datetime column and do partitioning based on this column.
- Put non clustered index on non datetime column of fact table, when the query usually using exact criteria.
- Do the query based on interval criteria, put BETWEEN on WHERE clause when dealing with datetime key, ofcourse after put clustered index on it.
Continue Reading October 19th, 2006
Imagine we have a business problem, and already have the historical data. We can analyze the data using several mining algorithm inside SQL Server 2005. This is what I’ve talked in my second session at Teched SEA 06 Kuala Lumpur. This was not so technical session, but explain any considerations to decide which mining model should be used for specific business problem. Then do the future prediction using the mining model.
Download sample code here
Download the powerpoint slide here
September 8th, 2006
I will speak today, the topic is “Smart ASP.NET Web Apps with SQL2005 Mining Model. This session mainly focus on OLE DB for DM and DMX query stuff. The sample code is about prediction of potential buyer based on their demographic data. It uses Microsoft Decision Trees algorithm in plain DMX query inside C# code.
Download sample code here
Download the powerpoint slide here
September 6th, 2006
If you’re an ASP.NET developer that work with SQL Server 2005, you may read my second installment of developer series in SQL2005. I write a brief intro of ROW_NUMBER function and how to apply it in practical use. This function replaces a tricky approach when dealing with numbering column in SQL Server. It also makes the data manipulation for a range of rows an easy task.
This writing also illustrates a custom paging of ASP.NET page with ROW_NUMBER and objecdatasource, the simple tip that will leverage ASP.NET performance. Read the article here.
May 15th, 2006
Hopefully I’ll be there. TechEd Asia 2006 will be hosted at Kuala Lumpur, September 5-8, 2006. This is one of the best MS Technical confrence in Asia. I will speak in 2 sessions about SQL Server 2005, Data Mining, and ASP.NET. My abstracts are already approved by Ed Quek, the content manager of this confrence. Here are the topics I’ll deliver:
- Using Data Mining for Better Data Pattern
- Creating Smart ASP.NET Application with SQL2005 Mining Model
Starting from now, I open TechEd category in this blog, for any updates about this events and also the progress of my working paper. Ed Quek also writes insider updates of this event in his blog: http://spaces.msn.com/edteched/
See you!
May 4th, 2006
I just come back from Yogyakarta, giving a 2 hours chat on Data Mining at Atma Jaya University. Last weekend was very busy, I presented about SQL Server 2005 BI for Foxpro developer in MS Office on Friday (April 28), and early in the Saturday morning on April 29 I went to Yogya with the first flight schedule.
The presentation material and demo code is rather same for both events, but I added some Foxpro snipet code for Friday material. I talked more on practical implementation of OLAP and data mining for Atma Jaya student, and my fellow Zeddy gave more attention on academic approach of mining model. I made some coding enhanchments for Saturday chat, so It looks more fancy and real. The demo code was about “smart” ASP.NET application using Association Rule mining algorithm of SQL2005.
Continue Reading May 1st, 2006
I’ll be at Atma Jaya University Yogyakarta on next April 29, 2006. It’s a nice opportunity can do speaking in academic community. I will give brief theory of data mining, what data mining is, and the statistical ideas behind each mining model. Then I will move to a practical examples of data mining tasks using SQL Server 2005.
I found that market segmentation, market basket analysis, and project feasibility study with clustering and decision three will be very interesting for academic students. Soon after I come back from this events, the slide and code will available for download
April 24th, 2006
Finally SQLServerCentral published my article. I discussed about PIVOT and UNPIVOT operation in SQL Server 2005, a nice enhanchment in 05 version comparing with SQL2K. I’m thrilled with many responses from the readers. They look forward for more articles about SQL2005 from developer point of view. You can read my writing here. Don’t forget to register (It’s free) if you’re not member yet.
I have submitted the second installment of SQL2005 developer series to SQLServerCentral editor. I wrote about the magic of ROW_NUMBER function, and some practical application for updating record and custom ASP.NET paging. Happy coding
April 13th, 2006
If you read my post about my speaking schedule, It is rescheduled to April 28 2006. There is an official announcement from government authority that March 31 will be a national holiday. Actually it is not a holiday. Because it will be deducted from our leave allowance. Oh may 
.
See you on Foxpro Community inTouch on April 28!. I will talk about Business Intelligence implementation of SQL2005 within Foxpro 9.0. Also, I will give an exciting demo about next version of Foxpro [codename:Sedna]. It works with .NET 2.0 in more native way than current version .
March 25th, 2006
Finally I make it,
I received an email from Steve Jones and Andy Warren last month, said that my article has been approved and edited for SQLServerCentral. Then I received a notification last morning, they said that my writing will be published in their site on March 29, 2006. What’s the title? Sorry I can not mention it now . But It is about SQL Server 2005. I wrote some simple tips of the new feature of this server. I’m writing the second installment now. Hopefully can be published next month.
It has been along time I just thought about writing for SQLServerCentral. Thanks to Steve, Andy, and Brian, and I’m so sorry about some grammar errors in my writing .
March 25th, 2006
It seems BI of SQL2005 become my favourite stuff now. This is very interesting topic, because it does not talk about technical stuff but also delivering business insight in it. I will speak about this topic for Foxpro community next March 31, 2006. Oh Foxpro? Yes!. Mr. Hardian, the leader of FoxId community is person in duty for this seminar. I will explain the basic principles of BI and why we need it, review some mining models and OLAP, and then build presentation interface with Foxpro . My latest Foxpro experiences is version 3.0, hopefully I do not find difficulties with 9.0. I will explore indepth on OLE DB for Data Mining and DMX query. Just register yourself to connections@netindonesia.net.
Also, I found this site is very interesting for data mining topics beside official MS site.
March 3rd, 2006
After more than 1 year I have run SQL Server group for Indonesia, Now I move to a higher stage of this group. This mailing list currently has more than 800 members, with 200 average posts in a month. This group has became a PASS Official Chapter last week. Also, we have been accepted by Culminis as a member of their alliance to build IT Pros community around the world. To be a part of this worldwide alliance opens many opportunities for learning and sharing knowledge in global community.
Continue Reading February 18th, 2006
Previous Posts
