#rowcounter

[sandeep2363]

Identifying unused indexes in SQL Server

Using SQL Server Dynamic Management Views (DMVs): SELECT OBJECT_NAME(i.object_id) AS TableName, i.name AS IndexName, i.index_id, i.type_desc AS IndexType, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, MAX(ius.last_user_seek) AS LastUserSeek, MAX(ius.last_user_scan) AS LastUserScan, MAX(ius.last_user_lookup) AS LastUserLookup, MAX(ius.last_user_update) AS LastUserUpdate FROM…

[learning-code-ficusoft]

Building Dynamic Pipelines in Azure Data Factory Using Variables and Parameters

Azure Data Factory (ADF) is a powerful ETL and data integration tool, and one of its greatest strengths is its dynamic pipeline capabilities. By using parameters and variables, you can make your pipelines flexible, reusable, and easier to manage — especially when working with multiple environments, sources, or files.

In this blog, we’ll explore how to build dynamic pipelines in Azure Data Factory using parameters and variables, with practical examples to help you get started.

🎯 Why Go Dynamic?

Dynamic pipelines:

Reduce code duplication

Make your solution scalable and reusable

Enable parameterized data loading (e.g., different file names, table names, paths)

Support automation across multiple datasets or configurations

🔧 Parameters vs Variables: What’s the Difference?

FeatureParametersVariablesScopePipeline level (readonly)Pipeline or activity levelUsagePass values into a pipelineStore values during executionMutabilityImmutable after pipeline startsMutable (can be set/updated)

 Step-by-Step: Create a Dynamic Pipeline

Let’s build a sample pipeline that copies data from a source folder to a destination folder dynamically based on input values.

✅ Step 1: Define Parameters

In your pipeline settings:

Create parameters like sourcePath, destinationPath, and fileName.

json"parameters": { "sourcePath": { "type": "string" }, "destinationPath": { "type": "string" }, "fileName": { "type": "string" } }

✅ Step 2: Create Variables (Optional)

Create variables like status, startTime, or rowCount to use within the pipeline for tracking or conditional logic.json"variables": { "status": { "type": "string" }, "rowCount": { "type": "int" } }

✅ Step 3: Use Parameters Dynamically in Activities

In a Copy Data activity, dynamically bind your source and sink:

Source Path Example:json@concat(pipeline().parameters.sourcePath, '/', pipeline().parameters.fileName)

Sink Path Example:json@concat(pipeline().parameters.destinationPath, '/', pipeline().parameters.fileName)

✅ Step 4: Set and Use Variables

Use a Set Variable activity to assign a value:json"expression": "@utcnow()"

Use an If Condition or Switch to act based on a variable value:json@equals(variables('status'), 'Success')

📂 Real-World Example: Dynamic File Loader

Scenario: You need to load multiple files from different folders every day (e.g., sales/, inventory/, returns/).

Solution:

Use a parameterized pipeline that accepts folder name and file name.

Loop through a metadata list using ForEach.

Pass each file name and folder as parameters to your main data loader pipeline.

🧠 Best Practices

🔁 Use ForEach and Execute Pipeline for modular, scalable design.

🧪 Validate parameter inputs to avoid runtime errors.

📌 Use variables to track status, error messages, or row counts.

🔐 Secure sensitive values using Azure Key Vault and parameterize secrets.

🚀 Final Thoughts

With parameters and variables, you can elevate your Azure Data Factory pipelines from static to fully dynamic and intelligent workflows. Whether you’re building ETL pipelines, automating file ingestion, or orchestrating data flows across environments — dynamic pipelines are a must-have in your toolbox.

WEBSITE: https://www.ficusoft.in/azure-data-factory-training-in-chennai/

[harmonyos-next]

HarmonyOS NEXT Practical: Page Watermark

In software development, a watermark is a mark embedded in an application page, image, or document, typically presented in the form of text or graphics. Watermarks are typically used for the following purposes:

Source identification: can be used to identify the source or author of applications, various files, and ensure the ownership of property rights.

Copyright protection: It can carry copyright protection information, effectively preventing others from tampering, stealing, and illegal copying.

Artistic effect: It can be used as an artistic effect to add a unique style to images or applications.

Implementation idea:

Create a Canvas canvas and draw a watermark on it.

Use the floating layer overlay property to integrate the canvas with UI page components for display.

Knowledge points: Canvas provides canvas components for custom drawing of graphics. Use the CanvasRendering Context2D object to draw on the Canvas component, where the fillText() method is used to draw text and the drawImage() method is used to draw images.

Canvas.onReady Event callback when Canvas component initialization is completed or when Canvas component size changes. When the event is triggered, the canvas is cleared, and after the event, the width and height of the Canvas component are determined and available for drawing using Canvas related APIs. When the Canvas component only undergoes a positional change, only the onAreaChange event is triggered and the onReady event is not triggered. The onAreaChange event is triggered after the onReady event.

Canvas.hitTestBehavior Set the touch test type for the component. Default value: HitTestMode.Default

Implement the draw() method for drawing watermarks. The default starting point for drawing is the origin of the coordinate axis (upper left corner of the canvas). By translating and rotating the coordinate axis, watermarks can be drawn at different positions and angles on the canvas. If the watermark has a certain rotation angle, in order to ensure that the first watermark can be displayed completely, it is necessary to translate the starting point of the drawing, and the translation distance is calculated based on the rotation angle and the width and height of the watermark. Finally, the watermark text was drawn using the CanvasRendering Context2D. tilText() method. [code] fillText(text: string, x: number, y: number, maxWidth?: number): void [/code] Draw fill type text. text： The text content that needs to be drawn. x： The x-coordinate of the bottom left corner of the text to be drawn. Default Unit: vp。 y： The y-coordinate of the bottom left corner of the text to be drawn. Default Unit: vp。 maxWidth： Specify the maximum width allowed for the text. Default unit: vp. Default value: unlimited width.

Create watermark: BuildWatermark [code] @Builder export function BuildWatermark() { Watermark() .width('100%') .height('100%') }

@Component struct Watermark { private settings: RenderingContextSettings = new RenderingContextSettings(true); private context: CanvasRenderingContext2D = new CanvasRenderingContext2D(this.settings); @Prop watermarkWidth: number = 120; @Prop watermarkHeight: number = 120; @Prop watermarkText: string = '这是文字水印'; @Prop rotationAngle: number = -30; @Prop fillColor: string | number | CanvasGradient | CanvasPattern = '#10000000'; @Prop font: string = '16vp';

build() { Canvas(this.context) .width('100%') .height('100%') .hitTestBehavior(HitTestMode.Transparent) .onReady(() => this.draw()) }

draw() { this.context.fillStyle = this.fillColor; this.context.font = this.font; const colCount = Math.ceil(this.context.width / this.watermarkWidth); const rowCount = Math.ceil(this.context.height / this.watermarkHeight); for (let col = 0; col <= colCount; col++) { let row = 0; for (; row <= rowCount; row++) { const angle = this.rotationAngle * Math.PI / 180; this.context.rotate(angle); const positionX = this.rotationAngle > 0 ? this.watermarkHeight * Math.tan(angle) : 0; const positionY = this.rotationAngle > 0 ? 0 : this.watermarkWidth * Math.tan(-angle); this.context.fillText(this.watermarkText, positionX, positionY); this.context.rotate(-angle); this.context.translate(0, this.watermarkHeight); } this.context.translate(0, -this.watermarkHeight * row); this.context.translate(this.watermarkWidth, 0); } } } [/code] Use watermark: [code] import { BuildWatermark } from './BuildWatermark';

@Entry @Component struct WatermarkDemoPage { @State message: string = 'WatermarkDemo';

build() { Column() { Text(this.message) .fontWeight(FontWeight.Bold) } .height('100%') .width('100%') .overlay(BuildWatermark()) } } [/code]

[phpgurukul1]

How to check Email and username availability live using jquery/ajax, PHP and PDO

In this tutorial, We will learn how to How to check Email and username availability live using jQuery/ajax and PHP-PDO.

Click : https://phpgurukul.com/how-to-check-email-and-username-availability-live-using-jquery-ajax-php-and-pdo/

File Structure for this tutorials

index.php (Main File)

config.php (Database Connection file)

check_availability.php (Used to check the Email and User availability)

Create a database with name demos. In demos database, create a table with name email_availabilty Sample structure of table email_availabilty

CREATE TABLE IF NOT EXISTS `email_availabilty` (

`id` int(11) NOT NULL,

`email` varchar(255) NOT NULL,

`username` varchar(255) NOT NULL

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

2. Create a database connection file

config.php

<?php

//DB Connection

define(‘DB_HOST’,’localhost’);

define(‘DB_USER’,’root’);

define(‘DB_PASS’,’’);

define(‘DB_NAME’,’demos’);

// Establish database connection.

try

{

$dbh = new PDO(“mysql:host=”.DB_HOST.”;dbname=”.DB_NAME,DB_USER, DB_PASS,array(PDO::MYSQL_ATTR_INIT_COMMAND => “SET NAMES ‘utf8’”));

}

catch (PDOException $e)

{

exit(“Error: “ . $e->getMessage());

}

3. Now Create an HTML form index.php

<?php

include_once(“config.php”);

?>

<table>

<tr>

<th width=”24%” height=”46" scope=”row”>Email Id :</th>

<td width=”71%” ><input type=”email” name=”email” id=”emailid” onBlur=”checkemailAvailability()” value=”” class=”form-control” required /></td>

</tr>

<tr>

<th width=”24%” scope=”row”></th>

<td > <span id=”email-availability-status”></span> </td>

</tr>

<tr>

<th height=”42" scope=”row”>User Name</th>

<td><input type=”text” name=”username” id=”username” value=”” onBlur=”checkusernameAvailability()” class=”form-control” required /></td>

</tr>

<tr>

<th width=”24%” scope=”row”></th>

<td > <span id=”username-availability-status”></span> </td>

</tr>

</table>

4. Jquery/ajax script where you pass variable to check_availability.php page. put this in index.php inside head.

<script>

function checkemailAvailability() {

$(“#loaderIcon”).show();

jQuery.ajax({

url: “check_availability.php”,

data:’emailid=’+$(“#emailid”).val(),

type: “POST”,

success:function(data){

$(“#email-availability-status”).html(data);

$(“#loaderIcon”).hide();

},

error:function (){}

});

}

function checkusernameAvailability() {

$(“#loaderIcon”).show();

jQuery.ajax({

url: “check_availability.php”,

data:’username=’+$(“#username”).val(),

type: “POST”,

success:function(data){

$(“#username-availability-status”).html(data);

$(“#loaderIcon”).hide();

},

error:function (){}

});

}

</script>

5.check_availability.php page in this page you will check the availability of email or email.

<?php

require_once(“config.php”);

//code check email

if(!empty($_POST[“emailid”])) {

$uemail=$_POST[“emailid”];

$sql =”SELECT email FROM email_availabilty WHERE email=:email”;

$query= $dbh -> prepare($sql);

$query-> bindParam(‘:email’, $uemail, PDO::PARAM_STR);

$query-> execute();

$results = $query -> fetchAll(PDO::FETCH_OBJ);

if($query -> rowCount() > 0)

echo “<span style=’color:red’> Email Already Exit .</span>”;

else

echo “<span style=’color:green’> Email Available.</span>”;

}

// End code check email

//Code check user name

if(!empty($_POST[“username”])) {

$username=$_POST[“username”];

$sql =”SELECT username FROM email_availabilty WHERE username=:username”;

$query= $dbh -> prepare($sql);

$query-> bindParam(‘:username’, $username, PDO::PARAM_STR);

$query-> execute();

$results = $query -> fetchAll(PDO::FETCH_OBJ);

if($query -> rowCount() > 0)

echo “<span style=’color:red’> Username already exit .</span>”;

else

echo “<span style=’color:green’> Username Available.</span>”;

}

// End code check username

?>

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[primathontech]

Optimizing React Performance: Tips for Faster and More Efficient Web Apps

Introduction

React, the popular JavaScript library for building user interfaces, has become a go-to choice for many developers due to its efficient rendering, component-based architecture, and rich ecosystem. However, as applications grow in complexity, maintaining optimal performance can become a challenge. In this article, we'll explore a range of techniques and best practices to help you optimize the performance of your React applications, ensuring they are fast, responsive, and efficient.

Memoization with React.memo()

One of the most effective ways to improve React performance is through the use of memoization. The React.memo() higher-order component (HOC) can be used to wrap functional components, preventing unnecessary re-renders when the component's props have not changed.import React, { memo } from 'react'; const MyComponent = memo(({ prop1, prop2 }) => { // component implementation });

By wrapping your components with React.memo(), React will skip re-rendering the component if its props have not changed, leading to significant performance improvements, especially for expensive or frequently rendered components.

Leveraging Virtualization with react-virtualized

When dealing with large datasets or long lists, traditional rendering can become slow and inefficient. React-virtualized is a powerful library that implements virtualization, rendering only the visible items in the viewport and dynamically loading more as the user scrolls. This technique can dramatically improve the performance of your application, especially when working with large data sets.import { List } from 'react-virtualized'; <List width={500} height={400} rowCount={1000} rowHeight={50} rowRenderer={({ index, key, style }) => ( <div key={key} style={style}> Row {index} </div> )} />

Code Splitting and Lazy Loading

Code splitting is a technique that allows you to split your application's code into smaller, more manageable chunks. This can be particularly beneficial for large applications, where loading the entire codebase upfront can lead to slow initial load times. By implementing code splitting and lazy loading, you can ensure that only the necessary code is loaded when it's needed, improving the overall performance of your application.import { lazy, Suspense } from 'react'; const MyComponent = lazy(() => import('./MyComponent')); <Suspense fallback={<div>Loading...</div>}> <MyComponent /> </Suspense>

Optimizing Rendering with React.PureComponent and shouldComponentUpdate

In class-based components, you can use React.PureComponent or implement the shouldComponentUpdate lifecycle method to control when a component should re-render. These techniques can help you avoid unnecessary re-renders, leading to improved performance.import React, { PureComponent } from 'react'; class MyComponent extends PureComponent { // component implementation }

Leveraging React.Fragment and Portals

React.Fragment allows you to group multiple elements without adding an extra DOM node, which can improve the efficiency of your component tree. Additionally, React Portals provide a way to render components outside the main component tree, which can be useful for modals, tooltips, and other UI elements that need to be positioned independently.import { Fragment, createPortal } from 'react'; return ( <Fragment> {/* component content */} </Fragment> {createPortal( <div className="modal">Modal content</div>, document.body )} );

Conclusion

Optimizing the performance of your React applications is crucial for providing a smooth and responsive user experience. By implementing techniques like memoization, virtualization, code splitting, and efficient rendering, you can ensure that your web apps are fast, efficient, and scalable. Remember, performance optimization is an ongoing process, and it's essential to continuously monitor and optimize your application as it grows and evolves. In conclusion, optimizing the performance of your React applications is essential for delivering a seamless user experience. By implementing techniques like memoization, virtualization, and efficient rendering, you can ensure your web apps are fast and responsive. For further enhancements or to explore advanced features, consider partnering with a reputable React.js development company or hire React.js developers to take your projects to the next level.

[speedwagons-glorious-mane]

I just came so close to messing up my knitting WIP from forgetting to update the rowcounter, I just counted by hand and my row counter is over twenty rows out and I'm three rows away from a big change in the pattern

[strandedyarns]

I got this super awesome row counter pin by @twillandprint gifted to me yesterday!! Thank you @mewmuiknits for the early bday present 😭🧶🍁 I love it! . #rowcounter #enamelpin #fallknitting #explorerknitsandfiber #explorerknits #twillandprint #knitting #pins #merinastrand https://www.instagram.com/p/CGVEKJJoJ9Q/?igshid=1v1dni0vjyba6

[csmlove-karen]

Much work on the new project. Almost done now… - see our progress on our website blog. ;) #csm #legarepedalpower #rowcounter #usingwhatyouhave #circularsockknittingmachine #sockknittingmachine #antiquesockmachine #knitting #karenramel (at Vancouver, British Columbia) https://www.instagram.com/p/CiW-DhdOYea/?igshid=NGJjMDIxMWI=

[handmadebycatkin]

I'm collaborating with Woolswap this September! Head over to www.woolswap.com.au to join in the yarny fun! All woolswappers who sign up for the September event will receive access to special discounts at my store and many other amazing yarn specialists during the event! Plus you'll have the chance to meet new yarn friends along the way! Check it out! #woolswap #woolswapseptgiveaway #woolswappers #september2022 #handmadebycatkin #handdyedyarn #handdyedcotton #stitchmarkers #progresskeepers #rowcounter #needlestoppers #knittingofinstagram #knittinginstagram #knitspiration #knitstagram #crochetersofinstagram #crochetinspiration #crochetinstagram #crotchet #crotchetersofinstagram #yarnlovers #yarnstash #yarnswap #yarnpornofinstagram #yarnspiration #yarny #yarnythings #yarn #wool #cotton (at Ngunnawal Country) https://www.instagram.com/p/CiCuyxdLaZ8/?igshid=NGJjMDIxMWI=

[jillsbeadedknitbits]

Wear your row counter on your wrist! Blue Wave Abacus Counting Bracelet- Gift for Knitters- Row Counter⠀ ➤ USD 22.95.⠀ For more info please visit the website.#knitting #knittingcounter #rowcounter #jillsbeadedknitbits #knittersofinstagram #countingbracelet #abacus #abacusbracelet

[angelicapullins]

The perfect new app for my apple watch #rowcounter #lalylala #lalylaladoll #lalylalalupo #crochet #crochetdoll #crochetaddict #etsyseller #etsy https://www.instagram.com/p/B0maDwrn8Hq/?igshid=1sn558ineeq1b

[quirkysewingknit]

'K' knitting is todays topic and here are a few knitting aids that I use. Needles of course! Also a needle case to keep a portion of what I have in, made by me. Circular needles, double ended needles, cable needles, row counters, stitch holders, knitting gauge and wool holders for doing fair Isle/colour knitting. #knitting #knittingneedles #knittingneedlecase #stitchholder #rowcounter #handknitting #cableknitting #circularneedles #zoknitandsew (at Millbrook, Cornwall) https://www.instagram.com/p/ByStyUTFTss/?igshid=wseugsacfdx8

[crimsonorchid]

A new Row Counter Bracelet. Functionality and beauty all in one! Keep track of your rows up to 100. Plus everything is on sale 20% off in our etsy store. Use coupon code ECLIPSE0817. #crochetersofinstagram #knittersofinstagram #stitchmarkers #rowcounter

[francescasfiber]

Had to make another! These are so fun and cute! #rowcounter #handmade #knitting #jewelry #igknitters #knittersofinstagram #knittingfriends #knityourshit2017 #ravelry #francescasfiber (at Yarnia)

[crochetnmore]

Free Crochet Pattern: Row Count Filler Afghan Square

http://www.crochetnmore.com/rowcountfillerafghansquare.html

[knitfororphans]

Fun & useful tools for #knitters ... stitch markers and row counters.