Monitoring SQL Server Space

Monitoring the space of SQL Server Machine.

How do we monitor our SQL Server file data? Acknowledge the size and the growth is an important thing for all of us. Knowing the condition of the machine is critical in term of Database Server need a specific condition in its physical infrastructure – the harddisk/physical device should be in a sufficient free space. The growth of the database and its current used space is also very critical to acknowledge because it will provide us knowledge how we interact with the data growth, decide, and how we maintain them. Not only critical for the database itself, but also for the Operating System as well. You can imagine if one of our database files growing in 30MB per daily, and someday in the future it hits Windows Server with hundreds MB left in space? How come??

Of course, every database is living on its own speed. The very active growth is everywhere as well as the ordinary one, as you can mention any retail or banking database or your sms content business which growing in 100 thousand records daily. And in other plant, the medical record of certain hospital may require no more than thousand rows per day.

We should also take care of the ratio between the maximum capacity and the growth per day. The blue one is the most acceptable thing. The orange is in danger speed.

Qt: How to add resource file (such as image)

It is common that we need to add some images in our widget/form/control to create a good application layout. We can do this by inserting into the widget, the image directly or create a resource file as well. Resource file in the Qt Application is .qrc file.

In a simple shot, we use the resource file by firstly create the file, and include the files into the Qt Application project, and compiling the application.


Ho to do that in detail?

How to Design sub report with classical CR 8.5 in VB6 IDE

Widyanahar: 3 march: 2008

I am trying to write this article due to the fact that it is uneasy to get howtos or step-by-steps info for this issue, even with our google, it is still hard to find out.

Thought that many of you experiencing the same problem on this! This article should be useful for those who is still in middle of legacy system which is running crystal report 85 with VB6 desperately. (You know that this is 2008).

Here is the code for accessing the subreport:

cr.DiscardSavedData

cr.Database.SetDataSource rsmain, 3, 1

cr.Subreport1.OpenSubreport.Database.SetDataSource rssub, 3, 1

cr.Subreport1.OpenSubreport.Database.Verify

frmReportView.CRViewer1.ReportSource = cr

frmReportView.CRViewer1.ViewReport

frmReportView.Show vbModal

Note: you use Active Data, prepare two ADO Recordset for main report dan subreport , say both as rsmain as rssub.

Here is the step-by-step:

1. The report files is included within the vb projects (.dsr file) rathe than .rpt, representing the main report and sub report.
2. The Sub Report file will be placed in one of sections within main report design, by insert report procedure (rightclick the design form, insert/subreport)
3. There must a field as conjuction/link between main report and subreport. That is a field that exist in rsmain and rssub. In this example, the field is CustomerID.

here is the menu to prepare the link :

4. After subreport insertion, subreport created once will not be used anymore for editing. You should use the subreport inserted by rightclicking subreport part in the mainreport form and click Edit SubReport as depicted below.


5. After step 4, you must have tab main Report dan Sub Report named crDetail. From this sub report, you should do your design work.


hope this helpful.

wid, 2008

Incredible Tool : SQL Profiler

Incredible tool: SQL Profiler

have you ever tried SQL Profiler for SQL Server 2005?

This is pretty good stuff, and i wish other rdbms engines has the same thing as this SS2005 provide.

In the middle of the User Interface crowd, Profiler is very helpful that you can monitor every query against your beloved data. You don't need to go to debugging mode of your coding. Many parameters are involved! too crowded? Calm down, if seen messy, you can choose which one fits your need: Audit Login, Session, Stored Procedures or, TSQL.

parameters involved in the monitor

Experience your best sql-debugging, even without peeping your code!

Wid, 2008