WordPress uses MySQL as its database back end and as a result it is important to upgrade and patch MySQL database versions when possible. This is especially true […]
Upgrading the version of PHP in IIS
WordPress is a one of the most commonly used technologies to host a website and blog. WordPress in turn uses PHP to render the content and therefore it […]
How to use Relative Time Filter in PowerBI
In this post we cover how to use the Relative Time Filter in PowerBI desktop. A great features to have when reporting the relative Time Filter Option allows […]
Power BI Automated page Refresh
Automated page refresh is a feature that allows the developer to display real time information on the power Bi report. This is not to be confused with features […]
PowerBI – Personalize Visual
This feature has been requested a number of times and it’s great to be able to see it being implemented in PowerBI finally. This feature is currently in […]
Power BI – New Features – importing data and enabling preview features
PowerBI is one of the products where Microsoft aggressively releases features every month. The effort is paying off as it’s quickly become the industry standard for reporting. The […]
DB options: – Recovery intervals and Checkpoint
In this video we talk about recovery intervals. Specifically how checkpoint allows recovery intervals to be maintained. Checkpoint is a feature that allows SQL server to recover faster […]
Using Snippets in SSMS
A little know and used feature by database developers is Snippets. Database developers understandably do not use this feature because we have long been accustomed to using prebuilt […]
Database Options: – Filestream
Filestream is a great feature for databases that have to handle a large volume of BLOB data. It allows the DBA to store data in Filesystem folders rather […]
DB Options: – Parameterization
In this video we cover the two options available under parameterization in MSSQL database properties. Ad hoc queries are queries that aren’t stored procedures. Since the code is […]