Month: September 2017

Backyard farming, tomatoes, eggplants, squash and sweet potatoes.

This is my stress reliever. I really plan a self sustaining environment and now is a good time to practice that.

In red containers are tomatoes, I might replace them with another seed type from RAMGO because the leaves and stems at the bottom easily rot. The plants to the left of the tomatoes are sweet potatoes and I apologize for the small picture.

 

These pictures are the close-up of my best tomatoes. Not happy with the seed type.

 

 

 

Eggplant starting from seeds is the left picture. The right picture is what you’ll expect from the seeds in 1 and 1/2 months. Still not producing but I really like the seed type, it is still RAMGO brand.

 

Squash. Flower of the squash has been harvested and it has been served through pinakbet(Filipino viand). We are still waiting for the squash itself.

 

🙂

SQL Server – Applying business logic using CHECK type constraint

Our client is in the business of fabricating soap. One feature of our accounting suite is keeping track of all their cooking sessions (they have a production line dedicated for that and it is called kettle).

A database table called ProductLineForm handles immediate data for each session.

A session can be NOT STARTED, STARTED and ENDED. Two columns StartDate and EndDate of type DATETIME must always be of valid values all the time.

NOT STARTED should have both start and end dates to have the SQL minimum date value.

STARTED should have its end date still using the minimum value while the start date will get the started date.

ENDED must be that the start date is always equal or earlier than the end date.

I need to implement this rule to the table. Here is the check constraint applied.

ALTER TABLE ProductLineForm
ADD CONSTRAINT ProductLineForm__Date__Rule
CHECK
(
(DATEDIFF(d,StartDate,’1753-01-01′) = 0 AND DATEDIFF(d,EndDate,’1753-01-01′)=0)
OR (DATEDIFF(d,’1753-01-01′, StartDate) > 0 AND DATEDIFF(d,EndDate,’1753-01-01′)=0)
OR DATEDIFF(d, StartDate, EndDate) >= 0
)

 

 

 

 

 

SQL Server Express Reporting Services and MYSQL

A freelancer would be having second thoughts of developing an SME database under a SQL Server Standard edition or above.

Looked up for the standard edition’s license price and it could cost thousands of dollars. I think it is around $3,000.00 – $6,000.00.

I would rather use MYSQL.

Still you can keep using some of the important features of SQL Server. Reporting services is available on express license.

I have hours researching on how to still use and connect Reporting Services to MYSQL under the express license. Creating a linked server connection is the only way for you to connect SSRS express to MYSQL.

If you are planning to use the ODBC connection directly from the report then it will not allow it.

SSRS Express only allows SQL Server connections. So again you have to use linked servers.