Tag Archives: SQL

Video PHP Security: SQL Injection

Brush up on your PHP security knowledge! Demonstrations and advice on the most common areas of PHP security.

Database Connectivity in ASP.NET/C# with SQL Server

Database Connectivity in ASP.NET/C# with SQL Server
// CodeProject Latest Articles

CRUD operation in ASP.NET/C# with SQL Server for beginners

Database connectivity in Asp.Net/C# with Sql Server

Database connectivity in Asp.Net/C# with Sql Server
// CodeProject Latest Articles

CRUD operation in Asp.Net/C# with Sql Server for beginners

JavaScript Parser: convert JSON to SQL being real

via JavaScript Parser: convert JSON to SQL being real.

JavaScript parsers can do many interesting tasks, which makes great thing: they economy your time. In this post I want to show you a lazy way to convert JSON file to SQL queries, which you can use for export parsed data to your database.

Idea for creating this post happened for me after that, when my friends-developers create personal blog – they have more than 100 videos on YouTube and I saw how one of them copy each frame and title of video and insert it into phpMyAdmin. I say: “it’s a horribly long way – let’s make parser”, and after 5 minutes we have SQL file with valid queries for their database table.

It was a real example of that, how JavaScript parsers can economy time. But let’s return to our task.

Video: Temporal in SQL Server 2016

Today, Scott welcomes Borko Novakovic back to Data Exposed and the Channel 9 studios. Borko, a Program Manager in the SQL Server team, is in Redmond all the way from his home in Belgrade, Serbia to introduce us to the new Temporal technology being introduced in SQL Server 2016. Temporal in SQL Server is designed to simply the handling of time-varying data. It provides the ability to look at data trends, types of data changes, and the overall data evolution within your database.

How to read XML data in SQL?

How to read XML data in SQL? Hello friends, in this article I am going to explain how to read xml data in SQL? In my previous article I explained you what are the differences between hash table and dictionary in C#? To see more about modes in asp.net please visits my previous article. Let’s […]


MEAN WEB DEVELOPMENT | Author Sander Rossel

So what is MEAN? I could call you dumb for not knowing, that would be mean (and unjustified, because you’ll know within seconds), but that’s not quite the mean I’m talking about! MEAN is actually an acronym (because we love acronyms in IT) and it stands for MongoDB, Express, AngularJS and Node.js. Chances are you’ve heard of those and if you read a previous blog post of mine, Web development #8: Where to go from here, you even know a little bit about what they are (although you could’ve got that from other sources too, of course).
In short, MongoDB is a NoSQL Document Model database, Node.js is a platform that allows you to run JavaScript on/as your web server, Express is a library that simplifies working with Node.js and AngularJS is a front end framework that let’s you create Single Page Applications (SPAs).

Don’t worry, we’ll look at all of them in much more detail later. In fact, I’ve already written on MongoDB in an earlier blog post, A first look at NoSQL and MongoDB in particular. Actually I’m going to ask you to read that post in a little bit.

So here’s the deal, MongoDB is a database that doesn’t use SQL, but JavaScript, as a query language, Node.js is a platform that let’s you use JavaScript on your back end, AngularJS is a JavaScript library for your front end and Express is just a library for Node.js. So that’s JavaScript across your entire stack! That’s pretty awesome, especially when you’re a fan of JavaScript.

You’re probably going to use more than just MEAN. MEAN is just a starting point, but, of course, you’re free to add (or remove) whatever you like. Perhaps a little jQuery UI, a HTML generator like Jade,  or sockets.io, a library for working with sockets in Node.js.