sp_who2

One of the first lines of defense in determining the causes of database slowdowns is to use sp_who2. sp_who2 shows all the sessions that are currently established in the database. These are denoted as SPID‘s, or Server process Id’s. Running sp_who2 is easy, all that is required is to type sp_who2 and execute it, however it’s … Read more

API Documentation: get_myview

Purpose The get.myview stored procedure API allows Power Applications to interact with the DataWarehouse by performing SELECT queries on specified DataMart views. The results are returned as a JSON array. Security Parameters Required Optional Typical Use URL HTTP Header: cURL Example: PowerBI: PowerShell

Transforming Your Data with Python: CSV to Parquet Conversion and NaN Handling

Efficient data storage and processing are crucial for businesses and organizations dealing with large datasets. Apache Parquet is a popular columnar storage format offering fast query performance and data compression, while CSV is a row-based format that may not be suitable for large-scale processing. This blog post covers how to convert CSV files to Parquet … Read more

Pandas.merge() function

The merge() function in Pandas is a powerful tool for combining two or more dataframes based on one or more keys. It is analogous to the JOIN operation in SQL databases and offers various options to customize the merge behavior. Here’s the basic syntax of the merge() function: pandas.merge(left, right, how=’inner’, on=None, left_on=None, right_on=None, left_index=False, … Read more

How to Redirect from HTTP to HTTPS

 Set up your redirects in your .htaccess file: <IfModule mod_rewrite.c>RewriteEngine OnRewriteCond %{HTTPS} offRewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI}[L,R=301]</IfModule> Look confusing? Here’s the breakdown:  You can also solve this from within PHP in case your provider has disabled .htaccess (which is unlikely since you asked for it, but anyway)

A Quick and Easy Guide To Creating WordPress Admin Pages

https://wpmudev.com/blog/creating-wordpress-admin-pages/ Creating a Top-Level Admin Page The first step is to create a menu entry with the add_menu_page() function. Here’s a full example, explanation ensues: add_action( ‘admin_menu’, ‘my_admin_menu’ ); function my_admin_menu() { add_menu_page( ‘My Top Level Menu Example’, ‘Top Level Menu’, ‘manage_options’, ‘myplugin/myplugin-admin-page.php’, ‘myplguin_admin_page’, ‘dashicons-tickets’, 6 ); } view rawtop level hosted with ❤ by GitHub The function takes seven arguments. … Read more