#sql-script

[erossiniuk]

Split SQL script tool

I have created a simple #CSharp console application as a tool to split big #SQL scripts. For example, I had a problem with data seed scripts.

I have created a simple C# console application a split SQL script tool to split big scripts. For example, I had a problem with data seed scripts. Those scripts are huge because the database has more than a million records. These records need to be added to a new database. Each script is roughly 400Mb and I can’t upload it in the repository in Azure DevOps for example. Example of big SQL to…

[python-programming-language]

MIMO - My SQL Certificate ...

Post #94: MIMO, Learn To Code, My SQL Certificate, 2023.

[athenaalexandria]

I’m going to make a script to auto block all the celebrities I can think of automatically on TikTok, but oh god my coding knowledge is failing me. It’s been 3 years since I last used anything other than SQL, my brain is failing me 😭

I’m hopeful I can bang something out this afternoon that functions so others can also run it to auto block. Then make it open source so others can add more celebrities and make it so it will also block elsewhere like Instagram or Twitter.

Will this work? Will anyone use it? Will anyone even know about it? Who knows, but at least it’ll make it easier for me to help friends block. As they say, why spend 30 minutes manually doing something when you can spend 3 hours failing to automate it 🙂‍↕️

[peach-thinks]

"SELECT m.ACTIVE, b.ACTIVE, h.ACTIVE

FROM ME_ARCHIVE m

LEFT JOIN BRAIN b ON b.CELL_COMPOSITION = m.CELL_COMPOSITION

JOIN HEART h ON h.CELL_COMPOSITION = m.CELL_COMPOSITION

WHERE m.UPDATE_DATE <= SYSDATE

ORDER BY m.UPDATE_DATE DESC

[Query results]

Fetched 28 rows in 883,594,012 seconds"

[anandshivam2411]

Leveraging JavaScript for Seamless Integration with Google Cloud IoT Services

Exploring JavaScript integration with Google Cloud IoT services allows developers to easily build smart, connected systems using familiar web tools. Google Cloud IoT offers a platform to connect, manage, and analyze data from many devices. With JavaScript and frameworks like Node.js, developers can connect devices to the cloud, handle data in real-time, and use tools like machine learning and automation.

JavaScript is flexible and makes it easy to write code for both devices and cloud services. This helps in building IoT applications that can grow as more devices are added. Plus, Google Cloud IoT provides strong security, ensuring data and devices are protected.

In short, using JavaScript with Google Cloud IoT services simplifies creating connected devices while taking advantage of cloud computing power and analytics. Exploring JavaScript integration with Google Cloud IoT services allows developers to easily build smart, connected systems using familiar web tools.

[zapperrr]

Securing Your Website: Best Practices for Web Developers

As the digital landscape continues to evolve, website security has become a paramount concern for businesses and individuals alike. With cyber threats becoming increasingly sophisticated, it is crucial for web developers to adopt robust security measures to safeguard their websites and the sensitive data they handle. In this article, we'll delve into the best practices that web developers can implement to enhance the security of their websites and protect against potential threats.

Introduction

In today's interconnected world, websites serve as the digital storefront for businesses, making them vulnerable targets for cyber attacks. From data breaches to malware infections, the consequences of a security breach can be severe, ranging from financial loss to damage to reputation. Therefore, prioritizing website security is essential for maintaining the trust and confidence of users.

Understanding Website Security

Before diving into best practices, it's crucial to understand the importance of website security and the common threats faced by websites. Website security encompasses measures taken to protect websites from cyber threats and unauthorized access. Common threats include malware infections, phishing attacks, SQL injection, cross-site scripting (XSS), and brute force attacks.

Best Practices for Web Developers

Keeping Software Updated

One of the most fundamental steps in website security is keeping all software, including the content management system (CMS), plugins, and server software, updated with the latest security patches and fixes. Outdated software is often targeted by attackers due to known vulnerabilities that can be exploited.

Implementing HTTPS

Implementing HTTPS (Hypertext Transfer Protocol Secure) encrypts the data transmitted between the website and its users, ensuring confidentiality and integrity. HTTPS not only protects sensitive information but also boosts trust among visitors, as indicated by the padlock icon in the browser's address bar.

Using Strong Authentication Methods

Implementing strong authentication methods, such as multi-factor authentication (MFA) and CAPTCHA, adds an extra layer of security to user accounts. MFA requires users to provide multiple forms of verification, such as a password and a one-time code sent to their mobile device, reducing the risk of unauthorized access.

Securing Against SQL Injection Attacks

SQL injection attacks occur when malicious actors exploit vulnerabilities in web applications to execute arbitrary SQL commands. Web developers can prevent SQL injection attacks by using parameterized queries and input validation to sanitize user inputs effectively.

Protecting Sensitive Data

It's essential to employ encryption techniques to protect sensitive data, such as passwords, credit card information, and personal details, stored on the website's servers. Encrypting data at rest and in transit mitigates the risk of data breaches and unauthorized access.

Regular Security Audits

Conducting regular security audits helps identify vulnerabilities and weaknesses in the website's infrastructure and codebase. Penetration testing, vulnerability scanning, and code reviews enable web developers to proactively address security issues before they are exploited by attackers.

Choosing a Secure Hosting Provider

Selecting a reputable and secure hosting provider is critical for ensuring the overall security of your website. When evaluating hosting providers, consider factors such as security features, reliability, scalability, and customer support.

Evaluating Security Features

Choose a hosting provider that offers robust security features, such as firewalls, intrusion detection systems (IDS), malware scanning, and DDoS protection. These features help protect your website from various cyber threats and ensure continuous uptime.

Ensuring Regular Backups

Regularly backing up your website's data is essential for mitigating the impact of security incidents, such as data breaches or website compromises. Choose a hosting provider that offers automated backup solutions and store backups securely offsite.

Customer Support and Response to Security Incidents

Opt for a hosting provider that provides responsive customer support and has established protocols for handling security incidents. In the event of a security breach or downtime, prompt assistance from the hosting provider can minimize the impact on your website and business operations.

Implementing Firewall Protection

Firewalls act as a barrier between your website and external threats, filtering incoming and outgoing network traffic based on predefined security rules. There are several types of firewalls, including network firewalls, web application firewalls (WAF), and host-based firewalls.

Configuring and Maintaining Firewalls

Properly configuring and maintaining firewalls is crucial for effective security. Define firewall rules based on the principle of least privilege, regularly update firewall configurations to reflect changes in the website's infrastructure, and monitor firewall logs for suspicious activity.

Educating Users about Security

In addition to implementing technical measures, educating users about security best practices is essential for enhancing overall website security. Provide users with resources, such as security guidelines, tips for creating strong passwords, and information about common phishing scams.

Importance of User Awareness

Users play a significant role in maintaining website security, as they are often the targets of social engineering attacks. By raising awareness about potential threats and providing guidance on how to recognize and respond to them, web developers can empower users to stay vigilant online.

Providing Training and Resources

Offer training sessions and educational materials to help users understand the importance of security and how to protect themselves while using the website. Regularly communicate updates and reminders about security practices to reinforce good habits.

Monitoring and Responding to Security Incidents

Despite taking preventive measures, security incidents may still occur. Establishing robust monitoring systems and incident response protocols enables web developers to detect and respond to security threats in a timely manner.

Setting Up Monitoring Tools

Utilize monitoring tools, such as intrusion detection systems (IDS), security information and event management (SIEM) systems, and website monitoring services, to detect abnormal behavior and potential security breaches. Configure alerts to notify you of suspicious activity promptly.

Establishing Incident Response Protocols

Develop comprehensive incident response plans that outline roles, responsibilities, and procedures for responding to security incidents. Establish clear communication channels and escalation paths to coordinate responses effectively and minimize the impact of security breaches.

Securing your website requires a proactive approach that involves implementing a combination of technical measures, choosing a secure hosting provider, educating users about security best practices, and establishing robust monitoring and incident response protocols. By following these best practices, web developers can mitigate the risk of security breaches and safeguard their websites and the sensitive data they handle.

[thedbahub]

Efficient Management of Multi-Server Queries: A T-SQL and PowerShell Approach

In today’s interconnected world, managing data across multiple SQL Server instances is a common scenario for many organizations. Whether for reporting, data aggregation, or monitoring, running the same query across these servers efficiently is paramount. This article explores practical techniques and tools to achieve this, focusing on T-SQL, linked servers, Central Management Server (CMS), and…

[docckolkata]

Computer Programming Language Training and Placements by DOCC Kolkata

Computer Programming Language online and offline Training ( PHP, PYTHON, NODE JS, JAVA-JAVASCRIPT, etc.,) from grass route level incl. Data structure, Algorithm, Program Coding, etc. And Projects for Assured Placements in the IT Sector by DOCC Kolkata, Lake Gardens. If interested please call 9433526196. Visit www.docckolkata.com

[spreadsheetautomation]

How to Write a Python Script

Python is a high-level programming language that many organizations use. Developers can use it to build sites, analyze data, perform tasks and more. A Python script is a set of commands written in a file that runs similarly to a program, allowing the file to perform a specific function.

The best and easiest way to write code is to use data apps for Python scripts. The right app can save you hours while reducing the risk of error. But even if you use data apps for Python scripts, it pays to know how to write them from scratch.

In this blog, you'll learn how to write a simple Python Script with one of the most famous coding exercises in the world.

Organize Your Scripts

The first step is to create a folder for your Python scripts. Naming conventions are flexible. The key is to choose a folder hierarchy that makes sense to you. For simplicity, consider making a separate folder on your desktop. You can name it "python_workshop."

Creating Your First Script

To start your script, open up Notepad++ and create a new file. Then, click File>Save As.

Save your script in your newly created "python_workshop" folder and name it "exercise_hello_world.py." Pay attention to that file extension!

Write Your Code

On the first line, type out:

# Author: YOUR NAME and email address

Fill out the code with the relevant information to make the script run properly.

On the next line, type:

# This is a script to test that Python is working.

Add an empty line to create your next line of code. It should read:

print("Hello world from YOUR NAME").

Save your file.

Running the Script

Open a new Terminal window. You should see:

C:\Users\YOURNAME>

After you see your name, type in "CD desktop." Hit "Enter," and you can type in the name of your "python_workshop" folder. Hit "Enter" again, and type in the name of the script file you just created.

After hitting "Enter," you should see that little "hello world" message you created in your script.

Read a similar article about chatgpt and spreadsheets here at this page.

[jobtrainingckolkata]

[sajzath]

Behind the Scenes: Delving into Back-End Web Development

When you browse the internet, you encounter various websites with captivating user interfaces and seamless functionality. However, what you may not be aware of is the intricate work that happens behind the scenes to make these websites perform effortlessly. This behind-the-scenes magic is the result of back-end web development – the backbone of any successful website. In this article, we will…

[komaedalovemail]

komaedas have you tried straw.page?

(i hope you don't mind if i make a big ollllle webdev post off this!)

i have never tried straw.page but it looks similar to carrd and other WYSIWYG editors (which is unappealing to me, since i know html/css/js and want full control of the code. and can't hide secrets in code comments.....)

my 2 cents as a web designer is if you're looking to learn web design or host long-term web projects, WYSIWYG editors suck doodooass. you don't learn the basics of coding, someone else does it for you! however, if you're just looking to quickly host images, links to your other social medias, write text entries/blogposts, WYSIWYG can be nice.

toyhouse, tumblr, deviantart, a lot of sites implement WYSIWYG for their post editors as well, but then you can run into issues relying on their main site features for things like the search system, user profiles, comments, etc. but it can be nice to just login to your account and host your information in one place, especially on a platform that's geared towards that specific type of information. (toyhouse is a better example of this, since you have a lot of control of how your profile/character pages look, even without a premium account) carrd can be nice if you just want to say "here's where to find me on other sites," for example. but sometimes you want a full website!

---------------------------------------

neocities hosting

currently, i host my website on neocities, but i would say the web2.0sphere has sucked some doodooass right now and i'm fiending for something better than it. it's a static web host, e.g. you can upload text, image, audio, and client-side (mostly javascript and css) files, and html pages. for the past few years, neocities' servers have gotten slower and slower and had total blackouts with no notices about why it's happening... and i'm realizing they host a lot of crypto sites that have crypto miners that eat up a ton of server resources. i don't think they're doing anything to limit bot or crypto mining activity and regular users are taking a hit.

↑ page 1 on neocitie's most viewed sites we find this site. this site has a crypto miner on it, just so i'm not making up claims without proof here. there is also a very populated #crypto tag on neocities (has porn in it tho so be warned...).

---------------------------------------

dynamic/server-side web hosting

$5/mo for neocities premium seems cheap until you realize... The Beautiful World of Server-side Web Hosting!

client-side AKA static web hosting (neocities, geocities) means you can upload images, audio, video, and other files that do not interact with the server where the website is hosted, like html, css, and javascript. the user reading your webpage does not send any information to the server like a username, password, their favourite colour, etc. - any variables handled by scripts like javascript will be forgotten when the page is reloaded, since there's no way to save it to the web server. server-side AKA dynamic web hosting can utilize any script like php, ruby, python, or perl, and has an SQL database to store variables like the aforementioned that would have previously had nowhere to be stored.

there are many places in 2024 you can host a website for free, including: infinityfree (i use this for my test websites :B has tons of subdomains to choose from) [unlimited sites, 5gb/unlimited storage], googiehost [1 site, 1gb/1mb storage], freehostia [5 sites/1 database, 250mb storage], freehosting [1 site, 10gb/unlimited storage]

if you want more features like extra websites, more storage, a dedicated e-mail, PHP configuration, etc, you can look into paying a lil shmoney for web hosting: there's hostinger (this is my promocode so i get. shmoney. if you. um. 🗿🗿🗿) [$2.40-3.99+/mo, 100 sites/300 databases, 100gb storage, 25k visits/mo], a2hosting [$1.75-12.99+/mo, 1 site/5 databases, 10gb/1gb storage], and cloudways [$10-11+/mo, 25gb/1gb]. i'm seeing people say to stay away from godaddy and hostgator. before you purchase a plan, look up coupons, too! (i usually renew my plan ahead of time when hostinger runs good sales/coupons LOL)

here's a big webhost comparison chart from r/HostingHostel circa jan 2024.

---------------------------------------

domain names

most of the free website hosts will give you a subdomain like yoursite.has-a-cool-website-69.org, and usually paid hosts expect you to bring your own domain name. i got my domain on namecheap (enticing registration prices, mid renewal prices), there's also porkbun, cloudflare, namesilo, and amazon route 53. don't use godaddy or squarespace. make sure you double check the promo price vs. the actual renewal price and don't get charged $120/mo when you thought it was $4/mo during a promo, certain TLDs (endings like .com, .org, .cool, etc) cost more and have a base price (.car costs $2,300?!?). look up coupons before you purchase these as well!

namecheap and porkbun offer something called "handshake domains," DO NOT BUY THESE. 🤣🤣🤣 they're usually cheaper and offer more appealing, hyper-specific endings like .iloveu, .8888, .catgirl, .dookie, .gethigh, .♥, .❣, and .✟. I WISH WE COULD HAVE THEM but they're literally unusable. in order to access a page using a handshake domain, you need to download a handshake resolver. every time the user connects to the site, they have to provide proof of work. aside from it being incredibly wasteful, you LITERALLY cannot just type in the URL and go to your own website, you need to download a handshake resolver, meaning everyday internet users cannot access your site.

---------------------------------------

hosting a static site on a dynamic webhost

you can host a static (html/css/js only) website on a dynamic web server without having to learn PHP and SQL! if you're coming from somewhere like neocities, the only thing you need to do is configure your website's properties. your hosting service will probably have tutorials to follow for this, and possibly already did some steps for you. you need to point the nameserver to your domain, install an SSL certificate, and connect to your site using FTP for future uploads. FTP is a faster, alternative way to upload files to your website instead of your webhost's file upload system; programs like WinSCP or FileZilla can upload using FTP for you.

if you wanna learn PHP and SQL and really get into webdev, i wrote a forum post at Mysidia Adoptables here, tho it's sorted geared at the mysidia script library itself (Mysidia Adoptables is a free virtual pet site script, tiny community. go check it out!)

---------------------------------------

file storage & backups

a problem i have run into a lot in my past like, 20 years of internet usage (/OLD) is that a site that is free, has a small community, and maybe sounds too good/cheap to be true, has a higher chance of going under. sometimes this happens to bigger sites like tinypic, photobucket, and imageshack, but for every site like that, there's like a million of baby sites that died with people's files. host your files/websites on a well-known site, or at least back it up and expect it to go under!

i used to host my images on something called "imgjoe" during the tinypic/imageshack era, it lasted about 3 years, and i lost everything hosted on there. more recently, komaedalovemail had its webpages hosted here on tumblr, and tumblr changed its UI so custom pages don't allow javascript, which prevented any new pages from being edited/added. another test site i made a couple years ago on hostinger's site called 000webhost went under/became a part of hostinger's paid-only plans, so i had to look very quickly for a new host or i'd lose my test site.

if you're broke like me, looking into physical file storage can be expensive. anything related to computers has gone through baaaaad inflation due to crypto, which again, I Freaquing Hate, and is killing mother nature. STOP MINING CRYPTO this is gonna be you in 1 year

...um i digress. ANYWAYS, you can archive your websites, which'll save your static assets on The Internet Archive (which could use your lovely donations right now btw), and/or archive.today (also taking donations). having a webhost service with lots of storage and automatic backups can be nice if you're worried about file loss or corruption, or just don't have enough storage on your computer at home!

if you're buying physical storage, be it hard drive, solid state drive, USB stick, whatever... get an actual brand like Western Digital or Seagate and don't fall for those cheap ones on Amazon that claim to have 8,000GB for $40 or you're going to spend 13 days in windows command prompt trying to repair the disk and thenthe power is gong to go out in your shit ass neighvborhood and you have to run it tagain and then Windows 10 tryes to update and itresets the /chkdsk agin while you're awayfrom town nad you're goig to start crytypting and kts just hnot going tot br the same aever agai nikt jus not ggiog to be the saeme

---------------------------------------

further webhosting options

there are other Advanced options when it comes to web hosting. for example, you can physically own and run your own webserver, e.g. with a computer or a raspberry pi. r/selfhosted might be a good place if you're looking into that!

if you know or are learning PHP, SQL, and other server-side languages, you can host a webserver on your computer using something like XAMPP (Apache, MariaDB, PHP, & Perl) with minimal storage space (the latest version takes up a little under 1gb on my computer rn). then, you can test your website without needing an internet connection or worrying about finding a hosting plan that can support your project until you've set everything up!

there's also many PHP frameworks which can be useful for beginners and wizards of the web alike. WordPress is one which you're no doubt familiar with for creating blog posts, and Bluehost is a decent hosting service tailored to WordPress specifically. there's full frameworks like Laravel, CakePHP, and Slim, which will usually handle security, user authentication, web routing, and database interactions that you can build off of. Laravel in particular is noob-friendly imo, and is used by a large populace, and it has many tutorials, example sites built with it, and specific app frameworks.

---------------------------------------

addendum: storing sensitive data

if you decide to host a server-side website, you'll most likely have a login/out functionality (user authentication), and have to store things like usernames, passwords, and e-mails. PLEASE don't launch your website until you're sure your site security is up to snuff!

when trying to check if your data is hackable... It's time to get into the Mind of a Hacker. OWASP has some good cheat sheets that list some of the bigger security concerns and how to mitigate them as a site owner, and you can look up filtered security issues on the Exploit Database.

this is kind of its own topic if you're coding a PHP website from scratch; most frameworks securely store sensitive data for you already. if you're writing your own PHP framework, refer to php.net's security articles and this guide on writing an .htaccess file.

---------------------------------------

but. i be on that phone... :(

ok one thing i see about straw.page that seems nice is that it advertises the ability to make webpages from your phone. WYSIWYG editors in general are more capable of this. i only started looking into this yesterday, but there ARE source code editor apps for mobile devices! if you have a webhosting plan, you can download/upload assets/code from your phone and whatnot and code on the go. i downloaded Runecode for iphone. it might suck ass to keep typing those brackets.... we'll see..... but sometimes you're stuck in the car and you're like damn i wanna code my site GRRRR I WANNA CODE MY SITE!!!

↑ code written in Runecode, then uploaded to Hostinger. Runecode didn't tell me i forgot a semicolon but Hostinger did... i guess you can code from your webhost's file uploader on mobile but i don't trust them since they tend not to autosave or prompt you before closing, and if the wifi dies idk what happens to your code.

---------------------------------------

ANYWAYS! HAPPY WEBSITE BUILDING~! HOPE THIS HELPS~!~!~!

-Mod 12 @eeyes

[coffee-dad-studies]

Hey, look who's back. Crazy that it took almost four months to get a resolution (or even a response).

So! Between the day they restricted this blog (12/05/24) and today (03/26/25), I have passed these courses:

systems security

scripting & programming

cloud security management

information security management

cryptography

penetration testing

database foundations

I've earned these certifications:

ISC2 Systems Security Certified Practitioner

CompTIA PenTest+

Thirty-five days or so until the end of my current term, with one course--SQL--and a capstone project to go.

[anandshivam2411]

Mastering IoT Development: Versatile JavaScript Solutions for Connected Devices

The Internet of Things (IoT) has revolutionized communication between devices, creating a vast network that shares data and controls various functions. Traditionally, programming languages like C, C++, and Python have been favored for IoT development due to their strong performance in embedded systems. However, versatile IoT development with JavaScript for connected devices has emerged as a powerful option, offering flexibility, ease of use, and a broad ecosystem. Its asynchronous capabilities and event-driven architecture make it ideal for managing device interactions, positioning JavaScript as a top choice for developers building modern IoT solutions.

[tunder]

but to be more specific I do unpaid overtime and drink too much coffee and have to multitask 5 things at once. This is not the way to work when you 22 I think

I should be paid more to do my stupid job bc I’m so sexy and smart and also very smart and also I’m a huge investor into the corporation’s coffee shop (which is not affiliated with the corporation)

but I’m so smart

[thedbahub]

Discovering Giants: Unveiling Large Tables in SQL Server

Navigating the vast landscapes of data within a SQL Server instance can sometimes feel like exploring uncharted territories. Particularly in environments where databases grow to monumental sizes, housing billions of rows, identifying the largest tables becomes not just a matter of curiosity but a crucial task for optimizing performance, storage, and management strategies. Why Focus on Large…